vladismenko Posted February 28, 2018 Share Posted February 28, 2018 Zdravím, prestalo mi fungovať pridávanie produktov. Chybová hláška je: Out of range value for column 'id_product' at row 1 Prosím, poraďte, čo s tým. Neviem sa pohnúť. Databáza vyzerá v poriadku. Link to comment Share on other sites More sharing options...
Karol88 Posted March 12, 2018 Share Posted March 12, 2018 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 More sharing options...
DorianS Posted May 25, 2021 Share Posted May 25, 2021 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 🤯 Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now