Magento 2 Your password has expired

After resetting password on a Magento 2 installation, when trying to login to backend, I get following error message. Your password has expired; please contact your administrator. All other open sessions for this account were terminated. It’s time to change your password. To fix this error, on the command line, run the following commands php … Read more

Magento 2 Disable Two-Factor Authorization

Magento Two-Factor Authorization

On a Magento 2.4 fresh installation, when I log in to the backend, I got the following error message. You need to configure Two-Factor Authorization in order to proceed to your store’s admin area An E-mail was sent to you with further instructions To disable Magento Two-Factor Authorization, run the command bin/magento module:disable Magento_TwoFactorAuth bin/magento … Read more

Validate class not found from basename Magento\Framework\Validator\EmailAddress

After Migrating a Magento site from shared hosting to a dedicated server running Plesk, when doing check out, I get an error message Unable to save address. Please check input data. When checking the error log var/log/exception.log, found following error message [2022-05-10 09:30:36] main.CRITICAL: Validate class not found from basename ‘Magento\Framework\Validator\EmailAddress’ {“exception”:”[object] (Zend_Validate_Exception(code: 0): Validate … Read more

How to clean Magento 1.x database

When I try to make a copy of the Magento 1 site, it takes forever to restore the MySQL database. The size of the database was 8.6 GB. On checking, I found some tables like report_event are very large. To clear the tables, Magento provides a script, you can run it with php -f shell/log.php … Read more

Can’t create table `catalog_product_relation` (errno: 140 “Wrong create options”)

When I try to restore the MySQL database of a Magento 1.x site on MariaDB 10.3.32 (source MySQL 5.7.36), I get the following error boby@sok-01:/www/magento/amazingplans/backup$ mysql amazingplans < amazingp_demo.sql ERROR 1005 (HY000) at line 4080: Can't create table `amazingplans`.`catalog_product_relation` (errno: 140 "Wrong create options") boby@sok-01:/www/magento/amazingplans/backup$ On checking the line in the error message, I found ... Read more

Magento 2 Password reset

magento 2

Magento 2 is popular open-source eCommerce software. If you lost admin password for your Magento 2 website, you can follow the instructions below to reset your password. Find the crypt key from file app/etc/evn.php Once you have the key, you can run following SQL command using MySQL command line or phpMyAdmin. UPDATE admin_user SET password … Read more

Magento 2 admin too many redirects error

magento 2 admin redirect error

On a Magento 2 site, after migrating to a new domain, when accessing the admin area, I get too many redirect error. To fix, using the following SQL command verify URLs are correct. SELECT * FROM core_config_data WHERE path like ‘%_url’; if any URL is not correct, fix it. Then run the following commands in … Read more

Magento Disable CDN

To see URLs configured on a Magento 2 installation, run the following SQL command select * from core_config_data where path like ‘%_url’; Example mysql> select * from core_config_data where path like ‘%_url’; +———–+———+———-+————————————+————————————————————————+———————+ | config_id | scope | scope_id | path | value | updated_at | +———–+———+———-+————————————+————————————————————————+———————+ | 10 | default | 0 | web/unsecure/base_url … Read more

Magento catalog_product_relation MySQL Error

On transferring a Magento website Database running on MySQL 5.7.34 to MariaDB 10.2.39, I get the following error [root@server52 etc]# mysql buildingplans_m1 < db.sql ERROR 1005 (HY000) at line 4080: Can't create table `buildingplans_m1`.`catalog_product_relation` (errno: 140 "Wrong create options") [root@server52 etc]# SQL Strict mode was already off on this MySQL server. MariaDB [(none)]> select @@sql_mode; … Read more