No announcement yet.

Error Number : 1109

  • Filter
  • Time
  • Show
Clear All
new posts

  • Error Number : 1109

    ihave error in Database

    Database error in vBulletin 3.5.4:

    Invalid SQL:

    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,

    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 : Friday, July 7th 2006 @ 06:38:55 AM
    Script :
    Referrer :
    IP Address : x.x.x.x
    Username : ??? ????
    Classname : vb_database

  • #2


    • #3
      This error is from a customization you've made. To troubleshoot this, remove any hacks and disable your plugins, then see if you still have this problem.

      Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

      define('DISABLE_HOOKS', true);

      If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

      Next, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it. Do you have the same problem?

      If so, this may be due to your language pack. Try the English pack to see if you have the same problem.
      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.


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