Problem in registration

[Carlo]

Hello,

I'm Carlo and i have started to see your application "JSforum". I have a problem in AddUser statement trapped with log4j:
INSERT INTO forum_users(user_name,password,email,registerdate,type) VALUES("pippus",password("pippus"),"pippus","SYSDATE()","user")

the following error appear:
java.sql.SQLException: Column not found,  message from server: "Unknown column 'type' in 'field list'"

Ineffect the sql script for the table "forum_users" shipped with the distribuition not contain the column "type":
CREATE TABLE forum_users
(id        int(10)        NOT NULL    auto_increment,
user_name    text        NOT NULL,   
password    text        NOT NULL,
email        text        NOT NULL,
registerdate    datetime    NOT NULL,
avatar        text        NOT NULL,
member_title    text        NOT NULL,
signature    text        NOT NULL,
PRIMARY KEY (id)
);

what i must configure the column "type" or create the table "forum_user" ?

Thank for a your reply, Carlo

[loz]

test reply