problems with mysql5

[Rich]

Jeff Mitchell wrote:
> "Commands out of sync" is an error that has been in all 5.0 versions, AFAIK
> (http://mysql.com/doc/refman/5.0/en/commands-out-of-sync.html)
> 
> If it's been working fine for you across 5.0 releases and works fine with 
> 5.0.22 but suddenly stopped working with 5.0.24, the first place I'd look 
> would be MySQL...

yeah, it looks more like an mysql problem - just that it happened for me 
with amarok. it could as well be mysql changing some things around, 
though i hope they are not doing that for that small release increments.

> Looking at the CollectionDB code for query (MySqlConnection::query), if 
> mysql_use_result is successful, mysql_free_result will always be called.  I 
> would guess that it does not have to be called if mysql_use_result is 
> unsuccessful, but if I'm wrong about that it could be the source of your 
> issue if you are having failed queries (in which case the problem is really 
> figuring out why you had a failed query in the first place).
> 
> I'd see how it behaves with other 5.0.x versions, especially with x > 24.  But 
> it really feels like a MySQL bug.

have to wait for them, 5.0.24 seems to be the latest :)

> --Jeff
...
-- 
  Rich