Lots of database errors

[alexongaro]

Since I've upgraded my forum to the latest vBulletin version, I'm having a lot of database and php errors. Most of the time it's just a connection error (even though I can connect to the database through phpMyAdmin).
Today my site is down with the following error:

Database error in vBulletin :

Invalid SQL:

SELECT *
FROM vb3_datastore
WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','la nguagecache','products','pluginlist','cron','profilefield','userstats','birthdaycache','ma xloggedin','iconcache','eventcache','mailqueue');

MySQL Error : Got error 12 from storage engine
Error Number : 1030
Date : Tuesday, January 2nd 2007 @ 01:55:35 AM
Script : http://www.renderglobal.org/forum_closed/
Referrer :
IP Address : xx.xx.xx.xx
Username :
Classname : vb_database

I had to rename my forum path due to the massive e-mails I'm getting.

If you go to renderglobal.org/forum_closed you get the following:

Warning: mysql_query() [function.mysql-query]: Unable to save result set in /includes/class_core.php on line 363

Any idea?

Thanks,
Alex

[alexongaro]

Since I can connect to the CP, I analyzed the database through phpMyAdmin and found a lot of corrupted tables. I was able to repair all of them but the following:

renderglobal_org_-_vB_2004.vb3_customprofilepic ¦ repair ¦error 12 ¦when fixing table

[alexongaro]

Still me. After fixing those tables (except the customprofilepic that I think I need to recreate but I don't know how) I was finally able to connect to the adminCP, but I'm still getting mySql errors, at least 1 time out of 3.

Invalid SQL:

SELECT setting.*, settinggroup.grouptitle
FROM vb3_settinggroup AS settinggroup
LEFT JOIN vb3_setting AS setting USING(grouptitle)
WHERE settinggroup.displayorder <> 0
ORDER BY settinggroup.displayorder, setting.displayorder;

MySQL Error : Got error 12 from storage engine
Error Number : 1030
Date : Tuesday, January 2nd 2007 @ 02:34:57 AM
Script : http://www.renderglobal.org/forum_cl...ons.php?null=0
Referrer : http://www.renderglobal.org/forum_cl...dex.php?do=nav
IP Address : xx.xx.xx.xx
Username : *****************
Classname : vb_database

I asked support to my host, but they believe (as always) the problem is on the vBulletin software but I doubt it.

[Boxy]

This is a server issue:

System error: 12 = Cannot allocate memory

You need to contact your host about this. They will probably need to reboot the server to fix this.

[alexongaro]

That's what I thought and I told them, but they keep on saying they don't see any error. I'm really thinking about changing server..

[Fuzzy Orange]

You dont by anychance use mediatemple for your hosting do you?

I'm having this exact same problem

[alexongaro]

Yes I do!!