vladismenko Posted April 2, 2018 Share Posted April 2, 2018 please, i have this problem, what I can do? [PrestaShopDatabaseException] Unknown column 'cl.id_shop' in 'where clause' SELECT bcp.`id_cms_category`, bcp.`id_parent`, bcp.`level_depth`, bcp.`active`, bcp.`position`, cl.`name`, cl.`link_rewrite` FROM `ps_cms_category` bcp INNER JOIN `ps_cms_category_lang` cl ON (bcp.`id_cms_category` = cl.`id_cms_category`) WHERE cl.`id_lang` = 6 AND cl.`id_shop` = 1 AND bcp.`id_parent` = 0 at line 635 in file classes/db/Db.php 629. WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 630. } 631. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) 632. { 633. if ($sql) 634. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 635. throw new PrestaShopDatabaseException($this->getMsgError()); 636. } 637. } 638. 639. /** Link to comment Share on other sites More sharing options...
bellini13 Posted April 2, 2018 Share Posted April 2, 2018 The error says that the database table named `ps_cms_category_lang` does not have a column named `id_shop` What exactly are you trying to do? What version of Prestashop? Did you do some kind of upgrade or customization? Link to comment Share on other sites More sharing options...
vladismenko Posted April 2, 2018 Author Share Posted April 2, 2018 thank you, I added column id_shop to table and it works Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now