Bug #72416 [Opn->Ver]: mysqli_stmt::__construct(): Unknown type 18 sent by the server.

From:	laruence@php.net	Date:	Sun, 19 Jun 2016 07:00:56 +0000
Subject:	Bug #72416 [Opn->Ver]: mysqli_stmt::__construct(): Unknown type 18 sent by the server.
References:	1	Groups:	php.bugs
Request:	Send a blank email to php-bugs+get-201730@lists.php.net to get a copy of this message

Edit report at https://bugs.php.net/bug.php?id=72416&edit=1

 ID:                 72416
 Updated by:         laruence@php.net
 Reported by:        webart dot video at gmail dot com
 Summary:            mysqli_stmt::__construct(): Unknown type 18 sent by
                     the server.
-Status:             Open
+Status:             Verified
 Type:               Bug
 Package:            MySQLi related
 Operating System:   Ubuntu 14.04 LTS
 PHP Version:        7.0.7
-Assigned To:        
+Assigned To:        mysql
 Block user comment: N
 Private report:     N

 New Comment:

5.6 is also affected


Previous Comments:
------------------------------------------------------------------------
[2016-06-15 15:06:59] webart dot video at gmail dot com

Description:
------------
PHP Information:

PHP 7.0.7-4+deb.sury.org~trusty+1 (cli) ( NTS )
Copyright (c) 1997-2016 The PHP Group
Zend Engine v3.0.0, Copyright (c) 1998-2016 Zend Technologies
    with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2016, by Zend Technologies
    with Xdebug v2.4.0, Copyright (c) 2002-2016, by Derick Rethans
    with blackfire v1.10.6, https://blackfire.io, by Blackfireio
Inc.

Pretty simple, using $mysqli->prepare($query) crashes the server with the message 
"mysqli_stmt::__construct(): Unknown type 18 sent by the server. Please send a report to the
developers"



Test script:
---------------
https://gist.github.com/NoMan2000/0ee7fbf41f69a7ae4cdc555241e2e5f6

Refer bug: https://bugs.php.net/bug.php?id=72041&edit=1

The difference is that user is using PDO, I'm using mysqli, but the underlying cause seems to
be the same.



------------------------------------------------------------------------



--
Edit this bug report at https://bugs.php.net/bug.php?id=72416&edit=1


   

Thread (15 messages)

• webart dot video at gmail dot comWed, 15 Jun 2016 15:07:04 +0000
  • laruence@php.netSun, 19 Jun 2016 07:00:56 +0000Bug #72416 [Opn->Ver]: mysqli_stmt::__construct(): Unknown type 18 sent by the server.
  • andrey@php.netMon, 20 Jun 2016 17:30:54 +0000Bug #72416 [Ver->Fbk]: mysqli_stmt::__construct(): Unknown type 18 sent by the server.
  • andrey@php.netTue, 21 Jun 2016 14:26:31 +0000Bug #72416 [Fbk]: mysqli_stmt::__construct(): Unknown type 18 sent by the server.
  • webart dot video at gmail dot comTue, 21 Jun 2016 15:44:13 +0000Bug #72416 [Fbk->Asn]: mysqli_stmt::__construct(): Unknown type 18 sent by the server.
  • andrey@php.netFri, 24 Jun 2016 13:49:54 +0000Bug #72416 [Asn]: mysqli_stmt::__construct(): Unknown type 18 sent by the server.
  • andrey@php.netFri, 24 Jun 2016 13:50:03 +0000Bug #72416 [Asn->Fbk]: mysqli_stmt::__construct(): Unknown type 18 sent by the server.
  • webart dot video at gmail dot comThu, 30 Jun 2016 16:07:07 +0000Bug #72416 [Com]: mysqli_stmt::__construct(): Unknown type 18 sent by the server.
  • php-bugs at lists dot php dot netSun, 03 Jul 2016 04:22:21 +0000Bug #72416 [Fbk->NoF]: mysqli_stmt::__construct(): Unknown type 18 sent by the server.
  • requinix@php.netSun, 03 Jul 2016 04:48:45 +0000Bug #72416 [NoF->Opn]: mysqli_stmt::__construct(): Unknown type 18 sent by the server.
  • andrey@php.netWed, 06 Jul 2016 14:45:32 +0000Bug #72416 [Asn]: mysqli_stmt::__construct(): Unknown type 18 sent by the server.
  • andrey@php.netThu, 07 Jul 2016 08:20:17 +0000Bug #72416 [Asn]: mysqli_stmt::__construct(): Unknown type 18 sent by the server.
  • andrey@php.netThu, 07 Jul 2016 08:42:46 +0000Bug #72416 [Asn]: mysqli_stmt::__construct(): Unknown type 18 sent by the server.
  • nikic@php.netThu, 10 Dec 2020 16:13:15 +0000Bug #72416 [Asn->Fbk]: mysqli_stmt::__construct(): Unknown type 18 sent by the server.
  • php-bugs at lists dot php dot netSun, 20 Dec 2020 04:22:15 +0000Bug #72416 [Fbk->NoF]: mysqli_stmt::__construct(): Unknown type 18 sent by the server.