Forum :: EOSERV :: Cannot create an account

I know there is a fix or w/e, have no idea how to do it.  Read every post and nothing about it on here.  Had the server running and connected in less than 5 minutes, pretty easy stuff.  I know the basics on compiling but yeah, tried to compile the new source, even tried the tutorial posted on here and had nothing but 50+ errors = failure.  Any help would be appreciated.

just edit your install.sql file as follows:

Find: `regip` VARCHAR(15) NOT NULL,
Replace: `regip` VARCHAR(15) DEFAULT NULL,

Thanks, probably totally passed over a post or announcement of that.  Too much redbull and no sleep is no good for the brain.

hey are you able to log in?

I tryed what he said and it still doesn't work.
Heres what it looks like.


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)          DEFAULT NULL,
    `lastip`     VARCHAR(15)          DEFAULT NULL,
    `created`    INTEGER     NOT NULL,
    `lastused`   INTEGER              DEFAULT NULL,

    PRIMARY KEY (`username`)

Edited the necessary line and still have the same issue, packet gets sent>waits to be created>gets to then end of creation and the server terminates.  

thats a relief, ii thought i was the only one with that problem... since noone has responded to my thread

I would of responded if I could of actually created an account.  Gonna try a few things out and see what happens.

yeah it created an account for me.. accoutn creation should have been fixed by that... now how do you fix login?....

Edit: lol i edited it after i read for post a second time, and also make sure you are using the compiled version of revision 66.... that one lets me create account but not log in....

Yeah, thats my problem, it won't even create the actual account.  Even with the fix.  Not even at the login part of it yet.

read my post again lol..... anyways eoserv 3.1 is compiled on revision 62, revision 66 is newer but still has the error

Yeah, I'm using revision 62.  Tried the compliling tutorial with 66 and that was a no-go.  Be nice if someone would upload a compiled 66 source to mess around with.

lol well ill do it, but do you want just the eoserv.debug.exe file or the whole folder?

Whole folder would be fine, I need to get this compiling stuff down.  Probably missing the obvious with lack of sleep but w/e lol

ill see what i can do, iam helping someone with compiling now