|   | 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 Group All rights reserved. | Last updated: Fri Oct 31 13: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)