When using Drupal your browser returns the following error

Got a packet bigger than 'max_allowed_packet'

The most likely cause of this error is your MySQL server. If you're new to Drupal think of MySQL server as a database.

To fix this, select the option below that better matches your needs: The beginners option or the advanced option.

Comments

kenorb’s picture

kenorb commented

On shared hosting you may try following module:
http://drupal.org/project/drupal_tweaks
You can increase your MySQL and PHP memory.

Francewhoa’s picture

Francewhoa
he/him
Primary language French
Location Sept-Îles, Québec, 🇨🇦
commented

Thanks kenorb I added your option to the handbook.

Loving back your Drupal community result in multiple benefits for you  
harvlad’s picture

harvlad commented

i found clearing the cache on my site, then reimporting the database fixed this error

calbasi’s picture

calbasi
Primary language Catalan
Location Catalonia
commented

Hello,

I've got this error. But:

- It was only in one of my several webs (hosted at the same VPS / server, same my.cnf, etc.)
- I have it only with my Iceweasel (firefox) 3.5.10 (debian testing)

Here you can read than "Both the client and the server have their own max_allowed_packet variable"

http://dev.mysql.com/doc/refman/5.1/en/packet-too-large.html

Ok, I've tried to increase the my.cnf memory to 32 or 64Mb without success but then I've think that my "client side" is my browser, isn't it... I've tried with other browser Epiphany 2.30.2 and I can now add / edit content without errors.

Regards!

www.calbasi.net

rhuffstedtler’s picture

rhuffstedtler commented

Since your comment is six years old, I'm guessing that you've already figured this out by now, so the reply is mostly for anyone else who comes along and finds this page.

Client in this instance is not your web browser. MySQL is a client server database. The client is the application that is opening the connection to interact with MySQL (in this case, Drupal using PHP PDO). The server is MySQL itself. Depending on your environment, you may have your MySQL server running on the same physical/virtual hardware as your Drupal installation or you may have it separate. If they are separate machines, you'll need to edit the my.cnf on both machines.