locked
downloaded classified starter kit and get an error message... RRS feed

  • Question

  • User-207099248 posted

    I downloaded the classified starter kit and opened it with vs2005.  I created a guest user account through asp.net configuration.  When I open the website locally and try to post an add I get the following error message... The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Ads_Members"

     I have searched the web but cannot find a solution.  Any help would be appreciated.

    Photon

    Sunday, September 21, 2008 8:47 PM

Answers

  • User730446648 posted

    Still use the final version but I just realized your issue.

    Do NOT create users with the asp.net configuration tool.
    Use the kit to create a user.

    The reason is it uses two databases, one is for the members and the other is the classifieds kit.

    When a user is created out of the kit, it adds to the members table in the classifieds kit.
    So the way you did it, it wouldn't be there, and there's your problem.

    Delete the member with the asp.net config tool, and create using the kit.

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, September 22, 2008 11:38 PM

All replies

  • User-207099248 posted

    Did I post this on the wrong forum or does no one know the solution to this problem? 

     Thanks,

    Photon

    Monday, September 22, 2008 9:12 PM
  • User730446648 posted

    Did you try using the final version I sent you?
    You shouldn't have to do anything, it works out of the box.

     

    Monday, September 22, 2008 11:34 PM
  • User730446648 posted

    Still use the final version but I just realized your issue.

    Do NOT create users with the asp.net configuration tool.
    Use the kit to create a user.

    The reason is it uses two databases, one is for the members and the other is the classifieds kit.

    When a user is created out of the kit, it adds to the members table in the classifieds kit.
    So the way you did it, it wouldn't be there, and there's your problem.

    Delete the member with the asp.net config tool, and create using the kit.

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, September 22, 2008 11:38 PM