Hallo,
hat schon jemand Activity Locking unter v1.9.7+ (20100127) zum Laufen bekommen?
Ich bekomme unter "Mitteilungen" folgende Fehler:
This script generated 5 warnings - Scroll to the first warning
activity_locking
(mysql): CREATE TABLE `mdl_course_module_locks` ( `id` int(10) unsigned NOT NULL auto_increment, `courseid` int(10) unsigned NOT NULL default '0', `moduleid` int(10) unsigned NOT NULL default '0', `lockid` int(10) unsigned NOT NULL default '0', `requirement` varchar(10) NOT NULL default '', PRIMARY KEY (id), UNIQUE KEY id (id), KEY lockid (lockid), KEY moduleid (moduleid), KEY courseid (courseid) ) TYPE=MyISAM
1050: Table 'mdl_course_module_locks' already exists
ADOConnection._Execute(CREATE TABLE `mdl_course_module_locks` ( `id` int(10) unsigned NOT NULL auto_increment, `courseid` int(10) unsigned NOT NULL d..., false) % line 891, file: adodb.inc.php
ADOConnection.Execute(CREATE TABLE `mdl_course_module_locks` ( `id` int(10) unsigned NOT NULL auto_increment, `courseid` int(10) unsigned NOT NULL d...) % line 89, file: dmllib.php
execute_sql(CREATE TABLE `mdl_course_module_locks` ( `id` int(10) unsigned NOT NULL auto_increment, `courseid` int(10) unsigned NOT NULL d...) % line 235, file: dmllib.php
modify_database(/www/htdocs/.../blocks/activity_locking/db/mysql.sql) % line 1398, file: blocklib.php
upgrade_blocks_plugins(http://.../admin/index.php) % line 452, file: index.php
FehlerScroll to next warning
(mysql): ALTER TABLE `mdl_course_modules` ADD `delay` VARCHAR( 10 ) NOT NULL AFTER `added`
1060: Duplicate column name 'delay'
ADOConnection._Execute(ALTER TABLE `mdl_course_modules` ADD `delay` VARCHAR( 10 ) NOT NULL AFTER `added`, false) % line 891, file: adodb.inc.php
ADOConnection.Execute(ALTER TABLE `mdl_course_modules` ADD `delay` VARCHAR( 10 ) NOT NULL AFTER `added`) % line 89, file: dmllib.php
execute_sql(ALTER TABLE `mdl_course_modules` ADD `delay` VARCHAR( 10 ) NOT NULL AFTER `added`) % line 235, file: dmllib.php
modify_database(/www/htdocs/.../blocks/activity_locking/db/mysql.sql) % line 1398, file: blocklib.php
upgrade_blocks_plugins(http:/.../index.php) % line 452, file: index.php
Scroll to previous warningFehlerScroll to next warning
(mysql): ALTER TABLE `mdl_course_modules` ADD `visiblewhenlocked` TINYINT( 1 ) UNSIGNED NOT NULL default '1' AFTER `visible`
1060: Duplicate column name 'visiblewhenlocked'
ADOConnection._Execute(ALTER TABLE `mdl_course_modules` ADD `visiblewhenlocked` TINYINT( 1 ) UNSIGNED NOT NULL default '1' AFTER `visible`, false) % line 891, file: adodb.inc.php
ADOConnection.Execute(ALTER TABLE `mdl_course_modules` ADD `visiblewhenlocked` TINYINT( 1 ) UNSIGNED NOT NULL default '1' AFTER `visible`) % line 89, file: dmllib.php
execute_sql(ALTER TABLE `mdl_course_modules` ADD `visiblewhenlocked` TINYINT( 1 ) UNSIGNED NOT NULL default '1' AFTER `visible`) % line 235, file: dmllib.php
modify_database(/www/.../blocks/activity_locking/db/mysql.sql) % line 1398, file: blocklib.php
upgrade_blocks_plugins(http://.../index.php) % line 452, file: index.php
Scroll to previous warningFehlerScroll to next warning
(mysql): ALTER TABLE `mdl_course_modules` ADD `checkboxforcomplete` TINYINT( 1 ) UNSIGNED NOT NULL default '0' AFTER `visible`
1060: Duplicate column name 'checkboxforcomplete'
ADOConnection._Execute(ALTER TABLE `mdl_course_modules` ADD `checkboxforcomplete` TINYINT( 1 ) UNSIGNED NOT NULL default '0' AFTER `visible`, false) % line 891, file: adodb.inc.php
ADOConnection.Execute(ALTER TABLE `mdl_course_modules` ADD `checkboxforcomplete` TINYINT( 1 ) UNSIGNED NOT NULL default '0' AFTER `visible`) % line 89, file: dmllib.php
execute_sql(ALTER TABLE `mdl_course_modules` ADD `checkboxforcomplete` TINYINT( 1 ) UNSIGNED NOT NULL default '0' AFTER `visible`) % line 235, file: dmllib.php
modify_database(/www/.../blocks/activity_locking/db/mysql.sql) % line 1398, file: blocklib.php
upgrade_blocks_plugins(http://.../index.php) % line 452, file: index.php
Scroll to previous warningFehlerScroll to next warning
(mysql): ALTER TABLE `mdl_course_modules` ADD `checkboxesforprereqs` TINYINT( 1 ) UNSIGNED NOT NULL default '1' AFTER `visible`
1060: Duplicate column name 'checkboxesforprereqs'
ADOConnection._Execute(ALTER TABLE `mdl_course_modules` ADD `checkboxesforprereqs` TINYINT( 1 ) UNSIGNED NOT NULL default '1' AFTER `visible`, false) % line 891, file: adodb.inc.php
ADOConnection.Execute(ALTER TABLE `mdl_course_modules` ADD `checkboxesforprereqs` TINYINT( 1 ) UNSIGNED NOT NULL default '1' AFTER `visible`) % line 89, file: dmllib.php
execute_sql(ALTER TABLE `mdl_course_modules` ADD `checkboxesforprereqs` TINYINT( 1 ) UNSIGNED NOT NULL default '1' AFTER `visible`) % line 235, file: dmllib.php
modify_database(/www/.../blocks/activity_locking/db/mysql.sql) % line 1398, file: blocklib.php
upgrade_blocks_plugins(http://.../index.php) % line 452, file: index.php
Hat vielleicht jemand eine Idee?
Ich bin für jeden Lösungsvorschlag dankbar, da ich diese Funktion zwingend benötige, sie aber nicht mehr funktioniert.
Vielen Dank und Grüße,
Ralf