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']);
}

Fix Magento Connect Manager installation issues

After a new Magento installation or Magento moving to another server,
Magento Connect Manager is throwing permissions errors like:
Warning: Your Magento folder does not have sufficient write permissions.

Fix Magento v1.4.1.x bug

Magento v1.4.1.x has a very serious bug in its core.

FREE - Add new menu link to Magento

We can add menu points to your magento installation.