1.0.3 to 2.0 on new server

[mooncreek]

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).

THANKS!

[Zachariah]

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.

[mooncreek]

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:

Invalid SQL:

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
LIMIT 30;

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