I just started running MySQL 3.23.37 with php-4.0.5. Anyway, I am randomly
getting this same problem. Probably 90% of the time I don't encounter a
problem, but the other 10% I get the Commands out of sync error. I never
got it before upgrading MySQL.
Any suggestions out there? Maybe in the meantime I should revert to an older
version of MySQL. Perhaps I should use mysql_free_result() in between any
calls, but that seems to be excessive. I'll give it a try in the meantime,
but would love to hear any advice or comments.
> -----Original Message-----
> From: Alexander Fordyce [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 19, 2001 10:10 AM
> To: [EMAIL PROTECTED]
> Subject: New with MySQL 3.23: Commands out of sync error
> I have just run into a strange problem that I'm having a hell
> of a time
> extricating myself from. Here's the story...
> Recently, I upgraded to MySQL 3.23.33, mainly to experiment
> with some of the
> new transactional capabilities. But a whole chunk of code
> which had always
> worked perfectly began failing. After adding evil debug code
> to display all
> MySQL error messages, I found that I was getting the
> following error when
> trying to retrieve data from a query result:
> "Commands out of sync; You can't run this command now"
> I looked up this error on the mysql site, and was taken to
> this page...
> It mentions the need to use the command mysql_use_result(),
> but php doesn't
> support that. I understand that it's on the "to do" list.
> Does anyone else have experience with this problem? At the
> moment, it has
> me completely incapacitated, as moving back to MySQL 3.22 is
> not an option.
> The applications in question are seriously heavy with
> database usage, and
> can't really be slimmed down.
> (Another problem which may be related is that I have been getting
> unpredictable results connecting to the database with
> mysql_connect and
> pconnect -- sometimes it fails to connect for no apparent
> reason (about 1
> time in 20, maybe (which is a lot))).
> Thanks in advance...
> - - - - - - - - - - - -
> Alexander Fordyce
> [EMAIL PROTECTED]
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]