> You may have a corrupt table. I would recommend printing the $query just > before mysql_query() is ran. This will give you the query that is failing > and the table that it is attempting to write to. May want to try a "check > table" on this table.
SELECT post_id, post_subject, post_text FROM phpbb_posts_text LIMIT 300000 , 10 MySQL said: #1030 - Got error 127 from table handler This is really weird. I'm showing a gap in posts_ID from 240915 to 4089168. This script has run before from 300,000 to the end before. Now if I check this table I get: Checking MyISAM file: phpbb_posts_text.MYI Data records: 324989 Deleted blocks: 0 myisamchk: warning: 1 clients is using or hasn't closed the table properly - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check record links myisamchk: Error reading file 'phpbb_posts_text.MYD' (Errcode: 5) myisamchk: error: got error: 5 when reading datafile at record: 3627 MyISAM-table 'phpbb_posts_text.MYI' is corrupted record: 3627 is where my script give me the error. Warning: mysql_query(): Unable to save result set I've run a check on this table before and it was ok. I don't know how this datafile would have been corrupted. Now, how can I remove that datafile specifically? I fear trying to rebuild that table for fear of it failing. Mark Susol -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
