I recently deleted around 300,000+ posts and now when you log in and try to send a PM, you receive this error:
Database error in vBulletin 3.7.4:
Invalid SQL:
SELECT pm.*, pmtext.*
, icon.title AS icontitle, icon.iconpath
FROM pm AS pm
LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
WHERE pm.userid=1 AND pm.folderid=0
ORDER BY pmtext.dateline DESC
LIMIT 0, 50;
MySQL Error : Got error 28 from storage engine
Error Number : 1030
Request Date : Tuesday, August 28th 2012 @ 08:51:37 PM
Error Date : Tuesday, August 28th 2012 @ 08:51:37 PM
I also have post count and thread count errors and issues when trying to respond. I've updated the counters, but still have issues if I try to optimize and repair the database.
Any help and all help is appreciated in correcting this issue to get things back working properly
Thanks!
Database error in vBulletin 3.7.4:
Invalid SQL:
SELECT pm.*, pmtext.*
, icon.title AS icontitle, icon.iconpath
FROM pm AS pm
LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
WHERE pm.userid=1 AND pm.folderid=0
ORDER BY pmtext.dateline DESC
LIMIT 0, 50;
MySQL Error : Got error 28 from storage engine
Error Number : 1030
Request Date : Tuesday, August 28th 2012 @ 08:51:37 PM
Error Date : Tuesday, August 28th 2012 @ 08:51:37 PM
I also have post count and thread count errors and issues when trying to respond. I've updated the counters, but still have issues if I try to optimize and repair the database.
Any help and all help is appreciated in correcting this issue to get things back working properly
Thanks!
Comment