Fixing “Front controller reached 100 router match iterations”

Leave a Comment / Magento Bugs / /

Ever got the bug: “Front controller reached 100 router match iterations”? Solve it as follows: 1. You can get more information by going to Magento Core file app/code/core/Mage/Core/Controller/Varien/Front.php, find there lines: while (!$request->isDispatched() && $i++<100) { foreach ($this->_routers as $router) { if ($router->match($this->getRequest())) { break; } } } Replace with: Mage::log(‘—-Matching routers——————————‘); Mage::log(‘Total ‘ . […]

Fixing “Front controller reached 100 router match iterations” Read More »

One Step Checkout – show shipping methods after postcode entered

Leave a Comment / Magento Optimizations / /

Would you like to show shipping methods of a one step checkout plugin after that a postcode is entered? Go to the file app/design/frontend/base/default/template/checkout/onepage/shipping_method/available.phtml and replicate this file in your default interface/theme. Within the file, after (about line 31): Add: And close the else tag at the end. You can do this with countries, cities,

One Step Checkout – show shipping methods after postcode entered Read More »

SSH import sql database with host syntax (if not localhost)

Leave a Comment / General / /

How to import a .sql.gz file when the host is not localhost? Use this syntax: $ mysql -h db365838511.db.1and1.com -u dbun1234 -p db365838511 < 1and1help.com-Joomla-Apr.05.2010.sql Explanation: mysql: This is the MySQL command to access your databases -h db365838511.db.1and1.com: This is the Host Name where your database is located (available from the 1&1 Control Panel). -u

SSH import sql database with host syntax (if not localhost) Read More »

Magento Direct SQL Queries

2 Comments / Magento Optimizations, Tips and Tricks / /

Queries for fetching in an array /** * Get the resource model */ $resource = Mage::getSingleton(‘core/resource’); /** * Retrieve the read connection */ $readConnection = $resource->getConnection(‘core_read’); $query = ‘SELECT * FROM ‘ . $resource->getTableName(‘catalog/product’); /** * Execute the query and store the results in $results */ $results = $readConnection->fetchAll($query); /** * Print out the results

Magento Direct SQL Queries Read More »

Magento Product Flat Data – reindex error

Leave a Comment / Magento Bugs / /

When you get the error: Product Flat Data index process unknown error: exception ‘PDOException’ with message ‘SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`sprayfoa_store`.<result 2 when explaining filename ‘#sql-66c_ab044′>, CONSTRAINT `FK_CAT_PRD_FLAT_1_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity`)’ in … Stack trace: Try to truncate all the

Magento Product Flat Data – reindex error Read More »

Magento A/B testing or Multivariate testing – Php script

1 Comment / Magento Optimizations, Magento Plugins, PHP / /

Follow-up: check out this free Matomo A/B testing plugin as an alternative. Split test A/B PHP Script Magento is quite limited in tools like conversion optimalisation like A/B testing or multivariate testing. That is why I created a very simple php script that you can put directly into a phtml file. It’s a bit hacky,

Magento A/B testing or Multivariate testing – Php script Read More »

Lesti::Fpc and layered navigation (Vinagento and Amasty)

6 Comments / Magento Optimizations, Magento Plugins / /

How to let Lesti::FPC Full page caching work with Vinagento Layered Navigation in Ajax mode? I just tried some random settings and this seemed to work: In System->Configuration->Sytem->Lesti FPC add the following to Session Params: catalogsearch_advanced_result_ajax, catalog_category_ajax_view, catalog_category_layered_ajax, catalogsearch_result_ajax In System->Configuration->Sytem->Lesti FPC add the following to Uri Params: id, category, page_id, p, limit, dir, order,

Lesti::Fpc and layered navigation (Vinagento and Amasty) Read More »

en_USEnglish
de_DEDeutsch nl_NLNederlands fr_FRFrançais es_ESEspañol it_ITItaliano sv_SESvenska en_USEnglish
Scroll to Top