powered by Jive Software

SQL syntax error boolean

Hi All

I’m using mysql 4.0 with openfire3.6.3 and packet filter 2.0.2. I installed the packetfilter plugin and ran the sql file that came with it to create the table. I got an error that there is an sql syntax error near boolean. This is the sql file:

CREATE TABLE ofPfRules (
id BIGINT NOT NULL AUTO_INCREMENT,
ruleorder BIGINT ,
type varchar(255) ,
tojid varchar(255) ,
fromjid varchar(255) ,
rulef varchar(255) ,
disabled boolean,
log boolean,
description varchar(255),
sourcetype varchar(255),
desttype varchar(255),
PRIMARY KEY (id)
);
INSERT INTO ofVersion(name,version) values(‘packetfilter’,2);

When I add a rule, nothing happens.

When I tried changing lines 8 and 9 to:

disabled ENUM(‘true’,‘false’),
log ENUM(‘true’,‘false’),

it ran without error and I could now add rules etc. but I cannot get logging to work.

Any help would be appreciated.

Hi,

what do you thing about using MySQL 5.1?

Extended support for MySQL 4.0 did end last year and will end this year for 4.1.

Active support for 4.x did end in 2006 so I really wonder why you are still using MySQL 4.x.

LG