PDO: MySQL server has gone away

by

Most likely you sent a packet to the server that is longer than the maximum allowed packet.

When you try to insert a BLOB that exceeds your server’s maximum packet size, even on a local server you will see the following error message on clientside:

MySQL server has gone away

And the following error message in the server log: (if error logging is enabled)

Error 1153 Got a packet bigger than ‘max_allowed_packet’ bytes

To fix this, you need to decide what is the size of the largest BLOB that you will ever insert, and set max_allowed_packet in my.ini accordingly, for example:

[mysqld]
...
max_allowed_packet = 200M
...

More Related Contents:

  1. Insert form in MySQL with PDO [duplicate]
  2. Undefined index $_POST
  3. How to check if a row exists in MySQL? (i.e. check if username or email exists in MySQL)
  4. Getting raw SQL query string from PDO prepared statements
  5. How do I set ORDER BY params using prepared PDO statement?
  6. “Invalid parameter number: parameter was not defined” Inserting data
  7. Having issue with matching rows in the database using PDO
  8. How can I properly use a PDO object for a parameterized SELECT query
  9. How do I return integer and numeric columns from MySQL as integers and numerics in PHP?
  10. PDO with INSERT INTO through prepared statements [closed]
  11. PDO::fetchAll vs. PDO::fetch in a loop
  12. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  13. Real escape string and PDO [duplicate]
  14. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  15. PDO Connection Test
  16. PHP PDO vs normal mysql_connect
  17. Can I create a database using PDO in PHP?
  18. PDO fetch one column from table into 1-dimensional array
  19. Getting a PHP PDO connection from a mysql_connect()?
  20. PDO error: SQLSTATE[HY000]: General error: 2031
  21. Having issue with matching rows in the database
  22. Checking for an empty result (PHP, PDO, and MySQL) [duplicate]
  23. PHP/SQL Insert Error when using Named Placeholders
  24. How to escape single-quote (apostrophe) in string using php
  25. PHP Laravel: No connection could be made because the target machine actively refused it
  26. php, mysql – Too many connections to database error
  27. PDO bindParam into one statement?
  28. Insert value list does not match column list: 1136 Column count doesn’t match value count
  29. What is the PDO equivalent of function mysql_real_escape_string?
  30. Installing PDO driver on MySQL Linux server

Leave a Comment