Database Error

[Rickeo]

Database error in vBulletin 3.6.8:

Invalid SQL:

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

MySQL Error : Can't create/write to file '/tmp/#sql_1c2d_0.MYD' (Errcode: 17)
Error Number : 1
Date : Thursday, September 6th 2007 @ 06:40:52 PM
Script : http://adviceforall.org.uk/admincp/options.php
Referrer : http://adviceforall.org.uk/admincp/index.php?do=nav
IP Address : 172.159.71.131
Username : StarDust
Classname : vb_database

Any idea whats happened here or how to fix it??

Rick

[Steve Machol]

System error: 17 = File exists

Ask your host to clear out the /tmp forum.

[Rickeo]

Thank you so so much thought my whole forum was ruined

Will tell him to do this will it defo fix it??

Thanks

Rick

[Steve Machol]

It will fix that error.