Bug #74769 [NEW]: PDO Related

From: kanduganesh at gmail dot com Operating system: Windows PHP version: Irrelevant Package: MySQL related Bug Type: Bug Bug description:PDO Related Description: ------------ PHP version 5.6 i am trying to get last 25 row in acceding order from msgs table working in mysql and phpmyadmin but getting error using mysql pdo Test script: --------------- $sql = '(SELECT id,msg,time,sender_id,mid from msgs WHERE mid > 0 and grp_id = :grp_id2 ORDER BY id DESC limit 25) ORDER BY id ASC'; $sql_array = array( 'grp_id2' => $grp_id, 'user' => $data['user']['id'], 'grp_id' => $grp_id ); $stmt = $data['pdo']->prepare($sql); $stmt->execute($sql_array); Expected result: ---------------- selected columns of table which is working in mysql and phpmyadmin Actual result: -------------- output Warning: PDO::prepare(): Unknown type 17 sent by the server. Please send a report to the developers in msgs.php on line 174 Fatal error: Call to a member function execute() on boolean in msgs.php on line 176 -- Edit bug report at https://bugs.php.net/bug.php?id=74769&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=74769&r=trysnapshot54 Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=74769&r=trysnapshot55 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=74769&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=74769&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=74769&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=74769&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=74769&r=needscript Try newer version: https://bugs.php.net/fix.php?id=74769&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=74769&r=support Expected behavior: https://bugs.php.net/fix.php?id=74769&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=74769&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=74769&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=74769&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=74769&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=74769&r=dst IIS Stability: https://bugs.php.net/fix.php?id=74769&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=74769&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=74769&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=74769&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=74769&r=mysqlcfg