Solved Mysql Error

[7amo]

How do I Fix This Error Iam Using Mysql

 

[Limos]

Do you get an error in your console?

 

[7amo]

@Limos Only Give Me This Error On Tibia And No Erros On Console!

 

[Limos]

Are you sure you don't get errors in this at the moment you try to login?

How did you created your character, on the website or acc manager and did you change anything in the database after creating it?

 

[7amo]

I Created My Character From My Website And I didn't Change Any Thing In The Database!

 

[7amo]

@Limos Sorry I Saw This Error (Mysql_Error) While I was Login

 

[Limos]

Can you show the whole error? I now only see the left part of it

 

[7amo]

@Limos [08/06/2014 21:36:08] mysql_real_query(): SELECT `id`, `account_id`, `group_id`, `world_id`, `sex`, `vocation`, `experience`, `level`, `maglevel`, `health`, `healthmax`, `mana`, `manamax`, `manaspent`, `soul`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `posx`, `posy`, `posz`, `cap`, `lastlogin`, `lastlogout`, `lastip`, `conditions`, `guildnick`, `rank_id`, `town_id`, `balance`, `kills`, `deaths`, `assists`, `marriage`, `promotion`, `description` FROM `players` WHERE `name` = 'Malizia' AND `world_id` = 0 AND `deleted` = 0 LIMIT 1 - MYSQL ERROR: Unknown column 'kills' in 'field list' (1054)

 

[Limos]

ALTER TABLE `players` ADD `kills` INT(11) NOT NULL DEFAULT 0;

 

[7amo]

@Limos No Work

 

[kafo]

I have this error too

 

[Limos]

Did you run the query in your database?

 

[7amo]

I Added
ALTER TABLE `players` ADD `kills` INT(11) NOT NULL DEFAULT 0;
But It Gives Me The Same Error

 

[Limos]

http://otland.net/threads/mysql-how-to-run-a-query.177833/
Do it like this.
You can also just remove kills from the query in the script.

 

[7amo]

New Error Appeared

 

[Limos]

Look for a line with that function and remove it.
If you want to remove de bot spam aswell, go to globalevents.xml, look for botmanager and delete that line.

 

[7amo]

@Limos Thanks alot you are the best