+ Post New Thread
Results 1 to 12 of 12
Virtual Learning Platforms Thread, Moodle 1.9.9 upgrade nightmare in Technical; Hello everyone, I hope someone can help with my current Moodle problem. . . I upgraded from Moodle 1.9.5 to ...
  1. #1

    Join Date
    Sep 2005
    Location
    Leicester
    Posts
    80
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Unhappy Moodle 1.9.9 upgrade nightmare

    Hello everyone, I hope someone can help with my current Moodle problem. . .

    I upgraded from Moodle 1.9.5 to 1.9.9 using the moodle.org package. This also upgraded my server's PHP, Apache and mySQL, of course. I now find I cannot use my previous 1.9.5 database or moodledata folder.

    The best I can manage is a completely new and empty install of Moodle 1.9.9, using the default database and moodledata folder. Any attempts to 'point' Moodle 1.9.9 at the 1.9.5 database and/or moodledata folder result in the dreaded 'Database connection failed. It is possible that the database is overloaded or otherwise not running properly' error.

    mySQL can see the 1.9.5 database and run commands on it. Running mysqlcheck shows several tables as corrupt with the error 'Incorrect key file'. Using mysqlcheck's '--auto-repair --optimize' and mysql's 'repair' doesn't change this.

    I should probably say I am running this on a Windows Server 2003 machine, which may surprise none of you. Please don't shout at me, I had nothing to do with that decision - I am merely the poor sap who has a broken Moodle just before the start of a new academic year.

    Finally, apologies if the solution is elsewhere on here or t'internet in general. Trust me, I have looked, but as time has gone on and my brain has become ever more fried I may have missed it.

  2. #2
    pritchardavid's Avatar
    Join Date
    Sep 2009
    Location
    South Ockendon, Thurrock, United Kingdom
    Posts
    932
    Thank Post
    18
    Thanked 64 Times in 58 Posts
    Rep Power
    25
    Have you got a backup of the database? If so it's best to restore from that

    Personally I would have waited for 2.0 to cone out, that's what I'm doing, think we have 1.9.5 toi

  3. #3


    Join Date
    Feb 2007
    Location
    Northamptonshire
    Posts
    4,690
    Thank Post
    352
    Thanked 795 Times in 714 Posts
    Rep Power
    346
    Deep breath.

    Back up the exact situation at this time.

    Do you have a back up of the database? If so, restore it and try and upgrade Moodle again, I wonder if something has gone wrong in the upgrade.

  4. #4
    morganw's Avatar
    Join Date
    Apr 2009
    Location
    Cambridge
    Posts
    816
    Thank Post
    46
    Thanked 132 Times in 126 Posts
    Rep Power
    39
    When you extracted the new moodle folder you'll have to change the config.php file to include your old site address, mysql username and mysql password. You'll get that error if you haven't changed it.

  5. #5

    Join Date
    Sep 2005
    Location
    Leicester
    Posts
    80
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks everyone - this is certainly more help than I'm getting from the moodle.org community at present!

    config.php has all the old site info as it should be. There's a new password for the mySQL user but config.php has that as well. I'm going to try sticking Moodle 1.9.5 back on and see if it works with the new mySQL/PHP/Apache setup. Wish me luck (or laugh cynically, whatever floats your boat).

  6. #6


    Join Date
    Feb 2007
    Location
    Northamptonshire
    Posts
    4,690
    Thank Post
    352
    Thanked 795 Times in 714 Posts
    Rep Power
    346
    It'll pan out alright, it's a pretty robust implementation.

    I've done a few 1.9.x to 1.9.9 upgrades recently (albeit on linux) and it's gone fine apart from a few teething issues with 'non standard' modules.

  7. #7
    sister_annex's Avatar
    Join Date
    Jan 2009
    Location
    Wolverhampton
    Posts
    593
    Thank Post
    99
    Thanked 135 Times in 119 Posts
    Rep Power
    49
    Our upgrade from 1.9.8+ to 1.9.9 went well, no issues (we dont have any non standard modules though) just copied/ replaced the files over the original (did take a backup!) and then let moodle do the rest - it should perform the upgradeand update the tables etc

  8. #8
    morganw's Avatar
    Join Date
    Apr 2009
    Location
    Cambridge
    Posts
    816
    Thank Post
    46
    Thanked 132 Times in 126 Posts
    Rep Power
    39
    I did an upgrade last weekend and found that the database would get upgraded but some post-processes would hang. In the end I think I had to loosen the permissions on the /tmp folder so the upgrade procedure would go all the way through. Not sure where the designated temp folder would be on a Windows installation though.

  9. #9

    Join Date
    Sep 2005
    Location
    Leicester
    Posts
    80
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks again, everyone - have now returned to Moodle 1.9.5 with its older versions of Apache, PHP and mySQL from a backup. Deep breath, lessons learned and all that.

  10. #10


    Join Date
    Feb 2007
    Location
    Northamptonshire
    Posts
    4,690
    Thank Post
    352
    Thanked 795 Times in 714 Posts
    Rep Power
    346
    Glad you're working again.

  11. #11
    gshaw's Avatar
    Join Date
    Sep 2007
    Location
    Essex
    Posts
    2,655
    Thank Post
    164
    Thanked 218 Times in 201 Posts
    Rep Power
    67
    As far as 2.0 goes it's going to be next year minimum before that's a realistic option... we'll be lucky if we see the release version in September and surely no-one is crazy enough to upgrade a live site to a .0 release for the start of their new academic year?!

    Then there's the interface changes, training for staff etc, I think 2.1 will be a better bet unless you need the new features desperately (I certainly want the repository functions but it's not enough to make me take the risk at the moment).

  12. #12

    Join Date
    Apr 2006
    Location
    UK
    Posts
    939
    Thank Post
    39
    Thanked 70 Times in 54 Posts
    Rep Power
    29
    Agree with gshaw, 2.0 isnt going to be a viable option for a while yet and ill also be waiting for 2.1.

SHARE:
+ Post New Thread

Similar Threads

  1. Had a nightmare with Exchange!!!
    By RichB in forum Office Software
    Replies: 8
    Last Post: 23rd June 2010, 02:00 PM
  2. Nightmare in a network
    By Rydra in forum Windows
    Replies: 46
    Last Post: 26th January 2010, 01:28 PM
  3. NtBackup Nightmare!
    By jpenn in forum Windows Server 2000/2003
    Replies: 8
    Last Post: 21st August 2009, 08:45 AM
  4. Moodle & LDAP, What a nightmare!
    By SkreeM1980 in forum Virtual Learning Platforms
    Replies: 5
    Last Post: 23rd January 2009, 01:28 PM
  5. Nightmare
    By mrforgetful in forum ICT KS3 SATS Tests
    Replies: 6
    Last Post: 16th May 2006, 02:27 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •