Edit report at https://bugs.php.net/bug.php?id=53185&edit=1
ID: 53185
Comment by: tom dot castleman at b3-it dot com
Reported by: alexc223 at googlemail dot com
Summary: PDO_MYSQL constructor, PHP warning w/ Exception
error mode
Status: Assigned
Type: Bug
Package: PDO MySQL
Operating System: Linux
PHP Version: 5.3.3
Assigned To: kalle
Block user comment: N
Private report: N
New Comment:
This error is present in 5.6.4.
PDO::__construct emits an E_WARNING despite passing PDO::ATTR_ERRMODE option to it:
$pdo = new PDO('mysql:host=foo;dbname=bar', 'user', 'pass',
[PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);
Expected Result:
----------------
PDOException - MySQL server has gone away
Actual Result:
--------------
E_WARNING: PDO::__construct(): MySQL server has gone away
Previous Comments:
------------------------------------------------------------------------
[2014-12-15 10:28:35] s dot adrichem at daisycon dot com
In php 5.3.23 this did not happen upon disconnects and such, eventough we never set the mode, now
though in PHP 5.6.3 it does happen even if we change the modes, with the following simple code.
$sHostName = "";
$sUserName = "";
$sPassword = "";
$sDefaultDb = "";
$sTestQuery = " SELECT NOW()";
$iPort = 3306;
$oDb = new PDO(
'mysql:host='.$sHostName.';port=' . $iPort,
$sUserName,
$sPassword
);
$oDb->setAttribute(
PDO::ATTR_ERRMODE,
PDO::ERRMODE_EXCEPTION
);
var_dump($oDb->getAttribute(PDO::ATTR_ERRMODE) === PDO::ERRMODE_EXCEPTION);
$sQuery = "SET WAIT_TIMEOUT = 1";
$oResult = $oDb->prepare( $sQuery );
$oResult->execute();
$sQuery = "use " . $sDefaultDb;
$oResult = $oDb->prepare( $sQuery );
$oResult->execute();
sleep(3);
$oResult = $oDb->prepare( $sTestQuery );
$oResult->execute();
while ($aRow = $oResult->fetch( PDO::FETCH_ASSOC ))
{
var_dump($aRow);
}
I get the following warnings:
Warning: PDOStatement::execute(): MySQL server has gone away in pdotest.php on line 31
Warning: PDOStatement::execute(): Error reading result set's header in pdotest.php on line 31
And then the expected exception
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General
error: 2006 MySQL server has gone away' in pdotest.php on line 31
Same goes for silent mode, so whats the point of these modes then ;)
------------------------------------------------------------------------
[2012-06-24 10:15:44] pineain at gmail dot com
Same problem on Windows 7 x64
------------------------------------------------------------------------
[2012-05-15 11:37:54] jach at wayf dot dk
Same error on OSX version 3.5.10
------------------------------------------------------------------------
[2010-12-22 17:19:46] alexc223 at googlemail dot com
Maybe there needs to be a way for it to know? Either way, it's highly annoying
since there is very little ways to handle it.
------------------------------------------------------------------------
[2010-11-02 22:12:57] felipe@php.net
The warning come from mysqlnd_connect() call that nothing knows about such PDO feature...
------------------------------------------------------------------------
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=53185
--
Edit this bug report at https://bugs.php.net/bug.php?id=53185&edit=1