Samples DB Error

[Pykera]

Hello.

I need the SQL for the sample in my DB i have triyed alot of methods and always error.

Please! Thanks

 

[Pykera]

#1054 - Unknown column 'old_name' in 'field list'

This is the error

 

[sn3ejk]

Could you show all error ;>?

 

[Pykera]

Error
consulta SQL:

INSERT INTO `players` (`id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `old_name`, `hide_char`, `worldtransfer`, `created`, `nick_verify`, `comment`, `auction_balance`) VALUES (1, 'Account Manager', 0, 1, 1, 1, 0, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, '', 400, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', NULL, 0, NULL, NULL, NULL, NULL, 0), (2, 'Rook Sample', 0, 1, 1, 1, 0, 150, 150,[...]

MySQL ha dicho:

#1054 - Unknown column 'old_name' in 'field list'

 

[sn3ejk]

ALTER TABLE  `players` ADD `old_name` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;

 

[Pykera]

Fixed! THanks!