Re: Error inserting blob into database
I changed the max_packet_size, not sure about the "local."
No pause, comes back quickly.
I get this while stepping through the PHP code:
PDOStatement::execute(): send of 8192 bytes failed with errno=10053 An established connection was aborted by the software in your host machine.
The code is inserting multiple items (4 items). It inserts the first one, but errors on the 2, 3, 4th...
I get this inthe PHP Error log, nothing in the MySQL logs.
[26-Mar-2021 22:53:36 America/Los_Angeles] PHP Warning: PDOStatement::execute(): MySQL server has gone away in C:\inetpub\wwwroot\inc\functions.inc.php on line 1490
[26-Mar-2021 22:53:36 America/Los_Angeles] PHP Stack trace:
[26-Mar-2021 22:53:36 America/Los_Angeles] PHP 1. {main}() C:\inetpub\wwwroot\admin\import_fe.php:0
[26-Mar-2021 22:53:36 America/Los_Angeles] PHP 2. include() C:\inetpub\wwwroot\admin\import_fe.php:129
[26-Mar-2021 22:53:36 America/Los_Angeles] PHP 3. UpdateDB_Calibration($dbL = *uninitialized*, $DBH = *uninitialized*, $debug = *uninitialized*) C:\inetpub\wwwroot\admin\import.php:1155
[26-Mar-2021 22:53:36 America/Los_Angeles] PHP 4. AddOrUpdateCalibrationObject($DBH = *uninitialized*, $calibration_id = *uninitialized*, $type_id = *uninitialized*, $plainObject = *uninitialized*, $debug = *uninitialized*) C:\inetpub\wwwroot\admin\import.php:922
[26-Mar-2021 22:53:36 America/Los_Angeles] PHP 5. PDOStatement->execute() C:\inetpub\wwwroot\inc\functions.inc.php:1490
[26-Mar-2021 22:53:37 America/Los_Angeles] PHP Warning: PDOStatement::execute(): Error reading result set's header in C:\inetpub\wwwroot\inc\functions.inc.php on line 1490
[26-Mar-2021 22:53:37 America/Los_Angeles] PHP Stack trace:
[26-Mar-2021 22:53:37 America/Los_Angeles] PHP 1. {main}() C:\inetpub\wwwroot\admin\import_fe.php:0
[26-Mar-2021 22:53:37 America/Los_Angeles] PHP 2. include() C:\inetpub\wwwroot\admin\import_fe.php:129
[26-Mar-2021 22:53:37 America/Los_Angeles] PHP 3. UpdateDB_Calibration($dbL = *uninitialized*, $DBH = *uninitialized*, $debug = *uninitialized*) C:\inetpub\wwwroot\admin\import.php:1155
[26-Mar-2021 22:53:37 America/Los_Angeles] PHP 4. AddOrUpdateCalibrationObject($DBH = *uninitialized*, $calibration_id = *uninitialized*, $type_id = *uninitialized*, $plainObject = *uninitialized*, $debug = *uninitialized*) C:\inetpub\wwwroot\admin\import.php:922
[26-Mar-2021 22:53:37 America/Los_Angeles] PHP 5. PDOStatement->execute() C:\inetpub\wwwroot\inc\functions.inc.php:1490
[26-Mar-2021 22:53:39 America/Los_Angeles] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in C:\inetpub\wwwroot\inc\functions.inc.php:1490
Stack trace:
#0 C:\inetpub\wwwroot\inc\functions.inc.php(1490): PDOStatement->execute()
#1 C:\inetpub\wwwroot\admin\import.php(922): AddOrUpdateCalibrationObject(Object(PDO), '42222', 48, 'D\xB7S\x900\xC0\xB2f\xDB\xFE\xDB\xB6m\xDB\xB6...', false)
#2 C:\inetpub\wwwroot\admin\import.php(1155): UpdateDB_Calibration(Object(PDO), Object(PDO), false)
#3 C:\inetpub\wwwroot\admin\import_fe.php(129): include('C:\\inetpub\\wwwr...')
#4 {main}
thrown in C:\inetpub\wwwroot\inc\functions.inc.php on line 1490