[support] Drupal 6 - strange menu related issue

Earnie Boyd earnie at users.sourceforge.net
Wed Oct 10 16:51:00 UTC 2012


On Wed, Oct 10, 2012 at 10:10 AM, Karsai Balázs wrote:
> 2012.10.09. 14:02 keltezéssel, Earnie Boyd írta:
>
> Check that you have "Database Logging" enabled at admin/build/modules.
>
>
> I enabled this module and added a menu item to see what happens. Now I get a
> lot of
> mysql errors when trying to edit a node (if I delete the menu item,
> everything is fine again).
>
> I got about 120 of these kind of errors, all in database.mysqli.inc on line
> 128:
>
>
> Warning: MySQL server has gone away query: INSERT INTO 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:1687470:\"MySQL server has gone away\nquery:
> UPDATE cache_menu SET data =
> 'a:2:{s:4:\\"tree\\";a:76:{i:212;a:2:{s:4:\\"link\\";a:37:{s:14:\\"load_functions\\";N;s:16:\\"to_arg_functions\\";N;s:15:\\"access_callback\\";N;s:16:\\"access_arguments\\";N;s:13:\\"page_callback\\";N;s:14:\\"page_arguments\\";N;s:5:\\"title\\";N;s:14:\\"title_callback\\";N;s:15:\\"title_arguments\\";N;s:4:\\"type\\";N;s:11:\\"description\\";N;s:9:\\"menu_name\\&
> in C:/Program Files (x86)/Apache Software
> Foundation/Apache2.2/htdocs\includes\database.mysqli.inc on line 128
>

The amount of data being set in cache_menu.data is larger than you
MySQL configuration allows.

> It looks like quite a lot of queries fail, but I don't know what to look
> for.
> Other than this, there are a bunch of errors in the log, regarding language
> javascript files that cannot be created,
> but they are there before and after inserting a menu link.
>
> Any suggestions?

You'll need to adjust your MySQL server configuration.

-- 
Earnie
-- https://sites.google.com/site/earnieboyd


More information about the support mailing list