DB Error after changing servers

[StarBuG]

Hi

After we changed the server I get the following error:

Datenbankfehler in vBulletin 3.8.2:

Invalid SQL:

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

MySQL-Fehler : 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
Fehler-Nr. : 1064
Fehler-Zeit : Tuesday, 23.06.2009 @ 12:27:03
Datum : Tuesday, 23.06.2009 @ 12:27:03
Skript : http://www.domain.de/gallery/
Referrer :
IP-Adresse : *.*.*.*
Benutzername : me
Klassenname : vB_Database
MySQL-Version : 5.0.32-Debian_7etch10


Plz help

I use: PhotoPost vBGallery 2.4.3
I reinstalled the plugin with overwrite but that did not help

Thanks in advance

[Chuck S]

Are you sure all tables where copied over?

Looking at that query the only issue I see is the order by statement is blank. Check your gallery settings and make sure the sortby is not blank.

[StarBuG]

If I change gallery category settings I get this error:

Datenbankfehler in vBulletin 3.8.2:

Invalid SQL:
SELECT catid, styleid, title, title_clean, allowusercats, catuserid, membercat, parent, parentlist, hasimages, password, active, options, useroptions, styleoverride FROM ppgal_categories ORDER BY , hasimages;

MySQL-Fehler : 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 ' hasimages' at line 1
Fehler-Nr. : 1064
Fehler-Zeit : Tuesday, 23.06.2009 @ 20:18:19
Datum : Tuesday, 23.06.2009 @ 20:18:19
Skript : http://www.domain.de/admincp/vba_gal...hp?do=saveopts
Referrer : http://www.domain.de/admincp/vba_gal...modifysettings
IP-Adresse : ip
Benutzername : me
Klassenname : vB_Database
MySQL-Version : 5.0.32-Debian_7etch10

We made a complete database dump so all tables are copied over

[Chuck S]

See here is the issue as I see it

Content visible to verified customers only.

See how on this copied site your gallery options for sortby and sortdirection are empty. These settings are in your main settings in vbgallery admin.

Category Display Order
Here you may choose to order categories by either the display order specified with each category, or alphabetically.

Category Display Direction
The default direction that categories should appear in.

[StarBuG]

there is a selection in every setting of vbgallery (ascending, alphabetical, etc), and if I try to save the settings I get the second mysql error.

do you have a db query I can run?

[Chuck S]

UPDATE ppgal_settings SET value='displayorder' WHERE varname='gallery_catsorderby';

UPDATE ppgal_settings SET value='ASC' WHERE varname='gallery_catsdirection';

Those are default queries you should use to update those settings.

[StarBuG]

Thanks, that worked.

Don't know what did go wrong there.

[Chuck S]

Well I would make sure all your options exist really.

Just go over things and make sure everything works. It seems to me maybe some settings and other stuff did not make it over when you where moving database tables etc into the new server.