Bug #67627 [NEW]: odbc_execute(): Not enough parameters, but there are

From: Date: Tue, 15 Jul 2014 19:51:46 +0000
Subject: Bug #67627 [NEW]: odbc_execute(): Not enough parameters, but there are
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-186643@lists.php.net to get a copy of this message 
From:             sean dot harris at nordstrom dot com
Operating system: Mac OS 10.9
PHP version:      5.5.14
Package:          ODBC related
Bug Type:         Bug
Bug description:odbc_execute(): Not enough parameters, but there are

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 bug report at https://bugs.php.net/bug.php?id=67627&edit=1
--

Thread (4 messages)

« previous php.bugs (#186643) next »