No announcement yet.

Database error

  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] Database error

    help me with this plezzzz

    Database error in vBulletin 4.0.3:
    Invalid SQL:
                            IF(votenum >= 1, votenum, 0) AS votenum,
                            IF(votenum >= 1 AND votenum > 0, votetotal  / votenum, 0) AS voteavg,
                     post.pagetext AS thumb,
                            thread.threadid, thread.title AS threadtitle,  thread.forumid, pollid, open, postusername, postuserid, thread.iconid AS  threadiconid,
                            thread.dateline, notes, thread.visible, sticky,  votetotal, thread.attach, thread.lastpost, thread.lastposter,  thread.lastposterid, thread.lastpostid, thread.replycount,  IF(thread.views<=thread.replycount, thread.replycount+1,  thread.views) AS views,
                            thread.prefixid, thread.taglist, hiddencount,  deletedcount,
                            user.usergroupid, user.homepage, user.options AS  useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend
                    FROM thread AS thread
                            LEFT JOIN user AS user ON (user.userid =  thread.lastposterid)
                            LEFT JOIN userlist AS userlist ON  (userlist.relationid = user.userid AND userlist.type = 'buddy' AND  userlist.userid = 0)
                    WHERE thread.threadid IN (0)
                    ORDER BY sticky DESC, lastpost DESC;
    MySQL Error   : Unknown column 'post.pagetext' in 'field list'
    Error Number  : 1054
    Request Date  : Saturday, May 15th 2010 @ 05:49:09 PM
    Error Date    : Saturday, May 15th 2010 @ 05:49:09 PM
    Script        : [URL][/URL]
    Referrer      :
    IP Address    :
    Username      : Unregistered
    Classname     : vB_Database
    MySQL Version :

  • #2
    It looks like this is from a modification. Try disabling your modifications/plugins and see if you still have this problem.
    Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

    PHP Code:

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools &lt;- awesome site for html/css help


    • #3
      What was the latest mod/modification you did to your forum prior to getting that issue?


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