Hello!

Im trying to upgrade to 1.0.8.2 but when I run the upgrade script I get this error:

MySQL Query ( DELETE FROM albums WHERE id = '47' ) Failed. Error: Cannot delete or update a parent row: a foreign key constraint fails (zenphoto.images, CONSTRAINT images_ibfk1 FOREIGN KEY (albumid) REFERENCES albums (id))

Any ideas?

That's only in the garbage collection process, so it shouldn't affect anything. The tables have already been upgraded at that point.

Looks like the 'ON DELETE CASCADE' didn't get into the images table schema somehow... it does it manually anyway, so it shouldn't be too big a problem, but to avoid that in the future I may change the order so images are deleted first. Thanks!

Thanks for your reply Trisweb, maybe it's not related but I cant get in to the admin pages. Whenever I try to go there I get the mentioned error message.

Thanks again!

-Z