+- 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: MySQL Error on sorting after upgrade (/thread-213.html)
MySQL Error on sorting after upgrade - RoQ - 2006-01-11
hi, i have upgrade zenphoto to 1.0 without problems, everything was fine until i was sorting the albums and when i click on "Save Order", i get this huge a scary error:
`
MySQL Query ( UPDATE albums SET sort_order='1' WHERE id=23 ) Failed. Error: Unknown column 'sort_order' in 'field list'
`
help please i dont know about MySQL.
MySQL Error on sorting after upgrade - RoQ - 2006-01-11
solved, just login in the admin, after that i go to upgrade.php and now it worked, maybe the first time when i log from upgrade.php it didnt upgrade the tables.
MySQL Error on sorting after upgrade - bensp - 2006-01-29
RoQ - I had the same problem - it didnt seem to upgrade it the first time it was run. Thanks for the fix