Home› General support

Failed Installation Version 1.2.2

Noppes Member
in General support
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

Comments

  • sbillard Member
    What is the release level of your installation? Where in the process does the error occur?
  • Noppes Member
    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.
  • sbillard Member
    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.
  • Noppes Member
    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])
  • sbillard Member
    Can you install the 1.2.1 version now? This code seems to be unchanged from then.
  • Noppes Member
    Should I copy the 1.2.1 in the same directory and should I delete the Database?
  • Noppes Member
    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.
  • Noppes Member
    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.
  • sbillard Member
    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.
  • Noppes Member
    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.
  • sbillard Member
    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.
  • Noppes Member
    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).
  • Noppes Member
    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.
  • sbillard Member
    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?
  • Noppes Member
    I don't have a Album. The Album-Directory is empty.
  • sbillard Member
    I tried an empty album. Cannot reproduce the problem with what will be tonight's build. Please give it a try tomorrow.
  • Noppes Member
    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
  • sbillard Member
    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.
  • sbillard Member
    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.
  • Noppes Member
    With a empty album folder I get this log-file:
    Array albums( 0 => , 1 => )
    Array albums( 0 => , 1 => )
    Array albums( 0 => , 1 => )
    Array albums( 0 => , 1 => )
    Array albums( 0 => , 1 => )
    Array albums( 0 => , 1 => )
    Array albums( 0 => , 1 => )
    Array albums( 0 => , 1 => )
  • Noppes Member
    The Adminpage told me this:
    Gallery Stats

    * 0 images
    * 2 albums
    * 0 comments

    But the Album dir is empty.....
  • Noppes Member
    When I go to my zenphoto side 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 1432

    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 1432

    Only the adminpage works.
  • Noppes Member
    Hello Sbillard,

    thanks for all your help. If I give you a ftp-account to my webspace and a account to the mysql-database is this helpful to find the bug?
  • sbillard Member
    Can you look at the above file in an editor which will show you non-displaying characters? If we take the output literally, there are two "folders" in your albums directory with an empty string as the filename. That is unlikely both from an operating system standpoint.

    I could possibly debug this with access to your site as you describe. Send email to stephen (at) sbillard (dot) org.
  • dede Member
    He Guys I'm having the very same issue. Did you 2 found a workaround eventually?
  • sbillard Member
    There is a fix for Nopes problem included in the nightly builds. So if that it the problem you have, install the nightly.
  • mg Member
    what is the "the nightly"
  • sbillard Member
    http://www.zenphoto.org/files/nightly/
  • acrylian Administrator, Developer
    Here is an explanation: http://www.zenphoto.org/2008/08/zenphoto-glossary/
Sign In or Register to comment.