#35534 [Opn->Bgs]: SQLSTATE HY093 Error

ID: 35534 Updated by: tony2001@php.net Reported By: paul dot zorn at gmail dot com -Status: Open +Status: Bogus Bug Type: PDO related Operating System: Fedora 3 PHP Version: 5.1.1 New Comment: Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely to be the same. Thank you for your interest in PHP. Duplicate of bug #35368 Previous Comments: ------------------------------------------------------------------------ [2005-12-03 21:10:05] paul dot zorn at gmail dot com Description: ------------ I was doing an update with the method: $dbh->query($update). I was getting the error. SQLSTATE[HY093]: Invalid parameter number: mixed name and positional parameters. The problem was that my value string inside the query had a single semi-colon. And was causing this error. If i made it a double semi-colon it worked right. Reproduce code: --------------- The main code was a update statement for mysql: UPDATE session SET user_id = '1', session = '$val' WHERE session_key = '$session_key' The $val == 'started|i:1;i;user_id....' Expected result: ---------------- I don't expect that the semi-colon inside the val code would through this error. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=35534&edit=1