View Full Version : plz help me, iget this error when i run cmp
jimmyboy
09-09-2004, 08:06 PM
Database error in vBulletin 3.0.3:
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 table handler
mysql error number: 1030
how do i fix it>?
Brian
09-10-2004, 12:45 AM
That means that either your setting or settinggroup tables has become corrupted. Repairing the tables should fix the problem (Admin CP => Import & Maintance => Repair / Optimize Tables).
jimmyboy
09-10-2004, 07:28 AM
yes, i have done that, but error still exists
Brian
09-10-2004, 04:04 PM
Not sure why it would still give an error if they've been repaired. You'd probably be better off posting at vbulletin.com since those are vB tables and have nothing to do with vBa.
Zachery
09-10-2004, 04:20 PM
That means that either your setting or settinggroup tables has become corrupted. Repairing the tables should fix the problem (Admin CP => Import & Maintance => Repair / Optimize Tables).
Error code 28: No space left on device
One or more partitions on your server is out of space or doesn't have enough space to complete this operation. Shutdown your forums and contact your host immediately. You or your host will need to find out which partition is low on space and free up some more space.
Brian
09-10-2004, 04:29 PM
Ohhh yea... Thanks Zach. :)
jimmyboy
09-11-2004, 07:00 AM
kk, thx a lot. man
vBulletin® v3.8.4, Copyright ©2000-2012, Jelsoft Enterprises Ltd.