Serhan
Joined: 15th Feb 2009
Posts: 19
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
|
fana
Joined: 18th Mar 2009
Posts: 15
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
|
Serhan
Joined: 15th Feb 2009
Posts: 19
Re: Little Bug Anyone Help Me Again :D
15 years, 4 weeks ago
|
fana
Joined: 18th Mar 2009
Posts: 15
Re: Little Bug Anyone Help Me Again :D
it works?..
can you creat accounts?
15 years, 4 weeks ago
|
Stephx
Joined: 21st Feb 2009
Posts: 299
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
| | | | | |