QUESTION:

Warning: mysql_query(): Unable to save result set..



ANSWER:

Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/somewhere/public_html/blog/textpattern/lib/txplib_db.php on line 53

The “Unable to save result set” error is generally associated with major MySQL problems, like a corrupt table or faulty install. It is not caused by Textpattern.

In some cases we’ve found that repairing the MySQL database fixes this, even though CHECK TABLE reported no problems at all.

The PHP manual has a FAQ topic on a PHP installation problem that can cause this error.

The MySQL manual has a section on checking and repairing tables.

For TextDrive users, the TxD Knowledge Base has step-by-step instructions on how to repair a table.

If your hosting company provides phpMyAdmin, you can select a table, then use the “Repair table” option under the Operations tab.

There is also a Textpattern plugin which can allow you to repair tables in your Textpattern database.