Magento: Upgrade from 1.6 to 1.9 PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.0' in 'on clause'' in lib/Zend/Db/Statement/Pdo.php:228

I've just upgraded our e-commerce website which uses Magento version 1.5. I upgraded it to the latest Really lots and lots of bug fixes to be done and of them is what's the title of this post.

Anyways, you can fix it by going to Mage_Reports_Model_Resource_Product_Collection::setProductEntityId and remove the (int) because it's trying to convert the string into integer. This is not the best fix but I'm in a hurry so if you found something that is more appropriate then please leave a comment and don't just runaway. Cheers

    public function setProductEntityId($entityId)
        $this->_productEntityId = (int)$entityId;
        return $this;


Popular posts from this blog

How to fix Cignal Top Box error - Please perform a smart card reset by removing your smart card for 15 seconds then reinsert the card. (1/2)

Magento: can't login to admin panel, can't add product to cart

Magento: How to fix "The requested URL /index.php was not found on this server" error