Announcement

Collapse
No announcement yet.

Somes errors after upgrades

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

  • Somes errors after upgrades

    After I upgraded my forum from 3.6.8 to 3.7.4, and it was still working, but when I login to my ACP and received:



    Database errorThe ABC database has encountered a problem.Please try the following:
    • Load the page again by clicking the Refresh button in your web browser.
    • Open the www.abc.com home page, then try to open another page.
    • Click the Back button to try another link.
    The www.ABC.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
    We apologise for any inconvenience.

    Database error in vBulletin 3.7.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 'svpy354.moderation.postid' in 'on clause'
    Error Number : 1054
    Date : Monday, December 8th 2008 @ 12:58:14 AM
    Script : http://www.abc.com/forum/admincp/index.php?do=home
    Referrer : http://www.abc.com/forum/admincp/index.phpIP
    Address : 123.19.197.208
    Username : atuanld
    Classname : vB_Database


    And vWhen I delete physically a topic I received :


    Database errorThe ABC database has encountered a problem.Please try the following:
    • Load the page again by clicking the Refresh button in your web browser.
    • Open the www.ABC.com home page, then try to open another page.
    • Click the Back button to try another link.
    The www.aBC.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
    We apologise for any inconvenience.

    Database error in vBulletin 3.7.4:
    Invalid SQL: DELETE FROM moderation WHERE postid = 59400 AND type = 'reply';
    MySQL Error : Unknown column 'postid' in 'where clause'
    Error Number : 1054
    Date : Monday, December 8th 2008 @ 01:07:59 AM
    Script : http://www.ABC.com/forum/inlinemod.p...ds=59399,59400
    Referrer : http://www.ABC.com/forum/inlinemod.p...adid=3843&p=IP
    Address : 123.19.197.208
    Username : atuanld
    Classname : vB_Database

    Please help me to fix them.

    Thanks all

  • #2
    You can try repair and optimize tables

    Comment


    • #3
      There is no 'postid' field in the 3.7.4 moderation table. This error is either from an old file or an add-on.

      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);


      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


      • #4
        I had tried with your advices, but it doesn't change. Ah, I think this error is made by restoring old database.

        2 weeks ago, my old hosting was died, and I only have unique file database SQL. The version at this time is vbb 3.6.8 . I 've hack many mods, and i don't have source codes of them now. After registering new host, I download from vbulletin.com source code 3.6.8, install vbb, and then restore my database. I think at this time the errors have come. After upgrading to 3.7.4, it still has much error like i describe above. I can't physically remove threads and post from member, and the error report is:
        Code:
        Database error in vBulletin 3.7.4:
        
        Invalid SQL:
        DELETE FROM moderation WHERE postid = 59649 AND type = 'reply';
        
        MySQL Error  : Unknown column 'postid' in 'where clause'
        Error Number : 1054
        Date         : Tuesday, December 9th 2008 @ 12:25:11 PM
        Script       : http://www.sinhvienphuyen.vn/forum/inlinemod.php?t=12904&p=59649&postids=59649
        Referrer     : http://www.sinhvienphuyen.vn/forum/inlinemod.php?threadid=12904&p=59649
        IP Address   : 118.69.111.249
        Username     : atuanld
        Classname    : vB_Database
        And the first screen when I log in Admin Control Panel is another Error:
        Code:
        Database error in vBulletin 3.7.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 'svpy354.moderation.postid' in 'on clause'
        Error Number : 1054
        Date         : Tuesday, December 9th 2008 @ 12:27:27 PM
        Script       : http://www.sinhvienphuyen.vn/forum/admincp/index.php?do=home
        Referrer     : http://www.sinhvienphuyen.vn/forum/admincp/index.php?do=nav
        IP Address   : 118.69.111.249
        Username     : atuanld
        Classname    : vB_Database
        And if this error appears when i choose Show all Settings from ACP
        Code:
        Database error in vBulletin 3.7.4:
        
        Invalid SQL:
        
                INSERT INTO regimage
                    (regimagehash, imagestamp, dateline)
                VALUES
                    ('fc42d130e53e9ab1698a46ba1ac6bda8', 'CZ4T9a', 1228851144);
        
        MySQL Error  : Table 'svpy354.regimage' doesn't exist
        Error Number : 1146
        Date         : Tuesday, December 9th 2008 @ 12:32:24 PM
        Script       : http://www.sinhvienphuyen.vn/forum/admincp/options.php?do=options&dogroup=%5Ball%5D
        Referrer     : http://www.sinhvienphuyen.vn/forum/admincp/options.php?null=0
        IP Address   : 118.69.111.249
        Username     : atuanld
        Classname    : vB_Database
        atuanld is the root admin of my site.
        Thanks you for reading.

        Comment


        • #5
          Hmmm...you really can't get those errors if you followed my instructions. I'm not making this up.

          All except for the last one which make be due to an older version of the Blog. You need to upgrade to 1.0.5 if you are running the Blog.
          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

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