Solved error at login!

[Vrotz]

Hello!

I would like to know what happening for this error appear at the momoment that I do login.

Error at console:
https://imgur.com/nqny0Dh


My databate:
https://www.sendspace.com/file/h8rl97

(using sql, yes i would not use mysql because i only want to use this server for fun and hosting in windows u.u)

I hope that anyone could fix it.
Thanks!

 

[Vrotz]

That mean you are imported sql schema without tables for war system, so if you don't need them, try to compile server without that.

Could you make these tables for me? The tfs has war system bro!

If you make the download of the link that I leave my db.. you will see that Ive "guild_invites, guild_kills, guild_ranks, guild_wars and

 

[kor]

If you are using SQLite there is full schema that come in package. You just need to save schema from this link https://github.com/Fir3element/3777/blob/master/schemas/sqlite.sql as sqlite.sql and import them correctly to your database file. Please note, that in this https://github.com/Fir3element/3777/blob/master/schemas/sqlite.sql#L114 line you should add comma after last "0" (zero).

 

[Vrotz]

If you are using SQLite there is full schema that come in package. You just need to save schema from this link https://github.com/Fir3element/3777/blob/master/schemas/sqlite.sql as sqlite.sql and import them correctly to your database file. Please note, that in this https://github.com/Fir3element/3777/blob/master/schemas/sqlite.sql#L114 line you should add comma after last "0" (zero).

Fixed.

I used this

DROP TABLE IF EXISTS killers;
CREATE TABLE killers (
   id          INTEGER PRIMARY KEY,
    death_id    INTEGER NOT NULL,
    final_hit   BOOLEAN NOT NULL
                        DEFAULT 'FALSE',
    unjustified BOOLEAN NOT NULL
                        DEFAULT 'FALSE',
    war         BIGINT  NOT NULL
                        DEFAULT '0',
    FOREIGN KEY ( death_id ) REFERENCES player_deaths ( id )
);