3.6.3 -> 3.8.4 moderation table not updated

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Meestor_X
    Senior Member
    • Apr 2006
    • 637
    • 3.8.x

    3.6.3 -> 3.8.4 moderation table not updated

    Moving servers. Created a mysql5 database and imported my 3.6.3 database into it.
    Copied my old forum files to the new server, then the 3.8.4 files overtop (without install.php)

    Ran upgrade.php but was unsuccessful in upgrading from 3.6.3 to 3.8.4 with the 3.6.3 forum intact (but offline). Maybe due to some mods I had installed.

    So....

    Deleted all files on the new server, cleared the database and imported the database again. Uploaded all 3.8.4 files to the new server and ran upgrade.php.
    This time the upgrade completed, but when it finished, trying to log into the forum, I get this error:

    Database error in vBulletin 3.8.4:
    Invalid SQL:
    SELECT COUNT(*) AS count
    FROM moderation AS moderation
    INNER JOIN post AS post USING (postid)
    WHERE moderation.type='reply';
    MySQL Error : Unknown column 'postid' in 'from clause'
    Error Number : 1054
    Request Date : Sunday, October 18th 2009 @ 04:27:18 PM
    Error Date : Sunday, October 18th 2009 @ 04:27:18 PM
    Script : http://www.xxxxx.com/forum/index.php
    Referrer :
    IP Address : 173.136.4.63
    Username : Andy
    Classname : vb_database
    MySQL Version : 5.0.81-log
    (my url changed to xxxxx for this post)

    Looking at the database, it does not have the "postid" field in the moderation table.

    Help?
    -Andy.
    http://www.checkcheckonetwo.com
    http://www.mindplacesupport.com
  • Meestor_X
    Senior Member
    • Apr 2006
    • 637
    • 3.8.x

    #2
    Ok, then...

    Could someone just tell me if I can add that field to the table?
    If so:
    Does it need any data?
    What is the schema of that table in 3.8.4 supposed to be?
    Or... Is there a documented schema of the whole database I can find so I can check that the other tables are correct?

    Thanks for any help anyone can offer.

    -Andy.
    -Andy.
    http://www.checkcheckonetwo.com
    http://www.mindplacesupport.com

    Comment

    • Lord Jordan
      New Member
      • May 2009
      • 22
      • 3.8.x

      #3
      Try disabling hooks and seeing what happens.

      Comment

      • Meestor_X
        Senior Member
        • Apr 2006
        • 637
        • 3.8.x

        #4
        Originally posted by Lord Jordan
        Try disabling hooks and seeing what happens.
        Sorry, I don't understand what that means or how to do that.

        At this point the forum won't even load as it hits that error before ever loading.
        -Andy.
        http://www.checkcheckonetwo.com
        http://www.mindplacesupport.com

        Comment

        Related Topics

        Collapse

        Working...
        😀
        😂
        🥰
        😘
        🤢
        😎
        😞
        😡
        👍
        👎