Discussion:
2014 Commands out of sync; you can't run this command now
(too old to reply)
y***@gmail.com
2007-07-25 17:09:37 UTC
Permalink
Hello All,

I was searching for a response about this topic but none get the right
answare, I hope i get help from you on this. :)

I trying to do an insert using a stored procedure to rely the charge
on the db but every type I run the call from my web page ussing PHP
5.X I get the same error.

This is what I'm doing:
______________________________________________________________________________________________
$link = mysql_connect( DB_HOST, DB_USER, DB_PASSWORD, true, 131074);
mysql_select_db(DB_NAME);

$sql = "call spTestCreate('" .
trim($Value1) . "', '" .
trim($Value2) . "', '" .
trim($Value3) . "', " .
$Value4 . ", " .
$Value5 . ", '" .
trim($Value6) . "', '" .
trim($Value7) . "', '" .
trim($Value8) . "') ; ";

$res = mysql_query($sql);

if (!$res) {
echo "Could not successfully run query (" . $sql . ") from DB: " .
mysql_error();
} else {
$row = mysql_fetch_row($res);
$LastId = $row[0];
}
______________________________________________________________________________________________

If I run the call from the SQLyog or any other tool it runs prefect
but that's not the case in the PHP.

Any Idea or Solution is welcome.

Thanks!
lark
2007-07-25 17:14:01 UTC
Permalink
Post by y***@gmail.com
Hello All,
I was searching for a response about this topic but none get the right
answare, I hope i get help from you on this. :)
I trying to do an insert using a stored procedure to rely the charge
on the db but every type I run the call from my web page ussing PHP
5.X I get the same error.
______________________________________________________________________________________________
$link = mysql_connect( DB_HOST, DB_USER, DB_PASSWORD, true, 131074);
mysql_select_db(DB_NAME);
$sql = "call spTestCreate('" .
trim($Value1) . "', '" .
trim($Value2) . "', '" .
trim($Value3) . "', " .
$Value4 . ", " .
$Value5 . ", '" .
trim($Value6) . "', '" .
trim($Value7) . "', '" .
trim($Value8) . "') ; ";
$res = mysql_query($sql);
if (!$res) {
echo "Could not successfully run query (" . $sql . ") from DB: " .
mysql_error();
} else {
$row = mysql_fetch_row($res);
$LastId = $row[0];
}
______________________________________________________________________________________________
If I run the call from the SQLyog or any other tool it runs prefect
but that's not the case in the PHP.
Any Idea or Solution is welcome.
Thanks!
do an echo($sql) or print($sql) and post the results in here.
y***@gmail.com
2007-07-25 17:23:07 UTC
Permalink
Post by lark
Post by y***@gmail.com
Hello All,
I was searching for a response about this topic but none get the right
answare, I hope i get help from you on this. :)
I trying to do an insert using a stored procedure to rely the charge
on the db but every type I run the call from my web page ussing PHP
5.X I get the same error.
______________________________________________________________________________________________
$link = mysql_connect( DB_HOST, DB_USER, DB_PASSWORD, true, 131074);
mysql_select_db(DB_NAME);
$sql = "call spTestCreate('" .
trim($Value1) . "', '" .
trim($Value2) . "', '" .
trim($Value3) . "', " .
$Value4 . ", " .
$Value5 . ", '" .
trim($Value6) . "', '" .
trim($Value7) . "', '" .
trim($Value8) . "') ; ";
$res = mysql_query($sql);
if (!$res) {
echo "Could not successfully run query (" . $sql . ") from DB: " .
mysql_error();
} else {
$row = mysql_fetch_row($res);
$LastId = $row[0];
}
______________________________________________________________________________________________
If I run the call from the SQLyog or any other tool it runs prefect
but that's not the case in the PHP.
Any Idea or Solution is welcome.
Thanks!
do an echo($sql) or print($sql) and post the results in here.
The result of the echo is the next:

call spTestCreate('myself', 'value2', 'value3', 56, 0, 'value6',
'value7', '7818ec0361') ;
Chainsaw [cr]
2007-07-25 18:09:17 UTC
Permalink
Post by y***@gmail.com
Post by lark
Post by y***@gmail.com
Hello All,
I was searching for a response about this topic but none get the right
answare, I hope i get help from you on this. :)
I trying to do an insert using a stored procedure to rely the charge
on the db but every type I run the call from my web page ussing PHP
5.X I get the same error.
______________________________________________________________________________________________
$link = mysql_connect( DB_HOST, DB_USER, DB_PASSWORD, true, 131074);
mysql_select_db(DB_NAME);
$sql = "call spTestCreate('" .
trim($Value1) . "', '" .
trim($Value2) . "', '" .
trim($Value3) . "', " .
$Value4 . ", " .
$Value5 . ", '" .
trim($Value6) . "', '" .
trim($Value7) . "', '" .
trim($Value8) . "') ; ";
$res = mysql_query($sql);
if (!$res) {
echo "Could not successfully run query (" . $sql . ") from DB: " .
mysql_error();
} else {
$row = mysql_fetch_row($res);
$LastId = $row[0];
}
______________________________________________________________________________________________
If I run the call from the SQLyog or any other tool it runs prefect
but that's not the case in the PHP.
Any Idea or Solution is welcome.
Thanks!
do an echo($sql) or print($sql) and post the results in here.
call spTestCreate('myself', 'value2', 'value3', 56, 0, 'value6',
'value7', '7818ec0361') ;
One more thing to say from my side is that all the select queries are
running fine and no errors so far. just in this kind of queries.

Hope you find guys could help me.

TIA.
lark
2007-07-25 20:56:54 UTC
Permalink
Post by Chainsaw [cr]
Post by y***@gmail.com
Post by lark
Post by y***@gmail.com
Hello All,
I was searching for a response about this topic but none get the right
answare, I hope i get help from you on this. :)
I trying to do an insert using a stored procedure to rely the charge
on the db but every type I run the call from my web page ussing PHP
5.X I get the same error.
______________________________________________________________________________________________
$link = mysql_connect( DB_HOST, DB_USER, DB_PASSWORD, true, 131074);
mysql_select_db(DB_NAME);
$sql = "call spTestCreate('" .
trim($Value1) . "', '" .
trim($Value2) . "', '" .
trim($Value3) . "', " .
$Value4 . ", " .
$Value5 . ", '" .
trim($Value6) . "', '" .
trim($Value7) . "', '" .
trim($Value8) . "') ; ";
$res = mysql_query($sql);
if (!$res) {
echo "Could not successfully run query (" . $sql . ") from DB: " .
mysql_error();
} else {
$row = mysql_fetch_row($res);
$LastId = $row[0];
}
______________________________________________________________________________________________
If I run the call from the SQLyog or any other tool it runs prefect
but that's not the case in the PHP.
Any Idea or Solution is welcome.
Thanks!
do an echo($sql) or print($sql) and post the results in here.
call spTestCreate('myself', 'value2', 'value3', 56, 0, 'value6',
'value7', '7818ec0361') ;
One more thing to say from my side is that all the select queries are
running fine and no errors so far. just in this kind of queries.
Hope you find guys could help me.
TIA.
what is the data type of the fields that correspond to values "56" and "0"?
--
lark -- ***@sbcdeglobalspam.net
To reply to me directly, delete "despam".
Chainsaw [cr]
2007-07-25 22:34:22 UTC
Permalink
Post by lark
Post by Chainsaw [cr]
Post by y***@gmail.com
Post by lark
Post by y***@gmail.com
Hello All,
I was searching for a response about this topic but none get the right
answare, I hope i get help from you on this. :)
I trying to do an insert using a stored procedure to rely the charge
on the db but every type I run the call from my web page ussing PHP
5.X I get the same error.
______________________________________________________________________________________________
$link = mysql_connect( DB_HOST, DB_USER, DB_PASSWORD, true, 131074);
mysql_select_db(DB_NAME);
$sql = "call spTestCreate('" .
trim($Value1) . "', '" .
trim($Value2) . "', '" .
trim($Value3) . "', " .
$Value4 . ", " .
$Value5 . ", '" .
trim($Value6) . "', '" .
trim($Value7) . "', '" .
trim($Value8) . "') ; ";
$res = mysql_query($sql);
if (!$res) {
echo "Could not successfully run query (" . $sql . ") from DB: " .
mysql_error();
} else {
$row = mysql_fetch_row($res);
$LastId = $row[0];
}
______________________________________________________________________________________________
If I run the call from the SQLyog or any other tool it runs prefect
but that's not the case in the PHP.
Any Idea or Solution is welcome.
Thanks!
do an echo($sql) or print($sql) and post the results in here.
call spTestCreate('myself', 'value2', 'value3', 56, 0, 'value6',
'value7', '7818ec0361') ;
One more thing to say from my side is that all the select queries are
running fine and no errors so far. just in this kind of queries.
Hope you find guys could help me.
TIA.
what is the data type of the fields that correspond to values "56" and "0"?
--
To reply to me directly, delete "despam".
Those fields are int(11);

FYI The other stored procedures run OK, only this and others with the
same insert and last_insert_id() has the problems.

TIA.
lark
2007-07-26 01:20:25 UTC
Permalink
Post by Chainsaw [cr]
Post by lark
Post by Chainsaw [cr]
Post by y***@gmail.com
Post by lark
Post by y***@gmail.com
Hello All,
I was searching for a response about this topic but none get the right
answare, I hope i get help from you on this. :)
I trying to do an insert using a stored procedure to rely the charge
on the db but every type I run the call from my web page ussing PHP
5.X I get the same error.
______________________________________________________________________________________________
$link = mysql_connect( DB_HOST, DB_USER, DB_PASSWORD, true, 131074);
mysql_select_db(DB_NAME);
$sql = "call spTestCreate('" .
trim($Value1) . "', '" .
trim($Value2) . "', '" .
trim($Value3) . "', " .
$Value4 . ", " .
$Value5 . ", '" .
trim($Value6) . "', '" .
trim($Value7) . "', '" .
trim($Value8) . "') ; ";
$res = mysql_query($sql);
if (!$res) {
echo "Could not successfully run query (" . $sql . ") from DB: " .
mysql_error();
} else {
$row = mysql_fetch_row($res);
$LastId = $row[0];
}
______________________________________________________________________________________________
If I run the call from the SQLyog or any other tool it runs prefect
but that's not the case in the PHP.
Any Idea or Solution is welcome.
Thanks!
do an echo($sql) or print($sql) and post the results in here.
call spTestCreate('myself', 'value2', 'value3', 56, 0, 'value6',
'value7', '7818ec0361') ;
One more thing to say from my side is that all the select queries are
running fine and no errors so far. just in this kind of queries.
Hope you find guys could help me.
TIA.
what is the data type of the fields that correspond to values "56" and "0"?
--
To reply to me directly, delete "despam".
Those fields are int(11);
FYI The other stored procedures run OK, only this and others with the
same insert and last_insert_id() has the problems.
TIA.
make sure that the user that is logged in through your php application
has execute privilege in the database where the stored procedure is
declared.
Chainsaw [cr]
2007-07-26 14:28:23 UTC
Permalink
Post by lark
Post by Chainsaw [cr]
Post by lark
Post by Chainsaw [cr]
Post by y***@gmail.com
Post by lark
Post by y***@gmail.com
Hello All,
I was searching for a response about this topic but none get the right
answare, I hope i get help from you on this. :)
I trying to do an insert using a stored procedure to rely the charge
on the db but every type I run the call from my web page ussing PHP
5.X I get the same error.
______________________________________________________________________________________________
$link = mysql_connect( DB_HOST, DB_USER, DB_PASSWORD, true, 131074);
mysql_select_db(DB_NAME);
$sql = "call spTestCreate('" .
trim($Value1) . "', '" .
trim($Value2) . "', '" .
trim($Value3) . "', " .
$Value4 . ", " .
$Value5 . ", '" .
trim($Value6) . "', '" .
trim($Value7) . "', '" .
trim($Value8) . "') ; ";
$res = mysql_query($sql);
if (!$res) {
echo "Could not successfully run query (" . $sql . ") from DB: " .
mysql_error();
} else {
$row = mysql_fetch_row($res);
$LastId = $row[0];
}
______________________________________________________________________________________________
If I run the call from the SQLyog or any other tool it runs prefect
but that's not the case in the PHP.
Any Idea or Solution is welcome.
Thanks!
do an echo($sql) or print($sql) and post the results in here.
call spTestCreate('myself', 'value2', 'value3', 56, 0, 'value6',
'value7', '7818ec0361') ;
One more thing to say from my side is that all the select queries are
running fine and no errors so far. just in this kind of queries.
Hope you find guys could help me.
TIA.
what is the data type of the fields that correspond to values "56" and "0"?
--
To reply to me directly, delete "despam".
Those fields are int(11);
FYI The other stored procedures run OK, only this and others with the
same insert and last_insert_id() has the problems.
TIA.
make sure that the user that is logged in through your php application
has execute privilege in the database where the stored procedure is
declared.
I did check the user access rights and has all the options granted but
still getting the same error. "Commands out of sync; you cannot run
this command now "
I still no have a clue around this.
lark
2007-07-26 17:52:24 UTC
Permalink
Post by Chainsaw [cr]
Post by lark
Post by Chainsaw [cr]
Post by lark
Post by Chainsaw [cr]
Post by y***@gmail.com
Post by lark
Post by y***@gmail.com
Hello All,
I was searching for a response about this topic but none get the right
answare, I hope i get help from you on this. :)
I trying to do an insert using a stored procedure to rely the charge
on the db but every type I run the call from my web page ussing PHP
5.X I get the same error.
______________________________________________________________________________________________
$link = mysql_connect( DB_HOST, DB_USER, DB_PASSWORD, true, 131074);
mysql_select_db(DB_NAME);
$sql = "call spTestCreate('" .
trim($Value1) . "', '" .
trim($Value2) . "', '" .
trim($Value3) . "', " .
$Value4 . ", " .
$Value5 . ", '" .
trim($Value6) . "', '" .
trim($Value7) . "', '" .
trim($Value8) . "') ; ";
$res = mysql_query($sql);
if (!$res) {
echo "Could not successfully run query (" . $sql . ") from DB: " .
mysql_error();
} else {
$row = mysql_fetch_row($res);
$LastId = $row[0];
}
______________________________________________________________________________________________
If I run the call from the SQLyog or any other tool it runs prefect
but that's not the case in the PHP.
Any Idea or Solution is welcome.
Thanks!
do an echo($sql) or print($sql) and post the results in here.
call spTestCreate('myself', 'value2', 'value3', 56, 0, 'value6',
'value7', '7818ec0361') ;
One more thing to say from my side is that all the select queries are
running fine and no errors so far. just in this kind of queries.
Hope you find guys could help me.
TIA.
what is the data type of the fields that correspond to values "56" and "0"?
--
To reply to me directly, delete "despam".
Those fields are int(11);
FYI The other stored procedures run OK, only this and others with the
same insert and last_insert_id() has the problems.
TIA.
make sure that the user that is logged in through your php application
has execute privilege in the database where the stored procedure is
declared.
I did check the user access rights and has all the options granted but
still getting the same error. "Commands out of sync; you cannot run
this command now "
I still no have a clue around this.
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 a `mysql_use_result()' or `mysql_store_result()' in between.

what version of php are you using?
Chainsaw [cr]
2007-07-26 21:27:35 UTC
Permalink
The stored procedure is built to do :

1- insert into a table
2- get last id inserted and return it in a select statement ( select
last_inserted_id(); )

And the PHP is located in to computers the first is a 5.2.3 which is
the Dev Server and other is an 5.2.0-8 in the Production server but so
far both has the same problem.

Thanks for all the help.
lark
2007-07-28 04:10:06 UTC
Permalink
Post by Chainsaw [cr]
1- insert into a table
2- get last id inserted and return it in a select statement ( select
last_inserted_id(); )
And the PHP is located in to computers the first is a 5.2.3 which is
the Dev Server and other is an 5.2.0-8 in the Production server but so
far both has the same problem.
Thanks for all the help.
somewhere, somehow, your sql statements are out of order; maybe not inside the
procedure but around the code that calls the procedure.



--
POST BY: lark with PHP News Reader
Gordon Burditt
2007-07-30 03:29:00 UTC
Permalink
Post by lark
Post by Chainsaw [cr]
1- insert into a table
2- get last id inserted and return it in a select statement ( select
last_inserted_id(); )
And the PHP is located in to computers the first is a 5.2.3 which is
the Dev Server and other is an 5.2.0-8 in the Production server but so
far both has the same problem.
Thanks for all the help.
somewhere, somehow, your sql statements are out of order; maybe not inside the
procedure but around the code that calls the procedure.
I believe it is not the *SQL STATEMENTS* that are out of order, but
the calls to the API functions that are out of order. One example
would be fetching a result set before executing a query. Another
example might be issuing a query before at least grabbing the result
set from the previous query.
lark
2007-07-31 03:21:11 UTC
Permalink
Post by Gordon Burditt
Post by lark
Post by Chainsaw [cr]
1- insert into a table
2- get last id inserted and return it in a select statement ( select
last_inserted_id(); )
And the PHP is located in to computers the first is a 5.2.3 which is
the Dev Server and other is an 5.2.0-8 in the Production server but so
far both has the same problem.
Thanks for all the help.
somewhere, somehow, your sql statements are out of order; maybe not inside the
procedure but around the code that calls the procedure.
I believe it is not the *SQL STATEMENTS* that are out of order, but
the calls to the API functions that are out of order. One example
would be fetching a result set before executing a query. Another
example might be issuing a query before at least grabbing the result
set from the previous query.
you are right. that is actually what i meant. thanks for clearing that up.
--
POST BY: lark with PHP News Reader

Loading...