By fuzzyjared on

We have drupal 6.2 installed and configured, everything was working fine, and all of a sudden the module page stopped working and produces the error below.

Internal Server Error. Please contact a server administrator.

There is nothing saved into the error log file and there isn't any code/number produced ( 500 etc...) I spoke with the hosting company and they said that the error that is produced isn't one that is produced by their server.

This error only occurs on the module page. and nowhere else. We have the php_memory set to 32mb's but that doesn't help.

⋅ Categories: Drupal 6.x

Comments

vm’s picture

vm commented

Id upgrade to drupal 6.3 and see if problem is still there.

if so: i'd disable modules manually in the DB by setting their status to 0 in the system table.

fuzzyjared’s picture

fuzzyjared commented

I will try that and post back.

fuzzyjared’s picture

fuzzyjared commented

I updated to 6.3 and i am still getting the error. I will next try to go through the modules and disable by default.

Does anyone know if Drupal could write this error out due to some kind of time out issue?

fuzzyjared’s picture

fuzzyjared commented

In looking at the report page for errors I am seeing a problem with web forms, stating:

Duplicate entry 'admin/content/node-type/image/groups/%/remove' for key 1 query: INSERT INTO menu_router (path, load_functions, to_arg_functions, access_callback, access_arguments, page_callback, page_arguments, fit, number_parts, tab_parent, tab_root, title, title_callback, title_arguments, type, block_callback, description, position, weight, file) VALUES ('admin/content/node-type/image/groups/%/remove' ETC... in /data/17/1/91/55/1580544/user/1702633/htdocs/includes/menu.inc on line 2371.

I shortened the error quite a bit.

The error location is /admin/build/modules

The referrer is /admin/

what exactly does this mean? I know that it is saying there are duplicate entries for a unique key, but I am not sure where.

arhak’s picture

arhak commented

I guess you aren't a drupal developer (I mean, you don't develop modules for drupal) so you don't use the devel module, but if you are in a development stage you perfectly can install the devel module, activate one of it's blocks (activate them all then keep the one I'll tell you) who have a link to rebuild menu, that will fix the problem, but the issue might come up again...

Why?
- here I started a kind of index, it links to the real discussions: #289618: menu_router table truncated and site goes down: Transaction or Lock required for D6
- the development discussion, some patches to improve the chances but not real fix, developers talking about to solve the issue in D7 first and maybe backport it later to D6 (IMO it won't be fix unless a LOT of user complains about it, and the better the hardware the less chances to hit this issue): #238760: menu_router table truncated and site goes down
- a different symptom to the same issue: #246653: Duplicate entry in menu_router: Different symptoms, same issue
- more discussion marked as duplicated: #248739: Duplicate entry errors - lots of them
- the hart of the problem: #249185: Concurrency problem with variable caching leading to cache inconsistency

fuzzyjared’s picture

fuzzyjared commented

No.. I am not a drupal module developer. I have developed a couple small modules, but I am new to it and I have not ran into this before. I would gladly install devel, but at this moment I can't because I am unable to access the modules page in the admin.

arhak’s picture

arhak commented

But you aren't a newbie, so you can deal with it.
Here is your roadmap:
- Create a repair.php file with the following code

  require_once './includes/bootstrap.inc';
  drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);
  menu_rebuild();

- upload the file to your server
- access the page and wait
- if there is no timeout it would do the trick.
- if there is a timeout, go to php.ini and increase the max_execution_time and increase it's value (up to 600 if needed, even more if it's a slow PC, later you can tune this to your needs)