February 26th, 2008, 09:51 AM
|
#1 (permalink)
|
| Guest | MySQL Error
Quote:
Database error in vBulletin 3.6.8:
Invalid SQL:
SELECT categories.title AS cattitle, categories.description AS catdesc, images.imageid, username, images.userid, images.title, images.catid, dateline, images.description, keywords, filename, thumbname, width, height, extension, filesize, originalname, originalfilesize, originalwidth, originalheight, views, posts, valid, open, sticky, votenum, votetotal, options, catimage, catuserid, membercat, useroptions, adv_setting, customfields.*
L
L
L
FROM ppgal_images AS images
LEFT JOIN ppgal_categories AS categories ON (images.catid = categories.catid)
LEFT JOIN ppgal_customfields_entries AS customfields ON (images.imageid = customfields.imgid)
L
L
L
WHERE images.imageid = '14673';
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 'L
L
FROM ppgal_images AS images
LEFT JOIN ppgal_categories AS categories O' at line 3
Error Number : 1064
Date : Tuesday, February 26th 2008 @ 08:59:12 AM
Script : http://www.tripsmarter.com/gallery/s...atid=newimages
Referrer : http://www.tripsmarter.com/gallery/
Classname : vb_database
|
I started getting this error last Friday when a logged in user tried to view an image, so I upgraded from 2.0 to the current version.
I'm still getting this error when someone is logged in after the upgrade.
I had problems upgrading, it stalled halfway through. I had to restore my DB and upgrade again. Everything seems fine except for this error and I don't have the vBGallery dropdown in the left hand nav of the admincp.
The post below is the exact same error: http://www.photopost.com/forum/archi.../t-134331.html |
|
|  |