Announcement

Collapse
No announcement yet.

printthread.php error

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

  • [Forum] printthread.php error

    hi,

    my forum when i open thread tools>show printable version > error

    Code:
    Database error in vBulletin 4.0.7:
    
    Invalid SQL:
    SELECT userid from post where threadid='10829'  AND userid=2;
    
    MySQL Error   : Table 'CXXXXX_XXX.post' doesn't exist
    Error Number  : 1146
    Request Date  : Saturday, October 9th 2010 @ 04:05:23 AM
    Error Date    : Saturday, October 9th 2010 @ 04:05:23 AM
    Script        : http://www.xxxxxx.com/printthread.php?t=10829
    Referrer      : http://www.xxxxxxx.com/xxxxxxxxx/10829xxxxxx.html
    IP Address    : 1xx.xxx.xxx.xx
    Username      : xxxxxx
    Classname     : vB_Database
    MySQL Version : 5.0.67-log

  • #2
    That indicates your 'post' table is missing. Assuming your forums are functioning fine otherwise, this is due to a modification.

    To troubleshoot this, first 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. Also be sure to upload the admincp files to whichever directory you have set in your config.php file. Then run 'Suspect File Versions' in Diagnostics to make sure you have all the original files for your version and that none show 'File does not contain expected contents':

    Admin CP -> Maintenance -> Diagnostics -> Suspect File Versions

    [Note: In some cases you may also need to remove any of the listed .xml files in the includes/xml directory.]

    Next, disable all products (except vB Blog and vB CMS if you are running the Suite.)

    Admin CP -> Plugins & Products -> Manage Products -> Disable

    Then manually uncheck all plugins that are not for 'vBulletin Blog' and vBulletin CMS' here:

    Admin CP -> Plugins & Products -> Plugin Manager

    You must do BOTH of those steps in order to disable all non vBulletin Modifications.

    Then if you still have this problem, 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?
    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
      yes problem with MARCO1 Hide All with Usergroups permission - Messages Manager mod when i disable this mod forum work well thanks sir

      Comment

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