Linux Connections / INVALID ACCOUNT NAME

[sobek07]

Yo, im compiling server to linux. When im started server:

> Houses synchronization time: 1.367 seconds.
> Content unserialization time: 9.967 seconds.
>> Loading game servers
> Servers loaded:
Example (16777343:7171)
>> Checking world type... PvP
>> Initializing game state modules and registering services...
mysql_real_query(): SELECT `id`, `name`, `password`, `premdays`, `lastday`, `key`, `warnings`, `true_ip` FROM `accounts` WHERE `id` = 1 LIMIT 1 - MYSQL ERROR: Unknown column 'true_ip' in 'field list' (1054)
> Global address: *********
> Local ports: 7171 7172
>> All modules were loaded, server is starting up...
>> The Forgotten server Online!

Unknown column 'true_ip' in 'field list' (1054)
Unknown column 'true_ip' in 'field list' (1054)
Unknown column 'true_ip' in 'field list' (1054)


And when im want to login im see "invalid account name" "invalid password" but it is correct!

Help.

REp++

 

[Diazapam]

its looking for the column true_ip in the database but can't find it.

Therefor It won't login (error message is wrong though)

 

[sobek07]

What i must do?

 

[sobek07]

Help plax

rep+

 

[Diazapam]

add the field true_ip in your sql database.

 

[sobek07]

lol, i know but where? In main database? or in accounts?

 

[Diazapam]

in accounts

 

[sobek07]

You can give me the codein SQL?

 

[sobek07]

Im added the table. 0 errors, but when im want to login, enter pass, clock login and now is debug :/


ehm.. wrong compilation?
In console:

[Warning - Protocol::RSA_decrypt] First byte != 0

In Tibia: