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 …
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 »
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 »
Having problem with slow Magento SQL queries? Then, enable Magento query logging in: lib/Varien/Db/Adapter/Pdo/Mysql.php More info about the settings at: http://briansnelson.com/Enable_Mysql_Slow_Query_Logging
Would like to add a product via an url like (as described in this Mage article):
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 …
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.
Problem: the wrong image is shown compared to the image you inserted. Possible errors: Check per product all the store view images. Maybe it crosses with your desired image. Rebuild the image cache Check permissions on the directory Check whether there is an image with the same name already in the media file. Also check …
Magento not finding or showing right product images Read More »
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 »
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 …