georgebishop Posted September 17, 2019 Share Posted September 17, 2019 (edited) 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) Link to comment Share on other sites More sharing options...
georgebishop Posted September 17, 2019 Author Share Posted September 17, 2019 Doh, can't believe I didn't try this...turning friendly URLs on and off solved the problem. 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