Dbugg error Query: Update 'players' ... ... .... "Out of range value for column 'experience' at row 1

[Joriku]

Why may couse this to happen at death?

Spawned right back where I we're hunting..

Dbugg msg in client if helpful.

Last row on dbugg,
Experience value underflow.

 

[Yalasari]

Out of range value

This means that value You are trying to insert into 'experience' is out of your variable type range, actually it is bigger than bigint so I would recommend You to change experience multipliers to lower, implement reborn system or something like that.

 

[Joriku]

This means that value You are trying to insert into 'experience' is out of your variable type range, actually it is bigger than bigint so I would recommend You to change experience multipliers to lower, implement reborn system or something like that.

Iam doing a high exp server where you exp on players.
Anyway to change it?
Here's the config.
experienceStages = true
experienceByKillingPlayers = "yes"
rateExperienceFromPlayers = 50
rateExp = 5
rateSkill = 22
rateLoot = 2.5
rateMagic = 8
rateSpawn = 1

Exp stages,
<?xml version="1.0" encoding="UTF-8"?>
<stages>
<world id="0" multiplier="1">
<stage minlevel="1" maxlevel="40000" multiplier="300000" />
<stage minlevel="40001" maxlevel="50000" multiplier="200000" />
<stage minlevel="50001" maxlevel="80000" multiplier="190000" />
<stage minlevel="80001" maxlevel="120000" multiplier="100000" />
<stage minlevel="120001" maxlevel="160000" multiplier="50000" />
<stage minlevel="160001" maxlevel="100000" multiplier="40000" />
<stage minlevel="100001" maxlevel="200000" multiplier="30000" />
<stage minlevel="200001" multiplier="1" />
</world>
</stages>

 

[Yalasari]

Limit is lying on database side, unsinged bigint is largest (2^64 - 1) integer type available. You should either rework experience (scale it down) or introduce something like reborn system.

 

[fabian766]

Limit is lying on database side, unsinged bigint is largest (2^64 - 1) integer type available. You should either rework experience (scale it down) or introduce something like reborn system.

Actually the positive value limit is probably (2^63 - 1) because TFS programmers forgot to make experience save as unsigned bigint so it saves as signed(since TFS use uint64_t it wouldn't overflow for unsigned bigint right?), there's also the same problem with manaspent value but it is even bigger as it gets saved as unsigned int(2^32 - 1) while the value is declared as uint64_t.
You can try these queries in mysql:

ALTER TABLE `players` CHANGE `manaspent` `manaspent` bigint(20) unsigned NOT NULL DEFAULT '0'
ALTER TABLE `players` CHANGE `experience` `experience` bigint(20) unsigned NOT NULL DEFAULT '0'

 

[Joriku]

Actually the positive value limit is probably (2^63 - 1) because TFS programmers forgot to make experience save as unsigned bigint so it saves as signed(since TFS use uint64_t it wouldn't overflow for unsigned bigint right?), there's also the same problem with manaspent value but it is even bigger as it gets saved as unsigned int(2^32 - 1) while the value is declared as uint64_t.
You can try these queries in mysql:

ALTER TABLE `players` CHANGE `manaspent` `manaspent` bigint(20) unsigned NOT NULL DEFAULT '0'
ALTER TABLE `players` CHANGE `experience` `experience` bigint(20) unsigned NOT NULL DEFAULT '0'

Sadly, Experience is not working..

Gyazo

gyazo.com

Nevermind. Just doing one a time solved it..
Iam too fast tying out for help instead of just checking the error lol..

It sadly did not work by updating that. Gyazo (https://gyazo.com/d43440556f94a47f5dc08ef0f76be031)
I did die tho, lost blessings and spawned at temple but still dbugging. (getting no error in console.)

changed this

[C++] How to increase maximum level on server

This is not 'code release' (only)! There is full description of problem with maximum number value in C++. Let's fix max. level problem (for high exp servers)! THIS FIX YOU CAN ONLY INSTALL BEFORE SERVER START. THIS FIX REQUIRES ALL CHARACTERS RESET (level and exp). Example with formulat with...

otland.net

using OTServBr-Global

GitHub - opentibiabr/otservbr-global: OTServBR-Global datapack was migrated to Canary repository: https://github.com/opentibiabr/canary

OTServBR-Global datapack was migrated to Canary repository: https://github.com/opentibiabr/canary - opentibiabr/otservbr-global

github.com

if this helps.

Btw, how do you screen the console?
file is called TFS but cannot do.
screen -x tfs / screen -x ./tfs
screen -r tfs / screen -r ./tfs

 

[Yalasari]

Btw, how do you screen the console?
file is called TFS but cannot do.
screen -x tfs / screen -x ./tfs
screen -r tfs / screen -r ./tfs

When you are inside folder with tfs:
screen ./tfs
When you are not inside folder, first argument is path to tfs. Use screen -r PID to load screen, and screen -ls to view list of PIDs

 

[Znote]

You have too high experience rate, you are breaking the limits of the engine/game.

Decrease the experience rate. I suggest somewhere between 1-100x exp rate.
If you want super high levels, instead of using super high experience multiplier, decrease the experience required per level.
(Like MasterCores, 200 xp = level 8, instead of 4200 xp).

The server will also run significantly better and lag less if there is less math computation needed, so you can get the same effect you have now in a more effective and better way.

<?xml version="1.0" encoding="UTF-8"?>
<stages>
<world id="0" multiplier="1">
<stage minlevel="1" maxlevel="40000" multiplier="30" />
<stage minlevel="40001" maxlevel="50000" multiplier="20" />
<stage minlevel="50001" maxlevel="80000" multiplier="19" />
<stage minlevel="80001" maxlevel="120000" multiplier="10" />
<stage minlevel="120001" maxlevel="160000" multiplier="5" />
<stage minlevel="160001" maxlevel="100000" multiplier="4" />
<stage minlevel="100001" maxlevel="200000" multiplier="3" />
<stage minlevel="200001" multiplier="1" />
</world>
</stages>

And reduce experience table / 10 000

To gain the same progression as your current stages.

 

[Joriku]

You have too high experience rate, you are breaking the limits of the engine/game.

Decrease the experience rate. I suggest somewhere between 1-100x exp rate.
If you want super high levels, instead of using super high experience multiplier, decrease the experience required per level.
(Like MasterCores, 200 xp = level 8, instead of 4200 xp).

The server will also run significantly better and lag less if there is less math computation needed, so you can get the same effect you have now in a more effective and better way.

<?xml version="1.0" encoding="UTF-8"?>
<stages>
<world id="0" multiplier="1">
<stage minlevel="1" maxlevel="40000" multiplier="30" />
<stage minlevel="40001" maxlevel="50000" multiplier="20" />
<stage minlevel="50001" maxlevel="80000" multiplier="19" />
<stage minlevel="80001" maxlevel="120000" multiplier="10" />
<stage minlevel="120001" maxlevel="160000" multiplier="5" />
<stage minlevel="160001" maxlevel="100000" multiplier="4" />
<stage minlevel="100001" maxlevel="200000" multiplier="3" />
<stage minlevel="200001" multiplier="1" />
</world>
</stages>

And reduce experience table / 10 000

To gain the same progression as your current stages.

Thank you, going to test it as soon as I got the acc maker work.

 

[Joriku]

You have too high experience rate, you are breaking the limits of the engine/game.

Decrease the experience rate. I suggest somewhere between 1-100x exp rate.
If you want super high levels, instead of using super high experience multiplier, decrease the experience required per level.
(Like MasterCores, 200 xp = level 8, instead of 4200 xp).

The server will also run significantly better and lag less if there is less math computation needed, so you can get the same effect you have now in a more effective and better way.

<?xml version="1.0" encoding="UTF-8"?>
<stages>
<world id="0" multiplier="1">
<stage minlevel="1" maxlevel="40000" multiplier="30" />
<stage minlevel="40001" maxlevel="50000" multiplier="20" />
<stage minlevel="50001" maxlevel="80000" multiplier="19" />
<stage minlevel="80001" maxlevel="120000" multiplier="10" />
<stage minlevel="120001" maxlevel="160000" multiplier="5" />
<stage minlevel="160001" maxlevel="100000" multiplier="4" />
<stage minlevel="100001" maxlevel="200000" multiplier="3" />
<stage minlevel="200001" multiplier="1" />
</world>
</stages>

And reduce experience table / 10 000

To gain the same progression as your current stages.

Sadly, did not work..

 

[Znote]

Because those players accumulated their experience points before the experience table was reduced, you need to do a query that reduces their experience by 10 000 as well to align with the new experience table values.

UPDATE `players` SET `experience` = `experience` / 10000;

 

[Joriku]

Because those players accumulated their experience points before the experience table was reduced, you need to do a query that reduces their experience by 10 000 as well to align with the new experience table values.

UPDATE `players` SET `experience` = `experience` / 10000;

got sort of the same..