reset XAMPP MySQL root password via PHPMYADMIN

Thursday, 8. November 2012

A little snippet for resetting a mysql root password via phpmyadmin

UPDATE mysql.USER SET Password=PASSWORD('password') WHERE USER='root';
FLUSH PRIVILEGES;

Magento 404 Error CMS Page Not Found In Admin Panel

Thursday, 1. November 2012

If you have been getting a 404 error when trying to access CMS pages in magento admin, possibly after an upgrade, chances are you have store IDs mixed up!

Run this script in phpmyadmin against the site database and hopefully it will bring smile to your face!

DELETE FROM cms_page_store WHERE store_id NOT IN (SELECT store_id FROM core_store);

Invalid model for shipping method: msmultiflat – Magento

Tuesday, 28. February 2012

Came across this error while upgrading Magento Invalid model for shipping method: msmultiflat – and here is a solution on how to solve it.

In this case, the shipping module in question was no longer needed, so the solution was to delete it from the system.

Open your phpmyadmin OR similar DB IDE of your choice and run the following script

DELETE FROM core_config_data WHERE path LIKE '%carriers/msmultiflat%'

*** CLEAR YOUR MAGENTO CACHE after running your script ***

NOTE:
Similar script can be used to delete any other missing model for that matter.. just replace msmultiflat with the missing model!