The S-Files: Acquia Drupal Stack installer Got packet bigger than max_allowed_packet bytes
by Robert Douglass
Tech Support Case Studies
The S-Files are a taste of the support that you get with a subscription to Acquia Support. Our support team helps you solve technical problems relating to your Drupal sites.
The Acquia Drupal Stack installer is a major productivity booster for getting up and running in the development of your Drupal site. Sometimes, though, Drupal modules like to cache huge data packets in the database. This results in an error in your browser that says this:
Got packet bigger than ‘max_allowed_packet’ bytes
This is an indication that the data being sent between Drupal and the database is large, and exceeds the default setting.
Fortunately the fix for this is easy. In the application installation directory of the stack installer you'll find the following directory and file:
Edit the my.ini file with whatever text editor you like, and add these lines to the end:
max_allowed_packet = 128M
Now stop and start the Acquia Drupal Stack using the Acquia Drupal Control Panel, and the new setting will come into effect. This should solve your max_allowed_packet problem!