SQL Problem - Upgrading photopost to vb3.7.2
 

Hey!

Database error in vBulletin 3.7.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 d d, hasimages;

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 'd, hasimages' at line 1
Error Number : 1064
Request Date : Wednesday, October 15th 2008 @ 11:47:45 AM
Error Date : Wednesday, October 15th 2008 @ 11:47:47 AM
Script : http://www.x.com/forum/admincp/vbgallery_install.php
Referrer : http://www.x.com/forum/admincp/vbgallery_install.php
IP Address : 000.000.000.00
Username : x
Classname : vB_Database
MySQL Version : 5.0.51a-community-log

Sorry just to add, i have a file backup ( and sql... ) from the old photogallery, where can i find the old version number so i can tell you guys ?

How is this error generated doing what the upgrade?

Yes I would need to know what version your vbgallery is so we can assist.

Hey again! Thanks for replying.

Ok, this error happens from the http://www.x.com/forum/admincp/vbgallery_install.php

After i logg inn as admin, i click Upgrade. Then it happens.

How can i find my version number from the file backup or SQL backup ?

You can find your version number in the settings table of vbgallery

SELECT value FROM ppgal_setting WHERE varname='gallery_version'

('gallery_version', 'adv_gallery_main', '2.0', '1.0.1 (vB 3.5)', 'hidden', 1),

yep.


Edit:

Any clues on what we can do to upgrade ?

I would have to look at your install as I do not see that query in any upgrade version

You can send full server details url and admin logins etc through the contact link in the header.