Moodle

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 2.0
• Fix Version/s: 2.0
• Component/s: Quiz
• Labels:

  None

Hi Tim,

I found this error while updating my 2.0 test system. Its only a testing system, not productive

error: DDL sql execution

(mysql): CREATE TABLE mdl_question_dataset_definitions ( id BIGINT(10) unsigned NOT NULL auto_increment, category BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', type BIGINT(10) NOT NULL DEFAULT 0, options VARCHAR(255) NOT NULL DEFAULT '', itemcount BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) ) 1050: Table 'mdl_question_dataset_definitions' already exists

ADOConnection._Execute(CREATE TABLE mdl_question_dataset_definitions (
id BIGINT(10) unsigned NOT NULL auto_increment,
category BIGINT(10) unsi..., false) % line 893, file: adodb.inc.php
ADOConnection.Execute(CREATE TABLE mdl_question_dataset_definitions (
id BIGINT(10) unsigned NOT NULL auto_increment,
category BIGINT(10) unsi...) % line 197, file: adodb_moodle_database.php
adodb_moodle_database.change_database_structure(CREATE TABLE mdl_question_dataset_definitions (
id BIGINT(10) unsigned NOT NULL auto_increment,
category BIGINT(10) unsi...) % line 83, file: database_manager.php
database_manager.execute_sql(CREATE TABLE mdl_question_dataset_definitions (
id BIGINT(10) unsigned NOT NULL auto_increment,
category BIGINT(10) unsi...) % line 70, file: database_manager.php
database_manager.execute_sql_arr(Array[11]) % line 432, file: database_manager.php

• Assignee:

  Tim Hunt

  Reporter:

  Ralf Hilgenstock

  Participants:

  Petr Škoda (skodak), Ralf Hilgenstock, Tim Hunt

• Created:

  13/Sep/08 4:35 PM

  Updated:

  17/Dec/10 1:03 PM

  Resolved:

  15/Sep/08 12:09 AM