Need Help. Read it please!

[picachu]

when server loading...

[20/10/2009 16:51:39] mysql_real_query(): SELECT `key`, `value` FROM `global_storage` WHERE `world_id` = 0 - MYSQL ERROR: Unknown column 'world_id' in 'where clause' (1054)
[20/10/2009 16:51:39] mysql_real_query(): UPDATE `bans` SET `active` = 0 WHERE `expires` <= 1256064699 AND `expires` >= 0 AND `active` = 1; - MYSQL ERROR: Unknown column 'expires' in 'where clause' (1054)
[20/10/2009 16:51:39] mysql_real_query(): UPDATE `players` SET `online` = 0 WHERE `world_id` = 0 - MYSQL ERROR: Unknown column 'world_id' in 'where clause' (1054)
[20/10/2009 16:51:39] mysql_real_query(): SELECT `id`, `name`, `password`, `premdays`, `lastday`, `key`, `warnings` FROM `accounts` WHERE `id` = 1 - MYSQL ERROR: Unknown column 'name' in 'field list' (1054)

when i try to enter in account manager...

[20/10/2009 16:51:47] mysql_real_query(): SELECT `id`, `value`, `param`, `expires` FROM `bans` WHERE `type` = 1 AND `active` = 1; - MYSQL ERROR: Unknown column 'id' in 'field list' (1054)
[20/10/2009 16:51:47] mysql_real_query(): SELECT `id` FROM `accounts` WHERE `name` = '1' - MYSQL ERROR: Unknown column 'name' in 'where clause' (1054)

{{{{{{{{{{{{when give this error in exe /\ my Tibia says account is incorrect}}}}}}}}}}}
what i do?
ty!

 

[Xexza]

Wrong database schema?

 

[picachu]

Nop, correct.
I used schema_mysql.

 

[Xexza]

That error doesn't make sense for me.

The best advice I can give you is just to setup a server with a new database, use default configs and files and see what happens.

 

[picachu]

I will try it now.

 

[Bam]

I've had this before, I think I sorted it out by uploading the right database with right configurations in the config file database settings.

Also don't forget to try logging in the sample chars first.

 

[picachu]

Now, when i loggin the server, it CRASH. =S

 

[Bam]

Try to reinstall the entire database and make sure that you have xampp 1.6.6 and the right schema.mysql file.

 

[picachu]

I fixed it now
Ty for help, all.
;*


~~~SOLVED~~~