Difference between revisions of "error/moodle/dmlwriteexception"

Jump to: navigation, search

Note: You are currently viewing documentation for Moodle 2.7. Up-to-date documentation for the latest stable version of Moodle may be available here: error/moodle/dmlwriteexception.

(See also)
(MySQL dmlwriteexception error when using calculated questions in a quiz (MDL-29332))
 
(6 intermediate revisions by 5 users not shown)
Line 1: Line 1:
 
This indicates that a general error occurred when Moodle tried to write to the database. If you turn on [[Debugging]] you will get more detailed information about what the problem is.
 
This indicates that a general error occurred when Moodle tried to write to the database. If you turn on [[Debugging]] you will get more detailed information about what the problem is.
  
When importing questions in Aiken format after successful reading all questions this error emerges when saving in the database. No definite rule why. Ver. 2.0
+
==MySQL==
 +
 
 +
If you're using a MySQL database for your Moodle installation, this error can be caused by the server's <code>max_allowed_packet</code> size being configured incorrectly. [https://moodle.org/mod/forum/discuss.php?d=230681#p1001751 Increasing this value may resolve the issue.]
 +
 
 +
==dmlwriteexception error when restoring a course==
 +
 
 +
If you obtain a  dmlwriteexception error when restoring a course, it is recommended that InnoDB tables are converted to the Barracuda file format. See the section 'Converting InnoDB tables to Barracuda' in [[Administration via command line]] for details of why this is recommended plus information on a tool for converting tables.
 +
 
 +
==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.
  
 
==See also==
 
==See also==
Line 8: Line 18:
  
 
[[Category:Error|Dmlwriteexception]]
 
[[Category:Error|Dmlwriteexception]]
<a href="http://www.logos-quiz-answers.net">logo quiz answers</a>
 
  
Logo Quiz Answers is a site that contains answers for iPhone, iPad, Android, BlackBerry and Windows phone game apps that carry numerous guessing names of logos from various companies.
+
[[es:error/moodle/dmlwriteexception]]

Latest revision as of 15:29, 22 September 2016

This indicates that a general error occurred when Moodle tried to write to the database. If you turn on Debugging you will get more detailed information about what the problem is.

MySQL

If you're using a MySQL database for your Moodle installation, this error can be caused by the server's
max_allowed_packet
size being configured incorrectly. Increasing this value may resolve the issue.

dmlwriteexception error when restoring a course

If you obtain a dmlwriteexception error when restoring a course, it is recommended that InnoDB tables are converted to the Barracuda file format. See the section 'Converting InnoDB tables to Barracuda' in Administration via command line for details of why this is recommended plus information on a tool for converting tables.

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.

See also