View Single Post
Old December 6th, 2007, 07:54 AM   #1 (permalink)
DrMirth
Junior Member
Verified Customer
 
Join Date: Sep 2003
Location: Aberdeen
Posts: 15
Send a message via MSN to DrMirth
[Fixed 2.4.1] SQL error viewing image following upgrade

Okay, next problem! When I try to view a full-size photo I receive the following error:

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT
posts.postid, posts.pagetext, posts.title, posts.userid, posts.username AS postusername, posts.dateline, posts.ipaddress AS ip, posts.iconid, posts.allowsmilie, posts.showsignature, user.*, userfield.*, usertextfield.*
,icon.title as icontitle, icon.iconpath
,avatar.avatarpath, NOT ISNULL(customavatar.filedata) AS hascustom, customavatar.dateline AS avatardateline, avatarrevision


FROM ppgal_posts AS posts
LEFT JOIN user AS user ON (posts.userid = user.userid)
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid)
LEFT JOIN icon AS icon ON (posts.iconid = icon.iconid)
LEFT JOIN reputationlevel AS reputationlevel ON (user.reputationlevelid = reputationlevel.reputationlevelid)

WHERE imageid = '8318' AND posts.visible = 1
ORDER BY posts.dateline
LIMIT 0, 10;

MySQL Error : Unknown table 'usertextfield'
Error Number : 1051
Date : Thursday, December 6th 2007 @ 08:35:35 AM
Script : http://www.aberdeen-music.com/galler...imageuser=1069

Just upgraded from v2.3 to v2.4 of VBGallery and I could view the same image fine in the previous version.

Any help would be much appreciated.
DrMirth is offline