Bug #74769 [Opn->Dup]: PDO Related

Edit report at https://bugs.php.net/bug.php?id=74769&edit=1 ID: 74769 Updated by: dharman@php.net Reported by: kanduganesh at gmail dot com Summary: PDO Related -Status: Open +Status: Duplicate Type: Bug Package: PDO MySQL Operating System: Windows PHP Version: Irrelevant -Assigned To: +Assigned To: dharman Block user comment: N Private report: N New Comment: Duplicate of https://bugs.php.net/bug.php?id=72416 Previous Comments: ------------------------------------------------------------------------ [2017-06-17 06:04:27] kanduganesh at gmail dot com 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 this bug report at https://bugs.php.net/bug.php?id=74769&edit=1