Magento Bugs

Magento remove images of deleted products

Clean up not used Magento images Magento unfortunately does not remove images of a product unfortunately if the product is removed. The following script checks all the images and checks if it’s still present in the database of Magento. If not, it deletes the image. Use the following code: Clean up Magento space: could save […]

Magento remove images of deleted products Read More »

Magento admin category tree shows no sub categories

Ever had that the category tree does not show specific subcategories that are present though? Than follow these steps: 1. Make a backup for if anything goes wrong (running all the steps is on your own risk of course). 2. Run this query SELECT c.entity_id, c.children_count as original_children_count, COUNT(c2.children_count) as `children_count`, c.level as original_level, (LENGTH(c.path)-LENGTH(REPLACE(c.path,’/’,”))) as

Magento admin category tree shows no sub categories Read More »

Fixing “Front controller reached 100 router match iterations”

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 »

Magento Product Flat Data – reindex error

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 Account Session Problems Google Chrome + Safari

This is the probable solution: Having session/cookie problems with webkit browsers (e.g. Chrome) in Magento? Go to System -> Configuration -> Web -> Session Cookie Management and set “Use HTTP Only” to no. Have fun. (Thanks to Howlingwolf.de). Setting your cookies to ‘36000’ instead of 3600 could be a solution as well.

Magento Account Session Problems Google Chrome + Safari Read More »

Module error message: MediabrowserUtility is not defined

If you install a custom module in Magento it could lack the TinyMce Mediabrowser. You get the following message then: error: error in [unknown object].fireEvent(): event name: open_browser_callback error message: MediabrowserUtility is not defined How to fix this? Quick fix In /app/design/adminhtml/default/default/layout/YOURMODULE.xml add: 1 js_cssprototype/windows/themes/default.css js_cssprototype/windows/themes/magento.css lib/prototype/windows/themes/magento.css Or change to Long solution (may not work)

Module error message: MediabrowserUtility is not defined Read More »

Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction

When having trouble with the error: “Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction” or when your place order / order confirmation gets stuck. Fixing the order process getting stuck: According to the Magento Forum, in MySQL, try: TRUNCATE `log_customer`; TRUNCATE `log_quote`; TRUNCATE `log_summary`; TRUNCATE `log_summary_type`; TRUNCATE `log_url`; TRUNCATE `log_url_info`; TRUNCATE `log_visitor`; TRUNCATE `log_visitor_info`; Of course create a

Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction Read More »

Scroll to Top