By tracytli on

Hi,

Could anyone tell me how to solve the following problem? Thanks!

user error: Got a packet bigger than 'max_allowed_packet' bytes
query: UPDATE node SET status = '1', moderate = '0', promote = '0', sticky = '0', comment = '0', title = ...
in .../includes/database.mysql.inc on line 66.

warning: Cannot modify header information - headers already sent by (output started at .../includes/common.inc:385) in .../includes/common.inc on line 193.

⋅ Categories: Drupal 4.5.x or older

Comments

tracytli’s picture

tracytli commented

I've fixed this problem.

frankgavin’s picture

frankgavin commented

How did you fix it?
I'm running into the same problem.

jmandala’s picture

jmandala commented

The file that I'm trying to attach is 374KB. /etc/my.cnf includes the following:

set-variable = max_allowed_packet=1M

I don't know why the error would occur in this situation, 1M seems like plenty for a 374KB file.

I resolved the problem by increasing the value to 3M and restarting the mysql server.

set-variable = max_allowed_packet=1M

I hope this helps!

lunatinker’s picture

lunatinker commented

Tools, tips, and links on optimizing mysql
http://drupal.org/node/85768
also -> http://drupal.org/node/121390

francewhoa’s picture

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

The following worked for me on Ubuntu 8.04.x LTS desktop edition http://drupal.org/node/541396

Loving back your Drupal community result in multiple benefits for you