Bug #67627 [Fbk->NoF]: odbc_execute(): Not enough parameters, but there are

From: Date: Sun, 18 Oct 2020 04:22:14 +0000
Subject: Bug #67627 [Fbk->NoF]: odbc_execute(): Not enough parameters, but there are
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-229706@lists.php.net to get a copy of this message 
Edit report at https://bugs.php.net/bug.php?id=67627&edit=1

 ID:               67627
 Updated by:       php-bugs@lists.php.net
 Reported by:      sean dot harris at nordstrom dot com
 Summary:          odbc_execute(): Not enough parameters, but there are
-Status:           Feedback
+Status:           No Feedback
 Type:             Bug
 Package:          ODBC related
 Operating System: Mac OS 10.9
 PHP Version:      5.5.14
 Assigned To:      cmb
 Private report:   N

 New Comment:

No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Re-Opened". Thank you.


Previous Comments:
------------------------------------------------------------------------
[2020-10-05 10:19:23] cmb@php.net

Can you still reproduce this with any of the actively supported
PHP versions[1]?

[1] <https://www.php.net/supported-versions.php>

------------------------------------------------------------------------
[2014-08-13 15:52:06] sean dot harris at nordstrom dot com

I contacted the makers of the ODBC driver and they claim this is not a bug with their driver but a
bug within PHP

------------------------------------------------------------------------
[2014-07-15 19:51:45] sean dot harris at nordstrom dot com

Description:
------------
We have been experiencing a strange and random bug. We only begun to notice it since we just started
using PHP’s ODBC prepared statements.

2 - 6 times out of a 1000 we will receive the following php warning:
Warning: odbc_execute(): Not enough parameters (2 should be 3)


We made a test script running the exact same query 1000 times. The last loop I ran the following
iterations threw the error:
130, 312, 340

Our current workaround is to throw a couple nulls at the end of the parameter array.

We are using 'Actual SQL Server' ODBC driver if that matters.

Test script:
---------------
//db connection stuff would be here

for ($i=0; $i < 1000; $i++) { 
	$sql = 'SELECT * FROM tags WHERE fk_userTagged = ? AND tagsID > ?';
	$statement = odbc_prepare($dbc,$sql);
	odbc_execute($statement,[638,5]);
	echo "$i<br/>";
}

Actual result:
--------------
Warning: odbc_execute(): Not enough parameters (2 should be 3)


------------------------------------------------------------------------



--
Edit this bug report at https://bugs.php.net/bug.php?id=67627&edit=1

Thread (4 messages)

« previous php.bugs (#229706) next »