Jump to content
  • 0

Help - [Il] Server Creation - Stuck On Charselect Screen


mercy4darkness

Question

Yo Guyz,

 

its been quiet some time since i was here or at L2 at all.

So i wanted to create a little Server for myself and friends (Just playing Lan and stuff) cause privat servers nowdays kinda suck. I played this game for about 12 years but never tryed to create a server at all, so i ll admit i am kind of a total noob in this.

 

Anyway. I followed tons of diffrent guides since 99% of the Links postet in them are broken due their age but ended up succeding.

The Main Problem now is that i cant get past the Character Selection Screen, i can create one but as soon i want to log-in - nothing happens.

 

Game Server Console gives me this error:

 

Client was not online --> New Client Connection
Could not restore char data:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'lastV
oteHopzone' in 'field list'
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
 
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
        at com.mysql.jdbc.Util.getInstance(Util.java:382)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:2119)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
2281)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPr
oxyPreparedStatement.java:76)
        at com.l2jfrozen.gameserver.model.actor.instance.L2PcInstance.restore(L2
PcInstance.java:10243)
        at com.l2jfrozen.gameserver.model.actor.instance.L2PcInstance.load(L2PcI
nstance.java:1728)
        at com.l2jfrozen.gameserver.network.L2GameClient.loadCharFromDisk(L2Game
Client.java:575)
        at com.l2jfrozen.gameserver.network.clientpackets.CharacterSelected.runI
mpl(CharacterSelected.java:67)
        at com.l2jfrozen.gameserver.network.clientpackets.L2GameClientPacket.run
(L2GameClientPacket.java:75)
        at com.l2jfrozen.gameserver.network.L2GameClient.run(L2GameClient.java:1
196)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
DEBUG [C] 0D CharacterSelected: Character could not be loaded (slot:0)
Could not restore char data:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'lastV
oteHopzone' in 'field list'
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
 
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
        at com.mysql.jdbc.Util.getInstance(Util.java:382)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:2119)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
2281)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPr
oxyPreparedStatement.java:76)
        at com.l2jfrozen.gameserver.model.actor.instance.L2PcInstance.restore(L2
PcInstance.java:10243)
        at com.l2jfrozen.gameserver.model.actor.instance.L2PcInstance.load(L2PcI
nstance.java:1728)
        at com.l2jfrozen.gameserver.network.L2GameClient.loadCharFromDisk(L2Game
Client.java:575)
        at com.l2jfrozen.gameserver.network.clientpackets.CharacterSelected.runI
mpl(CharacterSelected.java:67)
        at com.l2jfrozen.gameserver.network.clientpackets.L2GameClientPacket.run
(L2GameClientPacket.java:75)
        at com.l2jfrozen.gameserver.network.L2GameClient.run(L2GameClient.java:1
196)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
DEBUG [C] 0D CharacterSelected: Character could not be loaded (slot:0)
 
 
 
 
As i already mentioned - i dont understand to much of this yet. Seems to me that there is something fuked up on my Java?
For recreation - this was used:
 
-Navicat Premium Essentials
 
Followed this guides (mainly):
 
If any1 knows where i fuked up, i would realy appreciate some help
(SkypeID: Mercy4darkness90)
 
Ty :)
 
Link to comment
Share on other sites

15 answers to this question

Recommended Posts

  • 0

Stop using shared / preconfigured packs, especially when they are not fully shared. As the error says, you miss some rows in character table.

Link to comment
Share on other sites

  • 0

That says everything.

 

Stop using shared / preconfigured packs, especially when they are not fully shared. As the error says, you miss some rows in character table.

 

i would love to use a clean one, but all links are down and i didnt find one.....

Link to comment
Share on other sites

  • 0
  • 0

Nice, thanks alot.

Downloaded it and trying to get something to run, but on all the tutorials it looks kinda diffrent. You happen to know a tutorial for this clean pack?

Would mean alot to me. 

 

thanks for all the effort

Link to comment
Share on other sites

  • 0

You have to download it with eclipse svn repositories then check out the aCis_datapack and aCis_gameserver just right click check out and finish..when both is ready and on left side in eclipse just build.xml right click and compile both...

When you are ready with this make a file on your desktop go to workspace aCis_gameserver dist copy gameserver and login paste to the new folder...then go acis_datapack copy sql and tools file paste them to the new file..then from acis datapack copy file data and go to new file gameserver file paste there the data file..make this for the start

P.s you need java 1.8

Link to comment
Share on other sites

  • 0

People don't know to make short tutorials, they prefer to shit for 10min while it can be done within 1min ^_^

 

http://acis.i-live.eu/index.php?topic=78.msg20903#msg20903

Link to comment
Share on other sites

  • 0

People don't know to make short tutorials, they prefer to shit for 10min while it can be done within 1min ^_^

 

http://acis.i-live.eu/index.php?topic=78.msg20903#msg20903

Yes obviously a tutorial with photos is 2 min a tutorial with video is 10 min, a tutorial with video + explanation of what is every program is 30-40 minute. Isn't this normal?

Link to comment
Share on other sites

  • 0

People don't know to make short tutorials, they prefer to shit for 10min while it can be done within 1min ^_^

 

http://acis.i-live.eu/index.php?topic=78.msg20903#msg20903

thanks so much! you´re my heroine ^_^

Link to comment
Share on other sites

  • 0

Yes obviously a tutorial with photos is 2 min a tutorial with video is 10 min, a tutorial with video + explanation of what is every program is 30-40 minute. Isn't this normal?

I didint mind how long it takes, i am glad there was Vid + explanation.

Finally managed to get out the Errors =) ! thx to you as well!

Link to comment
Share on other sites

  • 0

Sorry to bother, but could one of you ladies or some1 else explain me why i can´t add this SQL for npc buffer at navicat?

 

http://www.maxcheaters.com/topic/150892-interlude-buffer-l2frozen/?hl=%2Binterlude+%2Bbuffer

 

-> always gives me this error:

 

[Err] 1146 - Table 'acis.npc' doesn't exist
[Err] INSERT INTO npc
   (`id`, `idTemplate`, `name`, `serverSideName`, `title`, `serverSideTitle`, `class`, `collision_radius`, `collision_height`, `level`, `sex`, `type`, `attackrange`, `hp`, `mp`, `hpreg`, `mpreg`, `str`, `con`, `dex`, `int`, `wit`, `men`, `exp`, `sp`, `patk`, `pdef`, `matk`, `mdef`, `atkspd`, `aggro`, `matkspd`, `rhand`, `lhand`, `armor`, `walkspd`, `runspd`, `faction_id`, `faction_range`, `isUndead`, `absorb_level`, `absorb_type`)
VALUES
   (9999, 31855, 'Galatea', 1, "[-> Buffer <-]", 1, 'NPC.a_traderA_MHuman', 08.00, 24.00, 70, 'Male', 'L2Npc', 40, 3862, 1493, 11.85, 2.78, 40, 43, 30, 21, 20, 10, 0, 0, 1314, 470, 780, 382, 278, 0, 333, 0, 0, 0, 55, 132, NULL, 0, 1, 0, 'LAST_HIT');
[Msg] Finished - Unsuccessfully
Link to comment
Share on other sites

  • 0

Yes obviously a tutorial with photos is 2 min a tutorial with video is 10 min, a tutorial with video + explanation of what is every program is 30-40 minute. Isn't this normal?

Nop, u sux ^.^

 

Locked.

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.


  • Posts

    • Shaper price updated to 700e. 
    • very trusted and very skilled developer, good luck with your project and sales!
    • There is nothing you can do about it, as Tryskell said forums are "deprecated" now and 95 % of the people use Discord as it offers everything and fast. Also MMO games are mostly dead so I don't know what community you expect to attract. 
    • Welcome to my store :  https://topestore.mysellix.io/fr/ 2015-2022 Aged Discord Account 2015 Discord Account : 50.99 $ 2016 Discord Account : 10$ 2017 Discord Account :3.99 $ 2018 Discord Account : 3.50$ 2019 Discord Account : 2.70 $ 2020 Discord Account :1.50$ 2021 Discord Account :0.99$ 2022 Discord Account :0.70$ Warranty :Lifetime Payment Methods : Crypto/ PayPal Contact Me On Discord Or Telegram Discord : @ultrasstore11 Telegram : https://t.me/ultrastore11      QUOTE    0   Welcome to my store :  https://topestore.mysellix.io/fr/ 2015-2022 Aged Discord Account 2015 Discord Account : 50.99 $ 2016 Discord Account : 10$ 2017 Discord Account :3.99 $ 2018 Discord Account : 3.50$ 2019 Discord Account : 2.70 $ 2020 Discord Account :1.50$ 2021 Discord Account :0.99$ 2022 Discord Account :0.70$ Warranty :Lifetime Payment Methods : Crypto/ PayPal Contact Me On Discord Or Telegram Discord : @ultrasstore11 Telegram : https://t.me/ultrastore11      QUOTE    0   Welcome to my store :  https://topestore.mysellix.io/fr/ 2015-2022 Aged Discord Account 2015 Discord Account : 50.99 $ 2016 Discord Account : 10$ 2017 Discord Account :3.99 $ 2018 Discord Account : 3.50$ 2019 Discord Account : 2.70 $ 2020 Discord Account :1.50$ 2021 Discord Account :0.99$ 2022 Discord Account :0.70$ Warranty :Lifetime Payment Methods : Crypto/ PayPal Contact Me On Discord Or Telegram Discord : @ultrasstore11 Telegram : https://t.me/ultrastore11      QUOTE    0   Welcome to my store :  https://topestore.mysellix.io/fr/ 2015-2022 Aged Discord Account 2015 Discord Account : 50.99 $ 2016 Discord Account : 10$ 2017 Discord Account :3.99 $ 2018 Discord Account : 3.50$ 2019 Discord Account : 2.70 $ 2020 Discord Account :1.50$ 2021 Discord Account :0.99$ 2022 Discord Account :0.70$ Warranty :Lifetime Payment Methods : Crypto/ PayPal Contact Me On Discord Or Telegram Discord : @ultrasstore11 Telegram : https://t.me/ultrastore11      QUOTE    0  
  • Topics

×
×
  • Create New...