#2 error

[Anonymous]

mysql 3.22.8
php 4.0 RC1
apache 1.3.12
redhat 6.1

slong@farrington.com

Creating Tables ...
processing tables/link_defs.mysql ...
processing tables/database_defs.mysql ...
processing tables/field_defs.mysql ...
processing tables/table_defs.mysql ...
processing tables/logins.mysql ...
processing tables/table_database_defs.mysql ...
processing tables/action_defs.mysql ...
sql_query: You have an error in your SQL syntax near 'when enum('before', 'after') NOT NULL, table_defs_id bigint(21) NOT NULL, ' at line 11
query: 'CREATE TABLE action_defs ( action_defs_id bigint(21) NOT NULL auto_increment, display_name varchar(128) NOT NULL, function varchar(128) NOT NULL, file
varchar(128) NOT NULL, trigger enum('add', 'modify', 'delete', 'list', 'detail') NOT NULL, when enum('before', 'after') NOT NULL, table_defs_id bigint(21) NOT NULL, primary key
(action_defs_id), index (table_defs_id), index (display_name), index (trigger), index (when) ) '
sql_select_db: You have an error in your SQL syntax near 'when enum('before', 'after') NOT NULL, table_defs_id bigint(21) NOT NULL, ' at line 11 processing
tables/permission_defs.mysql ...
Parsing xml ...
(This may take several minutes. Please be patient)
Add database 'Users'
Add table 'Users'
under database 'Users'
Add table 'Permissions'
under database 'Users'
Add field 'Admin'
under table 'Users'
Add field 'Name'
under table 'Users'
Add field 'Password'
under table 'Users'
Add field 'Guest'
under table 'Users'
Add field 'Permissions'
under table 'Users'
Add field 'User'
under field 'Permissions'
Add action 'Protect Admin'
under table 'Users'
sql_query: You have an error in your SQL syntax near 'when, table_defs_id) values('Protect Admin', 'protect_admin', 'users', 'add', 'b' at line 1
query: 'insert into action_defs (display_name, function, file, trigger, when, table_defs_id) values('Protect Admin', 'protect_admin', 'users', 'add', 'before', 1)'
db_add_action: error creating action defition
sql_query: Table 'mot2.action_defs' doesn't exist
query: 'select action_defs_id from action_defs where table_defs_id = 1'

Warning: Supplied argument is not a valid MySQL result resource in sql.php3 on line 98
sql_query: Table 'mot2.action_defs' doesn't exist
query: 'select action_defs_id from action_defs where table_defs_id = 2'

Warning: Supplied argument is not a valid MySQL result resource in sql.php3 on line 98
Error importing users file