PhotoPost Community - 1.0.3 to 2.0 on new server

PhotoPost Community (http://www.photopost.com/forum/)

- Installs and Upgrade - vBulletin 3.6x (http://www.photopost.com/forum/installs-upgrade-vbulletin-3-6x/)

- - 1.0.3 to 2.0 on new server (http://www.photopost.com/forum/installs-upgrade-vbulletin-3-6x/126756-1-0-3-2-0-new-server.html)

mooncreek

August 20th, 2006 10:32 AM

1.0.3 to 2.0 on new server

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

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.

mooncreek

August 20th, 2006 01:51 PM

Thanks. all seems to be working fine except I get this error when sorting by rating - any ideas?

Quote:

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

All times are GMT -5. The time now is 02:07 PM.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97