SQL Error, p. 456, step 16

member4953 · April 8th, 2009, 11:26 AM

I can view NewPhotoAlbum.aspx in the browser. I enter a name and click "Insert" and that works. But when I put data in the Description, Tooltip and ImageUrl text boxes of ManagePhotoAlbum.aspx and click Insert I get:

Code:

 Server Error in '/BookWebSite' Application.

                 The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Picture_PhotoAlbum". The conflict occurred in database "C:\DOCUMENTS AND SETTINGS\THOMAS\MY DOCUMENTS\VISUAL STUDIO 2008\WEBSITES\BEGASPNET\BOOKWEBSITE\APP_DATA\PLANETWROX.MDF", table "dbo.PhotoAlbum", column 'Id'.
The statement has been terminated.

In trying to figure this out I looked at the database. The PhotoAlbum table is getting the new name from NewPhotoAlbum.aspx. There is no data in the Picture table, but I can add the data to the Picture table manually that would have been put in place by adding it through the ManagePhotoAlbum.aspx page.

I am still working on it. If you have any thoughts, please let me know.

Thanks.

Thomas

member4953 · April 8th, 2009, 11:54 AM

Dang, never mind.

I misspelled ManagePhotoAlbum.aspx?PhotoAlbumId by leaving out the second 'o'. Makes a big difference.

BTW, I used the debugging feature and had to allow a change to web.config.

Has the book mentioned that as yet?

Thomas

Imar · April 8th, 2009, 01:19 PM

Yes, it it. Take a look at page 608, step 3...

Imar