Latest News: Latest Mods:


 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
MySQL error
Author Message
Alexandru21
Administrator



Posts: 781
Joined: Jun 2008
Reputation: 13
Post: #1
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]
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
Post: #2
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
Post: #3
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,438
Joined: May 2008
Reputation: 55
Post: #4
RE: MySQL error
That sounds like a server issue.

05-06-2009, 05:09 AM
 




User(s) browsing this thread: 2 Guest(s)