Announcement

Collapse
No announcement yet.

Error after upgrade from 4.2.0 Patch Level 1 to 4.2.0 Patch Level 2

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

  • [Forum] Error after upgrade from 4.2.0 Patch Level 1 to 4.2.0 Patch Level 2

    After upgrade from "4.1.12 Patch Level 1" to "4.2.0 Patch Level 2" I can't enter to the VBulletin options in the control panel, I get this error:

    Code:
    Database error in vBulletin 4.2.0:
    
    Invalid SQL:
    
    
            SELECT setting.*, settinggroup.grouptitle
            FROM settinggroup AS settinggroup
            LEFT JOIN setting AS setting USING(grouptitle)
            WHERE settinggroup.displayorder <> 0
            ORDER BY settinggroup.displayorder, setting.displayorder;
    
    
    MySQL Error   : Got error 28 from storage engine
    Error Number  : 1030
    Request Date  : Saturday, August 25th 2012 @ 11:25:43 AM
    Error Date    : Saturday, August 25th 2012 @ 11:25:43 AM
    Script        : http://rs-club.org/admincp/options.php?null=0
    Referrer      : http://rs-club.org
    IP Address    : 83.32.59.85
    Username      : keteflips
    Classname     : vB_Database
    MySQL Version : 5.1.63-rel13.4-log
    And this other error when I go to Articles:

    Code:
    Database error in vBulletin 4.2.0:
    
    Invalid SQL:
    SELECT node.nodeid, node.url, node.parentnode, node.nodeleft, node.noderight,
                node.setpublish, node.publishdate, info.title, node.permissionsfrom, node.hidden, COUNT(child.nodeid) AS children,
                  SUM(CASE WHEN (child.setpublish > 0 AND child.publishdate < 1345912035 AND child.contenttypeid <> 23) THEN 1 ELSE 0 END) AS publish_count
                FROM cms_node AS node
                LEFT JOIN cms_node AS child ON child.parentnode = node.nodeid AND child.new != 1
                LEFT JOIN cms_nodeinfo AS info ON info.nodeid = node.nodeid
                WHERE (node.contenttypeid = 23)
                GROUP BY node.nodeid, node.url, node.parentnode, node.nodeleft, node.noderight,
                node.setpublish, node.publishdate, info.title, node.permissionsfrom, node.hidden  HAVING COUNT(child.nodeid) > 0 
                ORDER by node.nodeleft;;
    
    
    MySQL Error   : Got error 28 from storage engine
    Error Number  : 1030
    Request Date  : Saturday, August 25th 2012 @ 11:27:15 AM
    Error Date    : Saturday, August 25th 2012 @ 11:27:15 AM
    Script        : http://rs-club.org/content.php
    Referrer      : http://rs-club.org
    IP Address    : 83.32.59.85
    Username      : keteflips
    Classname     : vB_Database
    MySQL Version : 5.1.63-rel13.4-log

    I try with the repair and optimize tables but don't works.
    Last edited by keteflips; Sat 25 Aug '12, 9:27am.

  • #2
    MySQL Error : Got error 28 from table handler

    Error Code 28 (No space left on device):
    Got error 28 from table handler means your server's mysql partition for your mysql database ran out of disk space or that the /tmp directory ( http://www.mysql.com/doc/T/e/Temporary_files.html )on your server doesn't have enough space, you need to

    1. close your forum to prevent further posting or writing to the database
    2. contact your web host
    3. or if your host yourself on a dedicated server, you need to move your mysql partition to a larger disk or change the /tmp directory location via your servers my.cnf file

    Comment

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