No announcement yet.

Strange MySQL error...

  • Filter
  • Time
  • Show
Clear All
new posts

  • Strange MySQL error...

    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:
    post.*,post.username AS postusername,post.ipaddress AS
    ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
    attachment.attachmentid,attachment.filename,attachment.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
    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

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

    Thanks to everyone who has been patient with my problems... I know I don't have many, but the few past problems have been like "did you read the sticky?" Sorry... I don't think I saw this problem...

    Thanks again! Now I'm gonna go back to messin around in the vB3 demo
    Andrew Tatum
    FinHeaven & Co - Get Splashed With FinForMation
    The FinHeaven & Co Forums - Your Opinion, Your Team, Speak It Here

  • #2
    That'd be from a hack -- one that shows your selected style I believe. Check at or upload an unmodified version of showthread.php.


    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.