I have a client with a forum (invision) and suddenly this week they have been getting mysql error's all week. They come and go without making any changes. below is the most recent error:
mySQL query error: SELECT f.*, c.id as cat_id, c.position as cat_position,
c.state as cat_state, c.name as cat_name, c.description as cat_desc,
c.image, c.url, m.member_name as mod_name,
m.member_id as mod_id, m.is_group, m.group_id, m.group_name, m.mid
FROM ibf_forums f, ibf_categories c
LEFT JOIN ibf_moderators m ON (f.id=m.forum_id)
WHERE c.id=f.category
ORDER BY c.position, f.position
mySQL error: Got error 28 from table handler
mySQL error code:
Date: Thursday 16th of September 2004 05:35:54 AM
can anyone suggest if this is a server issue? (cpanel28)
I found this info on error 28 http://www.mysql.com/news-and-events...000000249.html
seems like a space issue on the mysql server.
"What is error 28 and how can I avoid it?
Using the command line tool perror you can find out, what the error 28 means.
> perror 28
Error code 28: No space left on device
If you get his error, you need to check all filesystems where MySQL operates. It may be single filesystem or as we recommend you can have datadir, tmpdir and log files split into dedicated filesystems. MySQL often creates temporary tables for some queries - most of them are placed in tmpdir, but some into database directory (e.g. ALTER TABLE). You must ensure, that there is enough free disk space available for MySQL.
You can check out, that environment variables for MySQL are properly set."
mySQL query error: SELECT f.*, c.id as cat_id, c.position as cat_position,
c.state as cat_state, c.name as cat_name, c.description as cat_desc,
c.image, c.url, m.member_name as mod_name,
m.member_id as mod_id, m.is_group, m.group_id, m.group_name, m.mid
FROM ibf_forums f, ibf_categories c
LEFT JOIN ibf_moderators m ON (f.id=m.forum_id)
WHERE c.id=f.category
ORDER BY c.position, f.position
mySQL error: Got error 28 from table handler
mySQL error code:
Date: Thursday 16th of September 2004 05:35:54 AM
can anyone suggest if this is a server issue? (cpanel28)
I found this info on error 28 http://www.mysql.com/news-and-events...000000249.html
seems like a space issue on the mysql server.
"What is error 28 and how can I avoid it?
Using the command line tool perror you can find out, what the error 28 means.
> perror 28
Error code 28: No space left on device
If you get his error, you need to check all filesystems where MySQL operates. It may be single filesystem or as we recommend you can have datadir, tmpdir and log files split into dedicated filesystems. MySQL often creates temporary tables for some queries - most of them are placed in tmpdir, but some into database directory (e.g. ALTER TABLE). You must ensure, that there is enough free disk space available for MySQL.
You can check out, that environment variables for MySQL are properly set."
Comment