Announcement

Collapse
No announcement yet.

Unknown table 'post' in field list

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

  • Unknown table 'post' in field list

    I got this error. How can I fix it ?
    Database error in vBulletin 3.5.3:

    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, lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
    hiddencount


    ,post.pagetext
    FROM thread AS thread






    WHERE thread.threadid IN (0)
    ORDER BY sticky DESC, thread.lastpost DESC;

    MySQL Error : Unknown table 'post' in field list
    Error Number : 1109
    Date : Thursday, August 17th 2006 @ 05:30:35 PM
    Script : http://www.mydomain.info/forum/forumdisplay.php?f=46
    Referrer : http://www.mydomain.info/forum/
    IP Address : 75.32.165.174
    Username : guest
    Classname : vB_Database


  • #2
    Are you still getting this error? If not, then I would consider it a fluke because if you really were missing your post table your forums wouldn't be working.
    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
      The post table is not mentioned in the FROM-clause, so it is unknown within this query.

      This is very likely caused by a modification that you have installed. Please turn off the Plugin system and see if that fixes your problem.
      Want to take your board beyond the standard vBulletin features?
      Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

      Comment


      • #4
        well, I still get it, I also have the same question with you. I have tried to optimize and repair, It doesn;t help me

        Comment


        • #5
          Please see my reply. Repairing the database will not fix this problem. It is a problem that is probably caused by a modification you have installed.
          Want to take your board beyond the standard vBulletin features?
          Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

          Comment


          • #6
            i'm getting exact same database error since last night , 200 database errors have been sent to my email address , i'm using version 4.0.1

            Comment


            • #7
              Originally posted by YankForum View Post
              i'm getting exact same database error since last night , 200 database errors have been sent to my email address , i'm using version 4.0.1
              You are not getting the exact error since the query is from 3.5 and you are running 4.x. You should start your own thread and post the exact error you are getting so we can help you.

              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 vbulletin.org
              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

              Comment

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