Which database table to repair?

jeeves · 2007-01-25 03:26:07

I have an old textpattern site (1.0rc3) that has suddenly started returning the following error message at the top of each page:

Warning: mysql_query(): Unable to save result set in /home/fedev/public_html/textpattern/lib/txplib_db.php on line 35

According to the Texpattern FAQ this is likely caused by corrupted table. Repairing a table in PHPmyAdmin looks simple enough, but how do I know which of Texpattern’s 16 tables to attempt to repair?

I did take a look at line 35 of txplib_db.php – I was not able to figure out which table might be involved. Here is line 35

$result = $method($q,$DB->link);

Any advice would be greatly appreciated

Last edited by jeeves (2007-01-25 03:29:34)

Sencer · 2007-01-25 06:40:03

Try out high level diagnostics, it might give you a hint as it checks each table.

Otherwise try txp_log and textpattern table.

Mary · 2007-01-25 17:08:28

You could just run a repair on all of them, it doesn’t hurt anything if they’re not broken.

Textpattern CMS