Jump to content

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


vladismenko

Recommended Posts

  • 2 weeks later...

s týmto problémom som sa nedávno stretol, môže to mať viac príčin, u mna to bolo po aktualizácií prestashopu na poslednu verziu

otazka - verzia php aku pouzivas? , typ db aku pozivas? , u koho hostuješ prestashop ?

Link to comment
Share on other sites

  • 3 years later...

 I had today this same problem. I was struggling with it for 3 hours doing incredible things. SOLUTION I VERY VERY SIMPLE!

1) Go to database phpmyadmin to table ps_product

2) Expand the menu by clicking on the cross and choose "Columns"

3) Edit the id_product and uncheck "A_I" (AUTO_INCREMENT) >>> Click save

4) Go to edit id_product again and select back  "A_I" (AUTO_INCREMENT) >>> Click save

Now you can add product

 

Explanation for advanced users

PS. Somehow, most often after migration, the auto increment function loses the last product id.

Have no reference, this function automatically goes beyond the scope of the normal INTEGER.

For me, when I changed the product id in the column from INT (10) to BIGINT (255), I saw that adding products started working, creating a product with the id 4294967301 🤯

2021-05-25-17_10_26.png

Link to comment
Share on other sites

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...