Failed Installation Version 1.2.2

Member

Noppes 22-12-2008, 14:54

Hello,

I tried to install Zenphoto 1.2.2. But the installation failed with this Error Message:

Warning: array_flip() [function.array-flip]: Can only flip STRING and INTEGER values! in /www/html/zenphoto/zp-core/functions.php on line 472

Warning: array_flip() [function.array-flip]: Can only flip STRING and INTEGER values! in /www/html/zenphoto/zp-core/functions.php on line 472
Tabellenaktualisierung abgeschlossen!
Zenphoto Error
MySQL-Abfrage ( SELECT folder, sort_order, title, show, dynamic, search_params FROM zp_albums WHERE parentid= ORDER BY id ) 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 id' at line 1

Can someone help me?

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: 5.0.32

Member

sbillard 22-12-2008, 20:16

What is the release level of your installation? Where in the process does the error occur?

Member

Noppes 23-12-2008, 18:17

Hi, I tried it with the final Version 1.2.2 and with the nightly build from 21.12.08. Both have the same error. It happened after I klicked on the Button "Go". After that I can't use zenphoto. The Version 1.2.1. works fine.

Member

sbillard 23-12-2008, 20:16

Could you please do the following:

Using the current nightly build, modify the functions-basic.php file circa line 20. Change the define for DEBUG_ERROR from false to true and run the setup. This will give us a trace of where the query is being called.

Member

Noppes 23-12-2008, 20:31

Ok, here is the result:

About to create tables...

Warning: array_flip() [function.array-flip]: Can only flip STRING and INTEGER values! in /www/html/zenphoto/zp-core/functions.php on line 474

Warning: array_flip() [function.array-flip]: Can only flip STRING and INTEGER values! in /www/html/zenphoto/zp-core/functions.php on line 474
Done with table create!
Zenphoto Error
MySQL Query ( SELECT folder, sort_order, title, show, dynamic, search_params FROM zp_albums WHERE parentid= ORDER BY id ) failed. Error: 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 id' at line 1

Backtrace:

in query (functions.php [462])
in sortAlbumArray (class-album.php [479])
in Album->getSubAlbums (setup.php [70])
in checkAlbumParentid (setup.php [1438])

Member

sbillard 23-12-2008, 21:01

Can you install the 1.2.1 version now? This code seems to be unchanged from then.

Member

Noppes 23-12-2008, 21:07

Should I copy the 1.2.1 in the same directory and should I delete the Database?

Member

Noppes 23-12-2008, 21:22

I copied the Version 1.2.1 in the same directory and then I used the the setup.php. It works fine. I didn't delete the database. I use the same database.

Member

Noppes 23-12-2008, 21:30

I tried it again with Version 1.2.2. I get the same error. After that I couldn't open zenphoto. I get this message:

Warning: require_once(/www/html/zenphoto/themes/) [function.require-once]: failed to open stream: Invalid argument in /www/html/zenphoto/zp-core/functions.php on line 1425

Fatal error: require_once() [function.require]: Failed opening required '/www/html/zenphoto/themes/' (include_path='.:/opt/php5//lib/php') in /www/html/zenphoto/zp-core/functions.php on line 1425

If I copy Versin 1.2.1 on my webspace and run the setup again zenphoto works fine.

Member

sbillard 23-12-2008, 21:52

#10

Do you have much in the database? If you delete it you loose all your descriptions, comments, etc. All that will be left will be whatever is in the image metadata. Also, deleting the database should not be needed.

The code that setup is executing is not needed if you have successfully run the 1.2.1 release. You can delete the call on checkAlbumParentid (setup.php [1438]) and bypass it. But that code is not really the problem. Something is going wrong with album IDs. But give that a try. I have no idea at this point what could be causing the problem. It should be failing on 1.2.1 as well if it is going to fail.

You may encounter some other problem after getting past this one. If so, there is probably some problem in your database albums table. Unfortunately, you can't delete it without invalidating the images table, so deleting the database entirely and starting over would be the only solution.