Forum :: EOSERV :: I cant Make a account on my serv please help

I cant make a account on my eoserv I tryed aloth of stuff dint work install.sql is here


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`)
);

CREATE TABLE IF NOT EXISTS `characters`
(
    `name`        VARCHAR(12) NOT NULL,
    `account`     VARCHAR(16)          DEFAULT NULL,
    `title`       VARCHAR(32)          DEFAULT NULL,
    `home`        VARCHAR(32)          DEFAULT NULL,
    `partner`     VARCHAR(16)          DEFAULT NULL,
    `admin`       INTEGER     NOT NULL DEFAULT 0,
    `class`       INTEGER     NOT NULL DEFAULT 0,
    `gender`      INTEGER     NOT NULL DEFAULT 0,
    `race`        INTEGER     NOT NULL DEFAULT 0,
    `hairstyle`   INTEGER     NOT NULL DEFAULT 0,
    `haircolor`   INTEGER     NOT NULL DEFAULT 0,
    `map`         INTEGER     NOT NULL DEFAULT 192,
    `x`           INTEGER     NOT NULL DEFAULT 6,
    `y`           INTEGER     NOT NULL DEFAULT 6,
    `direction`   INTEGER     NOT NULL DEFAULT 2,
    `spawnmap`    INTEGER     NOT NULL DEFAULT 192,
    `spawnx`      INTEGER     NOT NULL DEFAULT 6,
    `spawny`      INTEGER     NOT NULL DEFAULT 6,
    `level`       INTEGER     NOT NULL DEFAULT 0,
    `exp`         INTEGER     NOT NULL DEFAULT 0,
    `hp`          INTEGER     NOT NULL DEFAULT 10,
    `tp`          INTEGER     NOT NULL DEFAULT 10,
    `str`         INTEGER     NOT NULL DEFAULT 0,
    `int`         INTEGER     NOT NULL DEFAULT 0,
    `wis`         INTEGER     NOT NULL DEFAULT 0,
    `agi`         INTEGER     NOT NULL DEFAULT 0,
    `con`         INTEGER     NOT NULL DEFAULT 0,
    `cha`         INTEGER     NOT NULL DEFAULT 0,
    `statpoints`  INTEGER     NOT NULL DEFAULT 6,
    `skillpoints` INTEGER     NOT NULL DEFAULT 6,
    `karma`       INTEGER     NOT NULL DEFAULT 1000,
    `sitting`     INTEGER     NOT NULL DEFAULT 0,
    `bankmax`     INTEGER     NOT NULL DEFAULT 30,
    `goldbank`    INTEGER     NOT NULL DEFAULT 0,
    `usage`       INTEGER     NOT NULL DEFAULT 0,
    `inventory`   TEXT        NOT NULL,
    `bank`        TEXT        NOT NULL,
    `paperdoll`   TEXT        NOT NULL,
    `spells`      TEXT        NOT NULL,
    `guild`       CHAR(3)              DEFAULT NULL,
    `guild_rank`  INTEGER              DEFAULT NULL,
   
    PRIMARY KEY (`name`)
);

CREATE TABLE IF NOT EXISTS `guilds`
(
    `tag`         CHAR(3)     NOT NULL,
    `name`        VARCHAR(32) NOT NULL,
    `description` TEXT        NOT NULL,
    `created`     INTEGER     NOT NULL,
    `ranks`       TEXT        NOT NULL,
    `bank`        INTEGER     NOT NULL DEFAULT 0,

    PRIMARY KEY (`tag`),
    UNIQUE      (`name`)
);

CREATE INDEX `character_account_index` ON `characters` (`account`);
CREATE INDEX `character_guild_index` ON `characters` (`guild`);

i got the same problem .. if you know how to fix pls tell me :()

I see nothing wrong with this, when creating an account do not capitalize any letters in the account name and everything should move smoothly

did it works now?

When i make a account this what it says

And when its almost greated i will go lost connect Please help me....

http://img16.imageshack.us/img16/4793/eoserv.jpg

I have this problem too.
I even reconfiged my mysql

This is what's in my error log.

Could not load file: ./data/maps/00080.emf
Could not load file: ./data/maps/00081.emf
Could not load file: ./data/maps/00185.emf
Could not load file: ./data/maps/00223.emf
Could not load file: ./data/maps/00264.emf
Could not load file: ./data/maps/00271.emf
Could not load file: ./data/maps/00272.emf
Could not load file: ./data/maps/00276.emf