Note: You are currently viewing documentation for Moodle 2.6. Up-to-date documentation for the latest stable version of Moodle may be available here: Upgrading.

Upgrading: Difference between revisions

From MoodleDocs
Main page ► Installation ► Upgrading
Installation
(copying recent changes from 21 wiki)
(→‎Possible issues that may affect you in Moodle 2.6: MySQL dmlwriteexception error when using calculated questions in a quiz (MDL-29332))
 
(67 intermediate revisions by 15 users not shown)
Line 1: Line 1:
{{Installing Moodle}}
{{Installing Moodle}}
'''Before you do anything else, read [[Upgrading to Moodle 2.2]]'''
''This page explains in detail how to upgrade Moodle. For a summary of the process, see [[Upgrade overview]].''


Moodle is designed to upgrade itself from one version to the next. The procedure is
==Check the requirements==
# [[Site backup|Back up everything]].
# Replace the old version of the code with the new one.
# Visit the [[Site_administration_block#Notifications|administrator notifications]] link, which triggers Moodle to self-update.
These steps are explained in more detail below.


Sometimes there are specific considerations when upgrading to a particular version. See the [[dev:Releases|Releases page]] for more information on this.  You also have to be more careful if you have installed additional plug-ins or customised the code.
Check that your server meets all requirements for 2.6 in ''Administration > Site administration > Server > [[Environment]]''.


See this tutorial if you are [http://ic.eflclasses.org/tutorials/howtoupgrademoodlewithcpanel.swf upgrading Moodle on cpanel]. It is a bit rough around the edges and is a little dated, but you should get the idea.
New in Moodle 2.6 is the php_setting [[OPcache]].


There is also a separate page about [[Ubuntu_Debian_Upgrades|upgrading Moodle if you installed it using the Ubuntu/Kubuntu/Debian package manager]].
Note: You can only upgrade to Moodle 2.6 from Moodle 2.2 or later. If upgrading from earlier versions, you must [https://docs.moodle.org/22/en/Upgrading_to_Moodle_2.2 upgrade to 2.2] as a first step.


==Before you upgrade your site for real==


__TOC__
'''We advise that you test the upgrade first on a COPY of your production site, to make sure it works as you expect.'''


When upgrading a Moodle installation you should follow these steps:
== Backup important data ==


==Before you upgrade your site for real==
There are three areas that should be backed up before any upgrade:
#Moodle software (For example, everything in server/htdocs/moodle)
#Moodle uploaded files (For example, server/moodledata)
#Moodle database (For example, your Postgres or MySQL database dump)


You are strongly advised to make a copy of your entire Moodle site onto another computer (see [[Moodle migration]]) and run the upgrade there to verify it will work.
See [[Site backup]] for more specific information.


==Check the requirements==
==Put your site into maintenance mode==
Spend some time re-reading the [[Installing Moodle | installation documentation]] and documentation for the new version. Check the system requirements for the target version you want to upgrade-to in ''Settings > Site administration > Server > [[Environment]]''.
Before you begin upgrading your site, you should put it into [[Maintenance_mode | maintenance mode]] to stop any non-admin users from logging in.


==Put your Site into Maintenance Mode==
== Check for add-on updates ==
Before you begin upgrading your site, you should put it into [[Maintenance_mode | Maintenance Mode]] to stop any non-admin users from logging in.


== Backup important data ==
If you have [[Automatic updates deployment]] enabled, you will be able to update installed add-ons automatically during the upgrade. Just make sure you check for available updates (via the button for it) at the Plugins check screen.
See [[Site backup]] for more specific information.


There are three areas that should be backed up before any upgrade:
If you are updating add-ons manually, it is a good moment now to check in the [http://moodle.org/plugins Moodle Plugins directory] whether there is a 2.6 version available for any add-ons (including themes) that you have previously installed on your site. If so, download the add-on package. In the next step, you will copy it to the appropriate location in your Moodle code (see [[Installing add-ons]]).
#Moodle software (For example, everything in server/htdocs/moodle)
#Moodle uploaded files (For example, server/moodledata)
#Moodle database (For example, the SQL or Postgres database)


Experienced site administrators know that it is a best practice (a very good idea) to make a backup of any production system before a major upgrade. In fact, it is a good idea to automate your server to backup your Moodle installation daily.  Most upgrades on sites that have used the standard Moodle packages (no contributed code and no little tweaks to the php files), will not have any major issues with the upgrade process.
The upgrade of the add-on will then happen as part of the Moodle upgrade process.


:''TIP:'' One more time, "do not risk what you can not afford to lose": do regular backups, make sure it is really backed up and know how to restore a backup!
If an out-of-date add-on causes your upgrade to fail, you can usually delete the add-on code rather than uninstalling it from within Moodle so that the data associated with it is not deleted.


== Install the new Moodle software ==
== Install the new Moodle software ==
Upgrading can be a simple process or a more complicated process.  Sites that have not used contributed code and are migrating from say Moodle 1.x.1 to 1.x.3 '''should''' not have a problem.  However, we still recommend that with any production server that you have made a successful backup of the MySQL database, the moodledata directory and the moodle program folders and files. 
*Do not overwrite an old installation unless you know what you are doing ... sometimes old files can cause problems in new installations. Review the backup section above.


=== Standard install package ===
=== Standard install package ===
Having read the cautions about backups, download a copy of the standard install package. Here is a set of simple instructions for an average site.
*It is probably a good idea to use the [[Site administration block]]>Server>Maintenance mode to prevent user activity as the site upgrades.
*Having moved your old Moodle software program files to another location, unzip or unpack the upgrade file so that all new the Moodle software program files are in the location the old files used to be in on the server.  Moodle will adjust SQL and [[Moodledata directory|moodledata]] if it needs to in the upgrade.
*Copy your old [[Configuration file|config.php file]] back to the new Moodle directory.
*If you had added any custom plugins or themes into your Moodle you can add them to the new code. It is important to check that you get the correct version for your new version of Moodle. You should check in the optional plugins database. Be particularly careful that you do not overwrite any code in the new version of Moodle. If you are upgrading to Moodle 2.0 or newer, note that all optional plugins and themes required a significant rewrite and most do not have 2.0 versions (yet).
*Use the notification link in the site administration to start the upgrade process. You will see a series of lines or screens indicating progress. 
*After a successful upgrade, turn off the maintenance mode, so your users can get into the site.


=== Using a downloaded archive ===
# Move your old Moodle software program files to another location. ''Do NOT copy new files over the old files.''
In some installs, the site administrator may overwrite the Moodle code with a backup copy. Or create a new clean install copy of Moodle, then restore an archive (via a compressed file or parts of a saved set of Moodle code files and folders).  
# Unzip or unpack the upgrade file so that all the new Moodle software program files are in the location the old files used to be in on the server. Moodle will adjust SQL and moodledata if it needs to in the upgrade.
 
# Copy your old [[Configuration file|config.php file]] back to the new Moodle directory.  
*Do not overwrite an old installation unless you know what you are doing ... sometimes old files can cause problems in new or "cleaned" installations. The best way is to rename the current Moodle code directory (for example rename "moodle" to "moodleold"), then unpack the new Moodle archive into the old location (for example, a new directory called "moodle").
# As mentioned above, if you had installed any custom add-ons on your site you should add them to the new code tree now. It is important to check that you get the correct version for your new version of Moodle. Be particularly careful that you do not overwrite any code in the new version of Moodle.
# Dont forget to also copy over your moodledata folder / directory.  If you don't you will get a "fatal error $cfg- dataroot is not configured properly".


====Linux====
====Linux====
  mv moodle moodle.backup
  mv moodle moodle.backup
  tar xvzf moodle-1.1.tgz
  tar xvzf moodle-2.6.tgz


Next, copy across your config.php, any other plugins such as custom themes, and your .htaccess file if you created one ('''check that optional/custom plugins are the correct version for your new Moodle first'''):
Next, copy across your config.php, any custom plugins, and your .htaccess file if you created one ('''check that custom plugins are the correct version for your new Moodle first'''):


  cp moodle.backup/config.php moodle
  cp moodle.backup/config.php moodle
Line 70: Line 56:
  cp -pr moodle.backup/mod/mymod moodle/mod/mymod
  cp -pr moodle.backup/mod/mymod moodle/mod/mymod


Don't forget to  
Don't forget to make moodle/config.php (and the rest of the source code) readable by your www server. Ideally the files should not be writeable by your server.
 
sudo chown www-data moodle/config.php


If you use cron, take care that cron.php is executeable and uses the correct php command:  
If you use cron, take care that cron.php is executeable and uses the correct php command:  
  chmod 740 admin/cli/cron.php (some configurations need chmod 750)
  chmod 740 admin/cli/cron.php (some configurations need chmod 750 or chmod 755)
  copy the first line from cron.php (if it looks like '#!/usr/local/bin/php' or '#!/usr/local/bin/php5.3', no need to copy '<?php')
  copy the first line from cron.php (if it looks like '#!/usr/local/bin/php' or '#!/usr/local/bin/php5.3', no need to copy '<?php')


if necessary.


if necessary.
=== Using Git ===
 
You can use Git for updating or upgrading your Moodle. See [[Git for Administrators]] for details.
 
===Command line upgrade===
 
On Linux servers, Moodle 2.6 supports running the [[CLI|upgrade from the command line]], rather than through a web browser. This is likely to be more reliable, particularly for large sites.
 
== Finishing the upgrade ==
 
The last step is to trigger the upgrade processes within Moodle.
 
To do this just go to ''Administration > Site administration > Notifications''.
 
Moodle will automatically detect the new version and perform all the SQL database or file system upgrades that are necessary. If there is anything it can't do itself (very rare) then you will see messages telling you what you need to do.


where www-data is whatever user the Apache user is on your system. This is often 'apache' or 'www'.
Assuming all goes well (no error messages) then you can start using your new version of Moodle and enjoy the new features!
You can find out by doing 'ls -l' in your /var/www/moodle folder (or wherever your moodle site is)
and then looking at the owner and group.


so you may see something like
Note: If you are running multiple servers then you should purge all caches manually (via ''Administration > Site administration > Development > Purge all caches'') after completing the upgrade on all servers.


ls -l
==After upgrading==
...lots of lines...
-rw-r--r--  1 apache system    784 Jun 28  2007 config.php
...lots more lines...


so the owner is apache and the group is system.  
The config.php file from your installation should work fine but if you take a look at config-dist.php that came with Moodle 2.6 there are more/different options available (e.g. database drivers and settings). It's a good idea to map your old config.php settings to a new one based on the 2.6 config-dist.php.


To replicate this on your new system you can do  'chown apache:system config.php'
==Fatal error: Maximum execution time of 30 seconds exceeded...==


or to do a whole group do
If your server uses a main language other than English, you may encounter a 'Fatal error: Maximum execution time of 30 seconds exceeded' when you try to upgrade it. You can increase max_execution_time = 160 on php.ini to allow the scripts enough time to process the language update. Otherwise, you can switch to English as the default language before doing the upgrade and back to your original language after a succcessful upgrade. See the forum discussion at https://moodle.org/mod/forum/discuss.php?d=119598 .


chown apache:system ./*
==Possible issues that may affect you in Moodle 2.6==
===Ghostscript===
For the new Annotate PDF assignment feature to work properly, Ghostscript needs to be installed on your server. Check the path from ''Site administration > Plugins > Activity modules > Assignment > Feedback plugins >Annotate PDF''. (Note that if is not enabled or the path is not correct, then the link 'Launch PDF editor' will not appear for teachers when grading PDF assignments.)


and recursively
===New Box.net API===


chown -R apache:system ./*
To continue using the [[Box.net repository]] and [[Box.net portfolio]], the Moodle site must use HTTPS and the plugins must be configured with a Box.net client ID and secret. See [[Box.net APIv1 migration]] for details.


=== Using CVS ===
Box.net repository users will no longer be possible to create a shortcut/alias to a file stored in Box.net.


New sites should now use Git rather than CVS (see next section). If your site already uses CVS, to update, just go into the Moodle root directory and update to the new files:
'''IMPORTANT''': The Box.net-alias-to-copy-conversion tool should be run ''as soon as possible''. See [[Box.net APIv1 migration]] for details.
<pre>
$ cd /path/to/your/moodle/
$ cvs update -dP
</pre>
To update from an older version type in the following:
<pre>
$ cd /path/to/your/moodle/
$ cvs -Q update -dP -r MOODLE_18_STABLE
</pre>


Make sure you use the "d" parameter to create new directories if necessary, and the "P" parameter to prune empty directories.
===Theme compatibility===


=== Using Git ===
If your site has a custom theme, then you might run into an error during upgrade "Debug info: Unknown column 'cacherev' in 'field list'".


You can use [[Git]] for updating or upgrading your Moodle. New sites are recommended to use this rather than CVS since all Moodle development has moved to Git.
The solution is to temporarily switch your theme to "standard" theme during the upgrade.  You can do this by adding "theme=standard" on the URL or by adding this to your Moodle config.php:


See [[Git for Administrators]] for further details.
$CFG->theme = "standard";


== Finishing the upgrade ==
After upgrade your theme might still work fine.


The last step is to trigger the upgrade processes within Moodle.  
Another solution is to complete your upgrade via a CLI.


To do this just visit the [[Site administration block]] admin page (or ''<nowiki>http://example.com/moodle/admin</nowiki>'') and the "Notifications" link.
===My Mobile theme removal===


Moodle will automatically detect the new version and perform all the SQL database or file system upgrades that are necessary. If there is anything it can't do itself (very rare) then you will see messages telling you what you need to do.
The "My Mobile" theme has been removed from Moodle 2.6 (MDL-40874). During the upgrade process, the theme will be uninstalled and all its settings will be deleted. The "My Mobile" theme and its extending themes will fall back to the mobile friendly "Clean" theme.


Assuming all goes well (no error messages) then you can start using your new version of Moodle and enjoy the new features!
To keep the "My Mobile" theme and its settings, BEFORE UPGRADING files from the unmaintained plugin must be copied into theme/mymobile. The unmaintained plugin can be downloaded from  the [https://moodle.org/plugins/view.php?plugin=theme_mymobile MyMobile theme entry in the plugins directory].


===Backup and restore of assignments from Moodle 2.2 and older===


:''TIP:'' Use the site administration block>Server>Maintenance mode to prevent users from changing data during the upgrade.
The [[Assignment module|assignment activity module]] was completely rewritten in Moodle 2.3. Assignments from Moodle 2.2 and older (e.g. from Moodle 1.9) need to be upgraded in order to continue being usable in Moodle 2.6. See the section 'Restoring course backups from Moodle 2.2 and older' in [[Assignment upgrade tool]] for details of what to do.
:''TIP:'' If you are running a large scale Moodle site (e.g. have more tha 10,000+ courses and 40,000+ users), make sure that you do your own performance profiling testing. Post a thread or check the [http://moodle.org/mod/forum/view.php?id=28 Installation problems forum] and check [[Tracker]] for potential issues.


== Verify the upgrade (optional) ==
===MySQL dmlwriteexception error when using calculated questions in a quiz===


If you wish to confirm that the database definitions in the upgraded database match the definitions of a new, clean install (which they should) you might like to look at [[Verify Database Schema]].
If you're using MySQL or SQL*Server and you have a problem with duplicated keys with the question_attempt_step_data table when using calculated questions in a quiz (from entering a formula which uses variables with the same characters in different cases), it is recommended that you upgrade to Moodle 3.0.x or higher ASAP. Alternatively, the problematic unique index can be dropped or the collation of the columns changed to be case-sensitive, however this is not considered a complete fix. See MDL-29332 for more information.


==Upgrading more than one version==
=== Moodle 2.3, 2.4 and 2.5 improvements ===


Normally you can upgrade directly form any Moodle version to any later version. So, for example you could upgrade from 2.0 to 2.1, or from 1.9 to 2.2.
Depending on which version you are upgrading from, please see the section 'Possible issues that may affect you' in the documentation


However, every so often, this general rule gets broken, because supporting really large jumps (for example Moodle 1.0 to 2.2 in one step) would be impossible. So far, the break points have been:
* [https://docs.moodle.org/23/en/Upgrading Upgrading to Moodle 2.3]
* You must have upgraded to version 1.9.x before you can upgrade to a later 2.x version.
* [https://docs.moodle.org/24/en/Upgrading Upgrading to Moodle 2.4]
* You must have upgraded to version 2.2.x before you can upgrade to 2.3 or later.
* [https://docs.moodle.org/25/en/Upgrading Upgrading to Moodle 2.5]


==See also==
==See also==


*[[Upgrading to Moodle 2.2]]
* Using Moodle [http://moodle.org/mod/forum/view.php?id=28 Installation problems forum]  
*[[Environment]]
* [[dev:Moodle 2.6 release notes|Moodle 2.6 release notes]]
*[[Git]] Version control and upgrading
* [[dev:Upgrade API|Upgrade API]]
*[[How to fix just one bug without upgrading]]
*Moodle.org [http://moodle.org/mod/forum/view.php?id=28 Installation problems forum]  
*[http://ic.eflclasses.org/tutorials/howtoupgrademoodlewithcpanel.swf How to upgrade Moodle with cpanel tutorial] - screencasts of older Moodle/Cpanel install but useful (also, a very large file that will take some time to load).
 
Using Moodle.org forum discussions:
*[http://moodle.org/mod/forum/discuss.php?d=26731&parent=125858 Using cvs]
*[http://moodle.org/mod/forum/discuss.php?d=56915 Upgrading from 1.5.2 to 1.7]
*[http://moodle.org/mod/forum/discuss.php?d=56991 Upgrade nightmares.... any help appreciated]
*[http://moodle.org/mod/forum/discuss.php?d=62463 After upgrading i get "Your site may not be secure." msg]
*[http://moodle.org/mod/forum/discuss.php?d=104887 Best practices for QA]
*[[Beginning_Moodle_2.0_Administration|Beginning Moodle 2.0 Administration]]


[[es:Actualización de moodle]]
[[es:Actualización de moodle]]
[[fr:Mise à jour]]
[[fr:Mise à jour]]
[[ja:Moodleをアップグレードする]]
[[ja:Moodleをアップグレードする]]
[[nl:Upgraden]]
[[zh:升级]]
[[pl:Aktualizacja]]
[[de:Aktualisierung von Moodle]]
[[de:Aktualisierung von Moodle]]
[[ru:Обновление]]

Latest revision as of 09:36, 22 September 2016

This page explains in detail how to upgrade Moodle. For a summary of the process, see Upgrade overview.

Check the requirements

Check that your server meets all requirements for 2.6 in Administration > Site administration > Server > Environment.

New in Moodle 2.6 is the php_setting OPcache.

Note: You can only upgrade to Moodle 2.6 from Moodle 2.2 or later. If upgrading from earlier versions, you must upgrade to 2.2 as a first step.

Before you upgrade your site for real

We advise that you test the upgrade first on a COPY of your production site, to make sure it works as you expect.

Backup important data

There are three areas that should be backed up before any upgrade:

  1. Moodle software (For example, everything in server/htdocs/moodle)
  2. Moodle uploaded files (For example, server/moodledata)
  3. Moodle database (For example, your Postgres or MySQL database dump)

See Site backup for more specific information.

Put your site into maintenance mode

Before you begin upgrading your site, you should put it into maintenance mode to stop any non-admin users from logging in.

Check for add-on updates

If you have Automatic updates deployment enabled, you will be able to update installed add-ons automatically during the upgrade. Just make sure you check for available updates (via the button for it) at the Plugins check screen.

If you are updating add-ons manually, it is a good moment now to check in the Moodle Plugins directory whether there is a 2.6 version available for any add-ons (including themes) that you have previously installed on your site. If so, download the add-on package. In the next step, you will copy it to the appropriate location in your Moodle code (see Installing add-ons).

The upgrade of the add-on will then happen as part of the Moodle upgrade process.

If an out-of-date add-on causes your upgrade to fail, you can usually delete the add-on code rather than uninstalling it from within Moodle so that the data associated with it is not deleted.

Install the new Moodle software

Standard install package

  1. Move your old Moodle software program files to another location. Do NOT copy new files over the old files.
  2. Unzip or unpack the upgrade file so that all the new Moodle software program files are in the location the old files used to be in on the server. Moodle will adjust SQL and moodledata if it needs to in the upgrade.
  3. Copy your old config.php file back to the new Moodle directory.
  4. As mentioned above, if you had installed any custom add-ons on your site you should add them to the new code tree now. It is important to check that you get the correct version for your new version of Moodle. Be particularly careful that you do not overwrite any code in the new version of Moodle.
  5. Dont forget to also copy over your moodledata folder / directory. If you don't you will get a "fatal error $cfg- dataroot is not configured properly".

Linux

mv moodle moodle.backup
tar xvzf moodle-2.6.tgz

Next, copy across your config.php, any custom plugins, and your .htaccess file if you created one (check that custom plugins are the correct version for your new Moodle first): 

cp moodle.backup/config.php moodle
cp -pr moodle.backup/theme/mytheme moodle/theme/mytheme
cp -pr moodle.backup/mod/mymod moodle/mod/mymod

Don't forget to make moodle/config.php (and the rest of the source code) readable by your www server. Ideally the files should not be writeable by your server.

If you use cron, take care that cron.php is executeable and uses the correct php command: 

chmod 740 admin/cli/cron.php (some configurations need chmod 750 or chmod 755)
copy the first line from cron.php (if it looks like '#!/usr/local/bin/php' or '#!/usr/local/bin/php5.3', no need to copy '<?php')

if necessary.

Using Git

You can use Git for updating or upgrading your Moodle. See Git for Administrators for details.

Command line upgrade

On Linux servers, Moodle 2.6 supports running the upgrade from the command line, rather than through a web browser. This is likely to be more reliable, particularly for large sites.

Finishing the upgrade

The last step is to trigger the upgrade processes within Moodle.

To do this just go to Administration > Site administration > Notifications.

Moodle will automatically detect the new version and perform all the SQL database or file system upgrades that are necessary. If there is anything it can't do itself (very rare) then you will see messages telling you what you need to do.

Assuming all goes well (no error messages) then you can start using your new version of Moodle and enjoy the new features!

Note: If you are running multiple servers then you should purge all caches manually (via Administration > Site administration > Development > Purge all caches) after completing the upgrade on all servers.

After upgrading

The config.php file from your installation should work fine but if you take a look at config-dist.php that came with Moodle 2.6 there are more/different options available (e.g. database drivers and settings). It's a good idea to map your old config.php settings to a new one based on the 2.6 config-dist.php.

Fatal error: Maximum execution time of 30 seconds exceeded...

If your server uses a main language other than English, you may encounter a 'Fatal error: Maximum execution time of 30 seconds exceeded' when you try to upgrade it. You can increase max_execution_time = 160 on php.ini to allow the scripts enough time to process the language update. Otherwise, you can switch to English as the default language before doing the upgrade and back to your original language after a succcessful upgrade. See the forum discussion at https://moodle.org/mod/forum/discuss.php?d=119598 .

Possible issues that may affect you in Moodle 2.6

Ghostscript

For the new Annotate PDF assignment feature to work properly, Ghostscript needs to be installed on your server. Check the path from Site administration > Plugins > Activity modules > Assignment > Feedback plugins >Annotate PDF. (Note that if is not enabled or the path is not correct, then the link 'Launch PDF editor' will not appear for teachers when grading PDF assignments.)

New Box.net API

To continue using the Box.net repository and Box.net portfolio, the Moodle site must use HTTPS and the plugins must be configured with a Box.net client ID and secret. See Box.net APIv1 migration for details.

Box.net repository users will no longer be possible to create a shortcut/alias to a file stored in Box.net.

IMPORTANT: The Box.net-alias-to-copy-conversion tool should be run as soon as possible. See Box.net APIv1 migration for details.

Theme compatibility

If your site has a custom theme, then you might run into an error during upgrade "Debug info: Unknown column 'cacherev' in 'field list'".

The solution is to temporarily switch your theme to "standard" theme during the upgrade. You can do this by adding "theme=standard" on the URL or by adding this to your Moodle config.php: 

$CFG->theme = "standard";

After upgrade your theme might still work fine.

Another solution is to complete your upgrade via a CLI.

My Mobile theme removal

The "My Mobile" theme has been removed from Moodle 2.6 (MDL-40874). During the upgrade process, the theme will be uninstalled and all its settings will be deleted. The "My Mobile" theme and its extending themes will fall back to the mobile friendly "Clean" theme.

To keep the "My Mobile" theme and its settings, BEFORE UPGRADING files from the unmaintained plugin must be copied into theme/mymobile. The unmaintained plugin can be downloaded from the MyMobile theme entry in the plugins directory.

Backup and restore of assignments from Moodle 2.2 and older

The assignment activity module was completely rewritten in Moodle 2.3. Assignments from Moodle 2.2 and older (e.g. from Moodle 1.9) need to be upgraded in order to continue being usable in Moodle 2.6. See the section 'Restoring course backups from Moodle 2.2 and older' in Assignment upgrade tool for details of what to do.

MySQL dmlwriteexception error when using calculated questions in a quiz

If you're using MySQL or SQL*Server and you have a problem with duplicated keys with the question_attempt_step_data table when using calculated questions in a quiz (from entering a formula which uses variables with the same characters in different cases), it is recommended that you upgrade to Moodle 3.0.x or higher ASAP. Alternatively, the problematic unique index can be dropped or the collation of the columns changed to be case-sensitive, however this is not considered a complete fix. See MDL-29332 for more information.

Moodle 2.3, 2.4 and 2.5 improvements

Depending on which version you are upgrading from, please see the section 'Possible issues that may affect you' in the documentation

See also

Retrieved from "https://docs.moodle.org/26/en/index.php?title=Upgrading&oldid=113641"
Powered by MediaWiki