Jump to content
--> Place your ad text here <--
Get Free Banners - Giveaway MaxCheaters.com
We're Rebuilding – Join Our Staff Team
  • 0

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

mercy4darkness

Asked by mercy4darkness,

 Share

Question

mercy4darkness Newbie

mercy4darkness

Posted
Posted

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 :)
 

15 answers to this question

Recommended Posts

  • 0
SweeTs Rookie

SweeTs

Posted
Posted

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

  • 0
mercy4darkness Newbie

mercy4darkness

Posted
  • Author
Posted

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.....

  • 0
mercy4darkness Newbie

mercy4darkness

Posted
  • Author
Posted

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

  • 0
Reborn12 Newbie

Reborn12

Posted
Posted

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

  • 0
SweeTs Rookie

SweeTs

Posted
Posted

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

  • 0
AccessDenied Newbie

AccessDenied

Posted
Posted

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?

  • 0
mercy4darkness Newbie

mercy4darkness

Posted
  • Author
Posted

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!

  • 0
mercy4darkness Newbie

mercy4darkness

Posted
  • Author
Posted

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
  • 0
SweeTs Rookie

SweeTs

Posted
Posted

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.

Guest
This topic is now closed to further replies.
 Share
Go to question listing


×
×
  • Create New...