Out of range value for column 'id_category' at row 1

[TempFail]

Out of range value for column 'id_category' at row 1

INSERT INTO `ps_category` (`nleft`, `nright`, `level_depth`, `active`, `id_parent`, `id_shop_default`, `is_root_category`, `position`, `date_add`, `date_upd`) VALUES ('0', '0', '5', '1', '102', '1', '0', '0', '2017-10-10 21:22:19', '2017-10-10 21:22:19')

 

When creating new category, I get that error (error reporting on). It is possible that category id is too high. How I can change categoryid autoincrement to start from ie. 1000?

[Sergio Araos]

Hi!  

 

5 years later, I have exactly the same error. Do you have a solution or figure out how to resolve?

[brandonc555]

To fix the "Out of range value for column 'id_category'" error when creating a new category, set the auto-increment value for id_category to start from 1000 with this SQL command:

ALTER TABLE `ps_category` AUTO_INCREMENT = 1000;

Run this command in your database to ensure new category IDs start from 1000, avoiding range issues.