MySQL Error

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

[Zachariah]

Have you add a PHP cache software to the server ?

The only software that we've added is phpmotion (youtube clone), but that was 3+ weeks ago. I started getting this error last Friday 02-22-2008.

I edited some of the templates/core files for the gallery, but on the upgrade every file/template was replaced.

In case anyone else has this problem, I commented out lines 295-297 and lines 301-303 in showimage.php (see below). I haven't seen any adverse effects.

295 - /*$query[favfields]
296 - $query[subfields]
297 - $query[exiffields]*/
298 - FROM " . TABLE_PREFIX . "ppgal_images AS images
299 - LEFT JOIN " . TABLE_PREFIX ."ppgal_categories AS categories ON (images.catid = categories.catid)
300 - LEFT JOIN " . TABLE_PREFIX . "ppgal_customfields_entries AS customfields ON (images.imageid = customfields.imgid)
301 - /*$query[favjoin]
302 - $query[subjoin]
303 - $query[exifjoin]*/

[Luciano]

Originally Posted by tripsmarter.com

In case anyone else has this problem, I commented out lines 295-297 and lines 301-303 in showimage.php (see below). I haven't seen any adverse effects.

295 - /*$query[favfields]
296 - $query[subfields]
297 - $query[exiffields]*/
298 - FROM " . TABLE_PREFIX . "ppgal_images AS images
299 - LEFT JOIN " . TABLE_PREFIX ."ppgal_categories AS categories ON (images.catid = categories.catid)
300 - LEFT JOIN " . TABLE_PREFIX . "ppgal_customfields_entries AS customfields ON (images.imageid = customfields.imgid)
301 - /*$query[favjoin]
302 - $query[subjoin]
303 - $query[exifjoin]*/

Well there will be some adverse effects...
$query[subfields] AND $query[subjoin]
==> you will not see any custom fields.. (thats ok if you dont have defined any)
$query[exiffields] AND $query[exifjoin]
==> thats ok.. because it never really worked...
BUT
$query[favfields] AND $query[favjoin]
==> you will loose some favorites functionality!!!!

try to reenable those last 2 (by not commenting them out)

Luc