mysql requirements zenphoto 1.2

BertSimons

I think the requierements on the frontpagepage need to be adjusted, the utf-8 character set as used for the tables was only introduced in mysql 4.1,
installation on 3.23.58 fails on fresh installs. installation on 4.1 and above however flawless.

zenphoto 1.5 still does work on 3.23

sbillard

We did correct this in the nightly builds. Did you try them?

BertSimons

tadays nightly build gives also gives error ¨not able to create table zp_obj_to_tag¨ on first run.

on second run though... not... but only:

About to update tables...
Table creation failure: You have an error in your SQL syntax near 'CHARACTER SET utf8' at line 6
Table creation failure: You have an error in your SQL syntax near 'CHARACTER SET utf8' at line 6
Table creation failure: You have an error in your SQL syntax near 'CHARACTER SET utf8' at line 7
Done with table update with errors

then I can log-in to zenphoto, edit etc but when browsing pages I get:

MySQL Query ( SELECT `tagid` FROM `zp_obj_to_tag` WHERE `type`='albums' AND `objectid`='1' ) failed. Error: Table 'bert200809.zp_obj_to_tag' doesn't exist

see :http://www.bertsimons.nl/zenphototest/test/

Inserting table zp_obj_to_tag into database by hand solves did but should not be like that off course..

ps I run zenphoto on several domains and only this one which still uses 3.23.58 has this problem..
other ones with 4.1 or higher don give any problem installing..

BertSimons

nightly build 30th september does not give any problems anymore. fresh installs and upgrading work fine..