Unknown column 's.id_theme' in 'on clause'

[gerhard7000]

Hi,

I get the following Error-message and I have no idea what I can do.It would be great, if you can help me. Thanks a lot. 

 

Unknown column 's.id_theme' in 'on clause'

 

SELECT su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory FROM ps_shop s LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop) LEFT JOIN ps_theme t ON (t.id_theme = s.id_theme) WHERE s.id_shop = 1 AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1

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

786. if ($webservice_call && $errno) { 787. $dbg = debug_backtrace(); 788. WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 789. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) { 790. if ($sql) { 791. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 792. } 793. 794. throw new PrestaShopDatabaseException($this->getMsgError()); 795. } 796. }

DbCore->displayError - [line 425 - classes/db/Db.php] - [1 Arguments]

DbCore->query - [line 690 - classes/db/Db.php] - [1 Arguments]

DbCore->getRow - [line 202 - classes/shop/Shop.php] - [1 Arguments]

ShopCore->setUrl - [line 133 - classes/shop/Shop.php]

ShopCore->__construct - [line 397 - classes/shop/Shop.php] - [1 Arguments]

ShopCore::initialize - [line 114 - config/config.inc.php]

require - [line 27 - index.php] - [1 Arguments]