doosa-moosa48
New Member
- Messages
- 2
- Reaction score
- 0
- Points
- 0
MyBB Support told me I need to talk to you guys about my issues I am having with mybb.<br>
<br>
Anyone who registers, or logs out, then attempts to log back in, or tries to login period, is greeted with this nice error message:<br>
<br>
MyBB SQL Error<br>
MyBB has experienced an internal SQL error and cannot continue.<br>
<br>
SQL Error:<br>
1030 - Got error 28 from storage engine<br>
Query:<br>
SHOW COLUMNS FROM mybb_users LIKE 'passwordconvert'<br>
Please contact the MyBB Group for support.<br>
<br>
or this<br>
<br>
MyBB SQL Error<br>
MyBB has experienced an internal SQL error and cannot continue.<br>
<br>
SQL Error:<br>
1030 - Got error 28 from storage engine<br>
Query:<br>
SHOW COLUMNS FROM mybb_users LIKE 'unreadpms'<br>
Please contact the MyBB Group for support.<br>
<br>
They told me to do this:<br>
<br>
---------- Post added at 09:32 PM ---------- Previous post was at 08:42 PM ----------
<BDWX19> Error code 28 for the OS means "No space left on device".
<BDWX19> Don't know if that's what MySQL is trying to hint at or not
<BDWX19> Yeah, that's exactly what it's hinting at.
<BDWX19> Means the partition on the disk that MySQL is storing its physical version of the database does not have enough free space to perform the query.
Can someone fix that issue? I really need this fixed ASAP! Thanks!
<BDWX19> I've come across that error too on a site I'm the "technical administrator" for (the guy that monitors/sets up things on the actual server filesystem, and manages the OS overall), the way I had the disks partitioned at the time was the cause.
<BDWX19> You just tell them that's what I said - error 28 means they need to double-check the storage space for MySQL's data directory.
---------- Post added at 09:41 PM ---------- Previous post was at 09:32 PM ----------
<BDWX19> That may also indicate out of RAM too.
<BDWX19> Since a SHOW COLUMNS would likely either allocate a temporary view table (which would be on the disk) OR attempt to load a query result into memory, depending on how MySQL is configured on their server.
<BDWX19> Yeah, just ask 'em to check their disk usage on MySQL's data directory, that's probably it then. When did this error start occurring?
<The_Weather_Guy> This morning.
<BDWX19> Ok, yeah, disk is getting full.
<BDWX19> Can't allocate space to store results.
Hint: I am The_Weather_Guy, and he is a member of my forums.
<br>
Anyone who registers, or logs out, then attempts to log back in, or tries to login period, is greeted with this nice error message:<br>
<br>
MyBB SQL Error<br>
MyBB has experienced an internal SQL error and cannot continue.<br>
<br>
SQL Error:<br>
1030 - Got error 28 from storage engine<br>
Query:<br>
SHOW COLUMNS FROM mybb_users LIKE 'passwordconvert'<br>
Please contact the MyBB Group for support.<br>
<br>
or this<br>
<br>
MyBB SQL Error<br>
MyBB has experienced an internal SQL error and cannot continue.<br>
<br>
SQL Error:<br>
1030 - Got error 28 from storage engine<br>
Query:<br>
SHOW COLUMNS FROM mybb_users LIKE 'unreadpms'<br>
Please contact the MyBB Group for support.<br>
<br>
They told me to do this:<br>
<br>
<br><br><br>Server: Boru<br><br>Site: http://intellistaremulator.x10.mx/<br><br>Issue page(s): http://intellistaremulator.x10.mx/forum/<br><br>I really need this fixed!!!! <br><br>THANK YOU!Yaldaram said:
---------- Post added at 09:32 PM ---------- Previous post was at 08:42 PM ----------
<BDWX19> Error code 28 for the OS means "No space left on device".
<BDWX19> Don't know if that's what MySQL is trying to hint at or not
<BDWX19> Yeah, that's exactly what it's hinting at.
<BDWX19> Means the partition on the disk that MySQL is storing its physical version of the database does not have enough free space to perform the query.
Can someone fix that issue? I really need this fixed ASAP!
Thanks!<BDWX19> I've come across that error too on a site I'm the "technical administrator" for (the guy that monitors/sets up things on the actual server filesystem, and manages the OS overall), the way I had the disks partitioned at the time was the cause.
<BDWX19> You just tell them that's what I said - error 28 means they need to double-check the storage space for MySQL's data directory.
---------- Post added at 09:41 PM ---------- Previous post was at 09:32 PM ----------
<BDWX19> That may also indicate out of RAM too.
<BDWX19> Since a SHOW COLUMNS would likely either allocate a temporary view table (which would be on the disk) OR attempt to load a query result into memory, depending on how MySQL is configured on their server.
<BDWX19> Yeah, just ask 'em to check their disk usage on MySQL's data directory, that's probably it then. When did this error start occurring?
<The_Weather_Guy> This morning.
<BDWX19> Ok, yeah, disk is getting full.
<BDWX19> Can't allocate space to store results.
Hint: I am The_Weather_Guy, and he is a member of my forums.