The Arcive of vBulletin Modifications Site. |
|
Strange MySQL error... Details »»
|
|||||||||||||||||||||||||
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.... Show Your Support
|
|||||||||||||||||||||||||
| Comments |
|
#2
|
||||
|
||||
|
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.
|
![]() |
|
|