I have a website with a lot of nodes (like 1000). All this nodes are linked in a menu. The website has got 5 menus, but the menu I called "nav" has got all the nodes linked to it

From this Sunday there is a very strange behaviour: when I create a node and add this node to the "nav" menu (the problem is only with this specific menu), I save then I go to every page of the site and click on "modify node" the header of the website disappear, all the contents disappear, and there also some strange message appearing when saving again the node like "The username admin does not exist."

The same problem appears creating new nodes

If I cancel for example 3 nodes from the list, I can add 3 new nodes without problem, but on the fourth The problem appears, like some limit has benne reached

I'm running drupal on a windows server with IIS

What can be happened? maybe something at the DB level?

Comments

dddave’s picture

dddave commented
Assigned: mikikiki » Unassigned
Category: bug » support
Status: Active » Postponed (maintainer needs more info)

Any updates? Site now 6.20?

dpearcefl’s picture

dpearcefl commented

is this still an active issue?

dpearcefl’s picture

dpearcefl commented
Priority: Critical » Normal
Status: Postponed (maintainer needs more info) » Fixed

No response, so I'm going to assume this issue has been resolved.

Status: Fixed » Closed (fixed)

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

moha7’s picture

moha7 commented

I had the exact same issue with Drupal 6.19 and a very large menu tree. Just posting to help anyone who finds this thread.

The cause of this was that the mysql packet size was exceeded. The packet size is 1MB by default and if it is exceeded, mysql just closes the connection. If this limit is increased, the problem is gone.

Adding the following line to the mysql config (my.ini) completely solves the issue:

[mysqld]
max_allowed_packet = 16M

This config value increases packet size from the default 1MB to 16MB. That should be enough for even a large menu system.