MySql Error

[Simons]

Hi I'm getting this error and I can't seem to find the problem.

Warning: mysql_query() [function.mysql-query]: Unable to save result set in /path/gallery/pp-inc.php on line 366

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /path/gallery/pp-inc.php on line 4299

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /path/gallery/pp-inc.php on line 1357

This is the email error report

An error was encountered during execution of the query:

SELECT c.id, c.description, c.catorder, c.photos, c.posts, c.catdepth,
p.id, p.bigimage, p.cat, p.approved, p.user, p.userid, p.date, p.width, p.height,
p2.bigimage, p2.cat, p2.storecat, p2.userid, p2.width, p2.height,
com.username, com.id, com.date, com.photo
FROM pp_categories c
LEFT JOIN pp_photos p ON c.lastphoto=p.id
LEFT JOIN pp_photos p2 ON c.thumbnail=p2.id
LEFT JOIN pp_comments com ON com.id=c.lastpost
ORDER BY c.catorder ASC

The query returned with an errorcode of:

Got error 127 from storage engine

Does anyone have any ideas?

[Simons]

Ok I repaired the category table and it appears to be ok now.

Anyone know why that might have happened?

[Chuck S]

Mysql corruption can happen on a server thats why you want backups and the repair function is part of mysql.

[Simons]

Thanks Chuck, I kinda thought that might be the case

[Chuck S]

No problem let us know if you need anything else.