#1 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

[Robert Schader]

Found that this problem is caused on some systems dur to the action_defs table trying
to use the reserved word "when" as a column label. Change it and all references to it to
something like "mywhen" instead. I can provide diffs for this when I get the time. I
am about to upgrade my MySQL Server, as it dumps core when I try to import the
Job tracking database now. (It is MySQL 3.23.3-alpha)

[Mark Bronnimann]

I just went through the files quickly w/vi doing a quick %s/when/mywhen/g. Had to do these files (sorry, from history)
1052 vi db_action.php3
1054 vi db_display.php3
1055 vi def_db.php3
1056 vi def_vars.php3
1057 vi def_vars_help.php3
as well as fixing up the action_defs.mysql file.

I've got to test it all out though. I just downloaded and installed it, haven't really tested it out yet.

[Nobody/Anonymous]

Logged In: NO

Looks like it time to get a new box