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.