Denannce

aqui os erros

mano ate que o site entrou mas acho que ficou meio bugado por partes pois o server e de poketibia :/

olá bom estou criando um site pelo xammp e eu estou com esse erro, sei que muitos vão falar e database errada bla bla bla, mas quem intende mesmo sabe que isso acontece normalmente, bom eu queria saber como eu posso adicionar essa tabela para poder colocar meu site online, e a primeira vez que ocorre isto, e eu estou usando a mesma database do otserver.

mesmo assim mano acho que e no script :/ so nao sei onde fica, no meu tb ta assim do gt que vc colocou

não mano e esse sim eu ja tentei

bom estou com esse problema em meu server alguem me ajuda a arrumar? ao inves de dar use e depois pescar ele aparece open

nice!

mais ou menos distro com muitos bugs, da pra coloca online somente para brincar pois ele e muito instavel.

qual a versão do Debian

sim mas eu gostaria de saber como posso fazer isto...

olá a todos eu ja vi em um Ot sistema de água transparente eu queria coloca no meu ot tb, alguám pode me ajudar como eu posso fazer isso?

mais um PDA acho mlhor eu fazer um open pra ve se o forum pelo menos sai dessa precariedade

instala elas no php admin

isso e falta de tabelas.

suave kkkkkkkkk ja vo fazer já

10.41

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) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Lost connection to MySQL server during query [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111) [Error - mysql_real_query] Query: ALTER TABLE `account_ban_history` DROP FOREIGN KEY `account_ban_history_ibfk_1` Message: Can't connect to MySQL server on '127.0.0.1' (111)

eu queria saber como arrumar o erro da tabela Account_ban_history no sql

olá pessoal dei conta de compilar e de coloca online mas quando eu fecho o SSh o server desliga, tem algum comando para evitar que ele caia pois depois que eu executo ./theforgottenserver ele liga eu entro no server, mas quando eu desligo o SSh ele fecha, alguem pode me ajudar?

sou leigo nessa parte eu queria um ja testado com a pasta certinha pq sou muit noob assim dizendo rsrsrsrs

olá quero um global 8.6 com soucers e que esta ate uns 96% sem mt bug e que da ate pra coloca online, tenho um vps linux e estou querendo montar um Global.

patrocinio eu diria impossivel já que se for PDA ninguem coloca a mão no fogo, mas conte um pouco mais quem sabe pelomenos uma equipe vc consegue

te mandei PM