When I installed Jextn Faq Extension I got the following error:
SQLSTATE[4 2S22]: Column not found: 1054 Unknown column 'store' in 'where clause'
SQLSTATE[4
I have just comment on three lines and works for me.
app\code\community\Jextn\Faq\Model\Mysql4\Faq\collection.php
after
public function setFirstStoreFlag($flag = false) { $this->$previewFlag = $flag; return $this; }
before
public function setFirstStoreFlag($flag = false) { // $this->$previewFlag = $flag; return $flag; }
In same file remove If condition from function _afterLoad() and its look like this
protected function _afterLoad() { // if ($this->$previewFlag) { $items = $this->getColumnValues('faq_id'); if (count($items)) { $select = $this->getConnection()->select() ->from($this->getTable('faq_store')) ->where($this->getTable('faq_store').'.faq_id IN (?)', $items); if ($result = $this->getConnection()->fetchPairs($select)) { foreach ($this as $item) { if (!isset($result[$item->getData('faq_id')])) { continue; } if ($result[$item->getData('faq_id')] == 0) { $stores = Mage::app()->getStores(false, true); $storeId = current($stores)->getId(); $storeCode = key($stores); } else { $storeId = $result[$item->getData('faq_id')]; $storeCode = Mage::app()->getStore($storeId)->getCode(); } $item->setData('_first_store_id', $storeId); $item->setData('store_code', $storeCode); } } } // } parent::_afterLoad(); }
change in this file also app\code\community\Jextn\Faq\Model\Mysql4\faq.php change
after
$collection = Mage::getModel('faq/faq')->getCollection() ->addStoreFilter($storeId) ->addIsActiveFilter();
before
$collection = Mage::getModel('faq/faq')->getCollection() //->addStoreFilter($storeId) ->addIsActiveFilter();
No comments:
Post a Comment