[Gambas-user] Error on gb.db.mysql: Commands out of sync; you can't run this command now

[David Villalobos Cambronero]

Not sure... but what I know for sure is that is not in my Gambas part. Attached is an example using only gb.db

 I try to take a look in the C part, but I couldn't find anything.

Attached is the entire script for my database, and an example.

I you connect directly to mysql and execute the last tow statements they work, so I think it is a bug in the C part.


MySQL says:


If you get Commands out of sync; you can't run this command now in your client code, you are calling client functions in the wrong order. 
This can happen, for example, if you are using mysql_use_result() and try to execute a new query before you have called mysql_free_result(). It can also happen if you try to execute two queries that return data without calling mysql_use_result() or mysql_store_result() in between. 
Best Regards


--
David



----- Original Message ----
From: Benoit Minisini <gambas at ...1...>
To: mailing list for gambas users <gambas-user at lists.sourceforge.net>
Sent: Saturday, January 10, 2009 3:51:07 PM
Subject: Re: [Gambas-user] Error on gb.db.mysql: Commands out of sync; you can't run this command now

On mercredi 7 janvier 2009, David Villalobos Cambronero wrote:
> Hi Benoit, did you have time to take a look at this?
>
>  Regards
>
>
> --
> David
>

Not really. I never encountered this error myself in all my MySQL life. 

By using the "DB.Debug = TRUE" feature, can't you have a dump of all SQL 
requests sent to the database driver? 

This way you could easily see if the requests sent are really bad, or if you 
did a bug in the gambas part of gb.db.mysql, or if I did a bug in the C part, 
or if there is a bug in MySQL (possible!)

Regards,

-- 
Benoit Minisini

------------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It is the best place to buy or sell services for
just about anything Open Source.
http://p.sf.net/sfu/Xq1LFB
_______________________________________________
Gambas-user mailing list
Gambas-user at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user



      
-------------- next part --------------
A non-text attachment was scrubbed...
Name: SMaRT.sql
Type: application/octet-stream
Size: 81543 bytes
Desc: not available
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20090112/94c28c2c/attachment.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: mysql.error-0.0.1.tar.gz
Type: application/x-gzip
Size: 7677 bytes
Desc: not available
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20090112/94c28c2c/attachment.bin>