The Planet Forums > Have you seen this MySQL error?

Full Version: Have you seen this MySQL error?

The Planet Forums > Control Panels > Other

swordzkof

May 9 2004, 11:27 PM

My Invision Power Board forums died this weekend. Each and every backup I've tried to restore, even one from a month ago, produces this error:

CODE

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: Monday 10th of May 2004 12:21:39 AM

When I try to "repair" the database, I get this error:

CODE

kustom_ipb.ibf_pfields_content OK

kustom_ipb.ibf_pfields_data OK

kustom_ipb.ibf_polls OK

kustom_ipb.ibf_posts

error : 28 when fixing table

error : Can't copy datafile-header to tempfile, error 9

status : Operation failed

kustom_ipb.ibf_reg_antispam OK

kustom_ipb.ibf_search_results OK

kustom_ipb.ibf_sessions OK

A search of Google and all the relevant messages boards has turned up zip.

Have you seen this before?

Thanks . . .

chirpy

May 10 2004, 02:22 AM

Odd. I just googled for "mySQL error: Got error 28 from table" and got plenty of hits. The general consensus is that either a partition os out of space, or the account is over quota (also check your /tmp partition space).

swordzkof

May 10 2004, 07:25 AM

I was serching for "Can't copy datafile-header to tempfile, error 9".

Thanks for the info . . .

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.