Last post Mar 02, 2009 11:33 PM by Lotos1
Feb 28, 2009 06:00 PM|Lotos1|LINK
I read the instructions in the Welcome file, but the Web Site Administration Tool does not start properly when I click ASP.NET Configuration in Visual Studio 2008. I get this error message: An error was encountered. Please return to the previous page and
try again and two ports get open on my localhost, one for the actual classifieds website, and one for the Web Site Administration Tool which gives the error in the browser.
I am not even sure where the roles are stored for this application? I checked the CLASSIFIEDSDB.mdf in the App_Data folder, and there is no table that stores roles and nothing for profiles. Where are the profiles stored since I can register new regular users
and post ads and their name and email address get stored in a profile, however, I cannot find the profile table inside CLASSIFIEDSDB.mdf? The members table inside CLASSIFIEDSDB.mdf does not store any names and email addresses nor does it store roles. I have
aspnetdb that I created for my original website into which I want to integrate the classifieds site, but I checked the aspnet_Profile table and it is empty. Should I modify my web.config for the classifieds website to use the aspnetdb that I already had before
running on the SQL Server 2005 and then just add CLASSIFIEDSDB.mdf to my SQL Server 2005? Will this automatically allow my classifieds site to use the existing users from aspnetdb?
Feb 28, 2009 09:01 PM|darkknight187|LINK
To set yourself as admin all you have to do is follow this link
http://forums.asp.net/t/1110595.aspx (the link to the users.aspx file it at the bottom of the first post)
unzip it and upload the two files to your website, in the main folder where anyone can access it.
(Technically it is in C#, and I use VB but it seems to work fine anyway, so you can just leave the code alone.)
Create yourself a login through your website, just like any user of your site.
Then point to your browser to the users.aspx file, and set your Id as administrator.
Then delete and/or move the two users files to a protected part of the website, such as Admin folder.
By the way it does not delete the user Id from the classifieds database when you use this tool to delete a user.
It does delete the user and all, but the current count of members displayed in your admin section will be wrong unless you delete the user from the classifieds members table aswell.
I did fix it on my site by rewritting the code and adding a storedprocedure to delete the row in members table. But this code available for download works great other than that.
By the way, did you get the final version of the kit from someone,
or did you download the beta?
(It says beta, or final on the .zip file)
For what ever reason the beta is available for download and has errors in it.
Feb 28, 2009 11:10 PM|Lotos1|LINK
Feb 28, 2009 11:54 PM|darkknight187|LINK
As far as I know there is nowhere to download it,
but if you send me a private message with your email address I'll send it to you.
Not sure why it's not up there.
I've been using this forum and the kit for over a year,
and I downloaded it the same way you did.
Then all of a sudden the link was broken.
When it started working again, it was the beta version.
So I'm glad I kept the original file.
Mar 02, 2009 05:18 PM|Lotos1|LINK
Thank you for the file.
I was able to connect to my original aspnetdb and I can log in my test users without problems. Which files do I need to change if I do not want to use profiles since my previous website did not use profiles? I would like to retrieve data like name, phone,
etc. from another database. Also if I want to use roles for the users, is this also going to be retrieved from the aspnetdb like it was in my original website? Another thing I noted, I cannot post ads when I login as my existing users because they are not
part of classifiedsdb.mdf and I get this error:
How do I solve this issue? I already have several hundred users on my live site, and I cannot enter each one of these manually into classifiedsdb.mdf. Is there a solution to this, because if there isn't, I will have to just make my own classifieds from scratch.
Mar 02, 2009 09:46 PM|darkknight187|LINK
It sounds like you have a lot of work ahead of you.
The only real advise I can give you is make Backups of everything in case you screw up.
As far as your error.
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Ads_Members". ... table "dbo.classifieds_Members", column 'Id'.
It needs the user Id in the members table to match the one in aspnetdb.
So just entering them won't work.
You would have to get the info from your aspnetdb (I don't know where it's kept)
And turn off the auto int feature so Ids are what you say they are.
It doesn't sound like it's going to be an easy task, have faith, MAKE BACKUPS,
And Good Luck.
Mar 02, 2009 11:33 PM|Lotos1|LINK
So, there is no way to copy users from aspnedtb to the corresponding classifiedsdb table? The kit will not work unless classifiedsdb has all of the members, in which case, I cannot use it with my existing users. This is no good to me since I already have
several hundred users. It is fine for people who are just starting a new site, but not for someone with existing users. I guess I will have to roll up my sleeves and start building my own classifieds. This way I will have more control over it and will be able
to manage my existing users.