Announcement

Collapse
No announcement yet.

Database error in vBulletin 3.6.7

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Database error in vBulletin 3.6.7

    Code:
     
    This message was created automatically by mail delivery software.
    A message that you sent could not be delivered to one or more of its recipients. This is a permanent error. The following address(es) failed:
    [email protected]
    retry timeout exceeded
    ------ This is a copy of the message, including all the headers. ------
    Return-path: <[email protected]>
    Received: from nobody by server.xxxx.com with local (Exim 4.63)
    (envelope-from <[email protected]>)
    id 1I937W-0002Bm-NY
    for [email protected]; Thu, 12 Jul 2007 22:10:30 +0400
    To: [email protected]
    Subject: vBulletin Database Error!
    From: [email protected]
    Message-Id: <[email protected]>
    Date: Thu, 12 Jul 2007 22:10:30 +0400
    Database error in vBulletin 3.6.7:
    Invalid SQL:
    SELECT 
    IF(votenum >= 1, votenum, 0) AS votenum,
    IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
    
    thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
    thread.lastpost, thread.lastposter, thread.lastpostid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
    hiddencount, deletedcount
    
    
    
    
    ,post.pagetext
    FROM thread AS thread
    
    
    
    
    
    
    
    WHERE thread.threadid IN (0,29327,29438,29387,29419,29171,29220,18100) 
    ORDER BY sticky DESC, lastpost DESC;
    MySQL Error : Unknown table 'post' in field list Error Number : 1109
    Date : Thursday, July 12th 2007 @ 10:10:30 PM
    Script : http://www.xxxxxxx.net/xxxxx/forumdisplay.php?f=19
    Referrer : 
    IP Address : 212.64.xxx.10
    Username : غير مسجل
    Classname : vb_database
    how can i fix it

  • #2
    MySQL Error : Unknown table 'post' in field list

    You are either missing your post table (which would be very bad), you are using a table prefix and have not updated config.php with the correct prefix, or you are using an add-on that ignores the tabve prefix setting.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      ok how can i fix this

      Comment


      • #4
        Check the database, check he table prefixes and if all else fails remove or disable your add-ons.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment

        Loading...
        Working...
        X