Autor Tema: Consulta -Mensaje Auction Data  (Leído 216 veces)

Mordor

  • Jr. Member
  • **
  • Mensajes: 83
  • Karma: +0/-0
    • Ver Perfil
Consulta -Mensaje Auction Data
« en: Mayo 04, 2018, 06:07:10 pm »
Hola, buenas tardes, tengo una duda con respecto a un mensaje que me sale en la consola cuando dentro del game habilito un hall a cualquier clan al tirar restart y cargar los halls me figura lo siguiente:

Código
---------------------------------------------------------------=[ Clan Halls ]
AuctionData: Exception: Auction.initNPC(): Erreur de syntaxe prÞs de '%' Ó la li
gne 1com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Erreur de syntax
e prÞs de '%' Ó la ligne 1
AuctionData: Exception: Auction.initNPC(): Erreur de syntaxe prÞs de '%' Ó la li
gne 1com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Erreur de syntax
e prÞs de '%' Ó la ligne 1
ClanHallManager: Loaded 30 clan halls.

Nose si es porque lo habilite con el admin o porque no lo hice desde el auctioner.

fissban

  • Administrador
  • Full Member
  • *
  • Mensajes: 196
  • Karma: +0/-0
    • Ver Perfil
Re:Consulta -Mensaje Auction Data
« Respuesta #1 en: Mayo 05, 2018, 04:26:12 am »
chequea este "fix"

Código
Index: java/net/sf/l2j/gameserver/data/AuctionData.java
===================================================================
--- java/net/sf/l2j/gameserver/data/AuctionData.java (revision 1040)
+++ java/net/sf/l2j/gameserver/data/AuctionData.java (working copy)
@@ -152,7 +152,7 @@
  }
 
  try (Connection con = L2DatabaseFactory.getInstance().getConnection();
- PreparedStatement statement = con.prepareStatement(INSERT.replace("%item", ITEM_INIT_DATA[i])))
+ PreparedStatement statement = con.prepareStatement(INSERT.replace("%item%", ITEM_INIT_DATA[i])))
  {
  statement.execute();
  LOG.info(AuctionData.class.getSimpleName() + ": Created auction for ClanHall: " + id);

Mordor

  • Jr. Member
  • **
  • Mensajes: 83
  • Karma: +0/-0
    • Ver Perfil
Re:Consulta -Mensaje Auction Data
« Respuesta #2 en: Mayo 05, 2018, 11:32:01 am »
Ahora me sale esto en la consola:
Código
---------------------------------------------------------------=[ Clan Halls ]
AuctionData: Exception: Auction.initNPC(): Column count doesn't match value coun
t at row 1java.sql.SQLException: Column count doesn't match value count at row 1

AuctionData: Exception: Auction.initNPC(): Column count doesn't match value coun
t at row 1java.sql.SQLException: Column count doesn't match value count at row 1

fissban

  • Administrador
  • Full Member
  • *
  • Mensajes: 196
  • Karma: +0/-0
    • Ver Perfil
Re:Consulta -Mensaje Auction Data
« Respuesta #3 en: Mayo 05, 2018, 12:45:46 pm »
bueno a adivinar se ah dicho xD

Código
Index: java/net/sf/l2j/gameserver/data/AuctionData.java
===================================================================
--- java/net/sf/l2j/gameserver/data/AuctionData.java (revision 1040)
+++ java/net/sf/l2j/gameserver/data/AuctionData.java (working copy)
@@ -36,33 +36,33 @@
 
  private static final String[] ITEM_INIT_DATA =
  {
- "(22, 0, 'NPC', 'Moonstone Hall', 20000000, 0, 1164841200000)",
- "(23, 0, 'NPC', 'Onyx Hall', 20000000, 0, 1164841200000)",
- "(24, 0, 'NPC', 'Topaz Hall', 20000000, 0, 1164841200000)",
- "(25, 0, 'NPC', 'Ruby Hall', 20000000, 0, 1164841200000)",
- "(26, 0, 'NPC', 'Crystal Hall', 20000000, 0, 1164841200000)",
- "(27, 0, 'NPC', 'Onyx Hall', 20000000, 0, 1164841200000)",
- "(28, 0, 'NPC', 'Sapphire Hall', 20000000, 0, 1164841200000)",
- "(29, 0, 'NPC', 'Moonstone Hall', 20000000, 0, 1164841200000)",
- "(30, 0, 'NPC', 'Emerald Hall', 20000000, 0, 1164841200000)",
- "(31, 0, 'NPC', 'The Atramental Barracks', 8000000, 0, 1164841200000)",
- "(32, 0, 'NPC', 'The Scarlet Barracks', 8000000, 0, 1164841200000)",
- "(33, 0, 'NPC', 'The Viridian Barracks', 8000000, 0, 1164841200000)",
- "(36, 0, 'NPC', 'The Golden Chamber', 50000000, 0, 1164841200000)",
- "(37, 0, 'NPC', 'The Silver Chamber', 50000000, 0, 1164841200000)",
- "(38, 0, 'NPC', 'The Mithril Chamber', 50000000, 0, 1164841200000)",
- "(39, 0, 'NPC', 'Silver Manor', 50000000, 0, 1164841200000)",
- "(40, 0, 'NPC', 'Gold Manor', 50000000, 0, 1164841200000)",
- "(41, 0, 'NPC', 'The Bronze Chamber', 50000000, 0, 1164841200000)",
- "(42, 0, 'NPC', 'The Golden Chamber', 50000000, 0, 1164841200000)",
- "(43, 0, 'NPC', 'The Silver Chamber', 50000000, 0, 1164841200000)",
- "(44, 0, 'NPC', 'The Mithril Chamber', 50000000, 0, 1164841200000)",
- "(45, 0, 'NPC', 'The Bronze Chamber', 50000000, 0, 1164841200000)",
- "(46, 0, 'NPC', 'Silver Manor', 50000000, 0, 1164841200000)",
- "(47, 0, 'NPC', 'Moonstone Hall', 50000000, 0, 1164841200000)",
- "(48, 0, 'NPC', 'Onyx Hall', 50000000, 0, 1164841200000)",
- "(49, 0, 'NPC', 'Emerald Hall', 50000000, 0, 1164841200000)",
- "(50, 0, 'NPC', 'Sapphire Hall', 50000000, 0, 1164841200000)"
+ "(22, 0, 'NPC', 22, 'Moonstone Hall', 20000000, 0, 1164841200000)",
+ "(23, 0, 'NPC', 23, 'Onyx Hall', 20000000, 0, 1164841200000)",
+ "(24, 0, 'NPC', 24, 'Topaz Hall', 20000000, 0, 1164841200000)",
+ "(25, 0, 'NPC', 25, 'Ruby Hall', 20000000, 0, 1164841200000)",
+ "(26, 0, 'NPC', 26, 'Crystal Hall', 20000000, 0, 1164841200000)",
+ "(27, 0, 'NPC', 27, 'Onyx Hall', 20000000, 0, 1164841200000)",
+ "(28, 0, 'NPC', 28, 'Sapphire Hall', 20000000, 0, 1164841200000)",
+ "(29, 0, 'NPC', 29, 'Moonstone Hall', 20000000, 0, 1164841200000)",
+ "(30, 0, 'NPC', 30, 'Emerald Hall', 20000000, 0, 1164841200000)",
+ "(31, 0, 'NPC', 31, 'The Atramental Barracks', 8000000, 0, 1164841200000)",
+ "(32, 0, 'NPC', 32, 'The Scarlet Barracks', 8000000, 0, 1164841200000)",
+ "(33, 0, 'NPC', 33, 'The Viridian Barracks', 8000000, 0, 1164841200000)",
+ "(36, 0, 'NPC', 36, 'The Golden Chamber', 50000000, 0, 1164841200000)",
+ "(37, 0, 'NPC', 37, 'The Silver Chamber', 50000000, 0, 1164841200000)",
+ "(38, 0, 'NPC', 38, 'The Mithril Chamber', 50000000, 0, 1164841200000)",
+ "(39, 0, 'NPC', 39, 'Silver Manor', 50000000, 0, 1164841200000)",
+ "(40, 0, 'NPC', 40, 'Gold Manor', 50000000, 0, 1164841200000)",
+ "(41, 0, 'NPC', 41, 'The Bronze Chamber', 50000000, 0, 1164841200000)",
+ "(42, 0, 'NPC', 42, 'The Golden Chamber', 50000000, 0, 1164841200000)",
+ "(43, 0, 'NPC', 43, 'The Silver Chamber', 50000000, 0, 1164841200000)",
+ "(44, 0, 'NPC', 44, 'The Mithril Chamber', 50000000, 0, 1164841200000)",
+ "(45, 0, 'NPC', 45, 'The Bronze Chamber', 50000000, 0, 1164841200000)",
+ "(46, 0, 'NPC', 46, 'Silver Manor', 50000000, 0, 1164841200000)",
+ "(47, 0, 'NPC', 47, 'Moonstone Hall', 50000000, 0, 1164841200000)",
+ "(48, 0, 'NPC', 48, 'Onyx Hall', 50000000, 0, 1164841200000)",
+ "(49, 0, 'NPC', 49, 'Emerald Hall', 50000000, 0, 1164841200000)",
+ "(50, 0, 'NPC', 50, 'Sapphire Hall', 50000000, 0, 1164841200000)"
  };
 
  //@formatter:off
@@ -152,7 +152,7 @@
  }
 
  try (Connection con = L2DatabaseFactory.getInstance().getConnection();
- PreparedStatement statement = con.prepareStatement(INSERT.replace("%item", ITEM_INIT_DATA[i])))
+ PreparedStatement statement = con.prepareStatement(INSERT.replace("%item%", ITEM_INIT_DATA[i])))
  {
  statement.execute();
  LOG.info(AuctionData.class.getSimpleName() + ": Created auction for ClanHall: " + id);

Mordor

  • Jr. Member
  • **
  • Mensajes: 83
  • Karma: +0/-0
    • Ver Perfil
Re:Consulta -Mensaje Auction Data
« Respuesta #4 en: Mayo 05, 2018, 12:59:44 pm »
jaja noop xD

Código
---------------------------------------------------------------=[ Clan Halls ]
AuctionData: Exception: Auction.initNPC(): Column count doesn't match value coun
t at row 1java.sql.SQLException: Column count doesn't match value count at row 1

AuctionData: Exception: Auction.initNPC(): Column count doesn't match value coun
t at row 1java.sql.SQLException: Column count doesn't match value count at row 1

ClanHallManager: Loaded 30 clan halls.