[SOLVED] DB Table layered_friendly_url does not exist

[georgebishop]

Hi all,

Having a major issue here! Whenever I click on a link in the nav on the site sport-banter.com it throws this error message:

Quote

 

[PrestaShopDatabaseException]

Table 'myiconsh_new.ps_layered_friendly_url' doesn't exist
 

SELECT data FROM `ps_layered_friendly_url` WHERE `url_key` = 'ca9754cd89b5e41fbfa5ad02925b1330' LIMIT 1

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

607. WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 608. } 609. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) 610. { 611. if ($sql) 612. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 613. throw new PrestaShopDatabaseException($this->getMsgError()); 614. } 615. } 616. 617. /**
		

		

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

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

DbCore->getRow - [line 550 - classes/db/Db.php] - [2 Arguments]

DbCore->getValue - [line 2130 - modules/blocklayered_mod/blocklayered_mod.php] - [1 Arguments]

BlockLayered_mod->getSelectedFilters - [line 1268 - modules/blocklayered_mod/blocklayered_mod.php] - [0 Argument]

BlockLayered_mod->hookFooter - [line 475 - classes/Hook.php] - [1 Arguments]

HookCore::exec - [line 774 - classes/controller/FrontController.php] - [1 Arguments]

FrontControllerCore->initFooter - [line 172 - classes/controller/Controller.php] - [0 Argument]

ControllerCore->run - [line 389 - modules/bvkseodispatcher/bvkseodispatcher.php] - [0 Argument]

BVKSEODispatcher->run - [line 334 - modules/bvkseodispatcher/bvkseodispatcher.php] - [1 Arguments]

BVKSEODispatcher->dispatch - [line 12 - override/classes/controller/Controller.php] - [0 Argument]

Controller::getController - [line 341 - classes/Dispatcher.php] - [1 Arguments]

DispatcherCore->dispatch - [line 30 - index.php] - [0 Argument]

 

Can't get into the Config section of the Layered Navigation Block module from the back office; clicking it throws this error:

Quote

 

[PrestaShopDatabaseException]

Table 'myiconsh_new.ps_layered_filter' doesn't exist
 

SELECT * FROM ps_layered_filter ORDER BY date_add DESC

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

607. WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 608. } 609. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) 610. { 611. if ($sql) 612. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 613. throw new PrestaShopDatabaseException($this->getMsgError()); 614. } 615. } 616. 617. /**
				

				

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

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

DbCore->executeS - [line 1645 - modules/blocklayered_mod/blocklayered_mod.php] - [1 Arguments]

BlockLayered_mod->getContent - [line 685 - controllers/admin/AdminModulesController.php] - [0 Argument]

AdminModulesControllerCore->postProcessCallback - [line 811 - controllers/admin/AdminModulesController.php] - [0 Argument]

AdminModulesControllerCore->postProcess - [line 158 - classes/controller/Controller.php] - [0 Argument]

ControllerCore->run - [line 348 - classes/Dispatcher.php] - [0 Argument]

DispatcherCore->dispatch - [line 53 - admin5354/index.php] - [0 Argument]

 

It's a multisite setup and the issue is affecting every site on the multisite setup. More about the setup...

PS Version: 1.5.6.2

Theme: Warehouse

PHP Version: 5.6.40

MySQL Version: 5.6.45 - MySQL Community Server (GPL)

Will appreciate any help!!

Edited September 17, 2019 by georgebishop (see edit history)

[georgebishop]

Doh, can't believe I didn't try this...turning friendly URLs on and off solved the problem.