EOSERV Forum > EOSERV > Little Bug Anyone Help Me Again :D
Topic is locked.
Page: << 1 >>
Little Bug Anyone Help Me Again :D
Author Message
Post #1127 Little Bug Anyone Help Me Again :D

Database Error: Field 'regip' doesn't have a default value

when i want to create new account it gave me that error 

what should i do?

15 years, 4 weeks ago
Post #1128 Re: Little Bug Anyone Help Me Again :D

CREATE TABLE IF NOT EXISTS `accounts`
(
    `username`   VARCHAR(16) NOT NULL,
    `password`   CHAR(64)    NOT NULL,
    `fullname`   VARCHAR(64) NOT NULL,
    `location`   VARCHAR(64) NOT NULL,
    `email`      VARCHAR(64) NOT NULL,
    `computer`   VARCHAR(64) NOT NULL,
    `hdid`       CHAR(10)    NOT NULL,
    `regip`      VARCHAR(15) NOT NULL,
    `lastip`     VARCHAR(15)          DEFAULT NULL,
    `created`    INTEGER     NOT NULL,
    `lastused`   INTEGER              DEFAULT NULL,

    PRIMARY KEY (`username`)

Could you tell me why i cant creat Accounts? :[]

15 years, 4 weeks ago
Post #1129 Re: Little Bug Anyone Help Me Again :D

okay i try

15 years, 4 weeks ago
Post #1130 Re: Little Bug Anyone Help Me Again :D

it works?..
can you creat accounts?

15 years, 4 weeks ago
Post #1142 Re: Little Bug Anyone Help Me Again :D
fana posted: (18th Mar 2009 05:52 pm)

CREATE TABLE IF NOT EXISTS `accounts`
(
    `username`   VARCHAR(16) NOT NULL,
    `password`   CHAR(64)    NOT NULL,
    `fullname`   VARCHAR(64) NOT NULL,
    `location`   VARCHAR(64) NOT NULL,
    `email`      VARCHAR(64) NOT NULL,
    `computer`   VARCHAR(64) NOT NULL,
    `hdid`       CHAR(10)    NOT NULL,
    `regip`      VARCHAR(15) NOT NULL,
    `lastip`     VARCHAR(15)          DEFAULT NULL,
    `created`    INTEGER     NOT NULL,
    `lastused`   INTEGER              DEFAULT NULL,

    PRIMARY KEY (`username`)

Could you tell me why i cant creat Accounts? :[]



its supposed to be DEFAULT NULL,
on `regip`      VARCHAR(15) NOT NULL,

so : `regip`      VARCHAR(15) DEFAULT NULL,

15 years, 4 weeks ago
Page: << 1 >>
Topic is locked.
EOSERV Forum > EOSERV > Little Bug Anyone Help Me Again :D