MyBB Community Forums

Full Version: My SQL Error
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
hey guys

i recentled moved my forum from my old host to my new host, i changed the settings.php to suit the cookies path etc, and the config to suit the sql database/locations, everything was fine for a while

though it was for a little while showing members that accounts didnt exsist anymore from the move and posts that arent there

I also merged the sql backup from my old host to the new host and merged the databases

and i could login and all that fine then today i got this error

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1 - Can't create/write to file '/tmp/#sql_145c_0.MYI' (Errcode: 28)
Query:
SHOW COLUMNS FROM mybb_users LIKE 'unreadpms'
Looks like the /tmp/ partition on the server is full. Contact your web host.