Rodex Mapif.c error

[ThyroDree 3]

Everytime closed my rodex or my character login to the game it gives me this error

 

[meko 170]

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

[ThyroDree 3]

1 hour ago, meko said:

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 🙏