takatok
06-09-2009, 04:59 AM
NOTE: I'm VERY new to SQL.
When setting up my server I got the following error:
Account Attempting to be created: qwertylicious 0
Error in CreateAccount query'INSERT INTO accountSET name='qwertylicious',status=0,lsaccountid=110177;' #1364: Field 'minilogin_ip' doesn't have a default value
After searching the forums for similiar problems I found 10-15 people with the same problem and everyone assuming they were trying to use minilogin (they weren't) :)
I fixed the problem by doing this in the dbase
mysql>alter table account alter column minilogin_ip set default 0
Anyway, the SVN checkout of PEQ_DB has this problem i think:
In account.sql Line 40
REPLACE
`minilogin_ip` varchar(32) NOT NULL,
WITH
`minilogin_ip` varchar(32) NOT NULL DEFAULT 0,
Hope this helps solve the problem
Tony
When setting up my server I got the following error:
Account Attempting to be created: qwertylicious 0
Error in CreateAccount query'INSERT INTO accountSET name='qwertylicious',status=0,lsaccountid=110177;' #1364: Field 'minilogin_ip' doesn't have a default value
After searching the forums for similiar problems I found 10-15 people with the same problem and everyone assuming they were trying to use minilogin (they weren't) :)
I fixed the problem by doing this in the dbase
mysql>alter table account alter column minilogin_ip set default 0
Anyway, the SVN checkout of PEQ_DB has this problem i think:
In account.sql Line 40
REPLACE
`minilogin_ip` varchar(32) NOT NULL,
WITH
`minilogin_ip` varchar(32) NOT NULL DEFAULT 0,
Hope this helps solve the problem
Tony