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
> Subject: New with MySQL 3.23: Commands out of sync error
> Hi.
> 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...
> http://www.mysql.com/doc/C/o/Commands_out_of_sync.html
> 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...
> Alex
> - - - - - - - - - - - -
> Alexander Fordyce

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]

Reply via email to