2014 Commands out of sync; you can't run this command now

[yaguirre]

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]

ya******@gmail.com wrote:

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!

do an echo($sql) or print($sql) and post the results in here.

[yaguirre]

On Jul 25, 11:14 am, lark <[e-mail]:

[e-mail] wrote:

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!

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]]

On Jul 25, 11:23 am, "[e-mail]" <[e-mail]:

On Jul 25, 11:14 am, lark <[e-mail]:

[e-mail] wrote:

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!

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') ;

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]

Chainsaw [cr] wrote:

On Jul 25, 11:23 am, "[e-mail]" <[e-mail]:

>On Jul 25, 11:14 am, lark <[e-mail]:

>>[e-mail] wrote:
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!
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') ;

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 -- ha****@sbcdeglobalspam.net
To reply to me directly, delete "despam".

[Chainsaw [cr]]

On Jul 25, 2:56 pm, lark <[e-mail]:

Chainsaw [cr] wrote:

On Jul 25, 11:23 am, "[e-mail]" <[e-mail]:

On Jul 25, 11:14 am, lark <[e-mail]:

>[e-mail] wrote:
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!
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') ;

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 -- [e-mail]
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]

Chainsaw [cr] wrote:

On Jul 25, 2:56 pm, lark <[e-mail]:

>Chainsaw [cr] wrote:

>>On Jul 25, 11:23 am, "[e-mail]" <[e-mail]:
On Jul 25, 11:14 am, lark <[e-mail]:
[e-mail] wrote:
>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!
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') ;
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 -- [e-mail]
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]]

On Jul 25, 7:20 pm, lark <[e-mail]:

Chainsaw [cr] wrote:

On Jul 25, 2:56 pm, lark <[e-mail]:

Chainsaw [cr] wrote:
On Jul 25, 11:23 am, "[e-mail]" <[e-mail]:
On Jul 25, 11:14 am, lark <[e-mail]:
[e-mail] wrote:
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!
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') ;
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 -- [e-mail]
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.

[Chainsaw [cr]]

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.