Hi I've been developing my Drupal site for a year, everything has been working fine and I haven't changed any modules (just been theming). All of a sudden at the end of last week, when trying to access my admin pages, it would take about 10 mins to load and then a huge bit of error code came up and at the bottom the admin links were visable. The code is (haven't added it all as its ridiculously long user warning: MySQL server has gone away query: 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:\"project_status\";s:9:\"published\";s:4:\"link\";s:36:\"http://drupal.org/project/admin_menu\";s:8:\"releases\";a:16:{s:14:\"6.x-3.0-alpha4\";a:21:{s:4:\"name\";s:25:\"admin_menu 6.x-3.0-alpha4\";s:7:\"version\";s:14:\"6.x-3.0-alpha4\";s:3:\"tag\";s:14:\"6.x-3.0-alpha4\";s:13:\"version_major\";s:1:\"3\";s:13:\"version_patch\";s:1:\"0\";s:13:\"version_extra\";s:6:\"alpha4\";s:6:\"status\";s:9:\"published\";s:12:\"release_link\";s:29:\"http://drupal.org/node/739026\";s:13:\"download_link\";s:69:\"http://ftp.drupal.org/files/projects/admin_menu-6.x-3.0-alpha4.tar.gz\";s:4:\"date\";s:10:\"1268274904\";s:6:\"mdhash\";s:32:\"ba93c801409700854965f87b5df72817\";s:8:\"filesize\";s:5:\"69865\";s:5:\"files\";s:4:\"\n \";s:4:\"file\";s:10:\"\n \n \";s:3:\"url\";s:135:\"http://ftp.drupal.org/files/projects/admin_menu-6.x-3.0-alpha4.tar.gzhttp://ftp.drupal.org/files/projects/admin_menu-6.x-3.0-alpha4.zip\";s:12:\"archive_type\";s:9:\"tar.gzzip\";s:3:\"md5

I've spoken to my hosting company and they've test mysql qhich they say is working fine. The strange thing is all my user facing pages are visable and work fine, its just the admin pages which results in this error.

I decided to backup the site and update to the latest version of Drupal 6 (which i've never done before). I uploaded the new files via ftp but I understand I need to update the database too and all the user contributed modules i've installed. How do I do this if the admin screen isn't working?

cheers

Comments

peterjlord’s picture

Try running example.com/update.php

phatmike10’s picture

So if I run that it should update my database with the new installation? Will it also update the user contributed modules and if so how long roughly does the process take?

cheers

peterjlord’s picture

It should do but make sure you get a backup of everything.
The length of this is dependent on the number on modules you have installed and amount of content on the site.
I'd recommend doing a test go first in-case there's any problems.
You may have to change something in you settings.php to give you access to the url

phatmike10’s picture

Hi thanks for this, I tried doing it and no errors occured but it was extremly quick almost too quick! It said it updated as follows:

The following queries were executed
color module
Update #6001

I've got a lot more modules than color, should it say all the modules that have been updated? Is so there should be a lot more being updated as i've never done an update before.

If it has worked, I'm still getting the original error, i've truncated all caches, so kind of out of ideas of what to do?

peterjlord’s picture

You should get a blue progress bar which goes through all the updates.
It's best to follow the instructions step by step as described http://drupal.org/documentation/upgrade/5/6
This looks even more detailed than when I used it.