New Album fails without error

Topics: Developer Discussion, Help, Request
Nov 7, 2009 at 3:59 PM

I have just started working with the starter kit.  When I attempt to add a new Album, it is not added and no indication of the error. 

Other parts of the project seem to be working.  I did change the attributes of a few of the columns in the Album table to allow nulls but that did nothing.

Is there a way to capture error with Try block?

Bob Storrs

Nov 24, 2009 at 3:09 AM
Edited Nov 24, 2009 at 3:11 AM

I had this same error and found that the issue was with the SQL trying to add the album.  This insert is in the Photo/new.aspx page was not correct.  the value "private" needed to be "isprivate"

InsertCommand

="INSERT INTO Albums(title, parentid, ownerid, private) VALUES (@title, @parentid, @ownerid, @private)"

it should be

 InsertCommand="INSERT INTO Albums(title, parentid, ownerid, isprivate) VALUES (@title, @parentid, @ownerid, @private)"