+- ZenphotoCMS Forum (https://forum.zenphoto.org)
+-- Forum: Support (https://forum.zenphoto.org/forum-1.html)
+--- Forum: General support (https://forum.zenphoto.org/forum-4.html)
+--- Thread: mysql requirements zenphoto 1.2 (/thread-3812.html)
mysql requirements zenphoto 1.2 - BertSimons - 2008-09-23
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
mysql requirements zenphoto 1.2 - sbillard - 2008-09-23
We did correct this in the nightly builds. Did you try them?
mysql requirements zenphoto 1.2 - BertSimons - 2008-09-23
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..
mysql requirements zenphoto 1.2 - BertSimons - 2008-09-30
nightly build 30th september does not give any problems anymore. fresh installs and upgrading work fine..