Account_ban_history

Denannce · Janeiro 22, 2015

eu queria saber como arrumar o erro da tabela

Account_ban_history no sql

Bruno Minervino · Janeiro 22, 2015

Assim fica difícil,

Qual o erro que está apresentando?

Denannce · Janeiro 22, 2015

este e o erro

>> Loading config

>> Establishing database connection... MySQL 5.5.40

>> Running database manager

> Abrindo

> Database has been updated to version 0.

> Updating database to version 1 (account names)

[Error - mysql_real_query] Query: ALTER TABLE `accounts` ADD `name` VARCHAR(32) NOT NULL AFTER `id`

Message: Duplicate column name 'name'

> Database has been updated to version 1.

> Updating database to version 2 (market offers)

[Error - mysql_real_query] Query: CREATE TABLE `market_offers` (`id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `player_id` INT NOT NULL, `sale` TINYINT(1) NOT NULL DEFAULT 0, `itemtype` INT UNSIGNED NOT NULL, `amount` SMALLINT UNSIGNED NOT NULL, `created` BIGINT UNSIGNED NOT NULL, `anonymous`

Message: Table 'market_offers' already exists

> Database has been updated to version 2.

> Updating database to version 3 (bank balance)

[Error - mysql_real_query] Query: ALTER TABLE `players` ADD `balance` BIGINT UNSIGNED NOT NULL DEFAULT 0

Message: Duplicate column name 'balance'

> Database has been updated to version 3.

> Updating database to version 4 (market history)

[Error - mysql_real_query] Query: CREATE TABLE `market_history` (`id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `player_id` INT NOT NULL, `sale` TINYINT(1) NOT NULL DEFAULT 0, `itemtype` INT UNSIGNED NOT NULL, `amount` SMALLINT UNSIGNED NOT NULL, `price` INT UNSIGNED NOT NULL DEFAULT 0, `expir

Message: Table 'market_history' already exists

> Database has been updated to version 4.

> Updating database to version 5 (black skull & guild wars)

[Error - mysql_real_query] Query: ALTER TABLE `players` CHANGE `redskull` `skull` TINYINT(1) NOT NULL DEFAULT '0', CHANGE `redskulltime` `skulltime` INT(11) NOT NULL DEFAULT '0'

Message: Unknown column 'redskull' in 'players'

> Database has been updated to version 5.

> Updating database to version 6 (market bug fix)

> Database has been updated to version 6.

> Updating database to version 7 (offline training)

[Error - mysql_real_query] Query: ALTER TABLE `players` ADD `offlinetraining_time` SMALLINT UNSIGNED NOT NULL DEFAULT 43200

Message: Duplicate column name 'offlinetraining_time'

[Error - mysql_real_query] Query: ALTER TABLE `players` ADD `offlinetraining_skill` INT NOT NULL DEFAULT -1

Message: Duplicate column name 'offlinetraining_skill'

> Database has been updated to version 7.

> Updating database to version 8 (account viplist with description, icon and notify server side)

[Error - mysql_real_query] Query: RENAME TABLE `player_viplist` TO `account_viplist`

Message: Table 'account_viplist' already exists

[Error - mysql_real_query] Query: ALTER TABLE `account_viplist` CHANGE `player_id` `account_id` INT( 11 ) NOT NULL COMMENT 'id of account whose viplist entry it is'

Message: Duplicate column name 'account_id'

[Error - mysql_real_query] Query: ALTER TABLE `account_viplist` CHANGE `vip_id` `player_id` INT( 11 ) NOT NULL COMMENT 'id of target player of viplist entry'

Message: Unknown column 'vip_id' in 'account_viplist'

[Error - mysql_real_query] Query: ALTER TABLE `account_viplist` DROP INDEX `vip_id`, ADD INDEX `player_id` (`player_id`)

Message: Can't DROP 'vip_id'; check that column/key exists

[Error - mysql_real_query] Query: ALTER TABLE `account_viplist` ADD `description` VARCHAR(128) NOT NULL DEFAULT '', ADD `icon` TINYINT( 2 ) UNSIGNED NOT NULL DEFAULT '0', ADD `notify` TINYINT( 1 ) NOT NULL DEFAULT '0'

Message: Duplicate column name 'description'

[Error - mysql_real_query] Query: ALTER TABLE `account_viplist` ADD UNIQUE `account_player_index` (`account_id`, `player_id`)

Message: Duplicate key name 'account_player_index'

> Database has been updated to version 8.

> Updating database to version 9 (global inbox)

> Database has been updated to version 9.

> Updating database to version 10 (stamina)

[Error - mysql_real_query] Query: ALTER TABLE `players` ADD `stamina` SMALLINT UNSIGNED NOT NULL DEFAULT 2520

Message: Duplicate column name 'stamina'

> Database has been updated to version 10.

> Updating database to version 11 (improved guild and players online structure)

[Error - mysql_real_query] Query: ALTER TABLE `guild_membership` ADD CONSTRAINT `guild_membership_ibfk_3` FOREIGN KEY (`rank_id`) REFERENCES `guild_ranks` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `guild_membership_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`i

Message: Can't create table 'global.#sql-885_a635' (errno: 121)

[Error - mysql_real_query] Query: ALTER TABLE `guild_invites` ADD PRIMARY KEY (`player_id`, `guild_id`)

Message: Multiple primary key defined

[Error - mysql_real_query] Query: ALTER TABLE `player_skills` ADD PRIMARY KEY (`player_id`, `skillid`)

Message: Table 'global.player_skills' doesn't exist

[Error - mysql_real_query] Query: ALTER TABLE `player_storage` ADD PRIMARY KEY (`player_id`, `key`)

Message: Multiple primary key defined

[Error - mysql_real_query] Query: SELECT `players`.`id` AS `player_id`, `players`.`rank_id` AS `rank_id`, `players`.`guildnick` AS `guild_nick`, `guild_ranks`.`guild_id` AS `guild_id` FROM `guild_ranks` INNER JOIN `players` ON `guild_ranks`.`id` = `players`.`rank_id`

Message: Unknown column 'players.rank_id' in 'field list'

[Error - mysql_store_result] Query: SELECT `players`.`id` AS `player_id`, `players`.`rank_id` AS `rank_id`, `players`.`guildnick` AS `guild_nick`, `guild_ranks`.`guild_id` AS `guild_id` FROM `guild_ranks` INNER JOIN `players` ON `guild_ranks`.`id` = `players`.`rank_id`

Message: Unknown column 'players.rank_id' in 'field list'

[Error - mysql_real_query] Query: ALTER TABLE `players` DROP `rank_id`, DROP `guildnick`, DROP `direction`, DROP `loss_experience`, DROP `loss_mana`, DROP `loss_skills`, DROP `premend`, DROP `online`

Message: Can't DROP 'rank_id'; check that column/key exists

> Database has been updated to version 11.

> Updating database to version 12 (storing players record and message of the day in database)

[Error - mysql_real_query] Query: INSERT INTO `server_config` (`config`, `value`) VALUES ('players_record', '0'), ('motd_hash', SHA1('')), ('motd_num', '')

Message: Duplicate entry 'players_record' for key 'PRIMARY'

> Database has been updated to version 12.

> Updating database to version 13 (house bidding system and additional columns to other tables)

[Error - mysql_real_query] Query: ALTER TABLE `player_deaths` ADD `mostdamage_by` varchar(100) NOT NULL, ADD `mostdamage_is_player` tinyint(1) NOT NULL DEFAULT '0', ADD `unjustified` tinyint(1) NOT NULL DEFAULT '0', ADD `mostdamage_unjustified` tinyint(1) NOT NULL DEFAULT '0', ADD KEY `kil

Message: Duplicate column name 'mostdamage_by'

[Error - mysql_real_query] Query: ALTER TABLE `houses` ADD `name` varchar(255) NOT NULL, ADD `rent` int(11) NOT NULL DEFAULT '0', ADD `town_id` int(11) NOT NULL DEFAULT '0', ADD `bid` int(11) NOT NULL DEFAULT '0', ADD `bid_end` int(11) NOT NULL DEFAULT '0', ADD `last_bid` int(11) NOT NULL

Message: Duplicate column name 'name'

[Error - mysql_real_query] Query: ALTER TABLE `players` ADD `onlinetime` int(11) NOT NULL DEFAULT '0', ADD `deletion` bigint(15) NOT NULL DEFAULT '0'

Message: Duplicate column name 'onlinetime'

[Error - mysql_real_query] Query: ALTER TABLE `accounts` ADD `points` int(11) NOT NULL DEFAULT '0', ADD `creation` int(11) NOT NULL DEFAULT '0'

Message: Duplicate column name 'creation'

> Database has been updated to version 13.

> Updating database to version 14 (account_bans, ip_bans and player_bans)

[Error - mysql_real_query] Query: SELECT `player`, `time` FROM `bans` WHERE `type` = 2

Message: Table 'global.bans' doesn't exist

[Error - mysql_store_result] Query: SELECT `player`, `time` FROM `bans` WHERE `type` = 2

Message: Table 'global.bans' doesn't exist

[Error - mysql_real_query] Query: DROP TRIGGER `ondelete_accounts`

Message: Trigger does not exist

[Error - mysql_real_query] Query: ALTER TABLE `accounts` DROP `warnings`

Message: Can't DROP 'warnings'; check that column/key exists

[Error - mysql_real_query] Query: DROP TABLE `bans`

Message: Unknown table 'bans'

Run this query in your database to create the ondelete_players trigger:

DELIMITER //

CREATE TRIGGER `ondelete_players` BEFORE DELETE ON `players`

FOR EACH ROW BEGIN

UPDATE `houses` SET `owner` = 0 WHERE `owner` = OLD.`id`;

END //

> Database has been updated to version 14.

> Updating database to version 15 (moving groups to data/XML/groups.xml)

[Error - mysql_real_query] Query: ALTER TABLE players DROP FOREIGN KEY players_ibfk_2

Message: Error on rename of './global/players' to './global/#sql2-885-a635' (errno: 152)

[Error - mysql_real_query] Query: DROP INDEX group_id ON players

Message: Can't DROP 'group_id'; check that column/key exists

[Error - mysql_real_query] Query: ALTER TABLE accounts DROP FOREIGN KEY accounts_ibfk_1

Message: Error on rename of './global/accounts' to './global/#sql2-885-a635' (errno: 152)

[Error - mysql_real_query] Query: DROP INDEX group_id ON accounts

Message: Can't DROP 'group_id'; check that column/key exists

[Error - mysql_real_query] Query: ALTER TABLE `accounts` DROP `group_id`

Message: Can't DROP 'group_id'; check that column/key exists

[Error - mysql_real_query] Query: SELECT `id`, `name`, `flags`, `access`, `maxdepotitems`, `maxviplist` FROM `groups` ORDER BY `id` ASC

Message: Table 'global.groups' doesn't exist

[Error - mysql_store_result] Query: SELECT `id`, `name`, `flags`, `access`, `maxdepotitems`, `maxviplist` FROM `groups` ORDER BY `id` ASC

Message: Table 'global.groups' doesn't exist

[Error - mysql_real_query] Query: DROP TABLE `groups`

Message: Unknown table 'groups'

> Database has been updated to version 15.

> Updating database to version 16 (moving skills into players table)

[Error - mysql_real_query] Query: ALTER TABLE `players` ADD `skill_fist` int(10) unsigned NOT NULL DEFAULT 10, ADD `skill_fist_tries` bigint(20) unsigned NOT NULL DEFAULT 0, ADD `skill_club` int(10) unsigned NOT NULL DEFAULT 10, ADD `skill_club_tries` bigint(20) unsigned NOT NULL DEFAULT 0

Message: Duplicate column name 'skill_fist'

[Error - mysql_real_query] Query: UPDATE `players` SET `skill_fist` = (SELECT `value` FROM `player_skills` WHERE `player_id` = `id` AND `skillid` = 0), `skill_fist_tries` = (SELECT `count` FROM `player_skills` WHERE `player_id` = `id` AND `skillid` = 0), `skill_club` = (SELECT `value` FROM

Message: Table 'global.player_skills' doesn't exist

[Error - mysql_real_query] Query: DROP TRIGGER `oncreate_players`

Message: Trigger does not exist

[Error - mysql_real_query] Query: DROP TABLE `player_skills`

Message: Unknown table 'player_skills'

> Database has been updated to version 16.

> Updating database to version 17 (fixing primary key in account ban history)