[PrestaShopDatabaseException]

Unknown column 'psi.id_country' in 'on clause'

SELECT psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM ek_product p INNER JOIN ek_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 8) INNER JOIN ek_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ek_category c ON (cp.id_category = c.id_category AND c.active=1) INNER JOIN ek_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) WHERE p.visibility IN ('both', 'catalog') AND p.id_manufacturer IN (95, 156, 266, 155, 34) AND c.nleft>=37 AND c.nright<=74 AND ps.id_shop='1'

at line 746 in file classes/db/Db.php

741.         if ($webservice_call && $errno) {
742.             $dbg = debug_backtrace();
743.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
744.         } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
745.             if ($sql) {
746.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
747.             }
748. 
749.             throw new PrestaShopDatabaseException($this->getMsgError());
750.         }
751.     }