EQEmulator Forums - Minilogin

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Development::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=596)

- - Minilogin_ip Default Error (https://www.eqemulator.org/forums/showthread.php?t=28518)

Minilogin_ip Default Error

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

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

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?