Error 500 ps_idxforbiddenproducts_categories

[Fabrizio r]

Hello,

I use the Leotheme Datran theme. After activating the classic theme, and after returning to Datran, I get a 500 error on all the pages of my site in prestashop 1.7.1.2.
Activating debugging tells me this error:

[PrestaShopDatabaseException]

Table 'databasename.ps_idxforbiddenproducts_categories' doesn't exist

SELECT DISTINCT id_category FROM ps_idxforbiddenproducts_categories

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

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

 

By activating "disable all overrides" the site becomes visible again, but not the category pages, which I understand are the problem.

I also tried to restore a copy of the saved database before changing the theme, but did not solve the problem.

Does anyone know how to help me?

Fabrizio

[Rolige]

Hello:

It seem that a DB table is missing, probably deleted when you change to classic theme. You should restore this table again in your DB.

Regards