Minilogin_ip Default Error

takatok · #1 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

Code:

REPLACE
`minilogin_ip` varchar(32) NOT NULL,
WITH
`minilogin_ip` varchar(32) NOT NULL DEFAULT 0,

Hope this helps solve the problem

Tony

Jobe123 · #2 08-03-2009, 04:24 PM

most helpful post ever... was having this problem after following the guide and this fixxed it for me... thank you so much!

Jobe123 · #3 08-03-2009, 06:44 PM

Sorry for the double reply couldn't find edit off hand.

Just a quick question, if I go in and manually change the SQL file in something like wordpad and resave it will I have to re run the server setup or will it fix it without having to go through the whole database issue agian?