Moved gallery to a new server and now I get an error

JLuerken · January 8th, 2006, 10:34 AM

Hi vBGallery Users,

I moved the gallery to another server and now I get the following error:

Database error in vBulletin 3.5.2:

Invalid SQL:

SELECT catid, title, description, parent, parentlist, catimage, imagecount, postcount, lastimageid, lastimagetitle, lastimageuserid, lastimageusername, lastimagedateline, lastpostid, lastpostuserid, lastpostusername, lastpostimagetitle, lastpostdateline
FROM vb3_adv_gallery_categories
ORDER BY;

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 '' at line 3
Error Number : 1064
Date : Sunday, January 8th 2006 @ 05:32:16 PM
Script : http://www.url.com/gallery/index.php
Referrer : http://www.url.com/forum/index.php
Classname : vb_database

I reuploaded all gallery files to make sure they are ok but I still get this error.

Can someone please help?

Chuck S · January 8th, 2006, 10:53 AM

Okay the only thread I pull up when I do a search on this query is Brian suggested the user did not upload all the required files.

Can you post links to forum and gallery? Did you upgrade vbulletin?

JLuerken · January 8th, 2006, 10:56 AM

Quote:

Originally Posted by Chuck S

Okay the only thread I pull up when I do a search on this query is Brian suggested the user did not upload all the required files.

Can you post links to forum and gallery? Did you upgrade vbulletin?

I've seen this thread also but it was vB 3.0.9 and I am using 3.5.2
I did not upgrade, I simply moved the whole board to a new server today.
This server is using a different MySQL Version and maybe this is the reason.

I reuploadad ALL Gallery Files and I also checked the tables which are ok.

Forum: http://www.clanforums.com/forum
Gallery: http://www.clanforums.com/gallery

Kind regards
jluerken

Chuck S · January 8th, 2006, 11:03 AM

Okay what mysql version is the new server using?

JLuerken · January 8th, 2006, 11:03 AM

Don't ask me why but I closed the gallery. Saved
Then I opened it again, saved and its working.

I have NO IDEA why cause I did not change anything

Mysterious things...