XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.5.2
    • Fix Version/s: 1.6
    • Component/s: Choice
    • Labels:
      None
    • Environment:
      Mac System 8.6
    • Database:
      Any
    • Affected Branches:
      MOODLE_15_STABLE
    • Fixed Branches:
      MOODLE_16_STABLE

      Description

      hello guys--

      i have done the solution in this link http://moodle.org/mod/forum/discuss.php?d=39485 to fix enable the choice. Now, i am getting the error below when i click on Moodle ? Administration ? Configuration then i clicked back to Administration:

      the error is:

      Setting up module tables Moodle ? Setting up module tables

      Copy of choice

      --------------------------------------------------------------------------------

      (mysql): CREATE TABLE mdl_choice ( id int(10) unsigned NOT NULL auto_increment, course int(10) unsigned NOT NULL default '0', name varchar(255) NOT NULL default '', text text NOT NULL, format tinyint(2) unsigned NOT NULL default '0', publish tinyint(2) unsigned NOT NULL default '0', `release` tinyint(2) unsigned NOT NULL default '0', display tinyint(4) unsigned NOT NULL default '0', allowupdate tinyint(2) unsigned NOT NULL default '0', showunanswered tinyint(2) unsigned NOT NULL default '0', limitanswers tinyint(2) unsigned NOT NULL default '0', timeopen int(10) unsigned NOT NULL default '0', timeclose int(10) unsigned NOT NULL default '0', timemodified int(10) unsigned NOT NULL default '0', PRIMARY KEY (id), UNIQUE KEY id (id), KEY course (course)) TYPE=MyISAM COMMENT='Available choices are stored here.'

      --------------------------------------------------------------------------------

      1050: Table 'mdl_choice' already exists

      ADOConnection._Execute(CREATE TABLE mdl_choice ( id int(10) unsigned NOT NULL auto_increment, course int(10) unsigned NOT NULL default '0', name var..., false) % line 854, file: adodb.inc.php

      ADOConnection.Execute(CREATE TABLE mdl_choice ( id int(10) unsigned NOT NULL auto_increment, course int(10) unsigned NOT NULL default '0', name var...) % line 55, file: datalib.php

      execute_sql(CREATE TABLE mdl_choice ( id int(10) unsigned NOT NULL auto_increment, course int(10) unsigned NOT NULL default '0', name var...) % line 199, file: datalib.php

      modify_database(C:\Inetpub\wwwroot\moodle\moodle/mod/Copy of choice/db/mysql.sql) % line 205, file: adminlib.php

      upgrade_activity_modules(http://bc354664/admin/index.php) % line 243, file: index.php

      Error

      --------------------------------------------------------------------------------

      (mysql): CREATE TABLE mdl_choice_answers ( id int(10) unsigned NOT NULL auto_increment, choiceid int(10) unsigned NOT NULL default '0', userid int(10) unsigned NOT NULL default '0', optionid int(10) NOT NULL default '0', timemodified int(10) NOT NULL default '0', PRIMARY KEY (id), UNIQUE KEY id (id), KEY userid (userid), KEY choiceid (choiceid)) TYPE=MyISAM

      --------------------------------------------------------------------------------

      1050: Table 'mdl_choice_answers' already exists

      ADOConnection._Execute(CREATE TABLE mdl_choice_answers ( id int(10) unsigned NOT NULL auto_increment, choiceid int(10) unsigned NOT NULL default '0',..., false) % line 854, file: adodb.inc.php

      ADOConnection.Execute(CREATE TABLE mdl_choice_answers ( id int(10) unsigned NOT NULL auto_increment, choiceid int(10) unsigned NOT NULL default '0',...) % line 55, file: datalib.php

      execute_sql(CREATE TABLE mdl_choice_answers ( id int(10) unsigned NOT NULL auto_increment, choiceid int(10) unsigned NOT NULL default '0',...) % line 199, file: datalib.php

      modify_database(C:\Inetpub\wwwroot\moodle\moodle/mod/Copy of choice/db/mysql.sql) % line 205, file: adminlib.php

      upgrade_activity_modules(http://bc354664/admin/index.php) % line 243, file: index.php

      Error

      --------------------------------------------------------------------------------

      (mysql): CREATE TABLE mdl_choice_options ( id int(10) unsigned NOT NULL auto_increment, choiceid int(10) unsigned NOT NULL default '0', `text` TEXT, maxanswers int(10) unsigned NULL default '0', timemodified int(10) NOT NULL default '0', PRIMARY KEY (id), UNIQUE KEY id (id), KEY choiceid (choiceid)) TYPE=MyISAM

      --------------------------------------------------------------------------------

      1050: Table 'mdl_choice_options' already exists

      ADOConnection._Execute(CREATE TABLE mdl_choice_options ( id int(10) unsigned NOT NULL auto_increment, choiceid int(10) unsigned NOT NULL default '0',..., false) % line 854, file: adodb.inc.php

      ADOConnection.Execute(CREATE TABLE mdl_choice_options ( id int(10) unsigned NOT NULL auto_increment, choiceid int(10) unsigned NOT NULL default '0',...) % line 55, file: datalib.php

      execute_sql(CREATE TABLE mdl_choice_options ( id int(10) unsigned NOT NULL auto_increment, choiceid int(10) unsigned NOT NULL default '0',...) % line 199, file: datalib.php

      modify_database(C:\Inetpub\wwwroot\moodle\moodle/mod/Copy of choice/db/mysql.sql) % line 205, file: adminlib.php

      upgrade_activity_modules(http://bc354664/admin/index.php) % line 243, file: index.php

      Error

      --------------------------------------------------------------------------------

      (mysql): INSERT INTO mdl_log_display VALUES ('choice', 'view', 'choice', 'name')

      --------------------------------------------------------------------------------

      Success

      --------------------------------------------------------------------------------

      (mysql): INSERT INTO mdl_log_display VALUES ('choice', 'update', 'choice', 'name')

      --------------------------------------------------------------------------------

      Success

      --------------------------------------------------------------------------------

      (mysql): INSERT INTO mdl_log_display VALUES ('choice', 'add', 'choice', 'name')

      --------------------------------------------------------------------------------

      Success

      --------------------------------------------------------------------------------

      (mysql): INSERT INTO mdl_log_display VALUES ('choice', 'report', 'choice', 'name')

      --------------------------------------------------------------------------------

      Success

      --------------------------------------------------------------------------------

      (mysql): INSERT INTO mdl_log_display VALUES ('choice', 'choose', 'choice', 'name')

      --------------------------------------------------------------------------------

      Success

      --------------------------------------------------------------------------------

      (mysql): INSERT INTO mdl_log_display VALUES ('choice', 'choose again', 'choice', 'name')

      --------------------------------------------------------------------------------

      Success

      --------------------------------------------------------------------------------

      (mysql): SELECT COUNT FROM mdl_message WHERE useridto = '17' AND timecreated > '0'

      --------------------------------------------------------------------------------

      Copy of choice tables could NOT be set up successfully!

      --------------------------------------------------------------------------------

      (mysql): SELECT * FROM mdl_user WHERE id = '17' AND username = 'guest' LIMIT 1

      --------------------------------------------------------------------------------

      --------------------------------------------------------------------------------

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Fix Release Date:
                20/Jun/06