+- ZenphotoCMS Forum (https://forum.zenphoto.org)
+-- Forum: Support (https://forum.zenphoto.org/forum-1.html)
+--- Forum: General support (https://forum.zenphoto.org/forum-4.html)
+--- Thread: Upgrade to 1.0.3 mysql error (/thread-543.html)
Upgrade to 1.0.3 mysql error - climberusa - 2006-06-01
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?
Upgrade to 1.0.3 mysql error - DarrellD - 2006-06-01
You got a link so we can check it out?
Upgrade to 1.0.3 mysql error - Chilifrei64 - 2006-06-02
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?
Upgrade to 1.0.3 mysql error - climberusa - 2006-06-02
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.
Upgrade to 1.0.3 mysql error - DarrellD - 2006-06-02
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 [b]not[/b] 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.