Jump to content

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


Recommended Posts

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?

Share this post

Link to post
Share on other sites

  • 5 years later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More