View Full Version : Admin Control Panel Error...


Omen1
2nd October 2004, 09:30 AM
Database error in vBulletin 3.0.3:
Ok guys I'm a complete n00b and in need of your assistance :-)
When inside the Admin Control Panel and clicking on the "vBulletin Options" @ the top left, I get the following error:

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: Can't create/write to file '--port=3306\#sql_c74_0.MYI' (Errcode: 2)

mysql error number: 1


This is a fresh install and everything else works great.

Floris
2nd October 2004, 01:57 PM
.MYI - database table crashed.
You should run optimize and repair on your database tables.

Omen1
2nd October 2004, 08:43 PM
.MYI - database table crashed.
You should run optimize and repair on your database tables.

Repair and optimize went fine but did not correct the problem.

Anything else I can try?