Re: Warning: MySQL: Unable to save result set
| From: | Leobarod Cortes | Date: | Tue, 23 Oct 2001 21:21:34 +0000 |
| Subject: | Re: Warning: MySQL: Unable to save result set | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-13646@lists.php.net to get a copy of this message | ||
HI there..
I ahve the following issue
Error
MySQL said:
Host 'bbtest' is not allowed to connect to this MySQL server
Do you have any idea what could go wrong???
Leo
Doug Schasteen wrote:
> Warning: MySQL: Unable to save result set in <location of script> on
> line ***
>
> I recently upgraded to php 4 from 3. I also upgraded MySQL to 3.23.43 at
> the same time and repopulated my database with a .sql file. Everything
> works fine but I get this warning message every time I do an UPDATE,
> DELETE, or an INSERT. The data still gets updated, deleted or inserted
> though. SELECTs work fine without any problems. Pretty much everything
> works, I just keep getting warning messages.
>
> I searched the web and found that several people have fixed the problem
> in the past by doing myisamchk -r on all the tables. This did not work
> for me.
>
> I also have plenty of diskspace, so I dont think I'm running out of
> room.
>
> These scripts were all working perfectly on another server with php 3
> and a slightly older version of mysql. Also, if I run the SQL commands
> in the commandline they run fine without any warnings.
>
> Any ideas?
>
> - Doug