Upgrade problems
| Project: | Administration menu |
| Version: | 6.x-1.5 |
| Component: | Miscellaneous |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | won't fix |
Jump to:
After updating from 1.5 to 3alpha or Dev, A message displays at the top of my screen and another one at the top of the content which runs too many pages long to estimate.
Warning: Got a packet bigger than 'max_allowed_packet' bytes query: INSERT INTO drupal_watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:1814815:\"Got a packet bigger than 'max_allowed_packet' bytes\nquery: UPDATE drupal_cache_menu SET data = 'a:2:{s:4:\\"tree\\";a:151:{i:1;a:2:{s:4:\\"link\\";a:37:{s:14:\\"load_functions\\";s:0:\\"\\";s:16:\\"to_arg_functions\\";s:0:\\"\\";s:15:\\"access_callback\\";s:1:\\"1\\";s:16:\\"access_arguments\\";s:6:\\"a:0:{}\\";s:13:\\"page_callback\\";s:17:\\"system_batch_page\\";s:14:\\"page_argument in /[Drupal install path]/includes/database.mysqli.inc on line 128
and
user warning: Got a packet bigger than 'max_allowed_packet' bytes query: UPDATE drupal_cache_menu SET data = 'a:2:{s:4:\"tree\";a:151:{i:1;a:2:{s:4:\"link\";a:37:{s:14:\"load_functions\";s:0:\"\";s:16:\"to_arg_functions\";s:0:\"\";s:15:\"access_callback\";s:1:\"1\";s:16:\"access_arguments\";s:6:\"a:0:{}\";s:13:\"page_callback\";s:17:\"system_batch_page\";s:14:\"page_arguments\";s:6:\"a:0:{}\";s:5:\"title\";s:0:\"\";s:14:\"title_callback\";s:1:\"t\";s:15:\"title_arguments\";s:0:\"\";s:4:\"type\";s:1:\"4\";s:11:\"description\";s:0:\"\";s:9:\"menu_name\";s:10:\"navigation\";s:4:\"mlid\";s:1:\"1\";s:4:\"plid\";s:1:\"0\";s:9:\"link_path\";s:5:\"batch\";s:11:\"router_path\";s:5:\"batch\";s:10:\"link_title\";s:0:\"\";s:7:\"options\";s:6:\"a:0:{}\";s:6:\"module\";s:6:\"system\";s:6:\"hidden\";s:2:\"-1\";s:8:\"external\";s:1:\"0\";s:12:\"has_children\";s:1:\"0\";s:8:\"expanded\";s:1:\"0\";s:6:\"weight\";s:1:\"0\";s:5:\"depth\";s:1:\"1\";s:10:\"customized\";s:1:\"0\";s:2:\"p1\";s:1:\"1\";s:2:\"p2\";s:1:\"0\";s:2:\"p3\";s:1:\"0\";s:2:\"p4\";s:1:\"0\";s:2:\"p5\";s:1:\"0\";s:2:\"p6\";s:1:\"0\";s:2:\"p7\";s:1:\"0\";s:2:\"p8\";s:1:\"0\";s:2:\"p9\";s:1:\"0\";s:7:\"updated\";s:1:\"0\";s:15:\"in_active ..........for more pages that I will post here
I am using Firefox 3.5 and Internet Explorer 7. I've tried switching themes, clearing the caches, running update.php, running cron, disabling and uninstalling the module and all others that reference watchdog and a few other things including increasing the PHP and MySQL memory limits, but nothing seems to fix the problem other than a database restore using Backup and Migrate. I have verfied that it has something to do with this module being upgraded but have not had time to fully test it out by creating a new drupal install and then trying to enable and upgrade this module before messing with any others. The problem does did not occur on the sites that already had version 3 Alpha or Developer. Once the problem occurs it does not go away and each time I try to edit a page I get an error list so long that it takes 30+ seconds for the page to load.

#1
I had the same problem when I tried to upgrade to 3.X. It actually hosed my whole menu system and wouldn't let me login to I had to revert to a backed up database. I really like this module but the bugs are killing me.
#2
This is a bug in Drupal core. Alternatively, your MySQL is not properly configured.
#3
Any suggestions on correcting the MYSQL configuration?