Announcement

Collapse
No announcement yet.

up dateproblem

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

  • up dateproblem

    just updated from 3.6 to the latest version. while the member are looks fine, my admincp shows the following:

    Database error in vBulletin 3.8.3:

    Invalid SQL:

    SELECT COUNT(*) AS count
    FROM vb_dgtmoderation AS moderation
    INNER JOIN vb_dgtpost AS post USING (postid)
    WHERE moderation.type='reply';

    MySQL Error : Unknown column 'postid' in 'from clause'
    Error Number : 1054
    Request Date : Thursday, June 18th 2009 @ 10:35:38 PM
    Error Date : Thursday, June 18th 2009 @ 10:35:39 PM
    Script : http://www.dumagueteinfo.com/board/d...ex.php?do=home
    Referrer : http://www.dumagueteinfo.com/board/d...ex.php?do=home
    IP Address : 222.127.167.200
    Username : Rhoody
    Classname : vB_Database
    MySQL Version : 5.0.77-community


    I am sure it is something very simple, but somehow I don't get it...

    ... additional I got some pages not found (like social bookmark manager)

    thank for your help in advanced... (and pleas make it in simple words that I understand )

    cheers

    Rhoody

  • #2
    There is no postid field in the 3.8.3 moderation table. This is either from an add-on or an old file.

    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 plugins.

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

    define('DISABLE_HOOKS', true);
    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
      thanks a lot....

      Comment

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