Share

JsForum

The forum address has changed, you have been automatically redirected. Please update any bookmarks to use the new URL.

Subscribe

Problem in registration

You are viewing a single message from this topic. View all messages.

  1. 2003-11-10 10:38:44 UTC
    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
< Previous | 1 | Next >

Add a Reply

This forum does not allow anonymous participation.

Log in to add a reply. Not registered? Create an account to participate and receive email updates when replies are posted to this topic.