Home› General support

Upgrade to 1.0.3 mysql error

climberusa Member
in General support
Hi,
My first post so I must first thank you for such a cool gallery and it's open-sourcedness(is that a word?)!

I just upgraded to 1.0.3 and when I go to an album>image I get this error"
MySQL Query ( UPDATE zp_images SET width=2048, height=1536 WHERE id=13; ) Failed. Error: Unknown" and no image. However, it links to the full-size image as it should.

I'm using a modified theme but I also tried the default theme and it is the exact same result. Has anyone experienced this yet? Anybody know how I ca fix this? I'm assuming it has to do with the tables being modified?

Comments

  • DarrellD Member
    You got a link so we can check it out?
  • Chilifrei64 Member
    just through fishin around with path names I found this
    http://www.akclimber.com/gallery/anchorage-bouldering/8-20-03+030.jpg
    which shows the error. Incase you are lookin GameDudeX.

    Ill see what I can find too.

    In the mean time.. 2 questions..
    Did you run the upgrade.php and did you clear the cache?
  • climberusa Member
    Sorry, I always forget to post a link, but it looks liek you found it.

    Yes I ran update.php and then cleared my cache.
  • DarrellD Member
    Was this an update or a new install?

    If it was an update, make sure that your new config (zp-config.php) sets this line:
    `$conf['mysql_prefix'] = "zp_";`
    to be the same prefix as your old config (config.php).

    If they were not the same, correct it, then run update.php again.

    ---

    Or you can just go into your mysql database and make sure that the line above matches the prefix of the current tables in your database.
Sign In or Register to comment.