Hy !
Yesterday my forum it was normal , "he" work normaly , but today when i want to log on , "he" don't work !
Look at the error and told me what to do :|
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1 - Can't create/write to file '/tmp/#sql_bc4_0.MYI' (Errcode: 30)
Query:
SHOW COLUMNS FROM mybb_users LIKE 'unreadpms'
Thanks
p.s: sorry for my "broke" english
You'll need to ask your host about this.
Host problem as Matt said. MySQL can't write to a temporary file.
I told with him but he don't know :|
This error disappeared but now another error appeared :|
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1 - Can't create/write to file '/tmp/#sql_bb0_0.MYI' (Errcode: 30)
Query:
SELECT t.*, p.displaystyle AS threadprefix, (t.totalratings/t.numratings) AS averagerating, r.uid AS rated, t.username AS threadusername, u.username FROM mybb_threads t LEFT JOIN mybb_users u ON (u.uid = t.uid) LEFT JOIN mybb_threadratings r ON(r.tid=t.tid AND r.uid='1') LEFT JOIN mybb_threadprefixes p ON (p.pid = t.prefix) WHERE t.fid='142' AND (t.visible='1' OR t.visible='0') GROUP BY t.tid ORDER BY t.sticky DESC, t.lastpost desc LIMIT 0, 20
Please help me :|
It's still a host problem. If your host doesn't know what's causing the problem, then they are probably a waste of time. Find a better host.
Shukaku do you know what's causing the problem ?
Until now I don't have the problems with this host :| ... anyway I ask him again , and again , ultil the problem disappeared .
The problem is in the error. MySQL can't write to a temporary file.
If they don't know what to do about this, find a new host.