RVMAN
02-06-2012, 02:22 PM
I keep getting sql problems with my Vbulletin suite hosted on Yahoo. Usually there is no error message but I repair the database and then it works this time repair database does not work.
I can log in pick post new message but when I try and post the message get this error?
Database error in vBulletin 4.1.8:
Invalid SQL:
SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = 'vb_types.types';
MySQL Error : Table './vbulletin/cache' is marked as crashed and last (automatic?) repair failed
Error Number : 144
Request Date : Monday, February 6th 2012 @ 07:12:38 AM
Error Date : Monday, February 6th 2012 @ 07:12:38 AM
Script : http://www.rvman.net/vbulletin/showthread.php?186-February-2012
Referrer : http://www.rvman.net/vbulletin/forumdisplay.php?27-RVMAN-Daily-Log
IP Address : 75.222.59.235
Username : rvman
Classname : vB_Database
MySQL Version : 5.1.55
Anyone know what the problem is I am running mysql V5. something on Yahoo.
Thanks
Bruce
--------------- Added 1328543060 at 1328543060 ---------------
Well got it fixed cleared my cache and went into the Vbulletin admin maintenance and rebuilt the mysql now it works again but no sure why I keep getting these sql problems all the time anyone else hosting with Yahoo?
--------------- Added 1328543202 at 1328543202 ---------------
Well went into the maintenance in the admin panel cleared the cache and fixed the my sql database and now it works again.
But not sure why I keep getting the sql errors all the time is anyone else hosting with Yahoo and having sql problems all the time?
I can log in pick post new message but when I try and post the message get this error?
Database error in vBulletin 4.1.8:
Invalid SQL:
SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = 'vb_types.types';
MySQL Error : Table './vbulletin/cache' is marked as crashed and last (automatic?) repair failed
Error Number : 144
Request Date : Monday, February 6th 2012 @ 07:12:38 AM
Error Date : Monday, February 6th 2012 @ 07:12:38 AM
Script : http://www.rvman.net/vbulletin/showthread.php?186-February-2012
Referrer : http://www.rvman.net/vbulletin/forumdisplay.php?27-RVMAN-Daily-Log
IP Address : 75.222.59.235
Username : rvman
Classname : vB_Database
MySQL Version : 5.1.55
Anyone know what the problem is I am running mysql V5. something on Yahoo.
Thanks
Bruce
--------------- Added 1328543060 at 1328543060 ---------------
Well got it fixed cleared my cache and went into the Vbulletin admin maintenance and rebuilt the mysql now it works again but no sure why I keep getting these sql problems all the time anyone else hosting with Yahoo?
--------------- Added 1328543202 at 1328543202 ---------------
Well went into the maintenance in the admin panel cleared the cache and fixed the my sql database and now it works again.
But not sure why I keep getting the sql errors all the time is anyone else hosting with Yahoo and having sql problems all the time?