How to Resolve Ambiguous Column Filter with Custom Magento Grid

We have situations with maintaining a custom magento grid by adding one or more custom columns for retrieving meaningful and expanded details. Suppose we have built a custom grid and the source collection has an ambiguous column in the where / group by clause when applying a filter option i.e., we may have stuck with the following exception in magento backend.

Read More

Best Configuration for Magento

Following are some important configurations that will speed up the Magento site. This tutorial is mainly focusing on my.cnf, php.ini and apache configuration files.

Read More

RUN MYSQLDUMP WITHOUT LOCKING TABLES

RUN MYSQLDUMP WITHOUT LOCKING TABLES

Hey all Magento administrators or developers out there, just a short tip here on how to avoid locking tables when you...

Read More

Column count doesn't match on saving the product after magneto upgrade

SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1. This problem was with the 9th column in catalogrule_product_price. It seems TBT adds a 9th column called rules_hash. It seems the newer versions don’t need this. You can looked at a magento 1.8.0.0 database and sure enough the stock database table doesn’t have this column. You can drop the field "rules_hash" and now no more error.

Read More

4 Item(s)