3 Feb 22:09
phpGACL Errors on Upgrade
From: Al Gartner <al.gartner <at> workscape.com>
Subject: phpGACL Errors on Upgrade
Newsgroups: gmane.comp.security.ossim.support
Date: 2005-02-03 21:10:44 GMT
Subject: phpGACL Errors on Upgrade
Newsgroups: gmane.comp.security.ossim.support
Date: 2005-02-03 21:10:44 GMT
I've been trying to keep up with the Debian distros
using the ossim deb packages via apt.
With the rc-1 build, it seems that the phpGACL has
gone pretty much sideways.
I have the debug output - be forewarned, I'm not a
database expert. I tried going through, deleting all the databases, and
reloading the page, but got similar results.
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: 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
Making sure database "ossim" exists...
(mysql): show databases Success! Good, database "ossim" 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 (mysql): SHOW COLUMNS FROM aco_map (mysql): SHOW COLUMNS FROM aco_map (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 (mysql): SHOW COLUMNS FROM aro_map (mysql): SHOW COLUMNS FROM aro_map (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 (mysql): SHOW COLUMNS FROM axo_map (mysql): SHOW COLUMNS FROM axo_map (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:
ALTER TABLE phpgacl DROP COLUMN `name`;
ALTER TABLE phpgacl DROP COLUMN `value`;
ALTER TABLE phpgacl ADD name VARCHAR(230) NOT NULL;
ALTER TABLE phpgacl ADD value VARCHAR(230) NOT NULL;
DELETE FROM phpgacl WHERE name='version';
INSERT INTO phpgacl (name,value) VALUES ('version','3.3.4');
DELETE FROM phpgacl WHERE name='schema_version';
INSERT INTO phpgacl (name,value) VALUES ('schema_version','2.1');
ALTER TABLE acl DROP COLUMN `note`;
ALTER TABLE acl ADD id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE acl ADD section_value VARCHAR(230) NOT NULL DEFAULT 'system';
ALTER TABLE acl ADD allow INTEGER NOT NULL DEFAULT 0;
ALTER TABLE acl ADD enabled INTEGER NOT NULL DEFAULT 0;
ALTER TABLE acl ADD return_value LONGTEXT;
ALTER TABLE acl ADD note LONGTEXT;
ALTER TABLE acl ADD 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 hidden_acl_sections ON acl_sections;
ALTER TABLE acl_sections DROP COLUMN `hidden`;
ALTER TABLE acl_sections DROP COLUMN `id`;
ALTER TABLE acl_sections DROP COLUMN `value`;
ALTER TABLE acl_sections DROP COLUMN `order_value`;
ALTER TABLE acl_sections DROP COLUMN `name`;
ALTER TABLE acl_sections ADD id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE acl_sections ADD value VARCHAR(230) NOT NULL;
ALTER TABLE acl_sections ADD order_value INTEGER NOT NULL DEFAULT 0;
ALTER TABLE acl_sections ADD name VARCHAR(230) NOT NULL;
ALTER TABLE acl_sections ADD 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 section_value_value_aco ON aco;
DROP INDEX hidden_aco ON aco;
ALTER TABLE aco DROP COLUMN `hidden`;
ALTER TABLE aco DROP COLUMN `id`;
ALTER TABLE aco DROP COLUMN `section_value`;
ALTER TABLE aco DROP COLUMN `value`;
ALTER TABLE aco DROP COLUMN `order_value`;
ALTER TABLE aco DROP COLUMN `name`;
ALTER TABLE aco ADD id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aco ADD section_value VARCHAR(240) NOT NULL DEFAULT '0';
ALTER TABLE aco ADD value VARCHAR(240) NOT NULL;
ALTER TABLE aco ADD order_value INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aco ADD name VARCHAR(255) NOT NULL;
ALTER TABLE aco ADD 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);
ALTER TABLE aco_map DROP COLUMN `value`;
ALTER TABLE aco_map DROP COLUMN `acl_id`;
ALTER TABLE aco_map DROP COLUMN `section_value`;
ALTER TABLE aco_map ADD acl_id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aco_map ADD section_value VARCHAR(230) NOT NULL DEFAULT '0';
ALTER TABLE aco_map ADD value VARCHAR(230) NOT NULL;
DROP INDEX value_aco_sections ON aco_sections;
DROP INDEX hidden_aco_sections ON aco_sections;
ALTER TABLE aco_sections DROP COLUMN `hidden`;
ALTER TABLE aco_sections DROP COLUMN `id`;
ALTER TABLE aco_sections DROP COLUMN `value`;
ALTER TABLE aco_sections DROP COLUMN `order_value`;
ALTER TABLE aco_sections DROP COLUMN `name`;
ALTER TABLE aco_sections ADD id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aco_sections ADD value VARCHAR(230) NOT NULL;
ALTER TABLE aco_sections ADD order_value INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aco_sections ADD name VARCHAR(230) NOT NULL;
ALTER TABLE aco_sections ADD 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 section_value_value_aro ON aro;
DROP INDEX hidden_aro ON aro;
ALTER TABLE aro DROP COLUMN `hidden`;
ALTER TABLE aro DROP COLUMN `id`;
ALTER TABLE aro DROP COLUMN `section_value`;
ALTER TABLE aro DROP COLUMN `value`;
ALTER TABLE aro DROP COLUMN `order_value`;
ALTER TABLE aro DROP COLUMN `name`;
ALTER TABLE aro ADD id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aro ADD section_value VARCHAR(240) NOT NULL DEFAULT '0';
ALTER TABLE aro ADD value VARCHAR(240) NOT NULL;
ALTER TABLE aro ADD order_value INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aro ADD name VARCHAR(255) NOT NULL;
ALTER TABLE aro ADD 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);
ALTER TABLE aro_map DROP COLUMN `value`;
ALTER TABLE aro_map DROP COLUMN `acl_id`;
ALTER TABLE aro_map DROP COLUMN `section_value`;
ALTER TABLE aro_map ADD acl_id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aro_map ADD section_value VARCHAR(230) NOT NULL DEFAULT '0';
ALTER TABLE aro_map ADD value VARCHAR(230) NOT NULL;
DROP INDEX value_aro_sections ON aro_sections;
DROP INDEX hidden_aro_sections ON aro_sections;
ALTER TABLE aro_sections DROP COLUMN `hidden`;
ALTER TABLE aro_sections DROP COLUMN `id`;
ALTER TABLE aro_sections DROP COLUMN `value`;
ALTER TABLE aro_sections DROP COLUMN `order_value`;
ALTER TABLE aro_sections DROP COLUMN `name`;
ALTER TABLE aro_sections ADD id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aro_sections ADD value VARCHAR(230) NOT NULL;
ALTER TABLE aro_sections ADD order_value INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aro_sections ADD name VARCHAR(230) NOT NULL;
ALTER TABLE aro_sections ADD 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 section_value_value_axo ON axo;
DROP INDEX hidden_axo ON axo;
ALTER TABLE axo DROP COLUMN `hidden`;
ALTER TABLE axo DROP COLUMN `id`;
ALTER TABLE axo DROP COLUMN `section_value`;
ALTER TABLE axo DROP COLUMN `value`;
ALTER TABLE axo DROP COLUMN `order_value`;
ALTER TABLE axo DROP COLUMN `name`;
ALTER TABLE axo ADD id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE axo ADD section_value VARCHAR(240) NOT NULL DEFAULT '0';
ALTER TABLE axo ADD value VARCHAR(240) NOT NULL;
ALTER TABLE axo ADD order_value INTEGER NOT NULL DEFAULT 0;
ALTER TABLE axo ADD name VARCHAR(255) NOT NULL;
ALTER TABLE axo ADD 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);
ALTER TABLE axo_map DROP COLUMN `value`;
ALTER TABLE axo_map DROP COLUMN `acl_id`;
ALTER TABLE axo_map DROP COLUMN `section_value`;
ALTER TABLE axo_map ADD acl_id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE axo_map ADD section_value VARCHAR(230) NOT NULL DEFAULT '0';
ALTER TABLE axo_map ADD value VARCHAR(230) NOT NULL;
DROP INDEX value_axo_sections ON axo_sections;
DROP INDEX hidden_axo_sections ON axo_sections;
ALTER TABLE axo_sections DROP COLUMN `hidden`;
ALTER TABLE axo_sections DROP COLUMN `id`;
ALTER TABLE axo_sections DROP COLUMN `value`;
ALTER TABLE axo_sections DROP COLUMN `order_value`;
ALTER TABLE axo_sections DROP COLUMN `name`;
ALTER TABLE axo_sections ADD id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE axo_sections ADD value VARCHAR(230) NOT NULL;
ALTER TABLE axo_sections ADD order_value INTEGER NOT NULL DEFAULT 0;
ALTER TABLE axo_sections ADD name VARCHAR(230) NOT NULL;
ALTER TABLE axo_sections ADD 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 DROP COLUMN `value`;
ALTER TABLE aro_groups DROP COLUMN `id`;
ALTER TABLE aro_groups DROP COLUMN `parent_id`;
ALTER TABLE aro_groups DROP COLUMN `lft`;
ALTER TABLE aro_groups DROP COLUMN `rgt`;
ALTER TABLE aro_groups DROP COLUMN `name`;
ALTER TABLE aro_groups ADD id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aro_groups ADD parent_id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aro_groups ADD lft INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aro_groups ADD rgt INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aro_groups ADD name VARCHAR(255) NOT NULL;
ALTER TABLE aro_groups ADD value VARCHAR(255) NOT NULL;
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 DROP COLUMN `aro_id`;
ALTER TABLE groups_aro_map DROP COLUMN `group_id`;
ALTER TABLE groups_aro_map ADD group_id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE groups_aro_map ADD aro_id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE groups_aro_map ADD INDEX aro_id (aro_id);
ALTER TABLE aro_groups_map DROP COLUMN `group_id`;
ALTER TABLE aro_groups_map DROP COLUMN `acl_id`;
ALTER TABLE aro_groups_map ADD acl_id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aro_groups_map ADD 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 DROP COLUMN `value`;
ALTER TABLE axo_groups DROP COLUMN `id`;
ALTER TABLE axo_groups DROP COLUMN `parent_id`;
ALTER TABLE axo_groups DROP COLUMN `lft`;
ALTER TABLE axo_groups DROP COLUMN `rgt`;
ALTER TABLE axo_groups DROP COLUMN `name`;
ALTER TABLE axo_groups ADD id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE axo_groups ADD parent_id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE axo_groups ADD lft INTEGER NOT NULL DEFAULT 0;
ALTER TABLE axo_groups ADD rgt INTEGER NOT NULL DEFAULT 0;
ALTER TABLE axo_groups ADD name VARCHAR(255) NOT NULL;
ALTER TABLE axo_groups ADD value VARCHAR(255) NOT NULL;
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 DROP COLUMN `axo_id`;
ALTER TABLE groups_axo_map DROP COLUMN `group_id`;
ALTER TABLE groups_axo_map ADD group_id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE groups_axo_map ADD axo_id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE groups_axo_map ADD INDEX axo_id (axo_id);
ALTER TABLE axo_groups_map DROP COLUMN `acl_id`;
ALTER TABLE axo_groups_map DROP COLUMN `group_id`;
ALTER TABLE axo_groups_map ADD acl_id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE axo_groups_map ADD group_id INTEGER NOT NULL DEFAULT 0; (mysql): ALTER TABLE phpgacl DROP COLUMN `name` (mysql): ALTER TABLE phpgacl DROP COLUMN `value` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE phpgacl DROP COLUMN `value`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE phpgacl DROP COLUMN `value`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE phpgacl ADD name VARCHAR(230) NOT NULL (mysql): ALTER TABLE phpgacl ADD value VARCHAR(230) NOT NULL 1060: Duplicate column name 'value'
adodb_mysql._execute(ALTER TABLE phpgacl ADD value VARCHAR(230) NOT NULL, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE phpgacl ADD value VARCHAR(230) NOT NULL) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): DELETE FROM phpgacl WHERE name='version' (mysql): INSERT INTO phpgacl (name, value) VALUES ('version', '3.3.4') (mysql): DELETE FROM phpgacl WHERE name='schema_version' (mysql): INSERT INTO phpgacl (name, value) VALUES ('schema_version', '2.1') (mysql): ALTER TABLE acl DROP COLUMN `note` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE acl DROP COLUMN `note`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE acl DROP COLUMN `note`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE acl ADD id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE acl ADD section_value VARCHAR(230) NOT NULL DEFAULT 'system' (mysql): ALTER TABLE acl ADD allow INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE acl ADD enabled INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE acl ADD return_value LONGTEXT (mysql): ALTER TABLE acl ADD note LONGTEXT 1060: Duplicate column name 'note'
adodb_mysql._execute(ALTER TABLE acl ADD note LONGTEXT, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE acl ADD note LONGTEXT) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE acl ADD 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 hidden_acl_sections ON acl_sections (mysql): ALTER TABLE acl_sections DROP COLUMN `hidden` (mysql): ALTER TABLE acl_sections DROP COLUMN `id` (mysql): ALTER TABLE acl_sections DROP COLUMN `value` (mysql): ALTER TABLE acl_sections DROP COLUMN `order_value` (mysql): ALTER TABLE acl_sections DROP COLUMN `name` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE acl_sections DROP COLUMN `name`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE acl_sections DROP COLUMN `name`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE acl_sections ADD id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE acl_sections ADD value VARCHAR(230) NOT NULL (mysql): ALTER TABLE acl_sections ADD order_value INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE acl_sections ADD name VARCHAR(230) NOT NULL 1060: Duplicate column name 'name'
adodb_mysql._execute(ALTER TABLE acl_sections ADD name VARCHAR(230) NOT NULL, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE acl_sections ADD name VARCHAR(230) NOT NULL) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE acl_sections ADD hidden INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE acl_sections ADD UNIQUE INDEX value_acl_sections (value) 1062: Duplicate entry '' for key 1
adodb_mysql._execute(ALTER TABLE acl_sections ADD UNIQUE INDEX value_acl_sections (..., false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE acl_sections ADD UNIQUE INDEX value_acl_sections (...) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (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 section_value_value_aco ON aco (mysql): DROP INDEX hidden_aco ON aco (mysql): ALTER TABLE aco DROP COLUMN `hidden` (mysql): ALTER TABLE aco DROP COLUMN `id` (mysql): ALTER TABLE aco DROP COLUMN `section_value` (mysql): ALTER TABLE aco DROP COLUMN `value` (mysql): ALTER TABLE aco DROP COLUMN `order_value` (mysql): ALTER TABLE aco DROP COLUMN `name` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE aco DROP COLUMN `name`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE aco DROP COLUMN `name`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE aco ADD id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aco ADD section_value VARCHAR(240) NOT NULL DEFAULT '0' (mysql): ALTER TABLE aco ADD value VARCHAR(240) NOT NULL (mysql): ALTER TABLE aco ADD order_value INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aco ADD name VARCHAR(255) NOT NULL 1060: Duplicate column name 'name'
adodb_mysql._execute(ALTER TABLE aco ADD name VARCHAR(255) NOT NULL, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE aco ADD name VARCHAR(255) NOT NULL) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE aco ADD hidden INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aco ADD UNIQUE INDEX section_value_value_aco (section_value, value) (mysql): ALTER TABLE aco ADD INDEX hidden_aco (hidden) (mysql): ALTER TABLE aco_map DROP COLUMN `value` (mysql): ALTER TABLE aco_map DROP COLUMN `acl_id` (mysql): ALTER TABLE aco_map DROP COLUMN `section_value` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE aco_map DROP COLUMN `section_value`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE aco_map DROP COLUMN `section_value`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE aco_map ADD acl_id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aco_map ADD section_value VARCHAR(230) NOT NULL DEFAULT '0' 1060: Duplicate column name 'section_value'
adodb_mysql._execute(ALTER TABLE aco_map ADD section_value VARCHAR(230) NOT NULL DEFA..., false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE aco_map ADD section_value VARCHAR(230) NOT NULL DEFA...) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE aco_map ADD value VARCHAR(230) NOT NULL (mysql): DROP INDEX value_aco_sections ON aco_sections (mysql): DROP INDEX hidden_aco_sections ON aco_sections (mysql): ALTER TABLE aco_sections DROP COLUMN `hidden` (mysql): ALTER TABLE aco_sections DROP COLUMN `id` (mysql): ALTER TABLE aco_sections DROP COLUMN `value` (mysql): ALTER TABLE aco_sections DROP COLUMN `order_value` (mysql): ALTER TABLE aco_sections DROP COLUMN `name` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE aco_sections DROP COLUMN `name`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE aco_sections DROP COLUMN `name`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE aco_sections ADD id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aco_sections ADD value VARCHAR(230) NOT NULL (mysql): ALTER TABLE aco_sections ADD order_value INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aco_sections ADD name VARCHAR(230) NOT NULL 1060: Duplicate column name 'name'
adodb_mysql._execute(ALTER TABLE aco_sections ADD name VARCHAR(230) NOT NULL, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE aco_sections ADD name VARCHAR(230) NOT NULL) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE aco_sections ADD 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 section_value_value_aro ON aro (mysql): DROP INDEX hidden_aro ON aro (mysql): ALTER TABLE aro DROP COLUMN `hidden` (mysql): ALTER TABLE aro DROP COLUMN `id` (mysql): ALTER TABLE aro DROP COLUMN `section_value` (mysql): ALTER TABLE aro DROP COLUMN `value` (mysql): ALTER TABLE aro DROP COLUMN `order_value` (mysql): ALTER TABLE aro DROP COLUMN `name` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE aro DROP COLUMN `name`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE aro DROP COLUMN `name`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE aro ADD id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aro ADD section_value VARCHAR(240) NOT NULL DEFAULT '0' (mysql): ALTER TABLE aro ADD value VARCHAR(240) NOT NULL (mysql): ALTER TABLE aro ADD order_value INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aro ADD name VARCHAR(255) NOT NULL 1060: Duplicate column name 'name'
adodb_mysql._execute(ALTER TABLE aro ADD name VARCHAR(255) NOT NULL, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE aro ADD name VARCHAR(255) NOT NULL) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE aro ADD hidden INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aro ADD UNIQUE INDEX section_value_value_aro (section_value, value) (mysql): ALTER TABLE aro ADD INDEX hidden_aro (hidden) (mysql): ALTER TABLE aro_map DROP COLUMN `value` (mysql): ALTER TABLE aro_map DROP COLUMN `acl_id` (mysql): ALTER TABLE aro_map DROP COLUMN `section_value` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE aro_map DROP COLUMN `section_value`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE aro_map DROP COLUMN `section_value`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE aro_map ADD acl_id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aro_map ADD section_value VARCHAR(230) NOT NULL DEFAULT '0' 1060: Duplicate column name 'section_value'
adodb_mysql._execute(ALTER TABLE aro_map ADD section_value VARCHAR(230) NOT NULL DEFA..., false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE aro_map ADD section_value VARCHAR(230) NOT NULL DEFA...) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE aro_map ADD value VARCHAR(230) NOT NULL (mysql): DROP INDEX value_aro_sections ON aro_sections (mysql): DROP INDEX hidden_aro_sections ON aro_sections (mysql): ALTER TABLE aro_sections DROP COLUMN `hidden` (mysql): ALTER TABLE aro_sections DROP COLUMN `id` (mysql): ALTER TABLE aro_sections DROP COLUMN `value` (mysql): ALTER TABLE aro_sections DROP COLUMN `order_value` (mysql): ALTER TABLE aro_sections DROP COLUMN `name` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE aro_sections DROP COLUMN `name`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE aro_sections DROP COLUMN `name`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE aro_sections ADD id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aro_sections ADD value VARCHAR(230) NOT NULL (mysql): ALTER TABLE aro_sections ADD order_value INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aro_sections ADD name VARCHAR(230) NOT NULL 1060: Duplicate column name 'name'
adodb_mysql._execute(ALTER TABLE aro_sections ADD name VARCHAR(230) NOT NULL, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE aro_sections ADD name VARCHAR(230) NOT NULL) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE aro_sections ADD 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 section_value_value_axo ON axo (mysql): DROP INDEX hidden_axo ON axo (mysql): ALTER TABLE axo DROP COLUMN `hidden` (mysql): ALTER TABLE axo DROP COLUMN `id` (mysql): ALTER TABLE axo DROP COLUMN `section_value` (mysql): ALTER TABLE axo DROP COLUMN `value` (mysql): ALTER TABLE axo DROP COLUMN `order_value` (mysql): ALTER TABLE axo DROP COLUMN `name` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE axo DROP COLUMN `name`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE axo DROP COLUMN `name`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE axo ADD id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE axo ADD section_value VARCHAR(240) NOT NULL DEFAULT '0' (mysql): ALTER TABLE axo ADD value VARCHAR(240) NOT NULL (mysql): ALTER TABLE axo ADD order_value INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE axo ADD name VARCHAR(255) NOT NULL 1060: Duplicate column name 'name'
adodb_mysql._execute(ALTER TABLE axo ADD name VARCHAR(255) NOT NULL, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE axo ADD name VARCHAR(255) NOT NULL) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE axo ADD hidden INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE axo ADD UNIQUE INDEX section_value_value_axo (section_value, value) (mysql): ALTER TABLE axo ADD INDEX hidden_axo (hidden) (mysql): ALTER TABLE axo_map DROP COLUMN `value` (mysql): ALTER TABLE axo_map DROP COLUMN `acl_id` (mysql): ALTER TABLE axo_map DROP COLUMN `section_value` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE axo_map DROP COLUMN `section_value`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE axo_map DROP COLUMN `section_value`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE axo_map ADD acl_id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE axo_map ADD section_value VARCHAR(230) NOT NULL DEFAULT '0' 1060: Duplicate column name 'section_value'
adodb_mysql._execute(ALTER TABLE axo_map ADD section_value VARCHAR(230) NOT NULL DEFA..., false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE axo_map ADD section_value VARCHAR(230) NOT NULL DEFA...) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE axo_map ADD value VARCHAR(230) NOT NULL (mysql): DROP INDEX value_axo_sections ON axo_sections (mysql): DROP INDEX hidden_axo_sections ON axo_sections (mysql): ALTER TABLE axo_sections DROP COLUMN `hidden` (mysql): ALTER TABLE axo_sections DROP COLUMN `id` (mysql): ALTER TABLE axo_sections DROP COLUMN `value` (mysql): ALTER TABLE axo_sections DROP COLUMN `order_value` (mysql): ALTER TABLE axo_sections DROP COLUMN `name` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE axo_sections DROP COLUMN `name`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE axo_sections DROP COLUMN `name`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE axo_sections ADD id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE axo_sections ADD value VARCHAR(230) NOT NULL (mysql): ALTER TABLE axo_sections ADD order_value INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE axo_sections ADD name VARCHAR(230) NOT NULL 1060: Duplicate column name 'name'
adodb_mysql._execute(ALTER TABLE axo_sections ADD name VARCHAR(230) NOT NULL, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE axo_sections ADD name VARCHAR(230) NOT NULL) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE axo_sections ADD 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 DROP COLUMN `value` (mysql): ALTER TABLE aro_groups DROP COLUMN `id` (mysql): ALTER TABLE aro_groups DROP COLUMN `parent_id` (mysql): ALTER TABLE aro_groups DROP COLUMN `lft` (mysql): ALTER TABLE aro_groups DROP COLUMN `rgt` (mysql): ALTER TABLE aro_groups DROP COLUMN `name` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE aro_groups DROP COLUMN `name`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE aro_groups DROP COLUMN `name`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE aro_groups ADD id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aro_groups ADD parent_id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aro_groups ADD lft INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aro_groups ADD rgt INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aro_groups ADD name VARCHAR(255) NOT NULL 1060: Duplicate column name 'name'
adodb_mysql._execute(ALTER TABLE aro_groups ADD name VARCHAR(255) NOT NULL, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE aro_groups ADD name VARCHAR(255) NOT NULL) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE aro_groups ADD value VARCHAR(255) NOT NULL (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 DROP COLUMN `aro_id` (mysql): ALTER TABLE groups_aro_map DROP COLUMN `group_id` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE groups_aro_map DROP COLUMN `group_id`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE groups_aro_map DROP COLUMN `group_id`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE groups_aro_map ADD group_id INTEGER NOT NULL DEFAULT 0 1060: Duplicate column name 'group_id'
adodb_mysql._execute(ALTER TABLE groups_aro_map ADD group_id INTEGER NOT NULL DEFAULT..., false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE groups_aro_map ADD group_id INTEGER NOT NULL DEFAULT...) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE groups_aro_map ADD 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 DROP COLUMN `group_id` (mysql): ALTER TABLE aro_groups_map DROP COLUMN `acl_id` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE aro_groups_map DROP COLUMN `acl_id`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE aro_groups_map DROP COLUMN `acl_id`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE aro_groups_map ADD acl_id INTEGER NOT NULL DEFAULT 0 1060: Duplicate column name 'acl_id'
adodb_mysql._execute(ALTER TABLE aro_groups_map ADD acl_id INTEGER NOT NULL DEFAULT 0, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE aro_groups_map ADD acl_id INTEGER NOT NULL DEFAULT 0) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE aro_groups_map ADD 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 DROP COLUMN `value` (mysql): ALTER TABLE axo_groups DROP COLUMN `id` (mysql): ALTER TABLE axo_groups DROP COLUMN `parent_id` (mysql): ALTER TABLE axo_groups DROP COLUMN `lft` (mysql): ALTER TABLE axo_groups DROP COLUMN `rgt` (mysql): ALTER TABLE axo_groups DROP COLUMN `name` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE axo_groups DROP COLUMN `name`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE axo_groups DROP COLUMN `name`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE axo_groups ADD id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE axo_groups ADD parent_id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE axo_groups ADD lft INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE axo_groups ADD rgt INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE axo_groups ADD name VARCHAR(255) NOT NULL 1060: Duplicate column name 'name'
adodb_mysql._execute(ALTER TABLE axo_groups ADD name VARCHAR(255) NOT NULL, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE axo_groups ADD name VARCHAR(255) NOT NULL) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE axo_groups ADD value VARCHAR(255) NOT NULL (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 DROP COLUMN `axo_id` (mysql): ALTER TABLE groups_axo_map DROP COLUMN `group_id` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE groups_axo_map DROP COLUMN `group_id`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE groups_axo_map DROP COLUMN `group_id`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE groups_axo_map ADD group_id INTEGER NOT NULL DEFAULT 0 1060: Duplicate column name 'group_id'
adodb_mysql._execute(ALTER TABLE groups_axo_map ADD group_id INTEGER NOT NULL DEFAULT..., false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE groups_axo_map ADD group_id INTEGER NOT NULL DEFAULT...) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE groups_axo_map ADD 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 DROP COLUMN `acl_id` (mysql): ALTER TABLE axo_groups_map DROP COLUMN `group_id` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE axo_groups_map DROP COLUMN `group_id`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE axo_groups_map DROP COLUMN `group_id`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE axo_groups_map ADD acl_id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE axo_groups_map ADD group_id INTEGER NOT NULL DEFAULT 0 1060: Duplicate column name 'group_id'
adodb_mysql._execute(ALTER TABLE axo_groups_map ADD group_id INTEGER NOT NULL DEFAULT..., false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE axo_groups_map ADD group_id INTEGER NOT NULL DEFAULT...) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php 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.
***********************************************************************
This message is intended only for the use of the intended recipient and
may contain information that is PRIVILEGED and/or CONFIDENTIAL. If you
are not the intended recipient, you are hereby notified that any use,
dissemination, disclosure or copying of this communication is strictly
prohibited. If you have received this communication in error, please
destroy all copies of this message and its attachments and notify us
immediately.
***********************************************************************
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: 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
phpGACL Database Setup
Configuration:
driver = mysql,
host =
10.32.1.206,
user = root,
database = ossim,
table
prefix =
Testing database connection...
Success! Connected to "mysql" database on "10.32.1.206".Testing database type...
Success! Compatible database type "mysql" detected!Making sure database "ossim" exists...
(mysql): show databases Success! Good, database "ossim" 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 (mysql): SHOW COLUMNS FROM aco_map (mysql): SHOW COLUMNS FROM aco_map (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 (mysql): SHOW COLUMNS FROM aro_map (mysql): SHOW COLUMNS FROM aro_map (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 (mysql): SHOW COLUMNS FROM axo_map (mysql): SHOW COLUMNS FROM axo_map (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:
ALTER TABLE phpgacl DROP COLUMN `name`;
ALTER TABLE phpgacl DROP COLUMN `value`;
ALTER TABLE phpgacl ADD name VARCHAR(230) NOT NULL;
ALTER TABLE phpgacl ADD value VARCHAR(230) NOT NULL;
DELETE FROM phpgacl WHERE name='version';
INSERT INTO phpgacl (name,value) VALUES ('version','3.3.4');
DELETE FROM phpgacl WHERE name='schema_version';
INSERT INTO phpgacl (name,value) VALUES ('schema_version','2.1');
ALTER TABLE acl DROP COLUMN `note`;
ALTER TABLE acl ADD id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE acl ADD section_value VARCHAR(230) NOT NULL DEFAULT 'system';
ALTER TABLE acl ADD allow INTEGER NOT NULL DEFAULT 0;
ALTER TABLE acl ADD enabled INTEGER NOT NULL DEFAULT 0;
ALTER TABLE acl ADD return_value LONGTEXT;
ALTER TABLE acl ADD note LONGTEXT;
ALTER TABLE acl ADD 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 hidden_acl_sections ON acl_sections;
ALTER TABLE acl_sections DROP COLUMN `hidden`;
ALTER TABLE acl_sections DROP COLUMN `id`;
ALTER TABLE acl_sections DROP COLUMN `value`;
ALTER TABLE acl_sections DROP COLUMN `order_value`;
ALTER TABLE acl_sections DROP COLUMN `name`;
ALTER TABLE acl_sections ADD id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE acl_sections ADD value VARCHAR(230) NOT NULL;
ALTER TABLE acl_sections ADD order_value INTEGER NOT NULL DEFAULT 0;
ALTER TABLE acl_sections ADD name VARCHAR(230) NOT NULL;
ALTER TABLE acl_sections ADD 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 section_value_value_aco ON aco;
DROP INDEX hidden_aco ON aco;
ALTER TABLE aco DROP COLUMN `hidden`;
ALTER TABLE aco DROP COLUMN `id`;
ALTER TABLE aco DROP COLUMN `section_value`;
ALTER TABLE aco DROP COLUMN `value`;
ALTER TABLE aco DROP COLUMN `order_value`;
ALTER TABLE aco DROP COLUMN `name`;
ALTER TABLE aco ADD id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aco ADD section_value VARCHAR(240) NOT NULL DEFAULT '0';
ALTER TABLE aco ADD value VARCHAR(240) NOT NULL;
ALTER TABLE aco ADD order_value INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aco ADD name VARCHAR(255) NOT NULL;
ALTER TABLE aco ADD 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);
ALTER TABLE aco_map DROP COLUMN `value`;
ALTER TABLE aco_map DROP COLUMN `acl_id`;
ALTER TABLE aco_map DROP COLUMN `section_value`;
ALTER TABLE aco_map ADD acl_id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aco_map ADD section_value VARCHAR(230) NOT NULL DEFAULT '0';
ALTER TABLE aco_map ADD value VARCHAR(230) NOT NULL;
DROP INDEX value_aco_sections ON aco_sections;
DROP INDEX hidden_aco_sections ON aco_sections;
ALTER TABLE aco_sections DROP COLUMN `hidden`;
ALTER TABLE aco_sections DROP COLUMN `id`;
ALTER TABLE aco_sections DROP COLUMN `value`;
ALTER TABLE aco_sections DROP COLUMN `order_value`;
ALTER TABLE aco_sections DROP COLUMN `name`;
ALTER TABLE aco_sections ADD id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aco_sections ADD value VARCHAR(230) NOT NULL;
ALTER TABLE aco_sections ADD order_value INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aco_sections ADD name VARCHAR(230) NOT NULL;
ALTER TABLE aco_sections ADD 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 section_value_value_aro ON aro;
DROP INDEX hidden_aro ON aro;
ALTER TABLE aro DROP COLUMN `hidden`;
ALTER TABLE aro DROP COLUMN `id`;
ALTER TABLE aro DROP COLUMN `section_value`;
ALTER TABLE aro DROP COLUMN `value`;
ALTER TABLE aro DROP COLUMN `order_value`;
ALTER TABLE aro DROP COLUMN `name`;
ALTER TABLE aro ADD id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aro ADD section_value VARCHAR(240) NOT NULL DEFAULT '0';
ALTER TABLE aro ADD value VARCHAR(240) NOT NULL;
ALTER TABLE aro ADD order_value INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aro ADD name VARCHAR(255) NOT NULL;
ALTER TABLE aro ADD 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);
ALTER TABLE aro_map DROP COLUMN `value`;
ALTER TABLE aro_map DROP COLUMN `acl_id`;
ALTER TABLE aro_map DROP COLUMN `section_value`;
ALTER TABLE aro_map ADD acl_id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aro_map ADD section_value VARCHAR(230) NOT NULL DEFAULT '0';
ALTER TABLE aro_map ADD value VARCHAR(230) NOT NULL;
DROP INDEX value_aro_sections ON aro_sections;
DROP INDEX hidden_aro_sections ON aro_sections;
ALTER TABLE aro_sections DROP COLUMN `hidden`;
ALTER TABLE aro_sections DROP COLUMN `id`;
ALTER TABLE aro_sections DROP COLUMN `value`;
ALTER TABLE aro_sections DROP COLUMN `order_value`;
ALTER TABLE aro_sections DROP COLUMN `name`;
ALTER TABLE aro_sections ADD id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aro_sections ADD value VARCHAR(230) NOT NULL;
ALTER TABLE aro_sections ADD order_value INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aro_sections ADD name VARCHAR(230) NOT NULL;
ALTER TABLE aro_sections ADD 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 section_value_value_axo ON axo;
DROP INDEX hidden_axo ON axo;
ALTER TABLE axo DROP COLUMN `hidden`;
ALTER TABLE axo DROP COLUMN `id`;
ALTER TABLE axo DROP COLUMN `section_value`;
ALTER TABLE axo DROP COLUMN `value`;
ALTER TABLE axo DROP COLUMN `order_value`;
ALTER TABLE axo DROP COLUMN `name`;
ALTER TABLE axo ADD id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE axo ADD section_value VARCHAR(240) NOT NULL DEFAULT '0';
ALTER TABLE axo ADD value VARCHAR(240) NOT NULL;
ALTER TABLE axo ADD order_value INTEGER NOT NULL DEFAULT 0;
ALTER TABLE axo ADD name VARCHAR(255) NOT NULL;
ALTER TABLE axo ADD 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);
ALTER TABLE axo_map DROP COLUMN `value`;
ALTER TABLE axo_map DROP COLUMN `acl_id`;
ALTER TABLE axo_map DROP COLUMN `section_value`;
ALTER TABLE axo_map ADD acl_id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE axo_map ADD section_value VARCHAR(230) NOT NULL DEFAULT '0';
ALTER TABLE axo_map ADD value VARCHAR(230) NOT NULL;
DROP INDEX value_axo_sections ON axo_sections;
DROP INDEX hidden_axo_sections ON axo_sections;
ALTER TABLE axo_sections DROP COLUMN `hidden`;
ALTER TABLE axo_sections DROP COLUMN `id`;
ALTER TABLE axo_sections DROP COLUMN `value`;
ALTER TABLE axo_sections DROP COLUMN `order_value`;
ALTER TABLE axo_sections DROP COLUMN `name`;
ALTER TABLE axo_sections ADD id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE axo_sections ADD value VARCHAR(230) NOT NULL;
ALTER TABLE axo_sections ADD order_value INTEGER NOT NULL DEFAULT 0;
ALTER TABLE axo_sections ADD name VARCHAR(230) NOT NULL;
ALTER TABLE axo_sections ADD 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 DROP COLUMN `value`;
ALTER TABLE aro_groups DROP COLUMN `id`;
ALTER TABLE aro_groups DROP COLUMN `parent_id`;
ALTER TABLE aro_groups DROP COLUMN `lft`;
ALTER TABLE aro_groups DROP COLUMN `rgt`;
ALTER TABLE aro_groups DROP COLUMN `name`;
ALTER TABLE aro_groups ADD id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aro_groups ADD parent_id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aro_groups ADD lft INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aro_groups ADD rgt INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aro_groups ADD name VARCHAR(255) NOT NULL;
ALTER TABLE aro_groups ADD value VARCHAR(255) NOT NULL;
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 DROP COLUMN `aro_id`;
ALTER TABLE groups_aro_map DROP COLUMN `group_id`;
ALTER TABLE groups_aro_map ADD group_id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE groups_aro_map ADD aro_id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE groups_aro_map ADD INDEX aro_id (aro_id);
ALTER TABLE aro_groups_map DROP COLUMN `group_id`;
ALTER TABLE aro_groups_map DROP COLUMN `acl_id`;
ALTER TABLE aro_groups_map ADD acl_id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE aro_groups_map ADD 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 DROP COLUMN `value`;
ALTER TABLE axo_groups DROP COLUMN `id`;
ALTER TABLE axo_groups DROP COLUMN `parent_id`;
ALTER TABLE axo_groups DROP COLUMN `lft`;
ALTER TABLE axo_groups DROP COLUMN `rgt`;
ALTER TABLE axo_groups DROP COLUMN `name`;
ALTER TABLE axo_groups ADD id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE axo_groups ADD parent_id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE axo_groups ADD lft INTEGER NOT NULL DEFAULT 0;
ALTER TABLE axo_groups ADD rgt INTEGER NOT NULL DEFAULT 0;
ALTER TABLE axo_groups ADD name VARCHAR(255) NOT NULL;
ALTER TABLE axo_groups ADD value VARCHAR(255) NOT NULL;
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 DROP COLUMN `axo_id`;
ALTER TABLE groups_axo_map DROP COLUMN `group_id`;
ALTER TABLE groups_axo_map ADD group_id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE groups_axo_map ADD axo_id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE groups_axo_map ADD INDEX axo_id (axo_id);
ALTER TABLE axo_groups_map DROP COLUMN `acl_id`;
ALTER TABLE axo_groups_map DROP COLUMN `group_id`;
ALTER TABLE axo_groups_map ADD acl_id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE axo_groups_map ADD group_id INTEGER NOT NULL DEFAULT 0; (mysql): ALTER TABLE phpgacl DROP COLUMN `name` (mysql): ALTER TABLE phpgacl DROP COLUMN `value` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE phpgacl DROP COLUMN `value`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE phpgacl DROP COLUMN `value`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE phpgacl ADD name VARCHAR(230) NOT NULL (mysql): ALTER TABLE phpgacl ADD value VARCHAR(230) NOT NULL 1060: Duplicate column name 'value'
adodb_mysql._execute(ALTER TABLE phpgacl ADD value VARCHAR(230) NOT NULL, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE phpgacl ADD value VARCHAR(230) NOT NULL) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): DELETE FROM phpgacl WHERE name='version' (mysql): INSERT INTO phpgacl (name, value) VALUES ('version', '3.3.4') (mysql): DELETE FROM phpgacl WHERE name='schema_version' (mysql): INSERT INTO phpgacl (name, value) VALUES ('schema_version', '2.1') (mysql): ALTER TABLE acl DROP COLUMN `note` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE acl DROP COLUMN `note`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE acl DROP COLUMN `note`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE acl ADD id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE acl ADD section_value VARCHAR(230) NOT NULL DEFAULT 'system' (mysql): ALTER TABLE acl ADD allow INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE acl ADD enabled INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE acl ADD return_value LONGTEXT (mysql): ALTER TABLE acl ADD note LONGTEXT 1060: Duplicate column name 'note'
adodb_mysql._execute(ALTER TABLE acl ADD note LONGTEXT, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE acl ADD note LONGTEXT) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE acl ADD 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 hidden_acl_sections ON acl_sections (mysql): ALTER TABLE acl_sections DROP COLUMN `hidden` (mysql): ALTER TABLE acl_sections DROP COLUMN `id` (mysql): ALTER TABLE acl_sections DROP COLUMN `value` (mysql): ALTER TABLE acl_sections DROP COLUMN `order_value` (mysql): ALTER TABLE acl_sections DROP COLUMN `name` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE acl_sections DROP COLUMN `name`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE acl_sections DROP COLUMN `name`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE acl_sections ADD id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE acl_sections ADD value VARCHAR(230) NOT NULL (mysql): ALTER TABLE acl_sections ADD order_value INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE acl_sections ADD name VARCHAR(230) NOT NULL 1060: Duplicate column name 'name'
adodb_mysql._execute(ALTER TABLE acl_sections ADD name VARCHAR(230) NOT NULL, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE acl_sections ADD name VARCHAR(230) NOT NULL) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE acl_sections ADD hidden INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE acl_sections ADD UNIQUE INDEX value_acl_sections (value) 1062: Duplicate entry '' for key 1
adodb_mysql._execute(ALTER TABLE acl_sections ADD UNIQUE INDEX value_acl_sections (..., false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE acl_sections ADD UNIQUE INDEX value_acl_sections (...) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (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 section_value_value_aco ON aco (mysql): DROP INDEX hidden_aco ON aco (mysql): ALTER TABLE aco DROP COLUMN `hidden` (mysql): ALTER TABLE aco DROP COLUMN `id` (mysql): ALTER TABLE aco DROP COLUMN `section_value` (mysql): ALTER TABLE aco DROP COLUMN `value` (mysql): ALTER TABLE aco DROP COLUMN `order_value` (mysql): ALTER TABLE aco DROP COLUMN `name` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE aco DROP COLUMN `name`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE aco DROP COLUMN `name`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE aco ADD id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aco ADD section_value VARCHAR(240) NOT NULL DEFAULT '0' (mysql): ALTER TABLE aco ADD value VARCHAR(240) NOT NULL (mysql): ALTER TABLE aco ADD order_value INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aco ADD name VARCHAR(255) NOT NULL 1060: Duplicate column name 'name'
adodb_mysql._execute(ALTER TABLE aco ADD name VARCHAR(255) NOT NULL, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE aco ADD name VARCHAR(255) NOT NULL) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE aco ADD hidden INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aco ADD UNIQUE INDEX section_value_value_aco (section_value, value) (mysql): ALTER TABLE aco ADD INDEX hidden_aco (hidden) (mysql): ALTER TABLE aco_map DROP COLUMN `value` (mysql): ALTER TABLE aco_map DROP COLUMN `acl_id` (mysql): ALTER TABLE aco_map DROP COLUMN `section_value` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE aco_map DROP COLUMN `section_value`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE aco_map DROP COLUMN `section_value`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE aco_map ADD acl_id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aco_map ADD section_value VARCHAR(230) NOT NULL DEFAULT '0' 1060: Duplicate column name 'section_value'
adodb_mysql._execute(ALTER TABLE aco_map ADD section_value VARCHAR(230) NOT NULL DEFA..., false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE aco_map ADD section_value VARCHAR(230) NOT NULL DEFA...) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE aco_map ADD value VARCHAR(230) NOT NULL (mysql): DROP INDEX value_aco_sections ON aco_sections (mysql): DROP INDEX hidden_aco_sections ON aco_sections (mysql): ALTER TABLE aco_sections DROP COLUMN `hidden` (mysql): ALTER TABLE aco_sections DROP COLUMN `id` (mysql): ALTER TABLE aco_sections DROP COLUMN `value` (mysql): ALTER TABLE aco_sections DROP COLUMN `order_value` (mysql): ALTER TABLE aco_sections DROP COLUMN `name` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE aco_sections DROP COLUMN `name`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE aco_sections DROP COLUMN `name`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE aco_sections ADD id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aco_sections ADD value VARCHAR(230) NOT NULL (mysql): ALTER TABLE aco_sections ADD order_value INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aco_sections ADD name VARCHAR(230) NOT NULL 1060: Duplicate column name 'name'
adodb_mysql._execute(ALTER TABLE aco_sections ADD name VARCHAR(230) NOT NULL, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE aco_sections ADD name VARCHAR(230) NOT NULL) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE aco_sections ADD 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 section_value_value_aro ON aro (mysql): DROP INDEX hidden_aro ON aro (mysql): ALTER TABLE aro DROP COLUMN `hidden` (mysql): ALTER TABLE aro DROP COLUMN `id` (mysql): ALTER TABLE aro DROP COLUMN `section_value` (mysql): ALTER TABLE aro DROP COLUMN `value` (mysql): ALTER TABLE aro DROP COLUMN `order_value` (mysql): ALTER TABLE aro DROP COLUMN `name` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE aro DROP COLUMN `name`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE aro DROP COLUMN `name`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE aro ADD id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aro ADD section_value VARCHAR(240) NOT NULL DEFAULT '0' (mysql): ALTER TABLE aro ADD value VARCHAR(240) NOT NULL (mysql): ALTER TABLE aro ADD order_value INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aro ADD name VARCHAR(255) NOT NULL 1060: Duplicate column name 'name'
adodb_mysql._execute(ALTER TABLE aro ADD name VARCHAR(255) NOT NULL, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE aro ADD name VARCHAR(255) NOT NULL) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE aro ADD hidden INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aro ADD UNIQUE INDEX section_value_value_aro (section_value, value) (mysql): ALTER TABLE aro ADD INDEX hidden_aro (hidden) (mysql): ALTER TABLE aro_map DROP COLUMN `value` (mysql): ALTER TABLE aro_map DROP COLUMN `acl_id` (mysql): ALTER TABLE aro_map DROP COLUMN `section_value` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE aro_map DROP COLUMN `section_value`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE aro_map DROP COLUMN `section_value`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE aro_map ADD acl_id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aro_map ADD section_value VARCHAR(230) NOT NULL DEFAULT '0' 1060: Duplicate column name 'section_value'
adodb_mysql._execute(ALTER TABLE aro_map ADD section_value VARCHAR(230) NOT NULL DEFA..., false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE aro_map ADD section_value VARCHAR(230) NOT NULL DEFA...) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE aro_map ADD value VARCHAR(230) NOT NULL (mysql): DROP INDEX value_aro_sections ON aro_sections (mysql): DROP INDEX hidden_aro_sections ON aro_sections (mysql): ALTER TABLE aro_sections DROP COLUMN `hidden` (mysql): ALTER TABLE aro_sections DROP COLUMN `id` (mysql): ALTER TABLE aro_sections DROP COLUMN `value` (mysql): ALTER TABLE aro_sections DROP COLUMN `order_value` (mysql): ALTER TABLE aro_sections DROP COLUMN `name` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE aro_sections DROP COLUMN `name`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE aro_sections DROP COLUMN `name`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE aro_sections ADD id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aro_sections ADD value VARCHAR(230) NOT NULL (mysql): ALTER TABLE aro_sections ADD order_value INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aro_sections ADD name VARCHAR(230) NOT NULL 1060: Duplicate column name 'name'
adodb_mysql._execute(ALTER TABLE aro_sections ADD name VARCHAR(230) NOT NULL, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE aro_sections ADD name VARCHAR(230) NOT NULL) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE aro_sections ADD 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 section_value_value_axo ON axo (mysql): DROP INDEX hidden_axo ON axo (mysql): ALTER TABLE axo DROP COLUMN `hidden` (mysql): ALTER TABLE axo DROP COLUMN `id` (mysql): ALTER TABLE axo DROP COLUMN `section_value` (mysql): ALTER TABLE axo DROP COLUMN `value` (mysql): ALTER TABLE axo DROP COLUMN `order_value` (mysql): ALTER TABLE axo DROP COLUMN `name` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE axo DROP COLUMN `name`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE axo DROP COLUMN `name`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE axo ADD id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE axo ADD section_value VARCHAR(240) NOT NULL DEFAULT '0' (mysql): ALTER TABLE axo ADD value VARCHAR(240) NOT NULL (mysql): ALTER TABLE axo ADD order_value INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE axo ADD name VARCHAR(255) NOT NULL 1060: Duplicate column name 'name'
adodb_mysql._execute(ALTER TABLE axo ADD name VARCHAR(255) NOT NULL, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE axo ADD name VARCHAR(255) NOT NULL) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE axo ADD hidden INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE axo ADD UNIQUE INDEX section_value_value_axo (section_value, value) (mysql): ALTER TABLE axo ADD INDEX hidden_axo (hidden) (mysql): ALTER TABLE axo_map DROP COLUMN `value` (mysql): ALTER TABLE axo_map DROP COLUMN `acl_id` (mysql): ALTER TABLE axo_map DROP COLUMN `section_value` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE axo_map DROP COLUMN `section_value`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE axo_map DROP COLUMN `section_value`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE axo_map ADD acl_id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE axo_map ADD section_value VARCHAR(230) NOT NULL DEFAULT '0' 1060: Duplicate column name 'section_value'
adodb_mysql._execute(ALTER TABLE axo_map ADD section_value VARCHAR(230) NOT NULL DEFA..., false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE axo_map ADD section_value VARCHAR(230) NOT NULL DEFA...) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE axo_map ADD value VARCHAR(230) NOT NULL (mysql): DROP INDEX value_axo_sections ON axo_sections (mysql): DROP INDEX hidden_axo_sections ON axo_sections (mysql): ALTER TABLE axo_sections DROP COLUMN `hidden` (mysql): ALTER TABLE axo_sections DROP COLUMN `id` (mysql): ALTER TABLE axo_sections DROP COLUMN `value` (mysql): ALTER TABLE axo_sections DROP COLUMN `order_value` (mysql): ALTER TABLE axo_sections DROP COLUMN `name` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE axo_sections DROP COLUMN `name`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE axo_sections DROP COLUMN `name`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE axo_sections ADD id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE axo_sections ADD value VARCHAR(230) NOT NULL (mysql): ALTER TABLE axo_sections ADD order_value INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE axo_sections ADD name VARCHAR(230) NOT NULL 1060: Duplicate column name 'name'
adodb_mysql._execute(ALTER TABLE axo_sections ADD name VARCHAR(230) NOT NULL, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE axo_sections ADD name VARCHAR(230) NOT NULL) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE axo_sections ADD 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 DROP COLUMN `value` (mysql): ALTER TABLE aro_groups DROP COLUMN `id` (mysql): ALTER TABLE aro_groups DROP COLUMN `parent_id` (mysql): ALTER TABLE aro_groups DROP COLUMN `lft` (mysql): ALTER TABLE aro_groups DROP COLUMN `rgt` (mysql): ALTER TABLE aro_groups DROP COLUMN `name` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE aro_groups DROP COLUMN `name`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE aro_groups DROP COLUMN `name`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE aro_groups ADD id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aro_groups ADD parent_id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aro_groups ADD lft INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aro_groups ADD rgt INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE aro_groups ADD name VARCHAR(255) NOT NULL 1060: Duplicate column name 'name'
adodb_mysql._execute(ALTER TABLE aro_groups ADD name VARCHAR(255) NOT NULL, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE aro_groups ADD name VARCHAR(255) NOT NULL) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE aro_groups ADD value VARCHAR(255) NOT NULL (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 DROP COLUMN `aro_id` (mysql): ALTER TABLE groups_aro_map DROP COLUMN `group_id` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE groups_aro_map DROP COLUMN `group_id`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE groups_aro_map DROP COLUMN `group_id`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE groups_aro_map ADD group_id INTEGER NOT NULL DEFAULT 0 1060: Duplicate column name 'group_id'
adodb_mysql._execute(ALTER TABLE groups_aro_map ADD group_id INTEGER NOT NULL DEFAULT..., false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE groups_aro_map ADD group_id INTEGER NOT NULL DEFAULT...) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE groups_aro_map ADD 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 DROP COLUMN `group_id` (mysql): ALTER TABLE aro_groups_map DROP COLUMN `acl_id` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE aro_groups_map DROP COLUMN `acl_id`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE aro_groups_map DROP COLUMN `acl_id`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE aro_groups_map ADD acl_id INTEGER NOT NULL DEFAULT 0 1060: Duplicate column name 'acl_id'
adodb_mysql._execute(ALTER TABLE aro_groups_map ADD acl_id INTEGER NOT NULL DEFAULT 0, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE aro_groups_map ADD acl_id INTEGER NOT NULL DEFAULT 0) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE aro_groups_map ADD 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 DROP COLUMN `value` (mysql): ALTER TABLE axo_groups DROP COLUMN `id` (mysql): ALTER TABLE axo_groups DROP COLUMN `parent_id` (mysql): ALTER TABLE axo_groups DROP COLUMN `lft` (mysql): ALTER TABLE axo_groups DROP COLUMN `rgt` (mysql): ALTER TABLE axo_groups DROP COLUMN `name` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE axo_groups DROP COLUMN `name`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE axo_groups DROP COLUMN `name`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE axo_groups ADD id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE axo_groups ADD parent_id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE axo_groups ADD lft INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE axo_groups ADD rgt INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE axo_groups ADD name VARCHAR(255) NOT NULL 1060: Duplicate column name 'name'
adodb_mysql._execute(ALTER TABLE axo_groups ADD name VARCHAR(255) NOT NULL, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE axo_groups ADD name VARCHAR(255) NOT NULL) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE axo_groups ADD value VARCHAR(255) NOT NULL (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 DROP COLUMN `axo_id` (mysql): ALTER TABLE groups_axo_map DROP COLUMN `group_id` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE groups_axo_map DROP COLUMN `group_id`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE groups_axo_map DROP COLUMN `group_id`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE groups_axo_map ADD group_id INTEGER NOT NULL DEFAULT 0 1060: Duplicate column name 'group_id'
adodb_mysql._execute(ALTER TABLE groups_axo_map ADD group_id INTEGER NOT NULL DEFAULT..., false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE groups_axo_map ADD group_id INTEGER NOT NULL DEFAULT...) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE groups_axo_map ADD 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 DROP COLUMN `acl_id` (mysql): ALTER TABLE axo_groups_map DROP COLUMN `group_id` 1090: You can't delete all columns with ALTER TABLE. Use DROP TABLE instead
adodb_mysql._execute(ALTER TABLE axo_groups_map DROP COLUMN `group_id`, false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE axo_groups_map DROP COLUMN `group_id`) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php (mysql): ALTER TABLE axo_groups_map ADD acl_id INTEGER NOT NULL DEFAULT 0 (mysql): ALTER TABLE axo_groups_map ADD group_id INTEGER NOT NULL DEFAULT 0 1060: Duplicate column name 'group_id'
adodb_mysql._execute(ALTER TABLE axo_groups_map ADD group_id INTEGER NOT NULL DEFAULT..., false) % line 833, file: adodb.inc.php adodb_mysql.execute(ALTER TABLE axo_groups_map ADD group_id INTEGER NOT NULL DEFAULT...) % line 265, file: adodb-datadict.inc.php adodb2_mysql.executesqlarray(Array[200], true) % line 1558, file: adodb-xmlschema.inc.php adoschema.executeschema() % line 158, file: setup.php 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.
RSS Feed