You may encounter the 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) … This error may occur after upgrading to Magento 2.3.x and executing…
Adding payment method icons to the i-ways PayPal Plus extension (Magento 2)
Everyone knows it and nobody likes it: when using the i-ways PayPal Plus extension for Magento 1 or Magento 2, payment methods from third-party providers often have no icons. This is not so much a problem with the i-ways extension…
Resetting a customer password using SQL (Magento 2)
Use the following SQL code to reset a customer’s password directly in your Magento 2 database.
|
1 2 3 4 5 |
SET @passwd='123456789', @salt=MD5(RAND()); UPDATE customer_entity SET password_hash = CONCAT(SHA2(CONCAT(@salt, @passwd), 256), ':', @salt, ':1') WHERE email = 'test@example.com'; |
Disabling or enabling CSS merging (Magento 2)
Run these commands from your Magento 2 root directory to disable CSS merging:
|
1 2 3 |
php bin/magento config:set dev/css/merge_css_files 0 php bin/magento cache:clean php bin/magento cache:flush |
To enable CSS merging again, run the following commands:
|
1 2 3 |
php bin/magento config:set dev/css/merge_css_files 1 php bin/magento cache:clean php bin/magento cache:flush |
This method works with Magento 2.2 and later.
Setting the next order number using SQL (Magento 2)
In Magento 2, the tables sequence_order_* determine which order number will be assigned next for each store view. The number at the end of the table name identifies the store view. For example, sequence_order_1 stores the sequence for store view…
Fixing Class adminhtml/catalog_product_helper_form_msrp_enabled does not exist (Magento 2)
If your Magento 2 store displays the error main.CRITICAL: Class adminhtml/catalog_product_helper_form_msrp_enabled does not exist , it is very likely that the store was migrated from Magento 1 at some point. To fix the issue, search your database for the value…
Checkout agreements not working / can not be accepted when using PayPal (Magento 2)
You created several checkout agreements in your Magento 2 store, but as soon as you choose PayPal as payment method in the checkout, it just won’t accept those agreements? Instead, a validation error is returned whether or not the agreement…
Disable maintenance mode for certain IP (Magento 2)
With Magento 2 it is possible to disable the maintenance mode for only a certain IP. Disabling the Magento 2 maintenance mode for your IP lets you browse the frontend and admin area as normal. All other visitors will still…
Referencing a static block from a CMS page (Magento 2)
Want to reference a static block on a Magento 2 CMS page? Just insert the following snippet into the content editor to render the static block identified by block_identifier anzeigen zu lassen.
|
1 |
{{block class="Magento\\Cms\\Block\\Block" block_id="block_identifier"}} |
PayPal checkout terms and conditions cannot be accepted (Magento 2)
Have you configured various checkout agreements in Magento 2, such as terms and conditions or withdrawal information, but PayPal still says the customer must accept them even though they were checked? The problem is that the checkout agreement values are…