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

[keteflips]

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:

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:

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.

[Zachery]

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