Edit report at https://bugs.php.net/bug.php?id=72416&edit=1
ID: 72416
Updated by: php-bugs@lists.php.net
Reported by: webart dot video at gmail dot com
Summary: mysqli_stmt::__construct(): Unknown type 18 sent by
the server.
-Status: Feedback
+Status: No Feedback
Type: Bug
Package: MySQLi related
Operating System: Ubuntu 14.04 LTS
PHP Version: 7.0.7
Private report: N
New Comment:
No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Re-Opened". Thank you.
Previous Comments:
------------------------------------------------------------------------
[2020-12-10 16:13:15] nikic@php.net
Does anyone still experience this issue on a current version of MySQL and PHP?
At least using MySQL 8.0.22 this does not reproduce any more, so presumably the issue has been fixed
on the server side, even though the bug report has not been closed.
------------------------------------------------------------------------
[2020-12-10 11:29:04] nikic@php.net
Related To: Bug #72041
------------------------------------------------------------------------
[2020-12-10 11:27:03] nikic@php.net
Related To: Bug #72041
------------------------------------------------------------------------
[2016-07-07 08:42:45] andrey@php.net
Hi, I have opened a MySQL server bug report as this is a server bug
Bug #82139 MySQL server sends internal column type over the wire
http://bugs.mysql.com/bug.php?id=82139
------------------------------------------------------------------------
[2016-07-07 08:20:16] andrey@php.net
Even shorter one:
<?php
/*
CREATE TABLE type18 (
tripDay datetime NOT NULL
) ENGINE=InnoDB;
INSERT INTO type18 VALUES ('2014-04-03 00:00:00');
*/
$conn = mysqli_connect('127.0.0.1', 'root', '', 'test');
$conn->query("set sql_mode=''");
$sql = "(SELECT tripDay FROM type18 ORDER BY YEAR(tripDay)) ORDER BY YEAR(tripDay)";
$stmt = $conn->prepare($sql);
var_dump($stmt, $conn->error);
?>
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
https://bugs.php.net/bug.php?id=72416
--
Edit this bug report at https://bugs.php.net/bug.php?id=72416&edit=1