upgrade from 1.15 to 1.2 and nightly build

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

  • 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!
Sign In or Register to comment.