antiblock
Rodnia | Alpha & Omega

  • Chatbox

    Did you check out our Discord? https://discord.gg/FFdvMjk9xA
    You don't have permission to chat.
    Load More
  • 0
Sign in to follow this  
Followers 0
Kɛɛɗ

[Duvida] Erro Ao Adicionar Query - Navicat

Asked by Kɛɛɗ,

Question

Kɛɛɗ    519

Kɛɛɗ
Posted

Olá, A Todos da Cyber-Gamers, Queria pergunta e saber também como resolver um erro que esta a me deixar com dor de cabeça, quando vou adicionar uma query para o mob_proto pelo navicat (obvio) sempre me da um erro 

 

Bom Abaixou irei mostra print do erro, a query para o navicat e o do mob_proto(client) para ver se esta tudo certo, então vamos la

 

Mob_Proto

 

<Mob vnum="9028" name="'?????'" gb2312name="Metin der Hoffnung" type="2" rank="5" battle_type="3" level="95" event_type="0" mob_color="0" />
   <Mob vnum="9029" name="'?????'" gb2312name="Metin des Schreckens" type="2" rank="5" battle_type="3" level="100" event_type="0" mob_color="0" />
   <Mob vnum="9030" name="'?????'" gb2312name="Metin des Zorns" type="2" rank="5" battle_type="3" level="105" event_type="0" mob_color="0" />
   <Mob vnum="9031" name="'?????'" gb2312name="Metin der Barmherzigkeit" type="2" rank="5" battle_type="3" level="110" event_type="0" mob_color="0" />
   <Mob vnum="9032" name="'?????'" gb2312name="Metin der Unterwelt" type="2" rank="5" battle_type="3" level="115" event_type="0" mob_color="0" />
   <Mob vnum="9033" name="'?????'" gb2312name="Metin der Wiedergeburt" type="2" rank="5" battle_type="3" level="120" event_type="0" mob_color="0" />
   <Mob vnum="9034" name="'?????'" gb2312name="Metin der Wut" type="2" rank="5" battle_type="3" level="125" event_type="0" mob_color="0" />
   <Mob vnum="9035" name="'?????'" gb2312name="Metin der Vernunft" type="2" rank="5" battle_type="3" level="130" event_type="0" mob_color="0" />
   <Mob vnum="9036" name="'?????'" gb2312name="Metin des Lichts" type="2" rank="5" battle_type="3" level="135" event_type="0" mob_color="0" />
   <Mob vnum="9037" name="'?????'" gb2312name="Metin der Verzweiflung" type="2" rank="5" battle_type="3" level="140" event_type="0" mob_color="0" />
   <Mob vnum="9038" name="'?????'" gb2312name="Metin der Geduld" type="2" rank="5" battle_type="3" level="145" event_type="0" mob_color="0" />
   <Mob vnum="9039" name="'?????'" gb2312name="Metin der Elemente" type="2" rank="5" battle_type="3" level="150" event_type="0" mob_color="0" />

 
Query Mysql
 

INSERT INTO mob_proto VALUES(9028, 'Metin der Hoffnung', 'Metin der Hoffnung', 5, 2, 3, 95, '', 'NOMOVE', 0, '', 'STUN,SLOW,CURSE,TERROR', 0, '', 0, 0, 0, 60, 0, 0, 0, 999999, 5, 1, 184800, 92400, 540, 57, 9529, 9530, 0, 2000, 175, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 70104, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO mob_proto VALUES(9029, 'Metin des Schreckens', 'Metin des Schreckens', 5, 2, 3, 100, '', 'NOMOVE', 0, '', 'STUN,SLOW,CURSE,TERROR', 0, '', 0, 0, 0, 60, 0, 0, 0, 999999, 5, 1, 184800, 92400, 540, 57, 9529, 9530, 0, 2000, 175, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 70104, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO mob_proto VALUES(9030, 'Metin des Zorns', 'Metin des Zorns', 5, 2, 3, 105, '', 'NOMOVE', 0, '', 'STUN,SLOW,CURSE,TERROR', 0, '', 0, 0, 0, 60, 0, 0, 0, 999999, 5, 1, 184800, 92400, 540, 57, 9529, 9530, 0, 2000, 175, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 70104, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO mob_proto VALUES(9031, 'Metin der Barmherzigkeit', 'Metin der Barmherzigkeit', 5, 2, 3, 110, '', 'NOMOVE', 0, '', 'STUN,SLOW,CURSE,TERROR', 0, '', 0, 0, 0, 60, 0, 0, 0, 999999, 5, 1, 184800, 92400, 540, 57, 9529, 9530, 0, 2000, 175, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 70104, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO mob_proto VALUES(9032, 'Metin der Unterwelt', 'Metin der Unterwelt', 5, 2, 3, 115, '', 'NOMOVE', 0, '', 'STUN,SLOW,CURSE,TERROR', 0, '', 0, 0, 0, 60, 0, 0, 0, 999999, 5, 1, 184800, 92400, 540, 57, 9529, 9530, 0, 2000, 175, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 70104, 0, 0, 0, 0, 0, 0, 0, 0, 0); 
INSERT INTO mob_proto VALUES(9033, 'Metin der Wiedergeburt', 'Metin der Wiedergeburt', 5, 2, 3, 120, '', 'NOMOVE', 0, '', 'STUN,SLOW,CURSE,TERROR', 0, '', 0, 0, 0, 60, 0, 0, 0, 999999, 5, 1, 184800, 92400, 540, 57, 9529, 9530, 0, 2000, 175, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 70104, 0, 0, 0, 0, 0, 0, 0, 0, 0); 
INSERT INTO mob_proto VALUES(9034, 'Metin der Wut', 'Metin der Wut', 5, 2, 3, 125, '', 'NOMOVE', 0, '', 'STUN,SLOW,CURSE,TERROR', 0, '', 0, 0, 0, 60, 0, 0, 0, 999999, 5, 1, 184800, 92400, 540, 57, 9529, 9530, 0, 2000, 175, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 70104, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO mob_proto VALUES(9035, 'Metin der Vernunft', 'Metin der Vernunft', 5, 2, 3, 130, '', 'NOMOVE', 0, '', 'STUN,SLOW,CURSE,TERROR', 0, '', 0, 0, 0, 60, 0, 0, 0, 999999, 5, 1, 184800, 92400, 540, 57, 9529, 9530, 0, 2000, 175, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 70104, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO mob_proto VALUES(9036, 'Metin des Lichts', 'Metin des Lichts', 5, 2, 3, 135, '', 'NOMOVE', 0, '', 'STUN,SLOW,CURSE,TERROR', 0, '', 0, 0, 0, 60, 0, 0, 0, 999999, 5, 1, 184800, 92400, 540, 57, 9529, 9530, 0, 2000, 175, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 70104, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO mob_proto VALUES(9037, 'Metin der Verzweiflung', 'Metin der Verzweiflung', 5, 2, 3, 140, '', 'NOMOVE', 0, '', 'STUN,SLOW,CURSE,TERROR', 0, '', 0, 0, 0, 60, 0, 0, 0, 999999, 5, 1, 184800, 92400, 540, 57, 9529, 9530, 0, 2000, 175, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 70104, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO mob_proto VALUES(9038, 'Metin der Geduld', 'Metin der Geduld', 5, 2, 3, 145, '', 'NOMOVE', 0, '', 'STUN,SLOW,CURSE,TERROR', 0, '', 0, 0, 0, 60, 0, 0, 0, 999999, 5, 1, 184800, 92400, 540, 57, 9529, 9530, 0, 2000, 175, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 70104, 0, 0, 0, 0, 0, 0, 0, 0, 0); 
INSERT INTO mob_proto VALUES(9038, 'Metin der Elemente', 'Metin der Geduld', 5, 2, 3, 150, '', 'NOMOVE', 0, '', 'STUN,SLOW,CURSE,TERROR', 0, '', 0, 0, 0, 60, 0, 0, 0, 999999, 5, 1, 184800, 92400, 540, 57, 9529, 9530, 0, 2000, 175, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 70104, 0, 0, 0, 0, 0, 0, 0, 0, 0);

 
Print do Erro :
 

 
Imagem colocada
 

 
Bom Acho que é tudo, preciso de ajuda pra isso urgentemente ;c 
 
Dou  :+1: por 2 dias ate ficar block de tantos  :+1: pra quem me ajudar :C
 
Cumprimentos

Share this post

Link to post
Share on other sites

7 answers to this question

  • 0

TiiTѳiɳѳ    173

TiiTѳiɳѳ
Posted

ja certificaste se não existe essa query ou até mesmo o ID nesse faço e 9028

Se ajudei da +1

Share this post

Link to post
Share on other sites
antiblock
diamwall
  • 0

Kɛɛɗ    519

Kɛɛɗ
Posted

ja certificaste se não existe essa query ou até mesmo o ID nesse faço e 9028

Se ajudei da +1

 

Sim.. 

Share this post

Link to post
Share on other sites
  • 0

TiiTѳiɳѳ    173

TiiTѳiɳѳ
Posted

Quer dizer que já tens esse mob

como eu disse ou já tem esse mob ou tem o mesmo ID já

Kɛɛɗ reacted to this

Share this post

Link to post
Share on other sites
  • 0

Kɛɛɗ    519

Kɛɛɗ
Posted

Quer dizer que já tens esse mob

Ja Olhei toda DB não ah este mob .. 

​não possuí o ID nada relacionado a esta query ... 

Share this post

Link to post
Share on other sites
  • 0

DarkWolf    102

DarkWolf
Posted

lol omg -_-' Kɛɛɗ como queres que as querys entrem se há valores que não estão entre aspas tipo lol assim esquece podes tar ai o resto da ano

Kɛɛɗ reacted to this

Share this post

Link to post
Share on other sites
  • 0

Kɛɛɗ    519

Kɛɛɗ
Posted

lol omg -_-' Kɛɛɗ como queres que as querys entrem se há valores que não estão entre aspas tipo lol assim esquece podes tar ai o resto da ano

 

omg, nem percebi sorry vou ver se consigo criar outra query, caso consiga, adicionar irei le dar :+1: ate fica block por 2 dias assim como esta no final do tópico ty xD

 

Edição ( Para não criar outro post )

 

PS: Não Resultou :c, mais achei um modo que veio a funcionar cujo irei colocar na área de tutoriais, para ajudar futuros administradores de servidores de metin2, a resolverem o erro :D, do mesmo jeito Obrigado e levas +1 assim todos que postaram no tópico para ajudar !

 

Obrigado a todos que tentaram ajudar. 

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  
Followers 0
Go To Question Listing Dúvidas & Pedidos