Failed: alter table pets drop runSpd; - MySQL Error: Can't DROP 'runSpd'; check that column/key exists
Failed: alter table pets drop walkSpd; - MySQL Error: Can't DROP 'walkSpd'; check that column/key exists
Failed: alter table pets drop heading; - MySQL Error: Can't DROP 'heading'; check that column/key exists
Failed: alter table pets drop x; - MySQL Error: Can't DROP 'x'; check that column/key exists
Failed: alter table pets drop y; - MySQL Error: Can't DROP 'y'; check that column/key exists
Failed: alter table pets drop z; - MySQL Error: Can't DROP 'z'; check that column/key exists
Failed: alter table pets drop unk1; - MySQL Error: Can't DROP 'unk1'; check that column/key exists
Failed: alter table pets drop unk2; - MySQL Error: Can't DROP 'unk2'; check that column/key exists
Failed: alter table pets drop colRad; - MySQL Error: Can't DROP 'colRad'; check that column/key exists
Failed: alter table pets drop colHeight; - MySQL Error: Can't DROP 'colHeight'; check that column/key exists
Failed: alter table pets drop pvpkills; - MySQL Error: Can't DROP 'pvpkills'; check that column/key exists
Failed: alter table pets drop npc_id; - MySQL Error: Can't DROP 'npc_id'; check that column/key exists
Failed: - MySQL Error: Query was empty
Failed: ALTER TABLE `character_shortcuts` ADD `page` decimal(3,0) DEFAULT '0' NOT NULL AFTER `slot`; - MySQL Error: Duplicate column name 'page'
Failed: - MySQL Error: Query was empty
Failed: ALTER TABLE `characters` ADD `rec_have` INT( 3 ) DEFAULT '0' NOT NULL AFTER `allyId` , ADD `rec_left` INT( 3 ) DEFAULT '0' NOT NULL AFTER `rec_have`; - MySQL Error: Duplicate column name 'rec_have'
Failed: - MySQL Error: Query was empty
Failed: - MySQL Error: Query was empty
Failed: alter table character_inventory add temp int auto_increment after object_id, add primary key (temp), drop primary key; - MySQL Error: Table 'l2jdb.character_inventory' doesn't exist
Failed: update character_inventory set temp=temp+600000000; - MySQL Error: Table 'l2jdb.character_inventory' doesn't exist
Failed: alter table character_inventory drop object_id; - MySQL Error: Table 'l2jdb.character_inventory' doesn't exist
Failed: alter table character_inventory change temp object_id int; - MySQL Error: Table 'l2jdb.character_inventory' doesn't exist
Failed: - MySQL Error: Query was empty
Failed: alter table character_inventory change char_obj_id owner_id int; - MySQL Error: Table 'l2jdb.character_inventory' doesn't exist
Failed: alter table character_inventory drop name; - MySQL Error: Table 'l2jdb.character_inventory' doesn't exist
Failed: alter table character_inventory drop equipslot; - MySQL Error: Table 'l2jdb.character_inventory' doesn't exist
Failed: alter table character_inventory add loc varchar(10); - MySQL Error: Table 'l2jdb.character_inventory' doesn't exist
Failed: alter table character_inventory add loc_data decimal(10,0); - MySQL Error: Table 'l2jdb.character_inventory' doesn't exist
Failed: alter table character_inventory add price_sell decimal(10,0); - MySQL Error: Table 'l2jdb.character_inventory' doesn't exist
Failed: alter table character_inventory add price_buy decimal(10,0); - MySQL Error: Table 'l2jdb.character_inventory' doesn't exist
Failed: update character_inventory set loc="INVENTORY"; - MySQL Error: Table 'l2jdb.character_inventory' doesn't exist
Failed: update character_inventory set loc_data=0; - MySQL Error: Table 'l2jdb.character_inventory' doesn't exist
Failed: update character_inventory set price_sell=0; - MySQL Error: Table 'l2jdb.character_inventory' doesn't exist
Failed: update character_inventory set price_buy=0; - MySQL Error: Table 'l2jdb.character_inventory' doesn't exist
Failed: - MySQL Error: Query was empty
Failed: alter table character_warehouse add temp int auto_increment after object_id, add primary key (temp), drop primary key; - MySQL Error: Table 'l2jdb.character_warehouse' doesn't exist
Failed: update character_warehouse set temp=temp+800000000; - MySQL Error: Table 'l2jdb.character_warehouse' doesn't exist
Failed: alter table character_warehouse drop object_id; - MySQL Error: Table 'l2jdb.character_warehouse' doesn't exist
Failed: alter table character_warehouse change temp object_id int; - MySQL Error: Table 'l2jdb.character_warehouse' doesn't exist
Failed: - MySQL Error: Query was empty
Failed: alter table character_warehouse change char_obj_id owner_id int; - MySQL Error: Table 'l2jdb.character_warehouse' doesn't exist
Failed: alter table character_warehouse drop name; - MySQL Error: Table 'l2jdb.character_warehouse' doesn't exist
Failed: alter table character_warehouse add loc varchar(10); - MySQL Error: Table 'l2jdb.character_warehouse' doesn't exist
Failed: alter table character_warehouse add loc_data decimal(10,0); - MySQL Error: Table 'l2jdb.character_warehouse' doesn't exist
Failed: alter table character_warehouse add price_sell decimal(10,0); - MySQL Error: Table 'l2jdb.character_warehouse' doesn't exist
Failed: alter table character_warehouse add price_buy decimal(10,0); - MySQL Error: Table 'l2jdb.character_warehouse' doesn't exist
Failed: update character_warehouse set loc="WAREHOUSE"; - MySQL Error: Table 'l2jdb.character_warehouse' doesn't exist
Failed: update character_warehouse set loc_data=0; - MySQL Error: Table 'l2jdb.character_warehouse' doesn't exist
Failed: update character_warehouse set price_sell=0; - MySQL Error: Table 'l2jdb.character_warehouse' doesn't exist
Failed: update character_warehouse set price_buy=0; - MySQL Error: Table 'l2jdb.character_warehouse' doesn't exist
Failed: - MySQL Error: Query was empty
Failed: alter table clan_warehouse add owner_id decimal(10,0) first; - MySQL Error: Table 'l2jdb.clan_warehouse' doesn't exist
Failed: update clan_warehouse,clan_data set clan_warehouse.owner_id=clan_data.leader_id where clan_warehouse.clan_id=clan_data.clan_id; - MySQL Error: Table 'l2jdb.clan_warehouse' doesn't exist
Failed: alter table clan_warehouse drop name; - MySQL Error: Table 'l2jdb.clan_warehouse' doesn't exist
Failed: alter table clan_warehouse add loc varchar(10); - MySQL Error: Table 'l2jdb.clan_warehouse' doesn't exist
Failed: alter table clan_warehouse add loc_data decimal(10,0); - MySQL Error: Table 'l2jdb.clan_warehouse' doesn't exist
Failed: alter table clan_warehouse add price_sell decimal(10,0); - MySQL Error: Table 'l2jdb.clan_warehouse' doesn't exist
Failed: alter table clan_warehouse add price_buy decimal(10,0); - MySQL Error: Table 'l2jdb.clan_warehouse' doesn't exist
Failed: update clan_warehouse set loc="CLANWH"; - MySQL Error: Table 'l2jdb.clan_warehouse' doesn't exist
Failed: update clan_warehouse set loc_data=clan_id; - MySQL Error: Table 'l2jdb.clan_warehouse' doesn't exist
Failed: update clan_warehouse set price_sell=0; - MySQL Error: Table 'l2jdb.clan_warehouse' doesn't exist
Failed: update clan_warehouse set price_buy=0; - MySQL Error: Table 'l2jdb.clan_warehouse' doesn't exist
Failed: alter table clan_warehouse drop clan_id; - MySQL Error: Table 'l2jdb.clan_warehouse' doesn't exist
Failed: - MySQL Error: Query was empty
Failed: alter table pet_inventory add owner_id decimal(10,0) first; - MySQL Error: Table 'l2jdb.pet_inventory' doesn't exist
Failed: alter table pet_inventory drop name; - MySQL Error: Table 'l2jdb.pet_inventory' doesn't exist
Failed: alter table pet_inventory add loc varchar(10); - MySQL Error: Table 'l2jdb.pet_inventory' doesn't exist
Failed: alter table pet_inventory add loc_data decimal(10,0); - MySQL Error: Table 'l2jdb.pet_inventory' doesn't exist
Failed: alter table pet_inventory add price_sell decimal(10,0); - MySQL Error: Table 'l2jdb.pet_inventory' doesn't exist
Failed: alter table pet_inventory add price_buy decimal(10,0); - MySQL Error: Table 'l2jdb.pet_inventory' doesn't exist
Failed: update pet_inventory set loc="PET"; - MySQL Error: Table 'l2jdb.pet_inventory' doesn't exist
Failed: update pet_inventory set loc_data=pet_obj_id; - MySQL Error: Table 'l2jdb.pet_inventory' doesn't exist
Failed: update pet_inventory set price_sell=0; - MySQL Error: Table 'l2jdb.pet_inventory' doesn't exist
Failed: update pet_inventory set price_buy=0; - MySQL Error: Table 'l2jdb.pet_inventory' doesn't exist
Failed: alter table pet_inventory drop pet_obj_id; - MySQL Error: Table 'l2jdb.pet_inventory' doesn't exist
Failed: alter table pet_inventory drop equipslot; - MySQL Error: Table 'l2jdb.pet_inventory' doesn't exist
Failed: - MySQL Error: Query was empty
Failed: insert items select * from character_inventory; - MySQL Error: Table 'l2jdb.character_inventory' doesn't exist
Failed: insert items select * from character_warehouse; - MySQL Error: Table 'l2jdb.character_warehouse' doesn't exist
Failed: insert items select * from clan_warehouse; - MySQL Error: Table 'l2jdb.clan_warehouse' doesn't exist
Failed: insert items select * from pet_inventory; - MySQL Error: Table 'l2jdb.pet_inventory' doesn't exist
Failed: - MySQL Error: Query was empty
Failed: drop table character_inventory; - MySQL Error: Unknown table 'character_inventory'
Failed: drop table character_warehouse; - MySQL Error: Unknown table 'character_warehouse'
Failed: drop table clan_warehouse; - MySQL Error: Unknown table 'clan_warehouse'
Failed: drop table pet_inventory; - MySQL Error: Unknown table 'pet_inventory'
converted database format


starting id cleaning for main database stage 1 (setting main database id's to start at 1):

MySQL Error: Table 'new_characters' already exists