Alexandru21
Administrator
Posts: 781
Joined: Jun 2008
Reputation: 13
|
MySQL error
I can't edit any settings on my forum.
When I'm going to settings:
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1 - Can't create/write to file '/tmp/#sql_1305_0.MYI' (Errcode: 30)
Query:
SELECT g.*, COUNT(s.sid) AS settingcount FROM mybb_settinggroups g LEFT JOIN mybb_settings s ON (s.gid=g.gid) GROUP BY g.gid ORDER BY g.disporder
Please contact the MyBB Group for support.
I have upgraded from 1.4.4 to 1.4.6 and the error is still here.
What can I do?
![[Image: Alexandru21.png]](https://www.sigtweet.com/Alexandru21.png)
Create your free Twitter Signature.
Webmaster Resources, Scripts, Free Godaddy Gift Cards
|
|
| 05-05-2009, 03:14 PM |
|
Polarbear541
Premium User
Posts: 1,195
Joined: Aug 2008
Reputation: 5
|
RE: MySQL error
considering it can't write to a file to do the SQL, I think you will have to contact your host
If it can't write to the database file then upgrading won't fix that.
Thanks, Polarbear541
MyBB SQA Lead
http://forums.yhm.co.uk - My PHP Projects
|
|
| 05-06-2009, 03:59 AM |
|
Stream
Junior Member
Posts: 10
Joined: Sep 2008
Reputation: 0
|
RE: MySQL error
Try to change
SQL Error:
1 - Can't create/write to file '/tmp/#sql_1305_0.MYI' (Errcode: 30)
Query:
SELECT g.*, COUNT(s.sid) AS settingcount FROM mybb_settinggroups g LEFT JOIN mybb_settings s ON (s.gid=g.gid) GROUP BY g.gid ORDER BY g.disporder
To
SQL Error:
1 - Can't create/write to file '/tmp/#sql_1305_0.MYI' (Errcode: 30)
Query:
SELECT g.*, COUNT(s.sid) AS settingcount FROM mybb_settinggroups g LEFT JOIN mybb_settings s ON (s.gid=g.gid) GROUP BY g.gid ORDER BY g.disporder
|
|
| 05-06-2009, 05:04 AM |
|
Nickman
Manager
Posts: 2,427
Joined: May 2008
Reputation: 51
|
RE: MySQL error
That sounds like a server issue.
|
|
| 05-06-2009, 05:09 AM |
|