Guest User

Untitled

a guest
Nov 15th, 2018
118
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.13 KB | None | 0 0
  1. SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-510' for key 'PRIMARY', query was: INSERT INTO `temp_catalog_category_tree_index_40850d82` (`parent_id`,`child_id`) VALUES (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?,
  2. Product Categories indexer process unknown error:
  3. SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-510' for key 'PRIMARY', query was: INSERT INTO `temp_catalog_category_tree_index_cebdbaaf` (`parent_id`,`child_id`) VALUES (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?,
  4. Catalog Rule Product index has been rebuilt successfully in 00:00:00
  5.  
  6. mysql> select row_id, entity_id, path from catalog_category_entity where path like '1/1/%';
  7.  
  8. +--------+-----------+---------+
  9. | row_id | entity_id | path |
  10. +--------+-----------+---------+
  11. | 510 | 510 | 1/1/510 |
  12. | 511 | 511 | 1/1/511 |
  13. +--------+-----------+---------+
  14. 2 rows in set (0.01 sec)
  15. Resolution: not a bug
  16. PLEASE PERFORM THE FOLLOWING ACTIONS:
  17. execute the next SQL:
  18. update catalog_category_entity set path = replace(path, '1/1/', '1/')
  19. where path like '1/1/%';
Add Comment
Please, Sign In to add comment