By voidengine on

Anyone have insight into this error message? I get it when I update a field in my content type:

user warning: Got a packet bigger than 'max_allowed_packet' bytes query: UPDATE cache_views SET data =... (lots of data)

Thanks...

⋅ Categories: Drupal 5.x

Comments

cog.rusty’s picture

cog.rusty commented

It is a MySQL setting. See:

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

voidengine’s picture

voidengine commented

That did the trick! I also found something here:http://drupal.org/node/121390.

Since I'm running MySQL using MAMP, my fix was to edit /applications/MAMP/binstartMysql.sh and add the flag:
-- max_allowed_packet=32M

hunthunthunt’s picture

hunthunthunt commented

I am running on MAMP also.

Note the space in the above will cause an error, should be:

--max_allowed_packet=32M

calebgilbert’s picture

calebgilbert commented

In addition to the correct from hunthunthunt - also be sure to place it before the ampersand at the end of the file. (in my first attempt at getting this to work, I didn't notice it there) :-)

~~~
HigherVisibility

yesct’s picture

yesct commented

perfect, this worked for me!

Anonymous’s picture

Anonymous (not verified) commented

Small typo ..

/applications/MAMP/bin/startMysql.sh