Magento ExtraMenu

Magento ExtraMenu replaces Magento classic menu with a customizable style drop down system menu, displaying all categories of the store.

Detailed description of Magento ExtraMenu is available at magentocommerce.com or bitmixsoft.com/magento/extramenu.html .

Magento HomeZones

Magento comes with an empty home page.
With Magento HomeZones you can show Top, Best price and Promotional products on home page of your store. You can individually select products to display in these sections on admin side when you add/edit products in Magento.
There are options to set display ordering, turn on/off any box, set number of items separately for each box.

Detailed description of Magento HomeZones is available at magentocommerce.com or bitmixsoft.com/magento/homezones.html .

Fix: CONNECT ERROR: The 'community' channel is not installed. Please use the MAGE shell script to install the 'community' channel.

CONNECT ERROR: The 'community' channel is not installed. Please use the MAGE shell script to install the 'community' channel.

To fix this issue just save Magento Conenct Settings.

QuickMobile.ro connector

New Magento module is available.

 

QuickMobile.ro connector import into Magento products,  mobile phone, accessories from Romanian QuickMobile Company..
Detailed description of QuickMobile.ro connector is available at magentocommerce.com.

STOKLASA-eu.com Connector

New Magento module is available.

STOKLASA-eu.com Connector import into Magento products, component, accessories and IT systems from Romanian RHS Company.
Detailed description of STOKLASA-eu.com Connector is available at magentocommerce.com.

RHS.ro connector

New Magento module is available.

RHS.ro connector import into Magento products, component, accessories and IT systems from Romanian RHS Company.
Detailed description of RHS.ro connector is available at magentocommerce.com.

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

Modify the method "_execute" in file "lib\Zend\Db\Statement\Pdo.php".

Original code:

/**
 * Executes a prepared statement.
 *
 * @param array $params OPTIONAL Values to bind to parameter placeholders.
 * @return bool
 * @throws Zend_Db_Statement_Exception
 */
public function _execute(array $params = null)
{
    try {
        if ($params !== null) {
            return $this->_stmt->execute($params);
        } else {
            return $this->_stmt->execute();
        }
    } catch (PDOException $e) {
        #require_once 'Zend/Db/Statement/Exception.php';
        throw new Zend_Db_Statement_Exception($e->getMessage(), (int) $e->getCode(), $e);
    }
}

New code:

public function _execute(array $params = null)
{
    $max_tries = 3;
    $tries = 0;
    do {
        $retry = false;
        try {
            if ($params !== null) {
                return $this->_stmt->execute($params);
            } else {
                return $this->_stmt->execute();
            }
        } catch (PDOException $e) {
            if ($tries < $max_tries && $e->getMessage()=='SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction') {
                $retry = true;
                sleep(1);
            } else {
                throw new Zend_Db_Statement_Exception($e->getMessage(), (int) $e->getCode(), $e);
            }
            $tries++;
        }
    } while ($retry);
}

Integrity constraint violation: 1062 error

If you are facing the following problem when you are trying to upload a product:

SQLSTATE[23000]: Integrity constraint violation: 1062 
Duplicate entry '167-1' for key 'IDX_STOCK_PRODUCT'

Try re-indexin from Admin panel > System > Index management or from the command prompt using the following command:

./shell php indexer.php reindexall

Running Custom SQL Query in Magento

If you want to execute your own MySQL query in Magento, here is the solution.

$sql_core = Mage::getSingleton('core/resource')->getConnection('core_read');
$select = $sql_core->select()
->from('tablename', array('*'))  // select * from tablename
->where('id=?',1);               // where id =1
$rowsArray = $sql_core->fetchAll($select);   // return all rows

Delete images programmatically

Delete all images from a product's media gallery programmatically:

Mage::app()->getStore()->setId(Mage_Core_Model_App::ADMIN_STORE_ID);

$mediaApi = Mage::getModel("catalog/product_attribute_media_api");
$mediaApiItems = $mediaApi->items($product_id);
foreach($mediaApiItems as $item) {
    $mediaApi->remove($product_id, $item['file']);
}