View Full Version : 1.0.3 to 2.0 on new server
August 20th, 2006, 10:32 AM
I just upgraded to vBulletin 3.6 and transferred to a new server. I was running vbgallery 1.0 RC3 on the old server and have not installed it on the new server. Do I need to install it on the new server before upgrading to vbgallery 2.0? Or can I just install the full version of 2.0?
I don't see vbgallery upgrade/install docs online, maybe there is a link?
I have transferred all the old images to the new server, and just renewed my license (but haven't received email yet).
August 20th, 2006, 01:28 PM
You can take your upgraded forums database w/ old gallery install and update to the 2.0 gallery.
You can also do a freash install of the gallery.
August 20th, 2006, 01:51 PM
Thanks. all seems to be working fine except I get this error when sorting by rating - any ideas?
Database error in vBulletin 3.6.0:
SELECT IF(votenum >= , votenum, 0) AS votenum, IF(votenum >= AND votenum> 0, votetotal / votenum, 0) AS voteavg, images.imageid
FROM adv_gallery_images AS images
WHERE valid = 1 AND votenum >=
ORDER BY voteavg DESC, votenum DESC, images.imageid DESC
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' votenum, 0) AS votenum, IF(votenum >= AND votenum> 0, votetotal / votenum, 0) ' at line 1
Error Number : 1064
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.