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

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

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

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.

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.

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

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])

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

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

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.

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.

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.

I started the Zenphoto 1.2.2 installation with a non existing zenphoto database. So the database was empty, because Zenphoto 1.2.2 created the database. But I get the described error message. After this I copied Version 1.2.1 on my webspace and run the setup.php. I didn't touch the zenphoto database. This works fine. After this a copied Version 1.2.2 on my webspace and tried it again. But it didn't work.

I have tried to reproduce this following your steps above, but no joy. Everything works properly for me. Are you sure the copy of zenphoto 1.2.2 is not corrupt? I will release some changes to the nightly build tonight which may help--Setup will try to detect the problem and correct it. But, of coures, since I cannot recreate the situation I don't know if the detections/corrections will work.

So, tomorrow, try the nightly build.

Thanks for your help. I don't think the copy of 1.2.2 is corrupt, because I have the same problem with the final version of 1.2.2 ond two different nightly build. I tried it with two different Mysql-Version (4er Version and with the 5er Version).

So, I tried it with the nightly build from 23.12.2008.

Before the installation I get always two warnings:
PHP magic_quotes_gpc [is enabled]
Warning!

You should consider disabling magic_quotes_gpc. For more information click here.

PHP mbstring package Your internal characater set is ISO-8859-1
Warning!

Setting mbstring.internal_encoding to UTF-8 in your php.ini file is recommended to insure accented and multi-byte characters function properly.

PHP MySQL support

After that I get the error message:
About to update tables...

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

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

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

Warning: array_flip() [function.array-flip]: Can only flip STRING and INTEGER values! in /www/html/zenphoto/zp-core/functions.php on line 477
Done with table update
Fixed album 0: id was empty should have been NULL

You can now View your gallery or administer.

Do you have an album named "0"? This is what is being complained of. Have you tried running setup a second time after the above messages?

I don't have a Album. The Album-Directory is empty.

I tried an empty album. Cannot reproduce the problem with what will be tonight's build. Please give it a try tomorrow.

Hi, tried it with the nightly build from 25.12.2006 with a brand new database. But I got the same error message (warning array_flip). After that I could go to the administration page, but I get some error. See the picture http://www.nortron.de/zenphoto/zenphoto_error_2.jpg
Then I created a user and tried to log on, but I get the message:
http://www.nortron.de/zenphoto/zenphoto_error_3.jpg

Is there an albums folder? If not create one. Then create an album by creating a folder within the albums folder.

I am sorry, but since I am not able to create this problem I am not able to find out what is going wrong. I only can make guesses. There is something about your configuation that is causing this, but I do not know what.

It is looking like there is some folder in your albums folders that is causing this problem. Please add the following to functions.php circa line 192.

Add `debugLogArray('albums', $albums);` just before the line that reads `$albums_r = array_flip($albums);`

Check to be sure you do not have a file `../zp-core/debug_log.txt` if you do, delete it. Then load the admin page. Afterwords you will have the above file. Let us know the contents.