I too was getting the error message "Got a packet bigger than 'max_allowed_packet' bytes" when selecting a page for a book. This modules seems to provide a solution.

1. Be nice if the Database Tweaks page reassured us novices that the database settings shown are the current settings; I wasn't sure whether I was expected to set all the values to reasonable values.

2. My MySQL database would not let me set a new MAX_ALLOWED_PACKET. Perhaps the module could check that if a new value is specified, it is actually accepted, otherwise provide a warning message to the contrary.

3. Perhaps an option to "Restore database values", just in case we get too enthusiastic and forget what we've changed.

Comments

kenorb’s picture

kenorb commented

1. Yes, its a good idea.

2. It's already done. If value is not accepted (there is some hosting limitation), there is a warning that value can't be changed. And the setting should be reverted automatically.

3. Did you tried 'Restore to defaults' button? I'm not sure, but it should work.

I'll make some tests.

iantresman’s picture

iantresman commented

Thanks for that.

I was finally able to get my web host to increase the 'max_allowed_packet' from 1Mb to 4Mb, which solved my problem.

kenorb’s picture

kenorb commented
Status: Active » Needs work

2. It's fixed in latest dev version.

kenorb’s picture

kenorb commented
Status: Needs work » Fixed

1.
http://drupal.org/cvs?commit=346084

2.
#545126: Increasing max_allowed_packet not possible in modern version of MySQL

3.
Try 'Reset to defaults' option or deactivate 'Enable database tweaks.'

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.