rb10 Posted October 14, 2020 Share Posted October 14, 2020 (edited) hi, i have a problem during creation new category in ps 17, when i create a new category, appear this error message : "an error occured during creation category" then instead create a category with name it create a category with code.... then i have also active debug, and appear this error message : ""×Duplicate entry '160-1' for key 'PRIMARY' INSERT INTO `ps_category_shop` (`id_category`, `id_shop`) VALUES ('161', '1') how i can solve this ? thanks Edited October 14, 2020 by rb10 (see edit history) Link to comment Share on other sites More sharing options...
musicmaster Posted October 14, 2020 Share Posted October 14, 2020 A product should at a minimum be present in three tables: ps_product, ps_product_shop and ps_product_lang. It looks there is something going wrong there in your case. However, your error is strange. How could entering 161-1 cause an 160-1 error? Link to comment Share on other sites More sharing options...
rb10 Posted October 14, 2020 Author Share Posted October 14, 2020 i create a new category and appear this Link to comment Share on other sites More sharing options...
rb10 Posted October 14, 2020 Author Share Posted October 14, 2020 could be depend on PHP version ? Link to comment Share on other sites More sharing options...
rb10 Posted October 15, 2020 Author Share Posted October 15, 2020 any advice? Link to comment Share on other sites More sharing options...
rb10 Posted October 16, 2020 Author Share Posted October 16, 2020 up Link to comment Share on other sites More sharing options...
Prescol Posted October 22, 2020 Share Posted October 22, 2020 If you has made a migration of your database: check that migration was successful and no index were missed. Link to comment Share on other sites More sharing options...
rb10 Posted October 22, 2020 Author Share Posted October 22, 2020 2 hours ago, Prescol said: If you has made a migration of your database: check that migration was successful and no index were missed. thanks for your reply, not migration, no migration was done, suddenly it started doing this, Link to comment Share on other sites More sharing options...
Prescol Posted October 22, 2020 Share Posted October 22, 2020 This can happen if system gets down during product deletion. Main product table deleted the record but was not able to delete the ps_product_shop record. Link to comment Share on other sites More sharing options...
rb10 Posted October 22, 2020 Author Share Posted October 22, 2020 But problem is in category not in products Link to comment Share on other sites More sharing options...
musicmaster Posted October 23, 2020 Share Posted October 23, 2020 Run the Prestools integrity checks. It is in the free part. It won't change anything in your database (unless you choose to fix it with repair or delete). That way we will know better what we are talking about. Link to comment Share on other sites More sharing options...
rb10 Posted October 23, 2020 Author Share Posted October 23, 2020 Come posso eseguire questi strumenti? 12 hours ago, musicmaster said: Eseguire i controlli di integrità di Prestools. È nella parte libera. Non cambierà nulla nel tuo database (a meno che tu non scelga di risolverlo con riparazione o eliminazione). In questo modo sapremo meglio di cosa stiamo parlando. Link to comment Share on other sites More sharing options...
musicmaster Posted October 24, 2020 Share Posted October 24, 2020 https://www.prestashop.com/forums/topic/1011667-free-script-prestools-suite-mass-edit-order-edit-and-much-more/ Link to comment Share on other sites More sharing options...
rb10 Posted October 24, 2020 Author Share Posted October 24, 2020 when i try to install it, error message receive? Link to comment Share on other sites More sharing options...
rb10 Posted October 24, 2020 Author Share Posted October 24, 2020 is this compatible with ps 1.7.6.8 ? Link to comment Share on other sites More sharing options...
rb10 Posted October 24, 2020 Author Share Posted October 24, 2020 1 minute ago, rb10 said: is this compatible with ps 1.7.6.8 ? now i have see, not a module, thanks 😉 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