dr_smit wrote on Sunday, April 27, 2008:
Failed! Failed creating tables. Please enable DEBUG mode (set it to TRUE in $gacl_options near top of admin/gacl_admin.inc.php)
for some noob like I…
DEBUG option is located in gacl.ini.php and not in gacl_admin.inc.php
Setting Debug=true results in http://smitdesk/phpgacl/setup.php showing the following errors I am yet to decipher… Help!! Help!!
Option: db_type
Valid Config options: db_type
Option: db_host
Valid Config options: db_host
Option: db_user
Valid Config options: db_user
Option: db_password
Valid Config options: db_password
Option: db_name
Valid Config options: db_name
Option: db_table_prefix
Valid Config options: db_table_prefix
Option: caching
Valid Config options: caching
Option: force_cache_expire
Valid Config options: force_cache_expire
Option: cache_dir
Valid Config options: cache_dir
Option: cache_expire_time
Valid Config options: cache_expire_time
Option: items_per_page
Valid Config options: items_per_page
Option: max_select_box_items
Valid Config options: max_select_box_items
Option: max_search_return_items
Valid Config options: max_search_return_items
Option: smarty_dir
ERROR: Config option: smarty_dir is not a valid option
Option: smarty_template_dir
ERROR: Config option: smarty_template_dir is not a valid option
Option: smarty_compile_dir
ERROR: Config option: smarty_compile_dir is not a valid option
phpGACL Database Setup
Configuration:
driver = mysql,
host = localhost,
user = root,
database = gacl,
table prefix =
Testing database connection…
Success! Connected to “mysql” database on “localhost”.
Testing database type…
Success! Compatible database type “mysql” detected!
Making sure database “gacl” exists…
(mysql): show databases Success! Good, database “gacl” already exists!
(mysql): select version() (mysql): SHOW INDEX FROM phpgacl (mysql): SHOW COLUMNS FROM `phpgacl` (mysql): SHOW COLUMNS FROM `phpgacl` (mysql): SHOW INDEX FROM acl (mysql): SHOW COLUMNS FROM `acl` (mysql): SHOW COLUMNS FROM `acl` (mysql): SHOW INDEX FROM acl_sections (mysql): SHOW COLUMNS FROM `acl_sections` (mysql): SHOW COLUMNS FROM `acl_sections` (mysql): SHOW INDEX FROM aco (mysql): SHOW COLUMNS FROM `aco` (mysql): SHOW COLUMNS FROM `aco` (mysql): SHOW INDEX FROM aco_map 1146: Table ‘gacl.aco_map’ doesn’t exist
(mysql): SHOW COLUMNS FROM `aco_map` 1146: Table ‘gacl.aco_map’ doesn’t exist
(mysql): SHOW INDEX FROM aco_sections (mysql): SHOW COLUMNS FROM `aco_sections` (mysql): SHOW COLUMNS FROM `aco_sections` (mysql): SHOW INDEX FROM aro (mysql): SHOW COLUMNS FROM `aro` (mysql): SHOW COLUMNS FROM `aro` (mysql): SHOW INDEX FROM aro_map 1146: Table ‘gacl.aro_map’ doesn’t exist
(mysql): SHOW COLUMNS FROM `aro_map` 1146: Table ‘gacl.aro_map’ doesn’t exist
(mysql): SHOW INDEX FROM aro_sections (mysql): SHOW COLUMNS FROM `aro_sections` (mysql): SHOW COLUMNS FROM `aro_sections` (mysql): SHOW INDEX FROM axo (mysql): SHOW COLUMNS FROM `axo` (mysql): SHOW COLUMNS FROM `axo` (mysql): SHOW INDEX FROM axo_map 1146: Table ‘gacl.axo_map’ doesn’t exist
(mysql): SHOW COLUMNS FROM `axo_map` 1146: Table ‘gacl.axo_map’ doesn’t exist
(mysql): SHOW INDEX FROM axo_sections (mysql): SHOW COLUMNS FROM `axo_sections` (mysql): SHOW COLUMNS FROM `axo_sections` (mysql): SHOW INDEX FROM aro_groups (mysql): SHOW COLUMNS FROM `aro_groups` (mysql): SHOW COLUMNS FROM `aro_groups` (mysql): SHOW INDEX FROM groups_aro_map (mysql): SHOW COLUMNS FROM `groups_aro_map` (mysql): SHOW COLUMNS FROM `groups_aro_map` (mysql): SHOW INDEX FROM aro_groups_map (mysql): SHOW COLUMNS FROM `aro_groups_map` (mysql): SHOW COLUMNS FROM `aro_groups_map` (mysql): SHOW INDEX FROM axo_groups (mysql): SHOW COLUMNS FROM `axo_groups` (mysql): SHOW COLUMNS FROM `axo_groups` (mysql): SHOW INDEX FROM groups_axo_map (mysql): SHOW COLUMNS FROM `groups_axo_map` (mysql): SHOW COLUMNS FROM `groups_axo_map` (mysql): SHOW INDEX FROM axo_groups_map (mysql): SHOW COLUMNS FROM `axo_groups_map` (mysql): SHOW COLUMNS FROM `axo_groups_map` Here’s the SQL to do the build:
DELETE FROM phpgacl WHERE name=‘version’;
INSERT INTO phpgacl (name,value) VALUES (‘version’,‘3.3.7’);
DELETE FROM phpgacl WHERE name=‘schema_version’;
INSERT INTO phpgacl (name,value) VALUES (‘schema_version’,‘2.1’);
DROP INDEX enabled_acl ON acl;
DROP INDEX section_value_acl ON acl;
DROP INDEX updated_date_acl ON acl;
ALTER TABLE acl MODIFY COLUMN id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE acl MODIFY COLUMN allow INTEGER NOT NULL DEFAULT 0;
ALTER TABLE acl MODIFY COLUMN enabled INTEGER NOT NULL DEFAULT 0;
ALTER TABLE acl MODIFY COLUMN updated_date INTEGER NOT NULL DEFAULT 0;
ALTER TABLE acl ADD INDEX enabled_acl (enabled);
ALTER TABLE acl ADD INDEX section_value_acl (section_value);
ALTER TABLE acl ADD INDEX updated_date_acl (updated_date);
DROP INDEX value_acl_sections ON acl_sections;
DROP INDEX hidden_acl_sections ON acl_sections;
ALTER TABLE acl_sections MODIFY COLUMN id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE acl_sections MODIFY COLUMN order_value INTEGER NOT NULL DEFAULT 0;
ALTER TABLE acl_sections MODIFY COLUMN hidden INTEGER NOT NULL DEFAULT 0;
ALTER TABLE acl_sections ADD UNIQUE INDEX value_acl_sections (value);
ALTER TABLE acl_sections ADD INDEX hidden_acl_sections (hidden);
DELETE FROM acl_sections WHERE id=1 AND value=‘system’;
INSERT INTO acl_sections (id,value,order_value,name) VALUES (1,‘system’,1,‘System’);
DELETE FROM acl_sections WHERE id=2 AND value=‘user’;
INSERT INTO acl_sections (id,value,order_value,name) VALUES (2,‘user’,2,‘User’);
DROP INDEX hidden_aco ON aco;
ALTER TABLE aco MODIFY COLUMN id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aco MODIFY COLUMN order_value INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aco MODIFY COLUMN hidden INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aco ADD UNIQUE INDEX section_value_value_aco (section_value, value);
ALTER TABLE aco ADD INDEX hidden_aco (hidden);
CREATE TABLE aco_map (
acl_id INTEGER NOT NULL DEFAULT 0,
section_value VARCHAR(230) NOT NULL DEFAULT ‘0’,
value VARCHAR(230) NOT NULL,
PRIMARY KEY (acl_id, section_value, value)
);
DROP INDEX value_aco_sections ON aco_sections;
DROP INDEX hidden_aco_sections ON aco_sections;
ALTER TABLE aco_sections MODIFY COLUMN id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aco_sections MODIFY COLUMN order_value INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aco_sections MODIFY COLUMN hidden INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aco_sections ADD UNIQUE INDEX value_aco_sections (value);
ALTER TABLE aco_sections ADD INDEX hidden_aco_sections (hidden);
DROP INDEX hidden_aro ON aro;
ALTER TABLE aro MODIFY COLUMN id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aro MODIFY COLUMN order_value INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aro MODIFY COLUMN hidden INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aro ADD UNIQUE INDEX section_value_value_aro (section_value, value);
ALTER TABLE aro ADD INDEX hidden_aro (hidden);
CREATE TABLE aro_map (
acl_id INTEGER NOT NULL DEFAULT 0,
section_value VARCHAR(230) NOT NULL DEFAULT ‘0’,
value VARCHAR(230) NOT NULL,
PRIMARY KEY (acl_id, section_value, value)
);
DROP INDEX value_aro_sections ON aro_sections;
DROP INDEX hidden_aro_sections ON aro_sections;
ALTER TABLE aro_sections MODIFY COLUMN id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aro_sections MODIFY COLUMN order_value INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aro_sections MODIFY COLUMN hidden INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aro_sections ADD UNIQUE INDEX value_aro_sections (value);
ALTER TABLE aro_sections ADD INDEX hidden_aro_sections (hidden);
DROP INDEX hidden_axo ON axo;
ALTER TABLE axo MODIFY COLUMN id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE axo MODIFY COLUMN order_value INTEGER NOT NULL DEFAULT 0;
ALTER TABLE axo MODIFY COLUMN hidden INTEGER NOT NULL DEFAULT 0;
ALTER TABLE axo ADD UNIQUE INDEX section_value_value_axo (section_value, value);
ALTER TABLE axo ADD INDEX hidden_axo (hidden);
CREATE TABLE axo_map (
acl_id INTEGER NOT NULL DEFAULT 0,
section_value VARCHAR(230) NOT NULL DEFAULT ‘0’,
value VARCHAR(230) NOT NULL,
PRIMARY KEY (acl_id, section_value, value)
);
DROP INDEX value_axo_sections ON axo_sections;
DROP INDEX hidden_axo_sections ON axo_sections;
ALTER TABLE axo_sections MODIFY COLUMN id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE axo_sections MODIFY COLUMN order_value INTEGER NOT NULL DEFAULT 0;
ALTER TABLE axo_sections MODIFY COLUMN hidden INTEGER NOT NULL DEFAULT 0;
ALTER TABLE axo_sections ADD UNIQUE INDEX value_axo_sections (value);
ALTER TABLE axo_sections ADD INDEX hidden_axo_sections (hidden);
DROP INDEX value_aro_groups ON aro_groups;
DROP INDEX parent_id_aro_groups ON aro_groups;
DROP INDEX lft_rgt_aro_groups ON aro_groups;
ALTER TABLE aro_groups MODIFY COLUMN id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aro_groups MODIFY COLUMN parent_id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aro_groups MODIFY COLUMN lft INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aro_groups MODIFY COLUMN rgt INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aro_groups ADD INDEX parent_id_aro_groups (parent_id);
ALTER TABLE aro_groups ADD UNIQUE INDEX value_aro_groups (value);
ALTER TABLE aro_groups ADD INDEX lft_rgt_aro_groups (lft, rgt);
DROP INDEX aro_id ON groups_aro_map;
ALTER TABLE groups_aro_map MODIFY COLUMN group_id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE groups_aro_map MODIFY COLUMN aro_id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE groups_aro_map ADD INDEX aro_id (aro_id);
ALTER TABLE aro_groups_map MODIFY COLUMN acl_id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aro_groups_map MODIFY COLUMN group_id INTEGER NOT NULL DEFAULT 0;
DROP INDEX value_axo_groups ON axo_groups;
DROP INDEX parent_id_axo_groups ON axo_groups;
DROP INDEX lft_rgt_axo_groups ON axo_groups;
ALTER TABLE axo_groups MODIFY COLUMN id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE axo_groups MODIFY COLUMN parent_id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE axo_groups MODIFY COLUMN lft INTEGER NOT NULL DEFAULT 0;
ALTER TABLE axo_groups MODIFY COLUMN rgt INTEGER NOT NULL DEFAULT 0;
ALTER TABLE axo_groups ADD INDEX parent_id_axo_groups (parent_id);
ALTER TABLE axo_groups ADD UNIQUE INDEX value_axo_groups (value);
ALTER TABLE axo_groups ADD INDEX lft_rgt_axo_groups (lft, rgt);
DROP INDEX axo_id ON groups_axo_map;
ALTER TABLE groups_axo_map MODIFY COLUMN group_id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE groups_axo_map MODIFY COLUMN axo_id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE groups_axo_map ADD INDEX axo_id (axo_id);
ALTER TABLE axo_groups_map MODIFY COLUMN acl_id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE axo_groups_map MODIFY COLUMN group_id INTEGER NOT NULL DEFAULT 0; (mysql): DELETE FROM phpgacl WHERE name=‘version’ (mysql): INSERT INTO phpgacl (name,value) VALUES (‘version’,‘3.3.7’) (mysql): DELETE FROM phpgacl WHERE name=‘schema_version’ (mysql): INSERT INTO phpgacl (name,value) VALUES (‘schema_version’,‘2.1’) (mysql): DROP INDEX enabled_acl ON acl (mysql): DROP INDEX section_value_acl ON acl (mysql): DROP INDEX updated_date_acl ON acl (mysql): ALTER TABLE acl MODIFY COLUMN id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE acl MODIFY COLUMN allow INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE acl MODIFY COLUMN enabled INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE acl MODIFY COLUMN updated_date INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE acl ADD INDEX enabled_acl (enabled) (mysql): ALTER TABLE acl ADD INDEX section_value_acl (section_value) (mysql): ALTER TABLE acl ADD INDEX updated_date_acl (updated_date) (mysql): DROP INDEX value_acl_sections ON acl_sections (mysql): DROP INDEX hidden_acl_sections ON acl_sections (mysql): ALTER TABLE acl_sections MODIFY COLUMN id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE acl_sections MODIFY COLUMN order_value INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE acl_sections MODIFY COLUMN hidden INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE acl_sections ADD UNIQUE INDEX value_acl_sections (value) (mysql): ALTER TABLE acl_sections ADD INDEX hidden_acl_sections (hidden) (mysql): DELETE FROM acl_sections WHERE id=1 AND value=‘system’ (mysql): INSERT INTO acl_sections (id,value,order_value,name) VALUES (1,‘system’,1,‘System’) (mysql): DELETE FROM acl_sections WHERE id=2 AND value=‘user’ (mysql): INSERT INTO acl_sections (id,value,order_value,name) VALUES (2,‘user’,2,‘User’) (mysql): DROP INDEX hidden_aco ON aco (mysql): ALTER TABLE aco MODIFY COLUMN id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aco MODIFY COLUMN order_value INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aco MODIFY COLUMN hidden INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aco ADD UNIQUE INDEX section_value_value_aco (section_value, value) 1071: Specified key was too long; max key length is 1000 bytes
(mysql): ALTER TABLE aco ADD INDEX hidden_aco (hidden) (mysql): CREATE TABLE aco_map ( acl_id INTEGER NOT NULL DEFAULT 0, section_value VARCHAR(230) NOT NULL DEFAULT ‘0’, value VARCHAR(230) NOT NULL, PRIMARY KEY (acl_id, section_value, value) ) 1071: Specified key was too long; max key length is 1000 bytes
(mysql): DROP INDEX value_aco_sections ON aco_sections (mysql): DROP INDEX hidden_aco_sections ON aco_sections (mysql): ALTER TABLE aco_sections MODIFY COLUMN id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aco_sections MODIFY COLUMN order_value INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aco_sections MODIFY COLUMN hidden INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aco_sections ADD UNIQUE INDEX value_aco_sections (value) (mysql): ALTER TABLE aco_sections ADD INDEX hidden_aco_sections (hidden) (mysql): DROP INDEX hidden_aro ON aro (mysql): ALTER TABLE aro MODIFY COLUMN id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aro MODIFY COLUMN order_value INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aro MODIFY COLUMN hidden INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aro ADD UNIQUE INDEX section_value_value_aro (section_value, value) 1071: Specified key was too long; max key length is 1000 bytes
(mysql): ALTER TABLE aro ADD INDEX hidden_aro (hidden) (mysql): CREATE TABLE aro_map ( acl_id INTEGER NOT NULL DEFAULT 0, section_value VARCHAR(230) NOT NULL DEFAULT ‘0’, value VARCHAR(230) NOT NULL, PRIMARY KEY (acl_id, section_value, value) ) 1071: Specified key was too long; max key length is 1000 bytes
(mysql): DROP INDEX value_aro_sections ON aro_sections (mysql): DROP INDEX hidden_aro_sections ON aro_sections (mysql): ALTER TABLE aro_sections MODIFY COLUMN id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aro_sections MODIFY COLUMN order_value INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aro_sections MODIFY COLUMN hidden INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aro_sections ADD UNIQUE INDEX value_aro_sections (value) (mysql): ALTER TABLE aro_sections ADD INDEX hidden_aro_sections (hidden) (mysql): DROP INDEX hidden_axo ON axo (mysql): ALTER TABLE axo MODIFY COLUMN id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE axo MODIFY COLUMN order_value INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE axo MODIFY COLUMN hidden INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE axo ADD UNIQUE INDEX section_value_value_axo (section_value, value) 1071: Specified key was too long; max key length is 1000 bytes
(mysql): ALTER TABLE axo ADD INDEX hidden_axo (hidden) (mysql): CREATE TABLE axo_map ( acl_id INTEGER NOT NULL DEFAULT 0, section_value VARCHAR(230) NOT NULL DEFAULT ‘0’, value VARCHAR(230) NOT NULL, PRIMARY KEY (acl_id, section_value, value) ) 1071: Specified key was too long; max key length is 1000 bytes
(mysql): DROP INDEX value_axo_sections ON axo_sections (mysql): DROP INDEX hidden_axo_sections ON axo_sections (mysql): ALTER TABLE axo_sections MODIFY COLUMN id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE axo_sections MODIFY COLUMN order_value INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE axo_sections MODIFY COLUMN hidden INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE axo_sections ADD UNIQUE INDEX value_axo_sections (value) (mysql): ALTER TABLE axo_sections ADD INDEX hidden_axo_sections (hidden) (mysql): DROP INDEX value_aro_groups ON aro_groups (mysql): DROP INDEX parent_id_aro_groups ON aro_groups (mysql): DROP INDEX lft_rgt_aro_groups ON aro_groups (mysql): ALTER TABLE aro_groups MODIFY COLUMN id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aro_groups MODIFY COLUMN parent_id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aro_groups MODIFY COLUMN lft INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aro_groups MODIFY COLUMN rgt INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aro_groups ADD INDEX parent_id_aro_groups (parent_id) (mysql): ALTER TABLE aro_groups ADD UNIQUE INDEX value_aro_groups (value) (mysql): ALTER TABLE aro_groups ADD INDEX lft_rgt_aro_groups (lft, rgt) (mysql): DROP INDEX aro_id ON groups_aro_map (mysql): ALTER TABLE groups_aro_map MODIFY COLUMN group_id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE groups_aro_map MODIFY COLUMN aro_id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE groups_aro_map ADD INDEX aro_id (aro_id) (mysql): ALTER TABLE aro_groups_map MODIFY COLUMN acl_id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aro_groups_map MODIFY COLUMN group_id INTEGER NOT NULL DEFAULT 0 (mysql): DROP INDEX value_axo_groups ON axo_groups (mysql): DROP INDEX parent_id_axo_groups ON axo_groups (mysql): DROP INDEX lft_rgt_axo_groups ON axo_groups (mysql): ALTER TABLE axo_groups MODIFY COLUMN id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE axo_groups MODIFY COLUMN parent_id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE axo_groups MODIFY COLUMN lft INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE axo_groups MODIFY COLUMN rgt INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE axo_groups ADD INDEX parent_id_axo_groups (parent_id) (mysql): ALTER TABLE axo_groups ADD UNIQUE INDEX value_axo_groups (value) (mysql): ALTER TABLE axo_groups ADD INDEX lft_rgt_axo_groups (lft, rgt) (mysql): DROP INDEX axo_id ON groups_axo_map (mysql): ALTER TABLE groups_axo_map MODIFY COLUMN group_id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE groups_axo_map MODIFY COLUMN axo_id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE groups_axo_map ADD INDEX axo_id (axo_id) (mysql): ALTER TABLE axo_groups_map MODIFY COLUMN acl_id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE axo_groups_map MODIFY COLUMN group_id INTEGER NOT NULL DEFAULT 0 Failed! Failed creating tables. Please enable DEBUG mode (set it to TRUE in $gacl_options near top of admin/gacl_admin.inc.php) to see the error and try again. You will most likely need to delete any tables already created.
Failed! Please fix the above errors and try again.