Ir para conteúdo
  • Cadastre-se
  • 0

Erro "ShowNPCcrest"


MichaelDouglas

Pergunta

Ola A todos tirei a tarde de hoje para organizar meus arquivos
E resolvi limpar o log de erros do meu server quando
Percebi que ao abrir o server ele da um erro de pesquisa
Ao procurar a coluna "ShowNPCcrest"
Sendo que passa tao rapido e quase imperseptivel
Mais por um acaso hoje eu percebi!
acredito que isso seja um mod que minha DB
Nao possua entao quem conhece poderia me da uma luz ?
Acredito que Talves eu so precise
Colocar essa coluna do mod dentro da minha DB
o que vcs acham ?

quem tiver a coluna posta aqui pra min pra testar !?

======================================================================-[ Zone ]
Loading zones...
Initializing ArenaManager
Initializing TownManager
Initializing OlympiadStadiaManager
Initializing CastleManager
java.sql.SQLException: Column 'showNpcCrest' not found.
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
        at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144)
        at com.mysql.jdbc.ResultSetImpl.getBoolean(ResultSetImpl.java:1761)
        at com.mchange.v2.c3p0.impl.NewProxyResultSet.getBoolean(NewProxyResultS
et.java:2391)
        at com.l2jfrozen.gameserver.model.entity.siege.Castle.load(Castle.java:5
70)
        at com.l2jfrozen.gameserver.model.entity.siege.Castle.<init>(Castle.java
:116)
        at com.l2jfrozen.gameserver.managers.CastleManager.load(CastleManager.ja
va:114)
        at com.l2jfrozen.gameserver.managers.CastleManager.<init>(CastleManager.
java:64)
        at com.l2jfrozen.gameserver.managers.CastleManager$SingletonHolder.<clin
it>(CastleManager.java:378)
        at com.l2jfrozen.gameserver.managers.CastleManager.getInstance(CastleMan
ager.java:46)
        at com.l2jfrozen.gameserver.model.zone.type.L2CastleZone.setParameter(L2
CastleZone.java:59)
        at com.l2jfrozen.gameserver.datatables.xml.ZoneData.load(ZoneData.java:5
05)
        at com.l2jfrozen.gameserver.datatables.xml.ZoneData.<init>(ZoneData.java
:104)
        at com.l2jfrozen.gameserver.datatables.xml.ZoneData.getInstance(ZoneData
.java:89)
        at com.l2jfrozen.gameserver.GameServer.main(GameServer.java:337)
java.sql.SQLException: Column 'showNpcCrest' not found.
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
        at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144)
        at com.mysql.jdbc.ResultSetImpl.getBoolean(ResultSetImpl.java:1761)
        at com.mchange.v2.c3p0.impl.NewProxyResultSet.getBoolean(NewProxyResultS
et.java:2391)
        at com.l2jfrozen.gameserver.model.entity.siege.Castle.load(Castle.java:5
70)
        at com.l2jfrozen.gameserver.model.entity.siege.Castle.<init>(Castle.java
:116)
        at com.l2jfrozen.gameserver.managers.CastleManager.load(CastleManager.ja
va:114)
        at com.l2jfrozen.gameserver.managers.CastleManager.<init>(CastleManager.
java:64)
        at com.l2jfrozen.gameserver.managers.CastleManager$SingletonHolder.<clin
it>(CastleManager.java:378)
        at com.l2jfrozen.gameserver.managers.CastleManager.getInstance(CastleMan
ager.java:46)
        at com.l2jfrozen.gameserver.model.zone.type.L2CastleZone.setParameter(L2
CastleZone.java:59)
        at com.l2jfrozen.gameserver.datatables.xml.ZoneData.load(ZoneData.java:5
05)
        at com.l2jfrozen.gameserver.datatables.xml.ZoneData.<init>(ZoneData.java
:104)
        at com.l2jfrozen.gameserver.datatables.xml.ZoneData.getInstance(ZoneData
.java:89)
        at com.l2jfrozen.gameserver.GameServer.main(GameServer.java:337)
java.sql.SQLException: Column 'showNpcCrest' not found.
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
        at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144)
        at com.mysql.jdbc.ResultSetImpl.getBoolean(ResultSetImpl.java:1761)
        at com.mchange.v2.c3p0.impl.NewProxyResultSet.getBoolean(NewProxyResultS
et.java:2391)
        at com.l2jfrozen.gameserver.model.entity.siege.Castle.load(Castle.java:5
70)
        at com.l2jfrozen.gameserver.model.entity.siege.Castle.<init>(Castle.java
:116)
        at com.l2jfrozen.gameserver.managers.CastleManager.load(CastleManager.ja
va:114)
        at com.l2jfrozen.gameserver.managers.CastleManager.<init>(CastleManager.
java:64)
        at com.l2jfrozen.gameserver.managers.CastleManager$SingletonHolder.<clin
it>(CastleManager.java:378)
        at com.l2jfrozen.gameserver.managers.CastleManager.getInstance(CastleMan
ager.java:46)
        at com.l2jfrozen.gameserver.model.zone.type.L2CastleZone.setParameter(L2
CastleZone.java:59)
        at com.l2jfrozen.gameserver.datatables.xml.ZoneData.load(ZoneData.java:5
05)
        at com.l2jfrozen.gameserver.datatables.xml.ZoneData.<init>(ZoneData.java
:104)
        at com.l2jfrozen.gameserver.datatables.xml.ZoneData.getInstance(ZoneData
.java:89)
        at com.l2jfrozen.gameserver.GameServer.main(GameServer.java:337)
java.sql.SQLException: Column 'showNpcCrest' not found.
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
        at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144)
        at com.mysql.jdbc.ResultSetImpl.getBoolean(ResultSetImpl.java:1761)
        at com.mchange.v2.c3p0.impl.NewProxyResultSet.getBoolean(NewProxyResultS
et.java:2391)
        at com.l2jfrozen.gameserver.model.entity.siege.Castle.load(Castle.java:5
70)
        at com.l2jfrozen.gameserver.model.entity.siege.Castle.<init>(Castle.java
:116)
        at com.l2jfrozen.gameserver.managers.CastleManager.load(CastleManager.ja
va:114)
        at com.l2jfrozen.gameserver.managers.CastleManager.<init>(CastleManager.
java:64)
        at com.l2jfrozen.gameserver.managers.CastleManager$SingletonHolder.<clin
it>(CastleManager.java:378)
        at com.l2jfrozen.gameserver.managers.CastleManager.getInstance(CastleMan
ager.java:46)
        at com.l2jfrozen.gameserver.model.zone.type.L2CastleZone.setParameter(L2
CastleZone.java:59)
        at com.l2jfrozen.gameserver.datatables.xml.ZoneData.load(ZoneData.java:5
05)
        at com.l2jfrozen.gameserver.datatables.xml.ZoneData.<init>(ZoneData.java
:104)
        at com.l2jfrozen.gameserver.datatables.xml.ZoneData.getInstance(ZoneData
.java:89)
        at com.l2jfrozen.gameserver.GameServer.main(GameServer.java:337)
java.sql.SQLException: Column 'showNpcCrest' not found.
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
        at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144)
        at com.mysql.jdbc.ResultSetImpl.getBoolean(ResultSetImpl.java:1761)
        at com.mchange.v2.c3p0.impl.NewProxyResultSet.getBoolean(NewProxyResultS
et.java:2391)
        at com.l2jfrozen.gameserver.model.entity.siege.Castle.load(Castle.java:5
70)
        at com.l2jfrozen.gameserver.model.entity.siege.Castle.<init>(Castle.java
:116)
        at com.l2jfrozen.gameserver.managers.CastleManager.load(CastleManager.ja
va:114)
        at com.l2jfrozen.gameserver.managers.CastleManager.<init>(CastleManager.
java:64)
        at com.l2jfrozen.gameserver.managers.CastleManager$SingletonHolder.<clin
it>(CastleManager.java:378)
        at com.l2jfrozen.gameserver.managers.CastleManager.getInstance(CastleMan
ager.java:46)
        at com.l2jfrozen.gameserver.model.zone.type.L2CastleZone.setParameter(L2
CastleZone.java:59)
        at com.l2jfrozen.gameserver.datatables.xml.ZoneData.load(ZoneData.java:5
05)
        at com.l2jfrozen.gameserver.datatables.xml.ZoneData.<init>(ZoneData.java
:104)
        at com.l2jfrozen.gameserver.datatables.xml.ZoneData.getInstance(ZoneData
.java:89)
        at com.l2jfrozen.gameserver.GameServer.main(GameServer.java:337)
java.sql.SQLException: Column 'showNpcCrest' not found.

Alguem poderia ajudar ?

Link para o comentário
Compartilhar em outros sites

6 respostass a esta questão

Posts recomendados


  • 0
Em 13/11/2014 at 21:49, MichaelDouglas disse:

Ola A todos tirei a tarde de hoje para organizar meus arquivos
E resolvi limpar o log de erros do meu server quando
Percebi que ao abrir o server ele da um erro de pesquisa
Ao procurar a coluna "ShowNPCcrest"
Sendo que passa tao rapido e quase imperseptivel
Mais por um acaso hoje eu percebi!
acredito que isso seja um mod que minha DB
Nao possua entao quem conhece poderia me da uma luz ?
Acredito que Talves eu so precise
Colocar essa coluna do mod dentro da minha DB
o que vcs acham ?

quem tiver a coluna posta aqui pra min pra testar !?


======================================================================-[ Zone ]
Loading zones...
Initializing ArenaManager
Initializing TownManager
Initializing OlympiadStadiaManager
Initializing CastleManager
java.sql.SQLException: Column 'showNpcCrest' not found.
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
        at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144)
        at com.mysql.jdbc.ResultSetImpl.getBoolean(ResultSetImpl.java:1761)
        at com.mchange.v2.c3p0.impl.NewProxyResultSet.getBoolean(NewProxyResultS
et.java:2391)
        at com.l2jfrozen.gameserver.model.entity.siege.Castle.load(Castle.java:5
70)
        at com.l2jfrozen.gameserver.model.entity.siege.Castle.<init>(Castle.java
:116)
        at com.l2jfrozen.gameserver.managers.CastleManager.load(CastleManager.ja
va:114)
        at com.l2jfrozen.gameserver.managers.CastleManager.<init>(CastleManager.
java:64)
        at com.l2jfrozen.gameserver.managers.CastleManager$SingletonHolder.<clin
it>(CastleManager.java:378)
        at com.l2jfrozen.gameserver.managers.CastleManager.getInstance(CastleMan
ager.java:46)
        at com.l2jfrozen.gameserver.model.zone.type.L2CastleZone.setParameter(L2
CastleZone.java:59)
        at com.l2jfrozen.gameserver.datatables.xml.ZoneData.load(ZoneData.java:5
05)
        at com.l2jfrozen.gameserver.datatables.xml.ZoneData.<init>(ZoneData.java
:104)
        at com.l2jfrozen.gameserver.datatables.xml.ZoneData.getInstance(ZoneData
.java:89)
        at com.l2jfrozen.gameserver.GameServer.main(GameServer.java:337)
java.sql.SQLException: Column 'showNpcCrest' not found.
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
        at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144)
        at com.mysql.jdbc.ResultSetImpl.getBoolean(ResultSetImpl.java:1761)
        at com.mchange.v2.c3p0.impl.NewProxyResultSet.getBoolean(NewProxyResultS
et.java:2391)
        at com.l2jfrozen.gameserver.model.entity.siege.Castle.load(Castle.java:5
70)
        at com.l2jfrozen.gameserver.model.entity.siege.Castle.<init>(Castle.java
:116)
        at com.l2jfrozen.gameserver.managers.CastleManager.load(CastleManager.ja
va:114)
        at com.l2jfrozen.gameserver.managers.CastleManager.<init>(CastleManager.
java:64)
        at com.l2jfrozen.gameserver.managers.CastleManager$SingletonHolder.<clin
it>(CastleManager.java:378)
        at com.l2jfrozen.gameserver.managers.CastleManager.getInstance(CastleMan
ager.java:46)
        at com.l2jfrozen.gameserver.model.zone.type.L2CastleZone.setParameter(L2
CastleZone.java:59)
        at com.l2jfrozen.gameserver.datatables.xml.ZoneData.load(ZoneData.java:5
05)
        at com.l2jfrozen.gameserver.datatables.xml.ZoneData.<init>(ZoneData.java
:104)
        at com.l2jfrozen.gameserver.datatables.xml.ZoneData.getInstance(ZoneData
.java:89)
        at com.l2jfrozen.gameserver.GameServer.main(GameServer.java:337)
java.sql.SQLException: Column 'showNpcCrest' not found.
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
        at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144)
        at com.mysql.jdbc.ResultSetImpl.getBoolean(ResultSetImpl.java:1761)
        at com.mchange.v2.c3p0.impl.NewProxyResultSet.getBoolean(NewProxyResultS
et.java:2391)
        at com.l2jfrozen.gameserver.model.entity.siege.Castle.load(Castle.java:5
70)
        at com.l2jfrozen.gameserver.model.entity.siege.Castle.<init>(Castle.java
:116)
        at com.l2jfrozen.gameserver.managers.CastleManager.load(CastleManager.ja
va:114)
        at com.l2jfrozen.gameserver.managers.CastleManager.<init>(CastleManager.
java:64)
        at com.l2jfrozen.gameserver.managers.CastleManager$SingletonHolder.<clin
it>(CastleManager.java:378)
        at com.l2jfrozen.gameserver.managers.CastleManager.getInstance(CastleMan
ager.java:46)
        at com.l2jfrozen.gameserver.model.zone.type.L2CastleZone.setParameter(L2
CastleZone.java:59)
        at com.l2jfrozen.gameserver.datatables.xml.ZoneData.load(ZoneData.java:5
05)
        at com.l2jfrozen.gameserver.datatables.xml.ZoneData.<init>(ZoneData.java
:104)
        at com.l2jfrozen.gameserver.datatables.xml.ZoneData.getInstance(ZoneData
.java:89)
        at com.l2jfrozen.gameserver.GameServer.main(GameServer.java:337)
java.sql.SQLException: Column 'showNpcCrest' not found.
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
        at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144)
        at com.mysql.jdbc.ResultSetImpl.getBoolean(ResultSetImpl.java:1761)
        at com.mchange.v2.c3p0.impl.NewProxyResultSet.getBoolean(NewProxyResultS
et.java:2391)
        at com.l2jfrozen.gameserver.model.entity.siege.Castle.load(Castle.java:5
70)
        at com.l2jfrozen.gameserver.model.entity.siege.Castle.<init>(Castle.java
:116)
        at com.l2jfrozen.gameserver.managers.CastleManager.load(CastleManager.ja
va:114)
        at com.l2jfrozen.gameserver.managers.CastleManager.<init>(CastleManager.
java:64)
        at com.l2jfrozen.gameserver.managers.CastleManager$SingletonHolder.<clin
it>(CastleManager.java:378)
        at com.l2jfrozen.gameserver.managers.CastleManager.getInstance(CastleMan
ager.java:46)
        at com.l2jfrozen.gameserver.model.zone.type.L2CastleZone.setParameter(L2
CastleZone.java:59)
        at com.l2jfrozen.gameserver.datatables.xml.ZoneData.load(ZoneData.java:5
05)
        at com.l2jfrozen.gameserver.datatables.xml.ZoneData.<init>(ZoneData.java
:104)
        at com.l2jfrozen.gameserver.datatables.xml.ZoneData.getInstance(ZoneData
.java:89)
        at com.l2jfrozen.gameserver.GameServer.main(GameServer.java:337)
java.sql.SQLException: Column 'showNpcCrest' not found.
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
        at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144)
        at com.mysql.jdbc.ResultSetImpl.getBoolean(ResultSetImpl.java:1761)
        at com.mchange.v2.c3p0.impl.NewProxyResultSet.getBoolean(NewProxyResultS
et.java:2391)
        at com.l2jfrozen.gameserver.model.entity.siege.Castle.load(Castle.java:5
70)
        at com.l2jfrozen.gameserver.model.entity.siege.Castle.<init>(Castle.java
:116)
        at com.l2jfrozen.gameserver.managers.CastleManager.load(CastleManager.ja
va:114)
        at com.l2jfrozen.gameserver.managers.CastleManager.<init>(CastleManager.
java:64)
        at com.l2jfrozen.gameserver.managers.CastleManager$SingletonHolder.<clin
it>(CastleManager.java:378)
        at com.l2jfrozen.gameserver.managers.CastleManager.getInstance(CastleMan
ager.java:46)
        at com.l2jfrozen.gameserver.model.zone.type.L2CastleZone.setParameter(L2
CastleZone.java:59)
        at com.l2jfrozen.gameserver.datatables.xml.ZoneData.load(ZoneData.java:5
05)
        at com.l2jfrozen.gameserver.datatables.xml.ZoneData.<init>(ZoneData.java
:104)
        at com.l2jfrozen.gameserver.datatables.xml.ZoneData.getInstance(ZoneData
.java:89)
        at com.l2jfrozen.gameserver.GameServer.main(GameServer.java:337)
java.sql.SQLException: Column 'showNpcCrest' not found.

 

Alguem poderia ajudar ?

 

 

9 horas atrás, DevilBoy disse:

estou com o mesmo erro :/

Procura aqui no forum que esse mod já existe... faça a comparação do codigo do mod e do que vc's tem... oque tiver faltando, modifique :D

Link para o comentário
Compartilhar em outros sites

  • 0
3 minutos atrás, Levy disse:

Basta criar uma coluna dentro da tabela castle, com o nome de showNpcCrest , do tipo bolleano.

Só criar a tabela, sem as especificação do que tem dentro... vai continuar o erro

Link para o comentário
Compartilhar em outros sites

  • 0
2 minutos atrás, Brayan000 disse:

Só criar a tabela, sem as especificação do que tem dentro... vai continuar o erro

true ou false. Isso é o tipo bolleano. Por isso nao especifiquei o que tinha dentro da coluna, porque quando cria tipo bolleano, ele ja adiciona true e false.
showNpcCrest    enum    0    0    0    0    0    0    0    false    0        utf8    utf8_general_ci    'true','false'    0    0
 

Editado por Levy
Cria assim

19028-361.gif

Link para o comentário
Compartilhar em outros sites

  • 0
  • L2JBr ADM

Seu banco de dados deve ser de uma versão anterior ou superior (acredito que inferior) do emulador, isso acontece quando você atualiza apenas os binários do gameserver/loginserver e esquece de atualizar o banco de dados também recomendo fazer a reeinstalação do servidor e aplicar a migração 

 

Temporariamente vc pode desabilitar o mod editando a referente linha do arquivo abaixo

config/functions/l2jfrozen.properties

 

# Show clan, alliance crests for territory NPC's.
# Default: False
ShowNpcCrest = True

EJoOSOj.gif

Sua pergunta foi respondida? Certifique-se de marcar a resposta como a solução aceita.
Se existe mais de uma resposta, utilize o "vote up" para destacá-la.
Se você achar uma resposta útil, diga obrigado clicando no botão "Gostei".

Link para o comentário
Compartilhar em outros sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Visitante
Responder esta pergunta...

×   Você colou conteúdo com formatação.   Remover formatação

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Processando...
  • Registre-se

    Faça parte da maior e  mais antigas comunidades sobre Lineage2 da América Latina.





×
×
  • Criar Novo...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.