Jump to content

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


TempFail

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?

Link to comment
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...