Community Documentation

"Got a packet bigger than 'max_allowed_packet' " error

Last updated March 26, 2010. Created by Francewhoa on August 6, 2009.
Edited by dchang, iantresman. Log in to edit this page.

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

drupal_tweaks

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

Thanks kenorb

Thanks kenorb I added your option to the handbook.

i found clearing the cache on

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

The problem could be the browser

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
Ps: If you can not understand me, it's my poor English skills fault :-p

Page status

No known problems

Log in to edit this page

About this page

Drupal version
Drupal 4.7.x, Drupal 5.x, Drupal 6.x, Drupal 7.x
Audience
Developers and coders, Site administrators

Reference

Drupal’s online documentation is © 2000-2012 by the individual contributors and can be used in accordance with the Creative Commons License, Attribution-ShareAlike 2.0. PHP code is distributed under the GNU General Public License.
nobody click here