Re: Strange error
| From: | Ignatius Reilly | Date: | Thu, 02 Oct 2003 06:12:24 +0000 |
| Subject: | Re: Strange error | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-21646@lists.php.net to get a copy of this message | ||
What version of MySQL are you using?
From 4.0.13 there is a severe bug that corrupts table after a DELETE
operation. Solution: revert to 4.0.12
See http://bugs.mysql.com/bug.php?id=1321
HTH
Ignatius
_________________________
----- Original Message -----
From: "Charlie Brewer" <paladin_brewer@sbcglobal.net>
To: "'[PHP-WIN]'" <php-windows@lists.php.net>
Sent: Thursday, October 02, 2003 8:03 AM
Subject: [PHP-WIN] Strange error
My forums used to work :) Now when I go to them from my main page, I get the
following error:
=======
General Error
Could not query forums information
DEBUG MODE
SQL Error : 1030 Got error 127 from table handler
SELECT f.*, p.post_time, p.post_username, u.username, u.user_id FROM ((
nuke_bbforums f LEFT JOIN nuke_bbposts p ON p.post_id =
f.forum_last_post_id ) LEFT JOIN nuke_users u ON u.user_id = p.poster_id )
ORDER BY f.cat_id, f.forum_order
Line : 217
File : C:\apache2\htdocs\phpnuke\modules\Forums\index.php
======
Any help would be appreciated!