How to recalculate MySQL ITEM IDs

Did you get the “ItemIDRange: NO MORE ITEM ID RANGE” error?

There are many ways to fix this.

My suggestion is to recalculate the mysql player.item.id field. There are two ways to do so:

1. deleting and recreate id but losing the insert order

    ALTER TABLE `item` DROP `id`;
    ALTER TABLE `item` AUTO_INCREMENT = 10000001;
    ALTER TABLE `item` ADD `id` int UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
   

2. update the id and keeping the previous insert order (suggested)

    SET @id:=10000000;
    UPDATE `item` SET id=@id:=@id+1 ORDER BY id;
    ALTER TABLE `item` AUTO_INCREMENT = 0;
   

Note: Both of them will have new ids so you can’t track them from the old log.log anymore.

Update the ITEM_ID_RANGE range value

After you update player.item, if you have many items, it may still keep cause this error because the range should be adjusted.

Edit gen_settings.py or db/conf.txt by specifying the highest item id+1 as the minimum range.

This is one of the many ways to get the highest item id+1:

SELECT id+1 FROM item ORDER BY id DESC LIMIT 1;

Example of the config option:

ITEM_ID_RANGE = 16448285 400000000