Database error in vBulletin 3.0.7:

[Hiro]

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT user.username, usergroupid, membergroupids, administrator.*
FROM administrator AS administrator
INNER JOIN user AS user USING(userid)
ORDER BY user.username

mysql error: Can't create/write to file '/tmp/mysql/#sql_189f_0.MYI' (Errcode: 2)

mysql error number: 1

Date: Wednesday 06th of April 2005 06:07:03 AM
Script: http://www.eliteneo.com/admincp/adminpermissions.php?do=modify
Referer: http://www.eliteneo.com/admincp/index.php?do=nav
Username: Kyle
IP Address: Removed

Help me please? :ermm:

[sabret00the]

not sure if you can just use USING like that, but hey i'm not SQL expert.

anyway looks like you gotta a curropt table to me, but again i'm no SQL expert, run a repair on the relevant tables.

[Hiro]

Hi sabre.

Thankyou for the reply.

I know NOTHING about mySQL, I struggled to set the database up for the forum LOL.

Most users on the forum do not get the error, Only people in specific usergroups get the error.

My sister wasnt getting the error in her usergroup, I changed someone into that usergroup and they still got the error, I dont know what it is but it needs to be fixed.

I will even pay somebody free web hosting to help me fix it.

[Marco van Herwaarden]

Well the error is pretty clear. There is no space or not enough permissions to create that temporary file. Search for the error code on www.mysql.com to find best solutions

[Hiro]

I have fixed it. :)