dbTalk Databases Forums  

A "Commands out of sync;" error

mailing.database.mysql mailing.database.mysql


Discuss A "Commands out of sync;" error in the mailing.database.mysql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
njord
 
Posts: n/a

Default A "Commands out of sync;" error - 10-16-2006 , 02:38 PM






Hi,

I try to use mysqli through ADODB to connect to my MySQL (5.0.15)
database.

I try to execute such a part of code:
$date = $this->db->Execute("call get_date()")->FetchObj->value;

and whatever I try to execute later, I get a message:
string(24) "select @result as result"
string(52) "Commands out of sync; you can't run this command now"

But when I execute
$date = $this->db->Execute("select date from table")->FetchObj->value;
everything is ok.

I have recently re-installed my MySQL server - about which setting did
I forget?...


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.