Error al escribir en la base de datos

Error al escribir en la base de datos

de David Reales -
Número de respuestas: 1

Buenas tardes,


recientemente he pedido a mi empresa de host el traslado de mi plataforma Moodle 2.6 a un nuevo servidor. 

Pues bien, ahora resulta que cuando trato de restaurar un curso me sale el siguiente error:

Nota: Ya he subido el parámetro max_allowed_packet a 20M, cuando el curso ocupa menos de 5 MB

Alguien sabe qué puede ser???

Muchas gracias!


Error al escribir a la base de datos

Más información sobre este error

Debug info: Duplicate entry '2995' for key 'mdl_qtypmultopti_que_uix'
INSERT INTO mdl_qtype_multichoice_options (layout,single,shuffleanswers,correctfeedback,correctfeedbackformat,partiallycorrectfeedback,partiallycorrectfeedbackformat,incorrectfeedback,incorrectfeedbackformat,answernumbering,shownumcorrect,questionid) VALUES(?,?,?,?,?,?,?,?,?,?,?,?)
[array (
0 => '0',
1 => '1',
2 => '1',
3 => '',
4 => '1',
5 => '',
6 => '1',
7 => '',
8 => '1',
9 => 'abc',
10 => '0',
11 => 2995,
)]
Error code: dmlwriteexception
Stack trace:
  • line 446 of /lib/dml/moodle_database.php: dml_write_exception thrown
  • line 1146 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
  • line 1188 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()
  • line 76 of /question/type/multichoice/backup/moodle2/restore_qtype_multichoice_plugin.class.php: call to mysqli_native_moodle_database->insert_record()
  • line 137 of /backup/util/plan/restore_structure_step.class.php: call to restore_qtype_multichoice_plugin->process_multichoice()
  • line 103 of /backup/util/helper/restore_structure_parser_processor.class.php: call to restore_structure_step->process()
  • line 151 of /backup/util/xml/parser/processors/grouped_parser_processor.class.php: call to restore_structure_parser_processor->dispatch_chunk()
  • line 91 of /backup/util/helper/restore_structure_parser_processor.class.php: call to grouped_parser_processor->postprocess_chunk()
  • line 148 of /backup/util/xml/parser/processors/simplified_parser_processor.class.php: call to restore_structure_parser_processor->postprocess_chunk()
  • line 92 of /backup/util/xml/parser/processors/progressive_parser_processor.class.php: call to simplified_parser_processor->process_chunk()
  • line 186 of /backup/util/xml/parser/progressive_parser.class.php: call to progressive_parser_processor->receive_chunk()
  • line 274 of /backup/util/xml/parser/progressive_parser.class.php: call to progressive_parser->publish()
  • line ? of unknownfile: call to progressive_parser->end_tag()
  • line 175 of /backup/util/xml/parser/progressive_parser.class.php: call to xml_parse()
  • line 154 of /backup/util/xml/parser/progressive_parser.class.php: call to progressive_parser->parse()
  • line 110 of /backup/util/plan/restore_structure_step.class.php: call to progressive_parser->process()
  • line 181 of /backup/util/plan/base_task.class.php: call to restore_structure_step->execute()
  • line 177 of /backup/util/plan/base_plan.class.php: call to base_task->execute()
  • line 167 of /backup/util/plan/restore_plan.class.php: call to base_plan->execute()
  • line 333 of /backup/controller/restore_controller.class.php: call to restore_plan->execute()
  • line 184 of /backup/util/ui/restore_ui.class.php: call to restore_controller->execute_plan()
  • line 99 of /backup/restore.php: call to restore_ui->execute()

Promedio de valoraciones: -
En respuesta a David Reales

Re: Error al escribir en la base de datos

de Fernando Acedo -

Parece una mala restauración de la base de datos. Deberias restaurar moodeldata y la base de nuevo y comprobar que funciona correctamente antes de ponerla en producción.