Note: You are currently viewing documentation for Moodle 2.3. Up-to-date documentation for the latest stable version is available here: Beginning Moodle 2.0 Administration.

Beginning Moodle 2.0 Administration

From MoodleDocs

The pages began life with the Beginning v1.9 Administration FAQ pages but are aimed specifically at Moodle 2.x. Many of the solutions to problems will work in both versions of Moodle so if you do not find something here, then you may find it in the other pages. The questions asked here are mostly questions that I was confronted with when I first started with administering a Moodle, but I had some experience as a user which helped me a lot. The other source of questions is the Moodle Forums.

My Host took my Moodle 2 down from the server due to an overload of the database.

This happens far too often on shared servers. The additional memory requirements of Moodle 2+ for installation and the additional database storage required is going to make it worse. The best bet is to find a dedicated server, that is the optimum, but reality is that costs do play a large part in making decisions about where a Moodle will be stored. A dedicated server will give you the entire disc space and all the memory on that server to use as you need. A virtual dedicated server means you are sharing with a few other users on a server, possibly as many as 10, but more likely 5 or 6. A shared server mean you are sharing one box with as many of the Host's clientele that can be put onto one server. This means sharing all resources and Moodle's demands get higher as the number of Users increases which affects all other Clients of the Host. There are any number of Moodle Partners who may be willing to host your Moodle, and the Internet also means you are not restricted by national or natural boundaries or currency transactions - politics, oceans and banks have no impact on where you host your Moodle.

Why am I having trouble restoring my existing Moodle 1.9.x courses into Moodle 2.0?

Simply put, the changes in coding between Moodle 1.9.x and Moodle 2.0 are large. Additional security has forced changes to the backup processes. In just looking at the databases there are an additional 60 or more tables, so that creates a number of restoring issues alone. To bring Moodle 1.9.x courses into Moodle 2.0 is a monumental challenge, and full credit to those who are trying it. There is, currently, one commercial Windows based solution but it is not fully successful in its restoration of courses.

NOTE: Moodle 2.0 can backup and restore courses from within itself perfectly, the issue appears to be centred on v1.x.x courses.
UPDATE: Moodle 2.1 was released on July 1, 2011 and can now restore course files from backups made in v1.9.x. Student file restorations are not yet available but are expected to be included in v2.2 to be released November, 2011.

How do I look up the error logs in Moodle 2.0?

First, turn the error logs on, go to

 Site administration ► Development ► Debugging

and set error messages to DEVELOPER: .... Then go to

 Site administration ► Reports ► Logs

set your report options to Home 2.0(Site), All Participants, All Activities or Site Errors, View, Display on Page and then click, "Get these logs". The report should give you something, and you may be able to develop an appropriate response from there.

Do I try to upgrade to Moodle 2.0 or just create a new install?

There is always debate around these issues, but simply put, Moodle 2.0 is a complete re-write of a tried and tested tool. This presents its own challenges, obviously, and those challenges need be met in the best way we can. It is a temptation to go all in and jump to the new tool, but this can be a dangerous practice when dealing with a lot of people who are resistant to change, and the change from Moodle 1.9.x to 2.0 is massive.

 Upgrading to Moodle 2.0 has always been an option, but make sure your environment will meet the newer specifications. 

Consider your own circumstances. Are you starting out on the Moodle journey or have you just been dropped into it? Perhaps you are starting out, and you have no resources or courses and you are building for the next few months when you want it to become a part of your learning centre and a showpiece for your institute. A complete new Moodle 2.x.x install and starting from scratch is most appropriate in this circumstance. All major features work in it and some of the tools are a lot more interesting than for Moodle 1.9.x.

 Don't worry about Moodle 1.9.x, just use the new Moodle 2.x.x and learn it if you are starting from scratch.

If you have been dropped into it, and have a lot of courses, and you need to administer your Moodle 1.9.x as well as look at updating, then the next best option is to install a new Moodle and open it just for your Administrators and Staff. Let them get used to the new interface, develop training courses around the new Moodle, not just for staff but for Users as well. Aim at your staff first, let them learn it then they can be more confident in using the new Moodle when they come to teaching their Users/Students.

 In short, best advice is NOT to install a Moodle 2.0 as a production site without thoroughly testing and training first. 

To install and run more than one Moodle successfully is actually simple. Install your Moodle 2.0 and then go to Site administration > Server > Session handling. Look for the Cookie prefix dialogue and add a value to it. Repeat the exercise in every other Moodle you have on your server, it should all work as it is supposed to - as long as the cookie prefixes are different for every Moodle, of course.

Cookie prefix for Moodle 2.0

Essentially, take your time and not be in too much of a rush if you have to convert your Staff and Learners to a new tool. Let the Staff get used to it first, then you can make the swap any time.

If you do update your v1.9.x to v 2.0, and experience some problems, you may want to consider putting the issues and any error messages into a Moodle Tracker item. If you do, you may be providing information to resolve a number of updating issues for a lot of people.

Well, we want to try and upgrade to test our systems.

Try, by all means. However, there are a couple of issues you may need be aware of.

A rough guide and checklist:

  1. Plugins that work in Moodle 1.9.x may not be updated to Moodle 2.0. Check your plugins. Are you using any non-core plugins?
  2. Can you remove any non-core plugins?
  3. Have you backed up your database?
  4. Have you backed up your moodledata folder?
  5. Have you allocated additional time make the update, as a contingency?

You may not necessarily have to remove the non-core plugins from the Moodle, or, they may still be present in the database even if you have deleted them from your Moodle Mod folder. The issue arising is that some plugins appear to be causing update errors as there is no matching core plugin from Moodle 2.0, or the plugin APIs are different and cannot accommodate the older plugins, or the older plugins that have not been properly maintained, cannot handle the newer environment.

NOTE:This is not meant to be an exhaustive checklist or to scare people off trying to upgrade their v1.9.x to v2.0.x, just be aware that Moodle 2.0 is still a work in progress, as is this checklist.

We have extensively used the Book for parts of our previous Moodle, can we do so for Moodle 2.0?

The really good news is that Petr Skoda (Skodak) has the Maintainer role for the Book plugin/module. Petr announced some time back that when his major coding tasks for Moodle 2.0 had been done, he was taking a short break then he would begin work on updating the Book for Moodle 2.0.

UPDATE: Petr's updating of the Book module is now complete, and is available at the above link. Initial testing shows it installs easily and seems to run faster than the original. Seems the code has been better optimized by Petr, who deserves a hearty congratulations!!!

Please note: the book module is available as standard in Moodle 2.3

That is OK for the Book, but what about other plugins and blocks?

As a general rule-of-thumb, if a plugin or block has not been maintained through Moodle 1.9.x then it is extremely unlikely it will make it to Moodle 2.0.x. This means the developer has not kept it current and may feel it is too much of a distraction from their current projects to keep active. This does not mean that you, or someone else, may not take it on, as long as you ensure that what you are working with is creative commons, open source or other non-proprietal software and you are not infringing either copyright or intellectual property rights. If you are not sure, try to contact the developer or last maintainer, they may be different - if required, get permission from them to continue development. Of course, you may also seek to develop an entirely new plugin, or block, but it is clear that it is actually duplicating something that already exists or was used in earlier versions of Moodle, but is no longer current. As long as you can prove the provenance of such a plugin or block, and do not use any code from anywhere else that is not original or acknowledged where the code came from, then you should be OK. For ideas and guidelines around developing or updating a plugin, look at this page from Developer Documentation. You can also join a class of developers and learn how it can be done.

I am getting error messages about plugins and the installation stops when upgrading. What do I do?

Quite frequently, not a lot at all, you can just continue on. Many of these messages are just that, messages, they are not supposed to stop or break the installation, they are just warnings that not all is working as you may be used to in an install. Usually they relate to plugins that are not part of Moodle 2.0 yet. Moodle is designed to display a message, but continue on. Or, you can consider that, given the above, upgrading is not really viable and just do a fresh install. If those messages continue, then you have another problem. If there were database errors, or code errors, then it is different, you really do need to stop and investigate.

We are installing Moodle and getting error messages about not using the unicode or UTF-8 charset

In recent times, this has become an issue with CPanel and Fantastico installers on some Linux servers. Apparently the default charset for these tools is a latin_swedish_ci charset. Moodle requires the UTF-8 charset. This is a relatively simple fix, if you have the right tools. Install phpMyAdmin and check it is working, if you do not already have it. You can then go to the SQL page and enter the following code:


There have been, in the past, reports of tables that do not change using this SQL code, so try:

 ALTER TABLE `mdl_tablename` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; 

There have been no reasons as to why some tables are missed, but you can alter individual tables by using the code above. The code should look something like:

Changing the charset in Moodle 2.0

This also works in Moodle 1.9.x IF you use the utf8_general_ci charset.

NOTE: This SQL is supposed to work across the database, but recent reports suggest that the ALTER DATABASE seems to have a number of issues stemming from problems with the GRANT command. GRANT [permissiontype] is supposed to allow a user to access the entire database, but it no longer appears to be the case. The ALTER TABLE SQL has not been affected by this issue.

FURTHER NOTE: When using the ALTER DATABASE SQL, it appears to be diverted to altering the db.opt file, but is not continued into the tables of the database. So whether this is a deliberate security feature of more recent editions of MySQL or not is, at this stage, unknown. How this affects Postgres, or Oracle databases is also unknown.

OK, but how can we tell what tables are not converted?

Using phpMyAdmin, you can find out almost anything you like about your database, as long as you know where to look. There is some real documentation about using phpMyAdmin that is linked both in the left and right panels. Go to the Database tab and then select the database you want to look at.

Selecting the database tab in Moodle 2.0

Once selected, you will see what the charset is of each table. Any table that does not comply you can change using the table SQL code above.

Checking the table listings in phpMyAdmin

How do I get and install phpMyAdmin?

phpMyAdmin is another very useful plugin. In Moodle 2.0 the plugin has been updated and is now located in a different place than it was in earlier versions. Go to the phpMyAdmin page in Modules and Plugins and download the Moodle 2.0 version. Unzip it to the moodle/local folder and then go to Notifications. Moodle will then tell you it has been successfully installed. If you look in Administration > Server you will now find a line "phpMyAdmin". To access your database, click the link.

When I update over a 1.9 install, I get an error message about an incompatible plugin and it all stops. What can I do?

One piece of advice is that you just do not do that!

Sometimes, a file/folder will be removed from the code between one version of Moodle and the next. If you upgrade Moodle by copying the new Moodle code over the top of the old code, then the older files not duplicated or no longer existent, or just disused and dropped, will remain, and can break things.

The correct way to upgrade is (assuming your Moodle code is in a folder called moodle on the server:

  1. Upload the new code onto the server into a folder with a temporary name, like moodle_new.
  2. Copy the config.php file from the moodle folder to the moodle_new folder.
  3. For any third-party plugins you have installed, copy them into moodle_new. (Make sure the plugin is compatible with the version of Moodle you are upgrading to.)
  4. Then rename the moodle folder to moodle_old, and then rename moodle_new to moodle.

If you insist though, then you can expect to be getting all sorts of error messages. Given the fundamental changes to the database and the manner in which plugins are structured, and employed, in Moodle 2.0.x this is a very time consuming and, ultimately, futile (I would suggest) approach. You can, of course, remove all non-core plugins, and their corresponding tables from the database, and then you give yourself a chance at getting through it somewhat less scathed, but I doubt it.

What is happening to my uploaded files? I cannot see them in the moodledata folder!

To improve security, Moodle has change how files are stored in the moodledata folder. There are there, but no longer obvious. When a file is uploaded it is given a storage name, an encrypted name, and it is placed into a specific folder within the moodledata folder. That folder's name is directly related to the file storage name. So we have a file with an encrypted name, inside a folder with a related name, inside the moodledata folder. Now comes the nifty part, these encrypted names are used as connections to the database. The database stores those encrypted names as aliases for the files and uses them to link the files to the courses. You see them, but you do not see them, well they are not obvious. Unfortunately, you cannot edit them in place, like you could files in Moodle 1.9.x you have to edit them, delete the older file and upload the new ones.

See Also