|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2014-08-13 15:52 UTC] sean dot harris at nordstrom dot com
[2020-10-05 10:19 UTC] cmb@php.net
-Status: Open
+Status: Feedback
-Assigned To:
+Assigned To: cmb
[2020-10-05 10:19 UTC] cmb@php.net
[2020-10-18 04:22 UTC] php-bugs at lists dot php dot net
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Tue Oct 28 05:00:01 2025 UTC |
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)