Saving product with data like this: $ids = array(‘1′,’1′,’2’); $_product->setWebsiteIds($ids); makes error : “SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry …”. To avoid this error, just use function array_unique, on $ids array. This solution, i think, could be implemented as default in new version of Magento.

Read more

Read more

Upgrade Magento from 1.3, 1.4 .. to latest via ssh

1.

2.

3.

4.

5.

6. If You have got an error: “Channel ‘community’ already exist!” try this:

7.

8.

9.

10.

11. If You have some error, try this:

12. After that, just load front page, and try to solve the rest of […]

Read more

Simple Configurable Products index price error

Simple Configurable Products module from Organic internet is one of better solution for display configurable products. However, Magento 1.7.0.2 not supported it completely. To make it work, you simple should add in file:

after(:87)

this code:

and in file:

change:

to:

Read more

Magento admin grid column is ambiguous – filter index

Sometimes, if you use custom collection with join tables:

you’ll get an error: ‘SQLSTATE[23000]: Integrity constraint violation: 1052 Column ‘created_at’ in where clause is ambiguous’ To avoid that, use this:

Read more

Custom admin template

Add in your module config.xml file, in

tag:

Create new catalogs, such like as: app/design/adminhtml/default/custom app/design/adminhtml/default/custom/template app/design/adminhtml/default/custom/layout And do what you use to do with frontend template 🙂

Read more

Admin 404 after transfer to other domain

Read more

Magento Indexer From Shell

Read more

Magento Events List

Location Line Event cron.php 44 default app/code/core/Mage/Adminhtml/Controller/Action.php 151 adminhtml_controller_action_predispatch_start app/code/core/Mage/Adminhtml/Block/Customer/Edit/Tab/Carts.php 61 adminhtml_block_html_before app/code/core/Mage/Adminhtml/Block/Report/Grid.php 186 adminhtml_widget_grid_filter_collection app/code/core/Mage/Adminhtml/Block/Cms/Page/Edit/Tab/Meta.php 76 adminhtml_cms_page_edit_tab_meta_prepare_form app/code/core/Mage/Adminhtml/Block/Cms/Page/Edit/Tab/Design.php 125 adminhtml_cms_page_edit_tab_design_prepare_form app/code/core/Mage/Adminhtml/Block/Cms/Page/Edit/Tab/Main.php 117 adminhtml_cms_page_edit_tab_main_prepare_form app/code/core/Mage/Adminhtml/Block/Cms/Page/Edit/Tab/Content.php 98 adminhtml_cms_page_edit_tab_content_prepare_form app/code/core/Mage/Adminhtml/Block/Widget/Container.php 307 adminhtml_widget_container_html_before app/code/core/Mage/Adminhtml/Block/Template.php 80 adminhtml_block_html_before app/code/core/Mage/Adminhtml/Block/Sales/Reorder/Renderer/Action.php 55 adminhtml_customer_orders_add_action_renderer app/code/core/Mage/Adminhtml/Block/Catalog/Category/Tabs.php 154 adminhtml_catalog_category_tabs app/code/core/Mage/Adminhtml/Block/Catalog/Category/Tree.php 284 adminhtml_catalog_category_tree_is_moveable app/code/core/Mage/Adminhtml/Block/Catalog/Category/Tree.php 321 adminhtml_catalog_category_tree_can_add_root_category app/code/core/Mage/Adminhtml/Block/Catalog/Category/Tree.php 341 adminhtml_catalog_category_tree_can_add_sub_category app/code/core/Mage/Adminhtml/Block/Catalog/Product/Attribute/New/Product/Attributes.php 64 adminhtml_catalog_product_edit_prepare_form app/code/core/Mage/Adminhtml/Block/Catalog/Product/Attribute/New/Product/Attributes.php 80 adminhtml_catalog_product_edit_element_types app/code/core/Mage/Adminhtml/Block/Catalog/Product/Attribute/Set/Main.php […]

Read more