Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By michael kh on
My hosting service provider transferred my site to a new host, and now the site works but the admin menu does not: Whatever menu item I choose, I get the following message or something similar:
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:1023:\"MySQL server has gone away\nquery: UPDATE cache_update SET data = 'a:23:{s:10:\\"admin_menu\\";a:10:{s:5:\\"title\\";s:19:\\"Administration menu\\";s:10:\\"short_name\\";s:10:\\"admin_menu\\";s:10:\\"dc:creator\\";s:3:\\"sun\\";s:11:\\"api_version\\";s:3:\\"6.x\\";s:17:\\"recommended_major\\";s:1:\\"1\\";s:16:\\"supported_majors\\";s:3:\\"1,3\\";s:13:\\"default_major\\";s:1:\\"1\\";s:14:\\"proje in /home/mikekh/public_html/includes/database.mysql.inc on line 128
Can anyone suggest what is causing this?
Comments
=-=
using phpmyadmin on your host or preferable tool. check the watchdog table to see if it needs repair. You can empty this table as well as you may only want to see infortion in your logs since the move.
another note: admin menu can be disabled, uninstalled using the uninstall tab. Then reinstalled and set up. Though I don't believe it is the crux of the issue. It's likley that nothing can write to the watchdog table at this point.
Now I've realised that I am
Now I've realised that I am getting several screenfuls of these WARNING messages, followed by the actual page which should display.
1. How do I disable inline WARNING messages? Is this in php.ini? If so, where do I find that file?
2. Aren't these WARNING messages trying to tell me something? Are a lot of queries being retried before they succeed?
=-=
best to leave them enabled so that you know when it's fixed.
Thanks, VM. I'll go take a
Thanks, VM. I'll go take a look.
watchdog table checked OK. I
watchdog table checked OK. I cleared it (PHPmyAdmin truncates it). No new entries. Looks as if Drupal can't write to the table. Tried editing a content record. Drupal successfully updated the table for that content type, so it's writing to the db OK.
=-=
which leaves trying to disable, uninstall the admin menu, clear cache tables, reenable admin_menu. I'd also make sure it's the most up to date version of the module.
admin menu doesn't hold any content and only has few settings thus resetting it up after uninstall shouldn't be a bug deal.
In that case, I think I
In that case, I think I should take this as a motive for upgrading to the latest release - I'm at least one level down. I've never done a Drupal upgrade before - where is the best set of instructions for upgrading? It looks slightly more involved than uploading anew level of Wordpress...
Thanks again for your help.
=-=
I wouldn't attempt an upgrade until you work through disabling admin_menu
There are multiple threads, with minor upgrade instructions. For most part it's extract new download upload it to your current drupal root overrwiting all files and folders.
if .htaccess was altered, compare files for changes
if settings.php was altered compre file for changes.
Thanks again, VM. Sorry, I
Thanks again, VM. Sorry, I don't have much time to spend on this each day, but I am following your advice. I'd appreciate it if you can continue to monitor this thread.
'admin' was a menu created to
'admin' was a menu created to provide links to data entry views for use by contributors to my site in the early stages, and is no longer used. I deleted all items and then deleted the menu itself. Problem still the same.
Next, I disabled and uninstalled the Drupal Administer menu. Still no improvement. I guess now I really do need to delete the current release of Drupal and install 6.15. It may be a couple of days before I do this.