Problem in Chapter 14

scrappy1871 · September 4th, 2011, 12:56 PM

Hiya,

I have been having an issue with Chapter 14 where when I try to do the Try it Outs with the Photo Album I am getting the following error:

The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Picture_PhotoAlbum". The conflict occurred in database "C:\USERS\IANWINDOWS7\DOCUMENTS\FINAL YEAR PROJECT\TRAINING MATERIAL\BEGINNING ASP.NET AND C# 4.0\SITE\APP_DATA\PLANETWROX.MDF", table "dbo.PhotoAlbum", column 'Id'.
The statement has been terminated.

I have managed to successfully load the source files, and they work, and the database this is referencing is the one provided in the source files. Can anyone offer a solution?

I am also using the source code files for the ManagePhotoAlbum.aspx page as well.

Imar · September 4th, 2011, 12:59 PM

Hi there,

A few things to check:

1. The relationships between the two tables in the database. Which columns are they joined on?

2. The ID of the album that is passed from NewAlbum to ManageAlbum. Do you see the correct ID in the query string?

Finally, storing a site in such a long path and with a # in its name will get you in problems later. Try moving it to a folder such as C:\Sites\

Cheers,

Imar

scrappy1871 · September 4th, 2011, 01:08 PM

Imar,

Thank-you so much for your very quick reply. Really appreciated.

I have now resolved the issue, turns out I had mistyped the query string in the NewPhotoAlbum.aspx.cs and had put "PhototAlbumId" rather than "PhotoAlbumId".

I will bare that in mind regarding the folder names.

Excellent book by the way. Has taught me so much!

Imar · September 4th, 2011, 02:49 PM

Ah, yes, that explains it. That would result in a PhotoAlbumId of 0 which doesn't exist in the database.

Quote:

Excellent book by the way. Has taught me so much!

Good to hear; thanks!

Imar