Suite à MAJ : Unknown column 'image_shop.id_product' in 'on clause'

[Gavimse]

Bonjour,

Suite à la MAJ de mon presta 1.6.1 à 1.6.1.24, je n'ai plus accès à mes produits sur le FO et dans le BO Catalogue / Produits j'ai ce message :

Mauvaise requête SQL
Unknown column 'image_shop.id_product' in 'on clause'

Quelle est la solution?

Merci

Edited September 9, 2019 by Gavimse (see edit history)

[Gavimse]

Quand je mets le mode debug, voici l'erreur :

Notice: Use of undefined constant _PS_CUSTOM_CONFIG_FILE_ - assumed '_PS_CUSTOM_CONFIG_FILE_' in /home/monsite/www/config/config.inc.php on line 69
Notice: Constant _PS_PRICE_DISPLAY_PRECISION_ already defined in /home/monsite/www/config/config.inc.php on line 131

[PrestaShopDatabaseException]
Table 'mabdd.ps_smarty_last_flush' doesn't exist
SELECT UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' 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 723 - classes/db/Db.php] - [2 Arguments]
DbCore->getValue - [line 95 - classes/SmartyCustom.php] - [2 Arguments]
SmartyCustomCore->check_compile_cache_invalidation - [line 109 - classes/SmartyCustom.php]
SmartyCustomCore->fetch - [line 2278 - classes/controller/AdminController.php] - [1 Arguments]
AdminControllerCore->initModal - [line 2777 - classes/controller/AdminController.php]
AdminControllerCore->init - [line 170 - classes/controller/Controller.php]
ControllerCore->run - [line 367 - classes/Dispatcher.php]
DispatcherCore->dispatch - [line 58 - admin/index.php]

Edited September 16, 2019 by Gavimse (see edit history)