SQL Problem - Upgrading photopost to vb3.7.2
Database error in vBulletin 3.7.2:
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),
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.
|All times are GMT -5. The time now is 02:44 AM.|
Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0