Announcement

Collapse
No announcement yet.

Database Error after Updating BBcode Manager

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

  • Database Error after Updating BBcode Manager

    After working on the Faceboook Video BB code, I saved, then immediately after, I could not access my site... giving the following error after a long period of idling.
    Prior to this Database error, I just recieved page not displayed due to capacity... etc..


    Code:
    Database error in vBulletin 4.2.2:
    
    Invalid SQL:
    
                        (SELECT 'package' AS classtype, package.packageid AS typeid, package.packageid AS packageid, package.productid AS productid, product.active AS enabled, package.class AS class
                         FROM package AS package
                         INNER JOIN product AS product
                          ON product.productid = package.productid
                          OR package.productid = 'vbulletin')
                        UNION
                        (SELECT 'contenttype' AS classtype, contenttypeid AS typeid, contenttype.packageid AS packageid, 1, 1, contenttype.class AS class
                         FROM contenttype AS contenttype)
                        UNION
                        (SELECT 'widgettype' AS classtype, widgettypeid AS typeid, widgettype.packageid AS packageid, 1, 1, widgettype.class AS class
                         FROM cms_widgettype AS widgettype);
    
    MySQL Error   : MySQL server has gone away
    Error Number  : 2006
    Request Date  : Monday, March 9th 2015 @ 07:44:44 PM
    Error Date    : Monday, March 9th 2015 @ 07:45:53 PM
    Script        : http://www.ruofficial.com/
    Referrer      : 
    IP Address    : 216.205.224.11
    Username      : SBOfficial
    Classname     : vB_Database
    MySQL Version :

  • #2
    when trying to access my admincp...
    Service Unavailable

    The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.
    Additionally, a 503 Service Unavailable error was encountered while trying to use an ErrorDocument to handle the request.

    Comment


    • #3
      If all you were doing was using the bbcode manager, I think it's likely that it has nothing to do with what you were working on. You should contact your host and tell them you're having a problem.

      Comment


      • #4
        Code:
        Database error in vBulletin 4.2.2:
        
        Invalid SQL:
        
                            (SELECT 'package' AS classtype, package.packageid AS typeid, package.packageid AS packageid, package.productid AS productid, product.active AS enabled, package.class AS class
                             FROM package AS package
                             INNER JOIN product AS product
                              ON product.productid = package.productid
                              OR package.productid = 'vbulletin')
                            UNION
                            (SELECT 'contenttype' AS classtype, contenttypeid AS typeid, contenttype.packageid AS packageid, 1, 1, contenttype.class AS class
                             FROM contenttype AS contenttype)
                            UNION
                            (SELECT 'widgettype' AS classtype, widgettypeid AS typeid, widgettype.packageid AS packageid, 1, 1, widgettype.class AS class
                             FROM cms_widgettype AS widgettype);
        
        MySQL Error   : MySQL server has gone away
        Error Number  : 2006
        Request Date  : Tuesday, March 10th 2015 @ 02:20:35 PM
        Error Date    : Tuesday, March 10th 2015 @ 02:21:20 PM
        Script        : http://Database error in vBulletin 4.2.2:
        
        Invalid SQL:
        
                            (SELECT 'package' AS classtype, package.packageid AS typeid, package.packageid AS packageid, package.productid AS productid, product.active AS enabled, package.class AS class
                             FROM package AS package
                             INNER JOIN product AS product
                              ON product.productid = package.productid
                              OR package.productid = 'vbulletin')
                            UNION
                            (SELECT 'contenttype' AS classtype, contenttypeid AS typeid, contenttype.packageid AS packageid, 1, 1, contenttype.class AS class
                             FROM contenttype AS contenttype)
                            UNION
                            (SELECT 'widgettype' AS classtype, widgettypeid AS typeid, widgettype.packageid AS packageid, 1, 1, widgettype.class AS class
                             FROM cms_widgettype AS widgettype);
        
        MySQL Error   : MySQL server has gone away
        Error Number  : 2006
        Request Date  : Tuesday, March 10th 2015 @ 02:20:35 PM
        Error Date    : Tuesday, March 10th 2015 @ 02:21:20 PM
        Script        : http://domain/
        Referrer      :
        IP Address    : 216.205.224.10
        Username      : SBOfficial
        Classname     : vB_Database
        MySQL Version : Database error in vBulletin 4.2.2:
        
        Invalid SQL:
        
                            (SELECT 'package' AS classtype, package.packageid AS typeid, package.packageid AS packageid, package.productid AS productid, product.active AS enabled, package.class AS class
                             FROM package AS package
                             INNER JOIN product AS product
                              ON product.productid = package.productid
                              OR package.productid = 'vbulletin')
                            UNION
                            (SELECT 'contenttype' AS classtype, contenttypeid AS typeid, contenttype.packageid AS packageid, 1, 1, contenttype.class AS class
                             FROM contenttype AS contenttype)
                            UNION
                            (SELECT 'widgettype' AS classtype, widgettypeid AS typeid, widgettype.packageid AS packageid, 1, 1, widgettype.class AS class
                             FROM cms_widgettype AS widgettype);
        
        MySQL Error   : MySQL server has gone away
        Error Number  : 2006
        Request Date  : Tuesday, March 10th 2015 @ 02:20:35 PM
        Error Date    : Tuesday, March 10th 2015 @ 02:21:20 PM
        Script        : http://www.domain.com/
        Referrer      :
        IP Address    : 216.205.224.10
        Username      : SBOfficial
        Classname     : vB_Database
        MySQL Version : /
        Referrer      :
        IP Address    : 216.205.224.10
        Username      : SBOfficial
        Classname     : vB_Database
        MySQL Version :
        seems more like vb.. but I may be wrong.. I cannot access the site at all, this DB area seems to reference vb.
        Last edited by concepts; Tue 10 Mar '15, 6:32am.

        Comment


        • #5
          Well, OK, but it looks like it's either a problem with the databse being corrupted, or else a problem with the db server.

          Do you have phpMyAdmin, and can you look at the database that way? If so, on the page where you see the list of tables in your database, scroll to the bottom and check the "check all" box. Then in the "With Selected" menu choose "Check Table" and press the Go button. If any tables have problems, you can try to repair them the same way.

          If you have free support from your host, it still might be a good idea to explain the problem you're having to them. It could save you a lot of time if they can tell you what's wrong.

          Comment

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