No announcement yet.

Database error

  • Filter
  • Time
  • Show
Clear All
new posts

  • Database error

    Help! I went into my vBulletin v 2.3.4 and in the threads I get the following message:

    Database error in vBulletin 2.3.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
    ,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 IN (0,27889,27905,28225)
    ORDER BY dateline
    mysql error: Column 'dateline' in order clause is ambiguous
    mysql error number: 1052
    Date: Wednesday 07th of July 2004 06:24:48 PM
    Script: http://forum.lowcarbtransformation.c...&threadid=2660
    Referer: http://forum.lowcarbtransformation.c...?s=&forumid=84
    Anyone have any ideas as to what may be the problem. If you havent already guessed, I am SOOO green when it comes to this stuff. I won't make it your lifes work if you just steer me in the right direction.

    Thanks so much.


  • #2
    Your host has upgraded MySQL to an unstable version (4.1.x-alpha)

    You shoud ask them to downgrade to the latest stable version which is 4.0.20.

    This is a known MySQL bug,
    Scott MacVicar

    My Blog | Twitter


    • #3
      Posted this si the wrong forum. I repostred in VB3 forum. SOrry...
      Last edited by kevinrstruck; Wed 7 Jul '04, 7:32pm. Reason: Wrong forum


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