Invalidating query cache entries key magento


03-Sep-2017 23:13

row *************************** url_rewrite_id: 266 entity_type: category entity_id: 8 request_path: whiskey/target_path: catalog/category/view/id/8 redirect_type: 0 store_id: 1 description: NULL is_autogenerated: 1 metadata: NULL *************************** 10.

row *************************** url_rewrite_id: 351 entity_type: product entity_id: 28 request_path: target_path: catalog/product/view/id/28 redirect_type: 0 store_id: 2 description: NULL is_autogenerated: 1 metadata: NULL *************************** 11.

Hope this helps another admin who experiences these issues.

Please add your solution to this issue if different.

Hello @mgomez-dgt Thanks for your answer but problem still exist if i can change the category url or name to say "test" or "demo". There is some difference in the way the URL rewrites are handled between Magento 2.1 and 2.2 so the code is a bit different, but you can look at my changes in the PR and create a solution for Magento 2.1 from it if you like.

With that approach, the issues above were resolved without any noticeable performance hit when cache is pruned, instead of purged. /bin/sh find /var/www/html/prod/var/cache/ -type f -mmin 120 -exec rm \; find /var/www/html/prod/var/session/ -type f -mmin 120 -exec rm \; find /var/www/html/prod/var/report/ -mtime 7 -exec rm -f \; find /var/www/html/prod/var/tmp/ -mtime 1 -exec rm -f \; * Change your path of course and run as root.

I am facing "URL key for specified store already exists" error when i am trying to update existing category name as its appearing in some categories. I have read so many articales where it stated that it is solved in magento 2.1 version but its appearing again. Thanks Magento 2.1.1 Try to update the name of existing category as its appearing in some categories Category's name is updated "URL key for specified store already exists" error This problem happens when you have product and category with the same url key. [Jackalopes] [Okapis] Combined PR - MAGETWO-66480 [GITHUB] URL key for specified store already exists #6671 - MAGETWO-67296 String localization is not working when phrase contains quote (') - MAGETWO-69657 Credit Card Information disappear after user enters promotion code - MAGETWO-63249 [Elasticsearch] Composite products not searchable I would also like to see a patch that we can apply to 2.1.x.



There could be another source, but I couldn’t find it.… continue reading »


Read more