ZenphotoCMS Forum
upgrade from 1.15 to 1.2 and nightly build - Printable Version

+- 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: upgrade from 1.15 to 1.2 and nightly build (/thread-3798.html)



upgrade from 1.15 to 1.2 and nightly build - BertSimons - 2008-09-20

after having build 2 new sites with the latest zenphoto I decided to try to upgrade my own heavily customized an wp integrated 1.15 zenphoto site to 1.2

upgrading from 1.1.5 to 1.2

I get this:

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
Zenphoto Error
MySQL Query ( SELECT id, tagid from zp_obj_to_tag WHERE objectid='196' AND type='albums' ) failed. Error: Table 'blog.zp_obj_to_tag' doesn't exist

ignoring this and checking my site, everything however works (except google maps)

upgrading from 1.2 to the latest nightly build I get the same messages during setup but when ignoring this and checking my site the site is broken and this message shows:

Zenphoto Error
MySQL Query ( SELECT tagid FROM zp_obj_to_tag WHERE type='images' AND objectid='1149' ) failed. Error: Table 'blog.zp_obj_to_tag' doesn't exist

any hints?




upgrade from 1.15 to 1.2 and nightly build - BertSimons - 2008-09-20

I manually inserted tables zp_tags and zp_obj-to_tag into my database, including the fields as described in the setup.php

now i only get About to update tables...

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