AionGermany / aion-germany

Aion Emulator
GNU General Public License v3.0
203 stars 184 forks source link

Luna Shop Error #126

Closed hiderian closed 1 year ago

hiderian commented 5 years ago

Luna shop doesn't work after completed the Housing quest. I'm not sure the Housing quests are related with luna shop, but when I delete my own house from SQL data, luna shop works. If I can’t solve the issues, I want to disable the luna shop. The error message show up when I click the luna shop after done the Housing quest so I think it’s better to disable it.

I completed all of [Housing Quest] 18800, 18801, 18802, 18806, 18807, 18827, 18828, 18829, 18830, 18831, 18832, 18847. Then, I lerned the skill "ID: 749247" but I can't use it after re-login to the game because the house data doesn't store in DB.

However, it seems not only Luna and House problem.

01 02

2019-01-20 08:02:14,641 class com.aionemu.gameserver.GameServer$2 - execution time: 5984msec 2019-01-20 08:02:20,537 class com.aionemu.gameserver.utils.chathandlers.ChatProcessor$1 - execution time: 5889msec 2019-01-20 08:02:22,768 class com.aionemu.gameserver.GameServer$2 - execution time: 14139msec 2019-01-20 08:02:24,890 class com.aionemu.gameserver.GameServer$2 - execution time: 16267msec 2019-01-20 08:02:25,514 Missing zone : 301690000 2019-01-20 08:02:25,545 Missing zone : 301690000 2019-01-20 08:02:25,607 class com.aionemu.gameserver.GameServer$2 - execution time: 16979msec 2019-01-20 08:02:42,385 Automatic restart/shutdown system disable. 2019-01-20 08:08:34,374 Unknown packet received from Aion client: 0x00D9, state=IN_GAME 0000: 01 . 2019-01-20 08:08:49,510 Exception in a Runnable execution: java.lang.NullPointerException: null at com.aionemu.gameserver.services.player.LunaShopService.onLogout(LunaShopService.java:592) ~[AL-Game.jar:na] at com.aionemu.gameserver.services.player.PlayerLeaveWorldService.startLeaveWorld(PlayerLeaveWorldService.java:219) ~[AL-Game.jar:na] at com.aionemu.gameserver.services.player.PlayerLeaveWorldService$1.run(PlayerLeaveWorldService.java:95) ~[AL-Game.jar:na] at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:48) ~[al-commons.jar:na] at com.aionemu.commons.utils.concurrent.RunnableWrapper.run(RunnableWrapper.java:40) [al-commons.jar:na] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [na:1.7.0_80] at java.util.concurrent.FutureTask.run(FutureTask.java:262) [na:1.7.0_80] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178) [na:1.7.0_80] at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292) [na:1.7.0_80] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_80] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_80] at java.lang.Thread.run(Thread.java:745) [na:1.7.0_80]

FrozenKiller35 commented 5 years ago

They are all on our Todo because a lot was changed with 6.2 but for know the main problem should be 2019-01-20 08:08:34,374 Unknown packet received from Aion client: 0x00D9, state=IN_GAME 0000: 01 .

If the house data won't be stored then you should have a Error (like this one for Luna) in your Log And is this report for 5.8 or 6.2 ?

hiderian commented 5 years ago

The unknown packet error is showing because I changed all of data in l10n folder in order to change language with the latest data.pak.

2019-01-20 09:34:57,712 ERROR [PacketProcessor:1] mysql5.MySQL5HousesDAO [MySQL5HousesDAO.java]:165] Could not store studio data. Duplicate entry '2001' for key 'address' com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'es2001' for key 'address'

However, the same error has occurred even if I use official 5.8 client. This report is for 5.8. I'm not testing 6.2 yet.

dhannyjsb commented 5 years ago

you can try Import sql table Houses, House_bids, house_object_cooldowns, house_scripts from 6.0 DB. #127

hiderian commented 5 years ago

I tried to import all of them from 6.0 but nothing has changed.

hiderian commented 5 years ago

I've found a bit curious from the console log. This may be a cause.

2019-01-27 11:52:14,997 INFO [PacketProcessor:0] com.aionemu.gameserver.network.aion.AionClientPacket [AionClientPacket.java:122] [C] 0x114 CM_FIND_GROUP wont be processed cuz its valid state don't match current connection state: AUTHED 2019-01-27 11:52:15,402 INFO [PacketProcessor:2] com.aionemu.gameserver.network.aion.AionClientPacket [AionClientPacket.java:122] [C] 0x1A6 CM_GET_HOUSE_BIDS wont be processed cuz its valid state don't match current connection state: AUTHED

FrozenKiller35 commented 5 years ago

@hiderian Thats not a problem its ok

hiderian commented 5 years ago

Idk the solutions... Anyway, I don’t need the luna shop system for me so I want to disable and/or turn off the luna shop icon like disable the in-game shop icon but is it possible?

ryuzaki01 commented 5 years ago

I have the fix here

151