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

[mercy4darkness]

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:

 

-http://dev.mysql.com/downloads/mysql/ (MYSQL 5.5)

-http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html (java SE development Kit 8u101 - windows 64x )

-Navicat Premium Essentials

 

Followed this guides (mainly):

https://l2topzone.com/forum/l2-guides/6/guidehow-to-setup-your-own-l2server-plus-images/44/

https://www.youtube.com/watch?v=5e8qceHjrnA

 

If any1 knows where i fuked up, i would realy appreciate some help

(SkypeID: Mercy4darkness90)

 

Ty :)

 

[lsj14]

Unknown column 'lastVoteHopzone' in 'field list'

 

That says everything.

[SweeTs]

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

[mercy4darkness]

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

[SweeTs]

They are not.

 

http://subversion.assembla.com/svn/L2jFrozenInterlude/trunk/

https://xp-dev.com/svn/aCis_public/

[mercy4darkness]

They are not.

 

http://subversion.assembla.com/svn/L2jFrozenInterlude/trunk/

https://xp-dev.com/svn/aCis_public/

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

[Reborn12]

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

[SweeTs]

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

[AccessDenied]

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?

[mercy4darkness]

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 ^_^

[mercy4darkness]

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!

[mercy4darkness]

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

[Reborn12]

Cause acis use xml npcs and dont sql

[mercy4darkness]

Cause acis use xml npcs and dont sql

ahhh alright! than i try to find something like that :)

 

Ty!

[Reborn12]

You can copy paste one npc and change id and type and ready..if is script buffer just add the id in the script

[SweeTs]

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.