I upgraded my site to Drupal 7, and noticed that now when I edit or add content types I receive an error (included below). Trial and error has narrowed the culprit down to Node Location; when I enable the Node Location sub-module the errors start, and when I disable it they go away. I even tried uninstalling the Node Location module and then enabling it fresh, but the error still occurs. Here is the error message I receive when adding/editing content types with Node Location enabled:

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT * FROM {menu_router} WHERE path IN (:ancestors_0, :ancestors_1, :ancestors_2, :ancestors_3, :ancestors_4, :ancestors_5, :ancestors_6) ORDER BY fit DESC LIMIT 0, 1; Array ( [:ancestors_0] => location/autocomplete/ca [:ancestors_1] => location/autocomplete/% [:ancestors_2] => location/%/ca [:ancestors_3] => location/%/% [:ancestors_4] => location/autocomplete [:ancestors_5] => location/% [:ancestors_6] => location ) in menu_get_item() (line 450 of C:\xampp\htdocs\includes\menu.inc).

Comments

canadrian’s picture

I should add that I'm on the latest 7.x-3.x-dev version from the end of August.

canadrian’s picture

Status: Active » Closed (works as designed)

I found the solution at http://drupal.org/node/984112#comment-4025560 - apparently it's a MySQL problem and not a Drupal/Location problem. The "max_allowed_packet" in my.ini needs to be increased and the MySQL server restarted.

mrpauldriver’s picture

I'm getting the same. I'm using WAMP but the above mentioned fix is not working for me. I've tried increasing the values but it is still broken.

This only happens when the Node Locations module is enabled and only when I attempt to edit my content types.

Stuck !