## General help

This discussion has been locked because a year has elapsed since the last post. Please start a new discussion topic.

max_allowed_packet is set in mysql config (my.cnf), NOT ON php side (ie. php.ini)

sql> SHOW VARIABLES LIKE 'max_allowed_packet';

In your my.cnf file, increase the size of max_allowed_packet to say 32MB (or greater than waht your database's settings are)

[mysqld]

max_allowed_packet=32M

restart your mysql services and try again

PS. You don't really need 32M ... 16M should be fine too..

Average of ratings: -

my.cnf file

[mysqld]
max_allowed_packet=32M

Average of ratings: -

That was it.  Thank yuio very much for setting me in the right direction.

Average of ratings: -

No problem Mike.

You also may want to tweak another parameter if you are using a lot of form fields.

Increase the max_input_vars in php.ini

This PHP configuration limits the maximum number of fields to post in a form: 1000 for max_input_vars

Increase it to somethin large like:

max_input_vars=19980

By doing this, it will prevent you from getting the error:

"Warning, your PHP configuration limits the maximum number of fields to post in a form: 1000 for max_input_vars."

Average of ratings: -