Login Error

[tsur]

Hi all!

I compiled OTServ and all right but when I run it and try to login with default sampleworlds.sql accounts (1,1) using the client (I have tested it with 8.70 client) I got a -1 Error(from Client). It actually displays the players name, but when I go with some of them, it does not connect. The Otserv outputs the next which is an error coming from the database schema used(I'm using Mysql):

... :: Starting Server OTServ... [done] :: OpenTibia Server Running...

mysql_real_query(): SELECT COUNT(*) AS count FROM bans WHERE type = 1 AND ((16777343 & 4294967295 & param) = (value & param & 4294967295)) AND active = 1 AND (expires >= 1386596187 OR expires <= 0): MYSQL ERROR: Unknown column 'type' in 'where clause'

mysql_store_result(): SELECT COUNT(*) AS count FROM bans WHERE type = 1 AND ((16777343 & 4294967295 & param) = (value & param & 4294967295)) AND active = 1 AND (expires >= 1386596187 OR expires <= 0): MYSQL ERROR: Unknown column 'type' in 'where clause'

I do not think the login problem is actually due to the errors display on the output above. I did also try to add the column type, param and value to the 'bans' table but login error still persists.

Thanks!

[tsur]

Just in case, I running the server on localhost(127.0.1.1) and port 7171

[tsur]

Thank you, it's now fixed!, The error was solve by changing the config.lua server_ip from global ip(auto) to my private one.

[iryont]

It seems like the database in scheme is outdated - I will have a look into that.

[iryont]

The ban code should be up to date with the database now.

[Pietia10]

ITs fixed so closing.