Rodex Mapif.c error

This error is quite explicit: the ID of your character in your SQL database (table `char`) is less than 150000 (the initial ID for auto-increment). This could happen if you manually added a character and explicitly specified an ID lower than 150000. Since the column is on auto-increment you should not specify a char id when adding rows to the table. You can find the offending rows with a simple query:

SELECT * FROM `char` WHERE `char_id` < 150000;


Keep in mind that if you end up changing the ID of a char it needs to be changed in every table that has a char_id column and should only be done when the server is offline.

 

You can reset the auto increment with this query:

ALTER TABLE `char` AUTO_INCREMENT = 1;


Setting auto increment to a value less than or equal the highest value will reset it to highest + 1

 
Last edited by a moderator:
This error is quite explicit: the ID of your character in your SQL database (table `char`) is less than 150000 (the initial ID for auto-increment). This could happen if you manually added a character and explicitly specified an ID lower than 150000. Since the column is on auto-increment you should not specify a char id when adding rows to the table. You can find the offending rows with a simple query:

SELECT * FROM `char` WHERE `char_id` < 150000;

SELECT * FROM `char` WHERE `char_id` < 150000;


Keep in mind that if you end up changing the ID of a char it needs to be changed in every table that has a char_id column and should only be done when the server is offline.

 

You can reset the auto increment with this query:

ALTER TABLE `char` AUTO_INCREMENT = 1;

ALTER TABLE `char` AUTO_INCREMENT = 1;


Setting auto increment to a value less than or equal the highest value will reset it to highest + 1 
Thank you! I used _M and _F to create account and character before.

It's fixed now 🙏

 
Back
Top