Jump to content
  • 0

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


Question

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


  • Posts

    • This post originally appeared on MmoGah. Dear exiles, hot news about PoE 1! The new league, 3.27 Keepers of the Flame, will launch on Oct 31, 2025. I will share with you the top 6 league starters, and each build is chosen for its strength in early progression, affordability, and synergy with the new mechanics introduced in the Bloodline Ascendancy system and Breach rework.       1. Exsanguinate Reap Mines Trickster Overview This build combines the physical spell damage of Exsanguinate and Reap with the mine playstyle, leveraging Trickster’s energy shield and recovery mechanics for survivability and speed. It’s a hybrid between trapper and spellcaster, offering high burst damage and smooth mapping. Key Mechanics Ascendancy: Trickster (Shadow) Main Skills: Exsanguinate, Reap, High-Impact Mine Support Defenses: Energy Shield, Evasion, Ghost Dance, Spell Suppression Strengths Excellent clear speed with overlapping AoE Strong single-target burst from Reap Trickster’s recovery and mobility make it forgiving Weaknesses Mines require setup and can feel clunky for some Physical damage scaling needs investment for the endgame Playstyle Tips Use Exsanguinate for mapping and Reap for bosses Prioritize mine throwing speed and recovery nodes Utilize Bloodline Grafts to enhance ES sustain and mine damage Ideal For Players who enjoy tactical gameplay with high burst potential   2. Cyclone Shockwave Slayer Overview Cyclone Shockwave Slayer is a melee build that uses Cyclone to trigger Shockwave Support, creating massive AoE explosions. Slayer’s leech and overleech mechanics make it durable and fast-paced. Key Mechanics Ascendancy: Slayer (Duelist) Main Skills: Cyclone, Shockwave Support, Rage Support Defenses: Life leech, Overleech, Fortify Strengths Smooth and fast mapping with Cyclone Shockwave adds huge AoE and damage Slayer’s leech makes it tanky even with minimal gear Weaknesses Requires a decent weapon early on Single-target can lag without investment Playstyle Tips Stack attack speed and physical damage Use Rage and Berserk for burst phases Bloodline Grafts can boost leech and AoE scaling Ideal For Players who love fast, aggressive melee builds   DID YOU KNOW?  MmoGah is the most trustworthy digital game goods store. Here you can buy safe PoE currency 3.27 to hold your strong build easily with low prices and fast delivery. poe currency 3.27     3. Rolling Magma Mines Saboteur Overview Rolling Magma Mines Saboteur is a powerful hybrid build that uses mines to trigger chain explosions. Saboteur’s mine bonuses and trap scaling make this build extremely potent for both clear and bossing. Key Mechanics Ascendancy: Saboteur (Shadow) Main Skills: Rolling Magma, Mine Support, Chain Support Defenses: Evasion, Spell Suppression, Mine immunity Strengths Massive AoE clear with chain mechanics High uptime on damage due to mine detonation Saboteur’s trap/mine bonuses make leveling easy Weaknesses Mines require setup and timing Visual clutter can be overwhelming Playstyle Tips Use Rolling Magma for chain clear and boss stacking Prioritize mine throwing speed and detonation speed Bloodline Grafts can enhance mine damage and trap cooldowns Ideal For Players who enjoy strategic, explosive gameplay   4. Kinetic Rain Elementalist (NEW) Overview Kinetic Rain is a new skill introduced in 3.27, firing a barrage of projectiles that rain down in an arc. Elementalist synergizes with elemental damage and ailment proliferation, making this build a top-tier mapper. Key Mechanics Ascendancy: Elementalist (Witch) Main Skills: Kinetic Rain, Greater Multiple Projectiles, Elemental Proliferation Defenses: Elemental ailment immunity, high life, block Strengths Incredible clear speed with projectile spread Elementalist’s golems and ailment immunity boost survivability New skill offers fresh playstyle and visuals Weaknesses Single-target depends on projectile overlap Requires investment in projectile speed and damage Playstyle Tips Scale elemental damage and projectile modifiers Use golems for buffs and tanking Bloodline Grafts can enhance elemental spread and projectile count Ideal For Players who want to try new mechanics with flashy visuals   5. Poisonous Concoction of Bouncing Slayer/Pathfinder Overview: This build uses Poisonous Concoction with the new “Bouncing” mechanic, allowing projectiles to ricochet and apply poison multiple times. Slayer and Pathfinder both offer strong synergy—Slayer for leech and Pathfinder for flask sustain. Key Mechanics Ascendancy: Slayer or Pathfinder (Duelist/Ranger) Main Skills: Poisonous Concoction, Plague Bearer, Wither Defenses: Evasion, Spell Suppression, Flask sustain Strengths Great single-target with poison stacking Bouncing mechanic improves clear and coverage No weapon required—uses flasks for scaling Weaknesses Flask management is crucial Visual clarity can be messy in dense fights Playstyle Tips Use Plague Bearer for clear and Poisonous Concoction for bosses Pathfinder offers smoother sustain; Slayer offers better leech Bloodline Grafts can boost poison duration and flask effects Ideal For Players who enjoy chaos builds and flask mechanics   6. Righteous Fire Chieftain Overview Righteous Fire Chieftain is a tanky, fire-based build that burns enemies with a persistent aura. Chieftain’s fire scaling and regen make it a great starter, especially with Breach-heavy content. Key Mechanics Ascendancy: Chieftain (Marauder) Main Skills: Righteous Fire, Fire Trap, Shield Charge Defenses: High life regen, fire resistance, armor Strengths Extremely tanky and consistent Great for Breach and dense packs Easy to gear and level Weaknesses Requires fire resistance and regen early Slower movement compared to zoomy builds Playstyle Tips Use Fire Trap for single-target and RF for clear Stack life, regen, and fire damage Bloodline Grafts can enhance burning damage and regen Ideal For Players who want a durable, low-maintenance build   Final Thoughts & Tips Bloodline Ascendancy: Mix and match ascendancy traits to create hybrid powerhouses. For example, combining Saboteur’s mine bonuses with Trickster’s recovery can yield unique builds. Breach Rework: Builds with strong AoE and sustain (like RF and Cyclone) excel in Breach-heavy zones. Leveling Strategy: Use alternate skills early (e.g., Fire Trap, Explosive Trap) and transition once gear is available. SSF vs Trade League: All builds here are viable in SSF, but some (like Poisonous Concoction and RF) are especially strong due to low gear dependency. Whether you prefer tactical mines, explosive melee, or elemental barrages, PoE 3.27 offers a rich meta with exciting new tools.
    • Some new features that we added: - 2 new quests - PvP Arena (to get hero status) Olympiad is disabled - Love Event - Dressme for armor/weapons/accessories - HWID Protection - More monsters - New farm zone - New autofarm system (works almost like adrenaline) - Auto enchant - Auto augment - 3 levels of armors - 3 levels of weapons - Anti KS System - Rebirth Manager - 30 days checking rewards - Small event (daily checking with small reward for all online players)
    • Added FloodProtector utility to prevent packet flooding for actions like item use and dice rolling. Integrated flood protection checks in relevant client packet handlers and registered/removal hooks in player lifecycle. Updated movement logic in L2PcInstance for improved position synchronization and geodata handling. Minor fixes and refactoring in attack logic, private store handling, and admin NPC editing. Refactored AI classes to enhance movement, attack, and skill usage logic for characters and mobs. Improved distance checks, attack range calculations, and skill casting conditions. Removed unused intention command logic from L2CharacterAI. Updated configuration to enable CellPathFinding. Minor code cleanups and bug fixes for more reliable AI behavior. Enhanced GeoPathFinding with detailed debug and error messages for region loading, including success/failure counts and file checks. Refactored L2AttackableAI and L2CharacterAI to improve attack range tolerance, immediate attack behavior, and added safety checks for missing targets. Updated configuration to disable CellPathFinding by default and added a new ShowRedName option for aggressive mobs. Minor config and log updates included. Applied TCP socket optimizations (e.g., TCP_NODELAY, buffer sizes, keepalive) in ClientThread, Connection, and SelectorThread to reduce latency and improve throughput. Enhanced L2AttackableAI with better random walk, aggro, and attack logic, including silent move checks, quest monster handling, and improved faction/raid/minion behavior. Added silent move support to L2PlayableInstance and quest monster flag to L2NpcTemplate/L2NpcInstance. These changes aim to improve server responsiveness, AI realism, and overall stability.
    • I’ve been using this Escape from Tarkov Hack for about a week now with no issues at all. ESP works great without any lag, and the aimbot is smooth and doesn't feel obvious. Had a quick setup with the loader, and support answered my questions right away. The HWID spoofer also did its job without messing with my system. So far, the cheat's staying undetected on my side.
  • Topics

×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock