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?
Comments
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!