PDA

View Full Version : Strange MySQL error...


WebMasterAJ
08-05-2002, 06:25 PM
Alright, I am pretty sure that I haven't seen this one... so here it goes.

Every now and then I receive an email from my boards saying this:

Database error in vBulletin 2.2.4:

Invalid SQL:
SELECT
post.*,post.username AS postusername,post.ipaddress AS
ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
attachment.attachmentid,attachment.filename,attach ment.visible AS
attachmentvisible,attachment.counter,style.title as styletitle
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS
hascustomavatar,customavatar.dateline AS avatardateline
FROM post
LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON
customavatar.userid=user.userid
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
WHERE post.postid = '49480'

mysql error: Unknown table 'style' in field list

mysql error number: 1109

Date: Monday 05th of August 2002 11:34:35 AM
Script:
http://www.finheaven.com/boardvb2/b...st&postid=49480
Referer:


I have no idea what this can possibly mean... LOL. Any ideas?

Thanks for your time....

scsa20
08-05-2002, 10:25 PM
it means that a table in field list called style isn't there thusk it means it's missing...go into the database via PHPMyAdmin or something and add the table.