月度归档： 2021年12月

发布于

[Maggento V2.3.4 composer]Higher matching version 4.0.1 of mageplaza/module-same-order-number was found in public repository packagist.org
than 1.0.3 in private https://repo.magento.com. Public package might’ve been taken over by a mal
icious entity,

安装Marketplace 的mageplaza/module-same-order-number

原因是 mageplaza/module-same-order-number 在packgist 版本是4.0.1

官方解释是防止依赖混淆攻击。

Magento 官方link

解决方法：

修改 根目录下的 composer.json

"type": "composer",
"url": "https://repo.magento.com/",
"canonical": false   // add this line

来自

发布于

[Magento 2.4.3] SQLSTATE[HY000]: General error: 1419 You do not have the SUPER privilege and binary logging is enabled in setup:performance:generate-fixtures – Solved

Background:

Run below commander in Magento CLI

php bin/magento setup:performance:generate-fixtures -s setup/performance-toolkit/profiles/ce/small.xml

Error msg:

Generating profile with following params:
 |- Admin Users: 50
 |- Websites: 1
 |- Store Groups Count: 1
 |- Store Views Count: 1
 |- Categories: 30
 |- Attribute Sets (Default): 3
 |- Attribute Sets (Extra): 10
 |- Simple products: 800
 |- Configurable products: 16
 |- Product images: 100, 3 per product
 |- Customers: 200
 |- Cart Price Rules: 20
 |- Catalog Price Rules: 20
 |- Coupon Codes: 20
 |- Orders: 80
Config Changes...  done in 00:00:00
SQLSTATE[HY000]: General error: 1419 You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable), query was: CREATE TRIGGER trg_catalog_category_entity_after_insert AFTER INSERT ON catalog_category_entity FOR EACH ROW
BEGIN
INSERT IGNORE INTO `catalog_category_product_cl` (`entity_id`) VALUES (NEW.`entity_id`);
END


How to fix

run in MySQL with root user

set global log_bin_trust_function_creators=1;

Refrence Link:

bitnami community

stackexchange magento