Member
Member
BertSimons   2008-09-20, 16:39
#1

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?

Member
Member
BertSimons   2008-09-20, 19:06
#2

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!

  
Powered By MyBB, © 2002-2026 MyBB Group.
Made with by Curves UI.