Ir para conteúdo

Bug no Gesior, ajudem

Por teter007
em Suporte Tibia OTServer

Featured Replies

Postado

Solução para esse problema:

 

1° No banco de dados do seu otserv apague a tabela player_skills.

 

2º Vá em SQL e dicione isto:

 

CREATE TABLE `player_skills` (
  `player_id` int(11) NOT NULL default '0',
  `skillid` tinyint(2) NOT NULL default '0',
  `value` int(10) unsigned NOT NULL default '0',
  `count` int(10) unsigned NOT NULL default '0',
  UNIQUE KEY `player_id_2` (`player_id`,`skillid`),
  KEY `player_id` (`player_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
3° Novamente em SQL adicione isto:
 
INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES
(2, 0, 10, 0),
(2, 1, 10, 0),
(2, 2, 10, 0),
(2, 3, 10, 0),
(2, 4, 10, 0),
(2, 5, 10, 0),
(2, 6, 10, 0),
(3, 0, 10, 0),
(3, 1, 10, 0),
(3, 2, 10, 0),
(3, 3, 10, 0),
(3, 4, 10, 0),
(3, 5, 10, 0),
(3, 6, 10, 0),
(4, 0, 10, 0),
(4, 1, 10, 0),
(4, 2, 10, 0),
(4, 3, 10, 0),
(4, 4, 10, 0),
(4, 5, 10, 0),
(4, 6, 10, 0),
(5, 0, 10, 0),
(5, 1, 10, 0),
(5, 2, 10, 0),
(5, 3, 10, 0),
(5, 4, 10, 0),
(5, 5, 10, 0),
(5, 6, 10, 0),
(6, 0, 10, 0),
(6, 1, 10, 0),
(6, 2, 10, 0),
(6, 3, 10, 0),
(6, 4, 10, 0),
(6, 5, 10, 0),
(6, 6, 10, 0),
(7, 0, 45, 297),
(7, 1, 45, 657),
(7, 2, 45, 447),
(7, 3, 128, 0),
(7, 4, 128, 0),
(7, 5, 44, 667),
(7, 6, 10, 0),
(8, 0, 10, 0),
(8, 1, 10, 0),
(8, 2, 10, 0),
(8, 3, 10, 0),
(8, 4, 10, 0),
(8, 5, 10, 0),
(8, 6, 10, 0),
(9, 0, 10, 0),
(9, 1, 10, 0),
(9, 2, 10, 0),
(9, 3, 10, 0),
(9, 4, 10, 0),
(9, 5, 10, 0),
(9, 6, 10, 0),
(10, 0, 10, 0),
(10, 1, 10, 0),
(10, 2, 10, 0),
(10, 3, 10, 0),
(10, 4, 10, 0),
(10, 5, 10, 0),
(10, 6, 10, 0),
(11, 0, 10, 0),
(11, 1, 10, 0),
(11, 2, 10, 0),
(11, 3, 10, 0),
(11, 4, 10, 0),
(11, 5, 10, 0),
(11, 6, 10, 0),
(12, 0, 10, 0),
(12, 1, 10, 0),
(12, 2, 10, 0),
(12, 3, 10, 0),
(12, 4, 10, 0),
(12, 5, 10, 0),
(12, 6, 10, 0),
(13, 0, 10, 0),
(13, 1, 10, 0),
(13, 2, 10, 0),
(13, 3, 10, 0),
(13, 4, 10, 0),
(13, 5, 10, 0),
(13, 6, 10, 0),
(14, 0, 10, 0),
(14, 1, 10, 0),
(14, 2, 10, 0),
(14, 3, 10, 0),
(14, 4, 10, 0),
(14, 5, 10, 0),
(14, 6, 10, 0),
(15, 0, 10, 0),
(15, 1, 10, 0),
(15, 2, 10, 0),
(15, 3, 10, 0),
(15, 4, 10, 0),
(15, 5, 10, 0),
(15, 6, 10, 0),
(16, 0, 10, 0),
(16, 1, 10, 0),
(16, 2, 10, 0),
(16, 3, 10, 0),
(16, 4, 10, 0),
(16, 5, 25, 27828),
(16, 6, 10, 0),
(17, 0, 10, 0),
(17, 1, 10, 0),
(17, 2, 10, 0),
(17, 3, 10, 0),
(17, 4, 10, 0),
(17, 5, 10, 0),
(17, 6, 10, 0),
(18, 0, 10, 0),
(18, 1, 10, 0),
(18, 2, 10, 0),
(18, 3, 92, 116310255),
(18, 4, 72, 1566),
(18, 5, 85, 27884),
(18, 6, 10, 0),
(19, 0, 10, 0),
(19, 1, 10, 0),
(19, 2, 10, 0),
(19, 3, 10, 0),
(19, 4, 10, 0),
(19, 5, 10, 0),
(19, 6, 10, 0),
(20, 0, 10, 0),
(20, 1, 10, 0),
(20, 2, 10, 0),
(20, 3, 10, 0),
(20, 4, 10, 0),
(20, 5, 10, 0),
(20, 6, 10, 0),
(21, 0, 10, 0),
(21, 1, 10, 0),
(21, 2, 10, 0),
(21, 3, 10, 0),
(21, 4, 10, 0),
(21, 5, 10, 0),
(21, 6, 10, 0),
(22, 0, 10, 0),
(22, 1, 10, 0),
(22, 2, 10, 0),
(22, 3, 10, 0),
(22, 4, 10, 0),
(22, 5, 10, 0),
(22, 6, 10, 0),
(23, 0, 10, 0),
(23, 1, 10, 0),
(23, 2, 10, 0),
(23, 3, 10, 0),
(23, 4, 10, 0),
(23, 5, 10, 0),
(23, 6, 10, 0),
(24, 0, 13, 7),
(24, 1, 10, 0),
(24, 2, 10, 0),
(24, 3, 10, 0),
(24, 4, 10, 0),
(24, 5, 10, 0),
(24, 6, 10, 0),
(25, 0, 10, 0),
(25, 1, 10, 0),
(25, 2, 10, 0),
(25, 3, 10, 0),
(25, 4, 10, 0),
(25, 5, 10, 0),
(25, 6, 10, 0),
(26, 0, 10, 0),
(26, 1, 10, 0),
(26, 2, 10, 0),
(26, 3, 10, 0),
(26, 4, 10, 0),
(26, 5, 10, 0),
(26, 6, 10, 0),
(27, 0, 10, 0),
(27, 1, 10, 0),
(27, 2, 10, 0),
(27, 3, 10, 0),
(27, 4, 10, 0),
(27, 5, 16, 23),
(27, 6, 10, 0),
(28, 0, 10, 0),
(28, 1, 10, 0),
(28, 2, 10, 0),
(28, 3, 10, 0),
(28, 4, 10, 0),
(28, 5, 10, 0),
(28, 6, 10, 0),
(29, 0, 10, 0),
(29, 1, 10, 0),
(29, 2, 10, 0),
(29, 3, 10, 0),
(29, 4, 10, 0),
(29, 5, 10, 0),
(29, 6, 10, 0),
(30, 0, 10, 0),
(30, 1, 10, 0),
(30, 2, 10, 0),
(30, 3, 10, 0),
(30, 4, 10, 0),
(30, 5, 10, 0),
(30, 6, 10, 0),
(31, 0, 10, 0),
(31, 1, 10, 0),
(31, 2, 10, 0),
(31, 3, 10, 0),
(31, 4, 10, 0),
(31, 5, 10, 0),
(31, 6, 10, 0),
(32, 0, 10, 0),
(32, 1, 10, 0),
(32, 2, 10, 0),
(32, 3, 10, 0),
(32, 4, 10, 0),
(32, 5, 10, 0),
(32, 6, 10, 0),
(33, 0, 10, 0),
(33, 1, 10, 0),
(33, 2, 10, 0),
(33, 3, 51, 0),
(33, 4, 10, 0),
(33, 5, 44, 127),
(33, 6, 10, 0),
(34, 0, 10, 0),
(34, 1, 10, 0),
(34, 2, 10, 0),
(34, 3, 10, 0),
(34, 4, 10, 0),
(34, 5, 10, 0),
(34, 6, 10, 0),
(35, 0, 10, 0),
(35, 1, 10, 0),
(35, 2, 10, 0),
(35, 3, 10, 0),
(35, 4, 10, 0),
(35, 5, 10, 0),
(35, 6, 10, 0),
(36, 0, 10, 0),
(36, 1, 10, 0),
(36, 2, 10, 0),
(36, 3, 10, 0),
(36, 4, 10, 0),
(36, 5, 10, 0),
(36, 6, 10, 0),
(37, 0, 10, 0),
(37, 1, 10, 0),
(37, 2, 10, 0),
(37, 3, 10, 0),
(37, 4, 10, 0),
(37, 5, 10, 0),
(37, 6, 10, 0),
(38, 0, 10, 0),
(38, 1, 10, 0),
(38, 2, 10, 0),
(38, 3, 10, 0),
(38, 4, 64, 2826),
(38, 5, 10, 0),
(38, 6, 10, 0),
(39, 0, 10, 0),
(39, 1, 10, 0),
(39, 2, 10, 0),
(39, 3, 10, 0),
(39, 4, 10, 0),
(39, 5, 10, 0),
(39, 6, 10, 0),
(40, 0, 10, 0),
(40, 1, 10, 0),
(40, 2, 10, 0),
(40, 3, 10, 0),
(40, 4, 10, 0),
(40, 5, 10, 0),
(40, 6, 10, 0),
(41, 0, 10, 0),
(41, 1, 10, 0),
(41, 2, 10, 0),
(41, 3, 10, 0),
(41, 4, 10, 0),
(41, 5, 10, 0),
(41, 6, 10, 0),
(42, 0, 10, 0),
(42, 1, 10, 0),
(42, 2, 10, 0),
(42, 3, 10, 0),
(42, 4, 10, 0),
(42, 5, 10, 0),
(42, 6, 10, 0),
(43, 0, 10, 0),
(43, 1, 10, 0),
(43, 2, 10, 0),
(43, 3, 10, 0),
(43, 4, 10, 0),
(43, 5, 10, 0),
(43, 6, 10, 0),
(44, 0, 10, 0),
(44, 1, 10, 0),
(44, 2, 10, 0),
(44, 3, 10, 0),
(44, 4, 10, 0),
(44, 5, 10, 0),
(44, 6, 10, 0),
(45, 0, 10, 0),
(45, 1, 10, 0),
(45, 2, 10, 0),
(45, 3, 10, 0),
(45, 4, 10, 0),
(45, 5, 10, 0),
(45, 6, 10, 0),
(46, 0, 10, 0),
(46, 1, 10, 0),
(46, 2, 10, 0),
(46, 3, 10, 0),
(46, 4, 10, 0),
(46, 5, 10, 0),
(46, 6, 10, 0),
(47, 0, 10, 0),
(47, 1, 10, 0),
(47, 2, 10, 0),
(47, 3, 10, 0),
(47, 4, 10, 0),
(47, 5, 10, 0),
(47, 6, 10, 0),
(48, 0, 10, 0),
(48, 1, 10, 0),
(48, 2, 10, 0),
(48, 3, 10, 0),
(48, 4, 10, 0),
(48, 5, 10, 0),
(48, 6, 10, 0),
(49, 0, 10, 0),
(49, 1, 10, 0),
(49, 2, 10, 0),
(49, 3, 10, 0),
(49, 4, 10, 0),
(49, 5, 10, 0),
(49, 6, 10, 0),
(50, 0, 10, 0),
(50, 1, 10, 0),
(50, 2, 10, 0),
(50, 3, 10, 0),
(50, 4, 10, 0),
(50, 5, 10, 0),
(50, 6, 10, 0),
(51, 0, 15, 60),
(51, 1, 10, 0),
(51, 2, 10, 0),
(51, 3, 10, 0),
(51, 4, 10, 0),
(51, 5, 10, 0),
(51, 6, 10, 0),
(52, 0, 16, 0),
(52, 1, 10, 0),
(52, 2, 10, 0),
(52, 3, 10, 0),
(52, 4, 10, 0),
(52, 5, 10, 0),
(52, 6, 10, 0),
(53, 0, 50, 1890),
(53, 1, 10, 0),
(53, 2, 30, 88),
(53, 3, 10, 0),
(53, 4, 10, 0),
(53, 5, 44, 2167),
(53, 6, 10, 0),
(54, 0, 10, 0),
(54, 1, 10, 0),
(54, 2, 10, 0),
(54, 3, 10, 0),
(54, 4, 10, 0),
(54, 5, 10, 0),
(54, 6, 10, 0),
(55, 0, 10, 0),
(55, 1, 10, 0),
(55, 2, 10, 0),
(55, 3, 10, 0),
(55, 4, 10, 0),
(55, 5, 10, 0),
(55, 6, 10, 0),
(56, 0, 10, 0),
(56, 1, 10, 0),
(56, 2, 10, 0),
(56, 3, 10, 0),
(56, 4, 10, 0),
(56, 5, 10, 0),
(56, 6, 10, 0),
(57, 0, 10, 0),
(57, 1, 10, 0),
(57, 2, 10, 0),
(57, 3, 10, 0),
(57, 4, 10, 0),
(57, 5, 10, 0),
(57, 6, 10, 0),
(58, 0, 10, 0),
(58, 1, 10, 0),
(58, 2, 10, 0),
(58, 3, 10, 0),
(58, 4, 10, 0),
(58, 5, 10, 0),
(58, 6, 10, 0),
(59, 0, 10, 0),
(59, 1, 10, 0),
(59, 2, 10, 0),
(59, 3, 10, 0),
(59, 4, 10, 0),
(59, 5, 10, 0),
(59, 6, 10, 0),
(60, 0, 10, 0),
(60, 1, 10, 0),
(60, 2, 10, 0),
(60, 3, 10, 0),
(60, 4, 10, 0),
(60, 5, 10, 0),
(60, 6, 10, 0),
(61, 0, 10, 0),
(61, 1, 10, 0),
(61, 2, 10, 0),
(61, 3, 10, 0),
(61, 4, 10, 0),
(61, 5, 10, 0),
(61, 6, 10, 0),
(62, 0, 10, 0),
(62, 1, 10, 0),
(62, 2, 10, 0),
(62, 3, 10, 0),
(62, 4, 10, 0),
(62, 5, 10, 0),
(62, 6, 10, 0),
(63, 0, 10, 0),
(63, 1, 10, 0),
(63, 2, 10, 0),
(63, 3, 10, 0),
(63, 4, 10, 0),
(63, 5, 10, 0),
(63, 6, 10, 0),
(64, 0, 10, 0),
(64, 1, 10, 0),
(64, 2, 10, 0),
(64, 3, 10, 0),
(64, 4, 10, 0),
(64, 5, 10, 0),
(64, 6, 10, 0),
(65, 0, 10, 0),
(65, 1, 10, 0),
(65, 2, 10, 0),
(65, 3, 10, 0),
(65, 4, 10, 0),
(65, 5, 10, 0),
(65, 6, 10, 0),
(66, 0, 10, 0),
(66, 1, 10, 0),
(66, 2, 10, 0),
(66, 3, 10, 0),
(66, 4, 10, 0),
(66, 5, 10, 0),
(66, 6, 10, 0),
(67, 0, 10, 0),
(67, 1, 10, 0),
(67, 2, 10, 0),
(67, 3, 10, 0),
(67, 4, 10, 0),
(67, 5, 10, 0),
(67, 6, 10, 0),
(68, 0, 10, 0),
(68, 1, 10, 0),
(68, 2, 10, 0),
(68, 3, 10, 0),
(68, 4, 10, 0),
(68, 5, 10, 0),
(68, 6, 10, 0),
(69, 0, 10, 0),
(69, 1, 10, 0),
(69, 2, 10, 0),
(69, 3, 10, 0),
(69, 4, 10, 0),
(69, 5, 10, 0),
(69, 6, 10, 0),
(70, 0, 10, 0),
(70, 1, 10, 0),
(70, 2, 10, 0),
(70, 3, 10, 0),
(70, 4, 10, 0),
(70, 5, 10, 0),
(70, 6, 10, 0);

 

Pronto!

 

Esse tipo de erro ocorre quando você tem alguma alteração nas vocações em sua pasta XML ou na própria data base inserindo uma tabela com erro ou com alguma informação ausente.

  • Citar
  • Mention
    • Respostas 5
    • Visualizações 969
    • Created
    • Última resposta

    Top Posters In This Topic

    Popular Days

    Participe da conversa

    Você pode postar agora e se cadastrar mais tarde. Se você tem uma conta, faça o login para postar com sua conta.

    Visitante
    Responder
    Ir para a lista de tópicos

    Quem Está Navegando 0

    • Nenhum usuário registrado visualizando esta página.

    Estatísticas dos Fóruns

    • Tópicos 96.9k
    • Posts 519.6k

    Informação Importante

    Confirmação de Termo

    I accept