I just ran into the following error when trying to use the admin gui after upgrading an existing zenphoto install (1.2.0b3 -> 1.6):

MySQL Query ( SELECT * FROM albums WHERE 'parentid' IS NULL ) Failed. Error: Unknown column 'parentid' in 'where clause'

I had to manually go in and drop the zenphoto database (probably could've just added in the parentid column), and re-run the setup.php script to get it to populate properly. In any case, it doesn't appear that the column was automagically added when I ran the setup script initially (tried twice).

As I said, just a heads up in case anyone else runs into that error

Hi, I have a similar problem but I don't understand your solution : how do you "drop" the zenphoto database ?

Sorry I found out alone a solution, I guess the same as you did : I went to configure the mysql database from my host and deleted everything from zenphoto (drop tables) and then started the setup.php again.

Thx for the help

There's also an 'upgrade.php' that you should run after any upgrade... just FYI in case you missed the instructions on the front page of zenphoto.org ;-)

I just checked and the field 'parentid' is added in the upgrade.php and the setup.php, everything should work correctly if you just upgrade.