[Solution] Account fails to load if your player logs off from within their studio

[OldTimeDev]

I discovered today that if you log off with your character inside their studio apartment, your account will fail to load with the Could not restore PlayerCommonData data for player error on the server console. (Example over here http://forum.ragezone.com/f587/relea...ml#post7813290)

The quick fix is to open the players table from the game server database (al_server_gs by default) and change your location to somewhere else (fields x,y,z, world_id and world_owner). I just copied another location from another character that was listed and that worked fine.

Not sure why the server barfs on that, but if I get it figured out, I'll let everyone know. I'm guessing it may not like the 'world_owner' setting to the player's id, as it is an instance created solely for the player. This may mean it might work fine for houses as those are not instanced, but I haven't tested houses yet.

Edit: Okay, change this to Your account will fail to load if you logout from within any instance. Same error as linked above.

[MentaL]

[Engager]

You get the same error if you miss-assign a class with //set class <id> and then try to fix it. Some other things cause that error too, still investigating.

[OldTimeDev]

Okay, found a new one and I don't know how to fix this one.

22:14:36.038 ERROR[pool-3-thread-10]: - Error during enter world 116870
java.lang.NullPointerException: null
        at com.aionemu.gameserver.services.StigmaService.getPossibleStigmaCount(StigmaService.java:241) ~[AL-Game.jar:na]
        at com.aionemu.gameserver.services.StigmaService.isPossibleEquippedStigma(StigmaService.java:338) ~[AL-Game.jar:na]
        at com.aionemu.gameserver.services.StigmaService.onPlayerLogin(StigmaService.java:184) ~[AL-Game.jar:na]
        at com.aionemu.gameserver.services.player.PlayerEnterWorldService.enterWorld(PlayerEnterWorldService.java:241) ~[AL-Game
.jar:na]
        at com.aionemu.gameserver.services.player.PlayerEnterWorldService$1.run(PlayerEnterWorldService.java:205) ~[AL-Game.jar:
na]
        at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:46) [al-commons-1.3.jar:na]
        at com.aionemu.commons.utils.concurrent.RunnableWrapper.run(RunnableWrapper.java:38) [al-commons-1.3.jar:na]
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:476) [na:na]
        at java.util.concurrent.FutureTask.run(FutureTask.java:237) [na:na]
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:151)
 [na:na]
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:264) [na:na
]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1115) [na:na]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:586) [na:na]
        at java.lang.Thread.run(Thread.java:724) [na:1.7.0_40]

The character in question had just obtained lvl 30. I had moved her to an instance to help someone else fix a problem. The server booted us both off while we were in the instance and we both couldn't log back in. I fixed our positions in the database. The other person was able to login fine, but my character got that error above, which seems to be related to the number of stigma slots. I couldn't find an appropriate entry for regular stigma slots in the database to be able to fix it, unfortunately.

[kornicska]

I discovered today that if you log off with your character inside their studio apartment, your account will fail to load with the Could not restore PlayerCommonData data for player error on the server console. (Example over here http://forum.ragezone.com/f587/relea...ml#post7813290)

The quick fix is to open the players table from the game server database (al_server_gs by default) and change your location to somewhere else (fields x,y,z, world_id and world_owner). I just copied another location from another character that was listed and that worked fine.

Not sure why the server barfs on that, but if I get it figured out, I'll let everyone know. I'm guessing it may not like the 'world_owner' setting to the player's id, as it is an instance created solely for the player. This may mean it might work fine for houses as those are not instanced, but I haven't tested houses yet.

Edit: Okay, change this to Your account will fail to load if you logout from within any instance. Same error as linked above.

I wrote about this as well.
If Instanced Dungeons (any instability) enter the characters play and pld during server restart happens from then on account of the character and bebugol coordinate and can not enter into play.
to solve anno 3.0 and 3.7 AL server, vol solution
repair.java
Specifically, if a user account is a character bebugolt the same ip to another account or the same account of the new characters joined the
entered by / / repair buggy character names
and this improved the sql command in the xyz coordinate a character that is modified and threw it back into place last backup database
and after that was able to move characters
And not everyone had to be revised because the player was able to resolve its own as a player command usage
This function is still lack, and I try to do such a thing, or if you do not come up here and help me.
Perhaps dwarfpicker or other dev with me find a solution for this.

Here is a sample that is not working 4.0
AL java 3.0 but it was what was used usercommand
Building on this basis and adjusted for new command needs to be done
http://www.mediafire.com/view/rog0hd...pf/Repair.java

[Dwarfpicker]

Added to aion wiki!

[OldTimeDev]

22:14:36.038 ERROR[pool-3-thread-10]: - Error during enter world 116870
java.lang.NullPointerException: null
        at com.aionemu.gameserver.services.StigmaService.getPossibleStigmaCount(StigmaService.java:241) ~[AL-Game.jar:na]
        at com.aionemu.gameserver.services.StigmaService.isPossibleEquippedStigma(StigmaService.java:338) ~[AL-Game.jar:na]
        at com.aionemu.gameserver.services.StigmaService.onPlayerLogin(StigmaService.java:184) ~[AL-Game.jar:na]
        at com.aionemu.gameserver.services.player.PlayerEnterWorldService.enterWorld(PlayerEnterWorldService.java:241) ~[AL-Game
.jar:na]
        at com.aionemu.gameserver.services.player.PlayerEnterWorldService$1.run(PlayerEnterWorldService.java:205) ~[AL-Game.jar:
na]
        at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:46) [al-commons-1.3.jar:na]
        at com.aionemu.commons.utils.concurrent.RunnableWrapper.run(RunnableWrapper.java:38) [al-commons-1.3.jar:na]
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:476) [na:na]
        at java.util.concurrent.FutureTask.run(FutureTask.java:237) [na:na]
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:151)
 [na:na]
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:264) [na:na
]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1115) [na:na]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:586) [na:na]
        at java.lang.Thread.run(Thread.java:724) [na:1.7.0_40]

I found the fix for this.

The problem was, I used GM skills to move into the instance created for the Sliver of Darkness stigma quest. In doing this, the record of my character having completed (or even started) that quest was removed from the player_quests table, which then screws up your character's stigma count (I had two stigmas slotted, but if I had never done the quest how could that be...).

I inserted the record back into the table that I had completed it and was able to enter the game on that character again.

So, be careful what you do with those GM commands, as it can really screw things up for you.

[kornicska]

GM positions do not need it because we have skill autolerarn
autolearn stigma and skill
that can be turned on, you can adjust the position with GM
Thus, these problems GM commands do not cause problems
do not enter a player to autolearn, mainly doing quests, and so by default they did not have this problem either

[OldTimeDev]

I'm not using the autolearn feature. I'm trying not to make too many changes to the experience from the real servers, but some things aren't working properly.