vincentw Posted December 7, 2011 Share Posted December 7, 2011 Hello, i'm having problems with my prestashop install that previously was working perfectly. Without changes to it, i suddenly can't add new products. When adding a new product an ' 1 error ' appears stating error occurred while creating object product Modifying products is working fine, tho the return to the page is timing out. What can cause this problem? Searching the forum gave me some [solved] topics but those don't have solutions mentioned only the OP stating it is solved and a hint it could have something to do with ps_products and ps_products_lang. These tables do match as far as I can see (last ID's match). Link to comment Share on other sites More sharing options...
vincentw Posted December 7, 2011 Author Share Posted December 7, 2011 I gues i could just mark this one as solved, and say it had to do with both ps_product and ps_product_lang But for the sake of others having the same, not very descriptive, errormessage: it turned out that some products had very high product_ID's (leaving a gap after productID 5900 and beginning from 22000) I removed the products with the high product ID's and the one with product ID 0 To reset the auto-increment counter, I ran this SQL statement ALTER TABLE ps_products AUTO_INCREMENT = 1 After doing this the BO allowed adding new products again. Link to comment Share on other sites More sharing options...
jurexy Posted February 20, 2012 Share Posted February 20, 2012 I have the same problem and error - some IDs are around 2000 and than suddenly one is ID 423454355. I would try ALTER TABLE statement but I'm afraid that it will run over existing products IDs after adding new products later, if I reset auto increment counter. Can you confirm that it won't rewrite my existing products when I add new ones after I reset the autoincrement? Thx Link to comment Share on other sites More sharing options...
GethThomas Posted March 7, 2012 Share Posted March 7, 2012 I have the same issue, but not solved. I've checked product and product_lang tables, and all id's seem to be ok. I've run the SQL query to reset the autoincrement, but no change. This is how I create the problem, Presta 1.4.7.0, 600 products (live site). Hosted with Siteground.com, MySQL client Version 4.1.22, and phpMyAdmin Version information: 3.4.3.2, latest stable version: 3.4.10.1 I export my product table to excel 2003, I change the quantity (item 12) from 100 to 4 (making sure data type is integer), drop the original table, import the modified excel file (first line as column headings), and then Presta won't create new products. When I drop the revised/modifed products table - and re-import the original SQL table - Presta works again. So the problem seems to be with modifying just one cell in Excel...any advice gratefully received. I've tried to cover everything... Link to comment Share on other sites More sharing options...
ovlcek Posted July 1, 2012 Share Posted July 1, 2012 I have had the same problem. PM me, I will take a look at it. Link to comment Share on other sites More sharing options...
giftsforyounme Posted September 7, 2012 Share Posted September 7, 2012 1 error An error occurred while creating object. product I am unable to add products to my website. How can I fix this problem gifts4younme.com Link to comment Share on other sites More sharing options...
iBones Posted September 15, 2012 Share Posted September 15, 2012 Same problem. Can anyone help? Also i'm having troubles with MySQL dump #1067 - Invalid default value for 'width' for ps_product Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts