Neven Kajić nkajic
nkajic
/ m2-delete-catalog-product-eav-duplicates.sql
Last active
March 22, 2023 09:33
Delete Magento 2 duplicates on store vs global view catalog product
View m2-delete-catalog-product-eav-duplicates.sql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- catalog_product_entity_varchar | |
| SELECT * -- DELETE attribute_value_store | |
| FROM catalog_product_entity_varchar attribute_value_store | |
| JOIN catalog_product_entity_varchar attribute_value_global | |
| ON attribute_value_global.store_id = 0 | |
| AND attribute_value_global.attribute_id = attribute_value_store.attribute_id | |
| AND attribute_value_global.entity_id = attribute_value_store.entity_id | |
| AND attribute_value_global.value = attribute_value_store.value | |
| WHERE attribute_value_store.store_id > 0 |
nkajic
/ remove-passive-listeners-warning-p1.patch
Last active
October 16, 2021 23:42
Remove passive listeners warning p1 and p2 patch
View remove-passive-listeners-warning-p1.patch
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| --- lib/web/jquery/patches/jquery.js | |
| +++ lib/web/jquery/patches/jquery.js | |
| @@ -19,6 +19,33 @@ define([], function () { | |
| }); | |
| } | |
| + /** | |
| + * Does not use passive listeners to improve scrolling performance | |
| + * https://stackoverflow.com/questions/60357083/does-not-use-passive-listeners-to-improve-scrolling-performance-lighthouse-repo | |
| + */ |
nkajic
/ LC_CTYPE.txt
Created
April 23, 2019 11:07
— forked from jampajeen/LC_CTYPE.txt
Centos warning: setlocale: LC_CTYPE: cannot change locale (UTF-8): No such file or directory
View LC_CTYPE.txt
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| vi /etc/environment | |
| add these lines... | |
| LANG=en_US.utf-8 | |
| LC_ALL=en_US.utf-8 |
View misc.xml
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?xml version="1.0"?> | |
| <project version="4"> | |
| <component version="2" name="ProjectRootManager"/> | |
| <component name="ProjectResources"> | |
| <resource url="urn:magento:module:Magento_Store:etc/config.xsd" location="$PROJECT_DIR$/vendor/magento/module-store/etc/config.xsd"/> | |
| <resource url="urn:magento:framework:ObjectManager/etc/config.xsd" location="$PROJECT_DIR$/vendor/magento/framework/ObjectManager/etc/config.xsd"/> | |
| <resource url="urn:magento:framework:Module/etc/module.xsd" location="$PROJECT_DIR$/vendor/magento/framework/Module/etc/module.xsd"/> | |
| <resource url="urn:magento:module:Magento_Config:etc/system_file.xsd" location="$PROJECT_DIR$/vendor/magento/module-config/etc/system_file.xsd"/> | |
| <resource url="urn:magento:framework:App/etc/routes.xsd" location="$PROJECT_DIR$/vendor/magento/framework/App/etc/routes.xsd"/> | |
| <resource url="urn:magento:module:Magento_Ui:etc/ui_definition.map.xsd" location="$PROJECT_DIR$/vendor/magento/module-ui/etc/ui_definition.map.xsd"/> |
View misc.xml
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?xml version="1.0" encoding="UTF-8"?> | |
| <project version="4"> | |
| <component name="ProjectResources"> | |
| <resource url="urn:magento:framework:Acl/etc/acl.xsd" location="$PROJECT_DIR$/vendor/magento/framework/Acl/etc/acl.xsd" /> | |
| <resource url="urn:magento:framework:Api/etc/extension_attributes.xsd" location="$PROJECT_DIR$/vendor/magento/framework/Api/etc/extension_attributes.xsd" /> | |
| <resource url="urn:magento:framework:App/etc/resources.xsd" location="$PROJECT_DIR$/vendor/magento/framework/App/etc/resources.xsd" /> | |
| <resource url="urn:magento:framework:App/etc/routes.xsd" location="$PROJECT_DIR$/vendor/magento/framework/App/etc/routes.xsd" /> | |
| <resource url="urn:magento:framework:Cache/etc/cache.xsd" location="$PROJECT_DIR$/vendor/magento/framework/Cache/etc/cache.xsd" /> | |
| <resource url="urn:magento:framework:Config/etc/theme.xsd" location="$PROJECT_DIR$/vendor/magento/framework/Config/etc/theme.xsd" /> | |
| <resource url="urn:magento:framework:Config/etc/view.xsd" location="$PROJECT_DIR$/vendor/ |