Edit report at https://bugs.php.net/bug.php?id=11765&edit=1
ID: 11765 Comment by: jorides at yahoo dot com Reported by: root at byone dot com Summary: Warning: MySQL: Unable to save result set in Status: Not a bug Type: Bug Package: MySQL related Operating System: redhat-6.2 PHP Version: 4.0.6 Block user comment: N Private report: N New Comment: The LIMIT is ON, Try, LIMIT 0,10! Previous Comments: ------------------------------------------------------------------------ [2004-03-17 12:45:59] julien_riel at hotmail dot com When you have message: "Unable to save result set error 127" May be your table is corrupt Use the SQL command "CHECK TABLE table_name" to see if everything is Ok on your table. I got this error after I shutdown Windows unproprely (scandisk started). Seems I lost all my data! Make some backups! Hope this help ------------------------------------------------------------------------ [2001-11-20 19:26:08] mfisc...@php.net Bogusified in favour of #12029. Please only respond to #12029! Bogus ------------------------------------------------------------------------ [2001-07-03 21:37:52] root at byone dot com I upgraded to mysql-3.23.39 and recompiled php-4.0.6 but nothing changed. ------------------------------------------------------------------------ [2001-06-28 21:25:12] root at byone dot com BTW : This error occur on ALL OF my scripts after I had upgraded my php from 4.0.3 to 4.0.6 ------------------------------------------------------------------------ [2001-06-28 21:21:26] root at byone dot com Yes I use Use mysql_query() / mysql_select_db() instead of mysql_db_query(). Both mysql_errno() and mysql_error() return NOTHING. The query was successful exectued by mysql.(I can find the query reselt in mysql database) But why php generated an error? ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at https://bugs.php.net/bug.php?id=11765 -- Edit this bug report at https://bugs.php.net/bug.php?id=11765&edit=1