The “Unable to save result set” error is generally associated with major MySQL problems, like a corrupt table or faulty install.
In some cases we’ve found that repairing the MySQL database fixes this, even though CHECK TABLE reported no problems at all.
If your hosting company provides phpMyAdmin, you can select a table, then use the “Repair table” option under the Operations tab.
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.
Repairing a MySQL table
To repair a corrupted MySQL (MyISAM) table either follow this video, or the steps bellow.
1.
Login to phpMyAdmin ().
Note: You'll need to substitute server with the name of the actual server for your account.
2. Select a database from the drop down menu on the left. A list of tables in that db will appear directly below the drop down menu.
3. In the main content area, select the check box next to the table you want to repair
4. In the With Selected drop down below, select Repair Table. You should now see a SQL-query message telling you that the status of the table is OK
5. At the top of the main content area, click the STRUCTURE tab
6. Select the same table again but this time select Optimize Table from the With Selected drop down. You should now see a SQL-query message telling you that the status of the table is OK.
Your MySQL table should now be repaired.
When a GIG is not enough --> Terabyte Dolphin Technical Support - Server Management and Support
