console_login:INFO 2023-07-07 04:53:28.030 [JobWorker_0_2] engine.server.login.LoginServerMsgHandler.KickToLogin(292) : Kicking to Login. Message: 'Major Version Failure: 1.2.26.0'
magicbane.conf
#Login Server configuration settings#
MB_LOGIN_PORT="6000"
MB_LOGIN_AUTOREG="TRUE"
MB_LOGIN_FNAME_REGEX="^[A-Za-z]+$" MB_MAJOR_VER="1.2.25.6"
MB_MINOR_VER="5.25.6"
if I modify MB_MAJOR_VER="1.2.25.6"=>MB_MAJOR_VER="1.2.26.0"
then I cound login But still can`t into the game world
please help me!
console_login:INFO 2023-07-07 04:53:28.030 [JobWorker_0_2] engine.server.login.LoginServerMsgHandler.KickToLogin(292) : Kicking to Login. Message: 'Major Version Failure: 1.2.26.0'
magicbane.conf
#Login Server configuration settings#
MB_LOGIN_PORT="6000"
MB_LOGIN_AUTOREG="TRUE"
MB_LOGIN_FNAME_REGEX="^[A-Za-z]+$"
**MB_MAJOR_VER="1.2.25.6"**
MB_MINOR_VER="5.25.6"
if I modify **MB_MAJOR_VER="1.2.25.6"**=>**MB_MAJOR_VER="1.2.26.0"**
then I cound login But still can`t into the game world
please help me!
You'll likely want to keep the MB_MAJOR_VER as 1.2.26.0 for now and ensure you're using a patched version of the client by running Shadowbane.exe. This is a bit of an inbetween time where the current version from the repo has an older sb.exe than the current release so the versions are a bit out of step. We'll be looking to release an update MagicBox shortly, along with a scheduled Production server wipe.
You'll likely want to keep the MB_MAJOR_VER as 1.2.26.0 for now and ensure you're using a patched version of the client by running Shadowbane.exe. This is a bit of an inbetween time where the current version from the repo has an older sb.exe than the current release so the versions are a bit out of step. We'll be looking to release an update MagicBox shortly, along with a scheduled Production server wipe.
1.2.26.0 you can get simply by running shadowbane.exe or by downloading the large client. The post to fix this is above: #21
Large Client Download (has the 1.2.26.0 sb.exe client inside): https://www.magicbane.com/download/bigclient.zip
1.2.26.0 you can get simply by running shadowbane.exe or by downloading the large client. The post to fix this is above: http://repo.magicbane.com/MagicBane/Server/issues/21#issuecomment-83
Large Client Download (has the 1.2.26.0 sb.exe client inside): https://www.magicbane.com/download/bigclient.zip
MISSING those config in "magicbane.conf"
MB_WORLD_REALMMAP=
MB_USE_RUINS=
MB_AI_CAST_FREQUENCY=
MB_AI_AGGRO_RANGE=
MB_NORMAL_EXP_RATE=
MB_NORMAL_DROP_RATE=
MB_HOTZONE_EXP_RATE=
MB_HOTZONE_DROP_RATE=
MB_HOTZONE_DURATION=
MB_HOTZONE_MIN_LEVEL=
MB_PRODUCTION_RATE=
MB_MAGICBOT_MAGICBOX=
MB_MAGICBOT_ADMINLOG=
AND MISSING Column in "mysql"
java.sql.SQLException: Column 'runeSet' not found.
When the MAGICBOX could working please PM me or send my email(clarklxr@126.com).
Do we have BBS or something like ,I can submit BUG
MISSING those config in "magicbane.conf"
MB_WORLD_REALMMAP=
MB_USE_RUINS=
MB_AI_CAST_FREQUENCY=
MB_AI_AGGRO_RANGE=
MB_NORMAL_EXP_RATE=
MB_NORMAL_DROP_RATE=
MB_HOTZONE_EXP_RATE=
MB_HOTZONE_DROP_RATE=
MB_HOTZONE_DURATION=
MB_HOTZONE_MIN_LEVEL=
MB_PRODUCTION_RATE=
MB_MAGICBOT_MAGICBOX=
MB_MAGICBOT_ADMINLOG=
AND MISSING Column in "mysql"
java.sql.SQLException: Column 'runeSet' not found.
When the MAGICBOX could working please PM me or send my email(clarklxr@126.com).
Do we have BBS or something like ,I can submit BUG
New MagicBox due in the coming news, that should fix this. It's just due to latency between the new server and getting MagicBox finalized. I'll report back here when it's released to let you know.
New MagicBox due in the coming news, that should fix this. It's just due to latency between the new server and getting MagicBox finalized. I'll report back here when it's released to let you know.
Hi!
New MagicBox:
ERROR 2023-07-27 10:46:48.659 [main] engine.db.handlers.dbBuildingLocationHandler.LOAD_BUILDING_LOCATIONS(43) : java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'magicbane.static_building_location.ID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
ERROR 2023-07-27 10:47:21.734 [main] engine.db.handlers.dbHandlerBase.getObjectFromRs(39) : java.lang.reflect.InvocationTargetException
Hi!
New MagicBox:
ERROR 2023-07-27 10:46:48.659 [main] engine.db.handlers.dbBuildingLocationHandler.LOAD_BUILDING_LOCATIONS(43) : java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'magicbane.static_building_location.ID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
ERROR 2023-07-27 10:47:21.734 [main] engine.db.handlers.dbHandlerBase.getObjectFromRs(39) : java.lang.reflect.InvocationTargetException
@snowfall looks to be because that area of code runs select * instead of specifying columns we need. You can look to update the query in a branch or update SQL to remove the ONLY_FULL_GROUP_BY option, which is enforcing this behavior.
SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
SHOW VARIABLES LIKE 'sql_mode';
@snowfall looks to be because that area of code runs select * instead of specifying columns we need. You can look to update the query in a branch or update SQL to remove the ONLY_FULL_GROUP_BY option, which is enforcing this behavior.
SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
SHOW VARIABLES LIKE 'sql_mode';
I pull new image, nothing changes, the error is the same as it was. SET sql_mode does not resolve the problem.
pull new image 1.5.1,it resolved the problem
> I pull new image, nothing changes, the error is the same as it was. SET sql_mode does not resolve the problem.
pull new image 1.5.1,it resolved the problem
ERROR 2023-08-10 20:51:53.685 [main] engine.objects.NPC.initializeNPC(800) : No available slot for NPC: 15551
WARNING 2023-08-10 20:51:53.736 [main] engine.objects.MobLoot.generateId(107) : Only 10,000 Id numbers remain useable. Server restart suggested.
ERROR 2023-08-10 20:51:53.813 [main] engine.objects.NPC.initializeNPC(800) : No available slot for NPC: 15895
ERROR 2023-08-10 20:51:53.915 [main] engine.objects.NPC.initializeNPC(800) : No available slot for NPC: 16056
INFO 2023-08-10 20:51:59.318 [main] engine.objects.City.setParent(642) : Khan'Ov Srekel created custom heightmap
ERROR 2023-08-10 20:51:59.411 [main] engine.objects.NPC.initializeNPC(800) : No available slot for NPC: 31969
Still can`t into gameserver
ERROR 2023-08-10 20:51:53.685 [main] engine.objects.NPC.initializeNPC(800) : No available slot for NPC: 15551
WARNING 2023-08-10 20:51:53.736 [main] engine.objects.MobLoot.generateId(107) : Only 10,000 Id numbers remain useable. Server restart suggested.
ERROR 2023-08-10 20:51:53.813 [main] engine.objects.NPC.initializeNPC(800) : No available slot for NPC: 15895
ERROR 2023-08-10 20:51:53.915 [main] engine.objects.NPC.initializeNPC(800) : No available slot for NPC: 16056
INFO 2023-08-10 20:51:59.318 [main] engine.objects.City.setParent(642) : Khan'Ov Srekel created custom heightmap
ERROR 2023-08-10 20:51:59.411 [main] engine.objects.NPC.initializeNPC(800) : No available slot for NPC: 31969
Still can`t into gameserver
"/home/mbbox/magicbane/mb.data/magicbane.conf"
Network autoconfig when set to 0.0.0.0
binds to preferred outgoing ip. (eth0)
MB_BIND_ADDR="0.0.0.0"
MB_EXTERNAL_ADDR=YourPcIP
NOTE:YourPcIP is localip ,like 192.168.1.* or 10.10.0.*;
ArcaneIP.cfg you can still use 127.0.0.1 or the same IP as YourPcIP
then you can login gameworld!!!
Have fun
"/home/mbbox/magicbane/mb.data/magicbane.conf"
Network autoconfig when set to 0.0.0.0
binds to preferred outgoing ip. (eth0)
MB_BIND_ADDR="0.0.0.0"
MB_EXTERNAL_ADDR=**YourPcIP**
NOTE:YourPcIP is localip ,like 192.168.1.* or 10.10.0.*;
ArcaneIP.cfg you can still use 127.0.0.1 or the same IP as YourPcIP
then you can login gameworld!!!
Have fun
console_login:INFO 2023-07-07 04:53:28.030 [JobWorker_0_2] engine.server.login.LoginServerMsgHandler.KickToLogin(292) : Kicking to Login. Message: 'Major Version Failure: 1.2.26.0'
magicbane.conf
#Login Server configuration settings#
MB_LOGIN_PORT="6000"
MB_LOGIN_AUTOREG="TRUE"
MB_LOGIN_FNAME_REGEX="^[A-Za-z]+$"
MB_MAJOR_VER="1.2.25.6"
MB_MINOR_VER="5.25.6"
if I modify MB_MAJOR_VER="1.2.25.6"=>MB_MAJOR_VER="1.2.26.0"
then I cound login But still can`t into the game world
please help me!
You'll likely want to keep the MB_MAJOR_VER as 1.2.26.0 for now and ensure you're using a patched version of the client by running Shadowbane.exe. This is a bit of an inbetween time where the current version from the repo has an older sb.exe than the current release so the versions are a bit out of step. We'll be looking to release an update MagicBox shortly, along with a scheduled Production server wipe.
My only wish is usb MAGICBOX to play the game,the version for me is not important.
Once the new MagicBox release is made this won't be an issue. For now though, you'll need to take the steps in my previous post to proceed.
Which post,could you show me the link?I greatly appreciate your help.
Where I can get the old client for MB_MAJOR_VER as 1.2.26.0?
1.2.26.0 you can get simply by running shadowbane.exe or by downloading the large client. The post to fix this is above: #21
Large Client Download (has the 1.2.26.0 sb.exe client inside): https://www.magicbane.com/download/bigclient.zip
MISSING those config in "magicbane.conf"
MB_WORLD_REALMMAP=
MB_USE_RUINS=
MB_AI_CAST_FREQUENCY=
MB_AI_AGGRO_RANGE=
MB_NORMAL_EXP_RATE=
MB_NORMAL_DROP_RATE=
MB_HOTZONE_EXP_RATE=
MB_HOTZONE_DROP_RATE=
MB_HOTZONE_DURATION=
MB_HOTZONE_MIN_LEVEL=
MB_PRODUCTION_RATE=
MB_MAGICBOT_MAGICBOX=
MB_MAGICBOT_ADMINLOG=
AND MISSING Column in "mysql"
java.sql.SQLException: Column 'runeSet' not found.
When the MAGICBOX could working please PM me or send my email(clarklxr@126.com).
Do we have BBS or something like ,I can submit BUG
New MagicBox due in the coming news, that should fix this. It's just due to latency between the new server and getting MagicBox finalized. I'll report back here when it's released to let you know.
Hi!
New MagicBox:
ERROR 2023-07-27 10:46:48.659 [main] engine.db.handlers.dbBuildingLocationHandler.LOAD_BUILDING_LOCATIONS(43) : java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'magicbane.static_building_location.ID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
ERROR 2023-07-27 10:47:21.734 [main] engine.db.handlers.dbHandlerBase.getObjectFromRs(39) : java.lang.reflect.InvocationTargetException
@snowfall looks to be because that area of code runs select * instead of specifying columns we need. You can look to update the query in a branch or update SQL to remove the ONLY_FULL_GROUP_BY option, which is enforcing this behavior.
SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
SHOW VARIABLES LIKE 'sql_mode';
I pull new image, nothing changes, the error is the same as it was. SET sql_mode does not resolve the problem.
pull new image 1.5.1,it resolved the problem
ERROR 2023-08-10 20:51:53.685 [main] engine.objects.NPC.initializeNPC(800) : No available slot for NPC: 15551
WARNING 2023-08-10 20:51:53.736 [main] engine.objects.MobLoot.generateId(107) : Only 10,000 Id numbers remain useable. Server restart suggested.
ERROR 2023-08-10 20:51:53.813 [main] engine.objects.NPC.initializeNPC(800) : No available slot for NPC: 15895
ERROR 2023-08-10 20:51:53.915 [main] engine.objects.NPC.initializeNPC(800) : No available slot for NPC: 16056
INFO 2023-08-10 20:51:59.318 [main] engine.objects.City.setParent(642) : Khan'Ov Srekel created custom heightmap
ERROR 2023-08-10 20:51:59.411 [main] engine.objects.NPC.initializeNPC(800) : No available slot for NPC: 31969
Still can`t into gameserver
"/home/mbbox/magicbane/mb.data/magicbane.conf"
Network autoconfig when set to 0.0.0.0
binds to preferred outgoing ip. (eth0)
MB_BIND_ADDR="0.0.0.0"
MB_EXTERNAL_ADDR=YourPcIP
NOTE:YourPcIP is localip ,like 192.168.1.* or 10.10.0.*;
ArcaneIP.cfg you can still use 127.0.0.1 or the same IP as YourPcIP
then you can login gameworld!!!
Have fun
@clarklxr any outstanding issues still or did you get things running?