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.*
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)
WHERE images.imageid = '14673';
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.
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)