Jump to content

Recommended Posts

Posted

i cant add this buffer :(

 

i dont now about init_py i need just the html file and the sql and i find a lots of problems with sql all the time appears error.:: :(

 

If you expect help, we need error log and description of your problem(s)

Posted

This is Error log with Buffer errors :F

 

15.12.2010 9:06:26 com.l2jserver.gameserver.model.quest.Quest showError
WARNING: D:\l2j\gameserver\data\scripts\custom\555_NPCBUFFER\__init__.py
Traceback (innermost last):
  (no code object) at line 0
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

at java.lang.reflect.Constructor.newInstance(Unknown Source)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)

at com.mysql.jdbc.Util.getInstance(Util.java:384)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2275)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)


com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'l2jdb.buffer_scheme_list' doesn't exist

at org.python.core.Py.JavaError(Unknown Source)
at org.python.core.PyObject._jthrow(Unknown Source)
at org.python.core.PyObject._jcall(Unknown Source)
at org.python.proxies.main$Quest$426.onFirstTalk(Unknown Source)
at com.l2jserver.gameserver.model.quest.Quest.notifyFirstTalk(Quest.java:506)
at handlers.actionhandlers.L2NpcAction.action(L2NpcAction.java:139)
at com.l2jserver.gameserver.model.L2Object.onAction(L2Object.java:275)
at com.l2jserver.gameserver.model.L2Object.onAction(L2Object.java:268)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.doInteract(L2PcInstance.java:4625)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance$AIAccessor.doInteract(L2PcInstance.java:361)
at com.l2jserver.gameserver.ai.L2PlayerAI.thinkInteract(L2PlayerAI.java:324)
at com.l2jserver.gameserver.ai.L2PlayerAI.onEvtThink(L2PlayerAI.java:349)
at com.l2jserver.gameserver.ai.L2CharacterAI.onEvtArrived(L2CharacterAI.java:704)
at com.l2jserver.gameserver.ai.AbstractAI.notifyEvent(AbstractAI.java:452)
at com.l2jserver.gameserver.ai.AbstractAI.notifyEvent(AbstractAI.java:339)
at com.l2jserver.gameserver.GameTimeController$MovingObjectArrived.run(GameTimeController.java:210)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Posted

This is Error log with Buffer errors :F

 

15.12.2010 9:06:26 com.l2jserver.gameserver.model.quest.Quest showError
WARNING: D:\l2j\gameserver\data\scripts\custom\555_NPCBUFFER\__init__.py
Traceback (innermost last):
  (no code object) at line 0
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

at java.lang.reflect.Constructor.newInstance(Unknown Source)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)

at com.mysql.jdbc.Util.getInstance(Util.java:384)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2275)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)


com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'l2jdb.buffer_scheme_list' doesn't exist

at org.python.core.Py.JavaError(Unknown Source)
at org.python.core.PyObject._jthrow(Unknown Source)
at org.python.core.PyObject._jcall(Unknown Source)
at org.python.proxies.main$Quest$426.onFirstTalk(Unknown Source)
at com.l2jserver.gameserver.model.quest.Quest.notifyFirstTalk(Quest.java:506)
at handlers.actionhandlers.L2NpcAction.action(L2NpcAction.java:139)
at com.l2jserver.gameserver.model.L2Object.onAction(L2Object.java:275)
at com.l2jserver.gameserver.model.L2Object.onAction(L2Object.java:268)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.doInteract(L2PcInstance.java:4625)
at com.l2jserver.gameserver.model.actor.instance.L2PcInstance$AIAccessor.doInteract(L2PcInstance.java:361)
at com.l2jserver.gameserver.ai.L2PlayerAI.thinkInteract(L2PlayerAI.java:324)
at com.l2jserver.gameserver.ai.L2PlayerAI.onEvtThink(L2PlayerAI.java:349)
at com.l2jserver.gameserver.ai.L2CharacterAI.onEvtArrived(L2CharacterAI.java:704)
at com.l2jserver.gameserver.ai.AbstractAI.notifyEvent(AbstractAI.java:452)
at com.l2jserver.gameserver.ai.AbstractAI.notifyEvent(AbstractAI.java:339)
at com.l2jserver.gameserver.GameTimeController$MovingObjectArrived.run(GameTimeController.java:210)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

 

 

Strange.... ??? I Hadn'd errors on adding this perfect  BUffer... What is your chronicle? and project?

 

 

Ps:One of the Best Buffers from me... It contains everything... Amazing Thanks For share

Posted

I got error  :D

 

[Err] 1264 - Out of range value for column 'patk' at row 1

[Err] REPLACE INTO `npc` VALUES(555, 18544, 'Buffer', 1, 'Edited by Z!T!oN', 1, 'LineageNpcEV.trap_ironcastle', '8', '24', 85, 'male', 'L2Npc', 40, '680', '1820', '0.00', '0.00', 40, 43, 30, 21, 20, 20, 0, 14, 101400, 6, 307525, 230, 1, 1, 0, 0, 0, 27, 120, 0, 0, 0, 0, 0, 1);

 

........

 

INSERT INTO `buffer_buff_list` VALUES ('1', '0', 'buff', '1036', '2', '2', '1');

INSERT INTO `buffer_buff_list` VALUES ('28', '0', 'special', '1323', '1', '3', '1');

INSERT INTO `buffer_buff_list` VALUES ('31', '1', 'song', '264', '1', '2', '1');

 

INSERT INTO `buff

[Msg] Finished - Unsuccessfully

--------------------------------------------------

 

Posted

On corruption issues have been fixed Unclosed connection in this version?

 

Dec 30, 2010 6:15:02 AM com.l2jserver.L2DatabaseFactory$ConnectionCloser run

WARNING: Unclosed connection! Trace: sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source)

java.lang.RuntimeException

at com.l2jserver.L2DatabaseFactory.getConnection(L2DatabaseFactory.java:227)

at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.python.core.PyReflectedFunction.__call__(Unknown Source)

at org.python.core.PyMethod.__call__(Unknown Source)

at org.python.core.PyObject.__call__(Unknown Source)

at org.python.core.PyInstance.invoke(Unknown Source)

at org.python.pycode.serializable._pyx1293660807218.buildHtml$19(__init__.py:344)

at org.python.pycode.serializable._pyx1293660807218.call_function(__init__.py)

at org.python.core.PyTableCode.call(Unknown Source)

at org.python.core.PyTableCode.call(Unknown Source)

at org.python.core.PyFunction.__call__(Unknown Source)

at org.python.pycode.serializable._pyx1293660807218.onAdvEvent$14(__init__.py:831)

at org.python.pycode.serializable._pyx1293660807218.call_function(__init__.py)

at org.python.core.PyTableCode.call(Unknown Source)

at org.python.core.PyTableCode.call(Unknown Source)

at org.python.core.PyTableCode.call(Unknown Source)

at org.python.core.PyFunction.__call__(Unknown Source)

at org.python.core.PyMethod.__call__(Unknown Source)

at org.python.core.PyObject.__call__(Unknown Source)

at org.python.core.PyObject._jcallexc(Unknown Source)

at org.python.core.PyObject._jcall(Unknown Source)

at org.python.proxies.main$Quest$427.onAdvEvent(Unknown Source)

at com.l2jserver.gameserver.model.quest.Quest.notifyEvent(Quest.java:448)

at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.processQuestEvent(L2PcInstance.java:1806)

at com.l2jserver.gameserver.network.clientpackets.RequestBypassToServer.runImpl(RequestBypassToServer.java:212)

at com.l2jserver.gameserver.network.clientpackets.L2GameClientPacket.run(L2GameClientPacket.java:62)

at com.l2jserver.gameserver.network.L2GameClient.run(L2GameClient.java:1001)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

[/Quote]

Posted

Nice share :) but i have a problem , everything is perfect but in the Buff section i have only 1 buff which is Magic Barrier the rest are not to be found :( how can i add them? even tho they are in navicat?

Guest
This topic is now closed to further replies.



  • Posts

    • https://prnt.sc/Bkkc0ShGXv9m https://prnt.sc/-JFLvZXsn27A
    • Hello guys want to sell adena in L2 Reborn Signature x1  Stock =14kk good price 
    • Hi guys, I have the following problem, I want to set up two servers on the same dedicated server and I can't.   L2jacis 409 Linux Server. The first gameserver has the following configuration: # ================================================================ # Gameserver setting # ================================================================ # This is transmitted to the clients, so it has to be an IP or resolvable hostname. If this ip is resolvable by Login just leave * Hostname = 190.25.103.103 # Bind ip of the gameserver, use * to bind on all available IPs. GameserverHostname = * GameserverPort = 7777 # The Loginserver host and port. LoginHost = 127.0.0.1 LoginPort = 9014 # This is the server id that the gameserver will request. RequestServerID = 1 # If set to true, the login will give an other id to the server (if the requested id is already reserved). AcceptAlternateID = True UseBlowfishCipher = True # ================================================================ # Database informations # ================================================================ URL = jdbc:mariadb://localhost/server1 Login = server1 Password = server1 I configured the second gameserver like this:   # ================================================================ # Gameserver setting # ================================================================ # This is transmitted to the clients, so it has to be an IP or resolvable hostname. If this ip is resolvable by Login just leave * Hostname = 0.0.0.0 # Bind ip of the gameserver, use * to bind on all available IPs. GameserverHostname = * GameserverPort = 7788 # The Loginserver host and port. LoginHost = 127.0.0.1 LoginPort = 9014 # This is the server id that the gameserver will request. RequestServerID = 2 # If set to true, the login will give an other id to the server (if the requested id is already reserved). AcceptAlternateID = True UseBlowfishCipher = True # ================================================================ # Database informations # ================================================================ URL = jdbc:mariadb://localhost/server2 Login = server2 Password = server2 apart from having tested 0.0.0.0 on the second gameserver I also tried 127.0.0.1 In both cases I see the two servers in the login when I log in, but I try to enter the one with the lowest ping and it kicks me out. The other server always appears with ping 9999 and I try to enter but it doesn't do anything and it freezes the login so I have to log in again. The hexids are in their respective folders. For server 1, it has its hexid inside the gameserver config folder, and I checked that the hexid id is the same id, for example id 1 in the gameserver is also id1 for server 1, and hexid 2 has its hexid 2 for server 2. The server ports are open and listening when I turn on both gameservers. I really don't know what could be wrong. If you could give me some help I would appreciate it. Excuse my English.
    • We have both old channels from 2006-2009 with the 3rd verification function enabled, and new ones.   For availability, please contact us below: Link - Telegram Link - Facebook WhatsApp - Click here to go to WhatsApp chat
    • You can contact me on skype: niedziolek50
  • Topics

×
×
  • Create New...