Hi,

recently I updated my Zenphoto 1.2.1 Gallery to 1.2.2.

During the Updateprocess I get a SQL-Error:
....
Warning: array_flip() [function.array-flip]: Can only flip STRING and INTEGER values! in /www/html/zenphoto/zp-core/functions.php on line 469
Tabellenaktualisierung abgeschlossen!

Zenphoto Error
MySQL-Abfrage ( SELECT folder, sort_order, title, show, dynamic, search_params FROM albums WHERE parentid= ORDER BY sort_order ) fehlgeschlagen. Fehler: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY sort_order' at line 1

Have someone a Idea what is wrong?

Thanks

Noppes

It would seem that ther is a problem with an album's parentid. Normally it should be NULL or the ID of the parent album. Perhaps it is not stored as NULL.

Try to change line 451 of functions.php from if (is_null($parentalbum)) { to if (empty($parentalbum)) {

But of course, this is not new code, so I do not know why it would start to fail just on 1.2.2

On more thought, this will probably not help. Something is wrong with the ID value of an album. That's the parentid=. It should never be empty. Also I do not have any idea how it could get empty.

Maybe a database refresh will help. Just a guess.

Hi,

I delete the complete zenphoto-folder (expect of the album-dir), I deleted the whole Database and then I install zenphoto 1.2.2 new. But the same message cames.

Can you tell what album it is processing? Any other information you can think of would help.

I delete the hole Zenphotofolder with all albums, then I delete the Datebase, Upload the new Zenphotoversion and then I installed Zenphoto new. But the Error Message comes up. After that you can't use zenphoto.

Please tell us what php and mysql version you are running.

Thank you all for your help!
My PHP-Version is 5.2.6 (Apache/2.0.54 (Debian GNU/Linux) mod_ssl/2.0.54 OpenSSL/0.9.7e)
My MYSQL-Version is: 4.1.11-Debian_4sarge7-log