Thanks Bernard...
I'm using AL 2.5 with Moodle 1.9 on a production server.
It works perferct... there are no problems with how it is working. The only problem is when you go to Site Admin menu and click on Notifications, you always get the message below, which is the same message that appeared when I first installed it.
I think the problem is that the AL module doesn't think it got installed properly, when really everything is ok because the tables & columns were already in place (and it's actually working fine).
----------------------
This script generated 7 warnings
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(/home/mysite/public_html/members/blocks/activity_locking/db/mysql.sql) % line 1355, file: blocklib.php
upgrade_blocks_plugins(http://www.mysite.com/members/admin/index.php) % line 441, file: index.php
--------------------------------------------------------------------------------
(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(/home/mysite/public_html/members/blocks/activity_locking/db/mysql.sql) % line 1355, file: blocklib.php
upgrade_blocks_plugins(http://www.mysite.com/members/admin/index.php) % line 441, file: index.php
--------------------------------------------------------------------------------
(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(/home/mysite/public_html/members/blocks/activity_locking/db/mysql.sql) % line 1355, file: blocklib.php
upgrade_blocks_plugins(http://www.mysite.com/members/admin/index.php) % line 441, file: index.php
--------------------------------------------------------------------------------
(mysql): ALTER TABLE `mdl_course_modules` ADD `stylewhenlocked` VARCHAR( 200 ) NULL default 'locked' AFTER `visible`
--------------------------------------------------------------------------------
1060: Duplicate column name 'stylewhenlocked'
ADOConnection._Execute(ALTER TABLE `mdl_course_modules` ADD `stylewhenlocked` VARCHAR( 200 ) NULL default 'locked' AFTER `visible`, false) % line 891, file: adodb.inc.php
ADOConnection.Execute(ALTER TABLE `mdl_course_modules` ADD `stylewhenlocked` VARCHAR( 200 ) NULL default 'locked' AFTER `visible`) % line 89, file: dmllib.php
execute_sql(ALTER TABLE `mdl_course_modules` ADD `stylewhenlocked` VARCHAR( 200 ) NULL default 'locked' AFTER `visible`) % line 235, file: dmllib.php
modify_database(/home/mysite/public_html/members/blocks/activity_locking/db/mysql.sql) % line 1355, file: blocklib.php
upgrade_blocks_plugins(http://www.mysite.com/members/admin/index.php) % line 441, file: index.php
--------------------------------------------------------------------------------
(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(/home/mysite/public_html/members/blocks/activity_locking/db/mysql.sql) % line 1355, file: blocklib.php
upgrade_blocks_plugins(http://www.mysite.com/members/admin/index.php) % line 441, file: index.php
-------------------------------------------------------------------------------
(mysql): ALTER TABLE `mdl_course_modules` ADD `stylewhencomplete` VARCHAR( 200 ) NULL default '' AFTER `visible`
--------------------------------------------------------------------------------
1060: Duplicate column name 'stylewhencomplete'
ADOConnection._Execute(ALTER TABLE `mdl_course_modules` ADD `stylewhencomplete` VARCHAR( 200 ) NULL default '' AFTER `visible`, false) % line 891, file: adodb.inc.php
ADOConnection.Execute(ALTER TABLE `mdl_course_modules` ADD `stylewhencomplete` VARCHAR( 200 ) NULL default '' AFTER `visible`) % line 89, file: dmllib.php
execute_sql(ALTER TABLE `mdl_course_modules` ADD `stylewhencomplete` VARCHAR( 200 ) NULL default '' AFTER `visible`) % line 235, file: dmllib.php
modify_database(/home/mysite/public_html/members/blocks/activity_locking/db/mysql.sql) % line 1355, file: blocklib.php
upgrade_blocks_plugins(http://www.mysite.com/members/admin/index.php) % line 441, file: index.php
--------------------------------------------------------------------------------
(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(/home/mysite/public_html/members/blocks/activity_locking/db/mysql.sql) % line 1355, file: blocklib.php
upgrade_blocks_plugins(http://www.mysite.com/members/admin/index.php) % line 441, file: index.php
Block activity_locking tables could NOT be set up successfully!