search

Smile-SA / mongogento

98 stars 48 forks source link

category_ids is not supported since magento 1.4 #18

Closed southerncomputer closed 8 years ago

southerncomputer commented 8 years ago

PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.category_ids' in 'field list'' in /var/www/html/scw.com/lib/Zend/Db/Statement/Pdo.php:228

Caused by $staticFields[0]='category_ids' being passed to :+1:

protected function _getProducts(array $staticFields, $productIds = null, $lastProductId = 0) { $readAdapter = $this->_getReadAdapter();

    $select = $readAdapter->select()
        ->useStraightJoin(true)
        ->from(
            array('e' => $this->getTable('catalog/product')),
            array_merge(array('entity_id', 'type_id', 'attribute_set_id', 'entity_type_id'), $staticFields)
        );

"Magento removing the field “category_ids” from catalog_product_entity table in version 1.4 "

unset($staticFields[0]); is not a graceful way to patch this!

hmphu commented 8 years ago

hi @southerncomputer , This issue is fixed by merge request #19

romainruaud commented 8 years ago

@hmphu is right. I close the issue.