October 22nd, 2005, 10:20 AM
|
#2 (permalink)
|
| Member Verified Customer
Join Date: Jan 2005
Posts: 118
| Re: restoring vba_gallery database to 3.5
and when i click on the only thumbnails showing ..it gives me this Quote:
Database error in vBulletin 3.5.0:
Invalid SQL:
SELECT 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, customfields.*
,NOT ISNULL(favorites.imageid) AS favid
,NOT ISNULL(subscribeimage.imageid) AS issubscribed
, exifinfo
FROM adv_gallery_images AS images
LEFT JOIN adv_gallery_categories AS categories ON (images.catid = categories.catid)
LEFT JOIN adv_gallery_customfields_entries AS customfields ON (images.imageid = customfields.imgid)
LEFT JOIN adv_gallery_favorites AS favorites ON (favorites.imageid = images.imageid AND favorites.userid = 1)
LEFT JOIN adv_gallery_subscribeimage AS subscribeimage ON (subscribeimage.imageid = images.imageid AND subscribeimage.userid = 1)
LEFT JOIN adv_gallery_exif AS exif ON (images.imageid = exif.imageid)
WHERE images.imageid = '9495';
MySQL Error : Unknown column 'membercat' in 'field list'
Error Number : 1054
Date : Saturday, October 22nd 2005 @ 03:20:24 PM
Script : http://www.maroceve.com/gallery/show...atid=newimages
Referrer : http://www.maroceve.com/gallery/
IP Address : 81.192.222.248
Username : Ez
Classname : vb_database
| |
| |