[Help] [Prestashopdatabaseexception] Issue

[ifede84]

Hi All,

I m asking help for a big trouble with my prestashop ecommerce

 

Since this morning my website front end is showing  the screen i've attached: i didnt' have any changes before this problem.

 

I've some experience with woocommerce, but not with prestashop.

Thank you all


Federico


[PrestaShopDatabaseException]

Table 'supermar_scarpa.ps_smarty_lazy_cache' doesn't exist



SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8dbe0fda139feff62ec212662965836e' AND cache_id="stmegamenu|1|1|10" AND compile_id="" LIMIT 1
at line 765 in file classes/db/Db.php

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

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);761. }762. elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))763. {764. if ($sql)765. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');766. 767. throw new PrestaShopDatabaseException($this->getMsgError());768. }769. }770. 
 

• DbCore->displayError - [line 418 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 669 - classes/db/Db.php] - [1 Arguments]
• DbCore->getRow - [line 225 - classes/SmartyCustom.php] - [2 Arguments]
• SmartyCustomCore->is_in_lazy_cache - [line 163 - classes/SmartyCustom.php] - [3 Arguments]
• SmartyCustomCore->check_template_invalidation - [line 126 - classes/SmartyCustom.php] - [3 Arguments]
• SmartyCustomCore->createTemplate - [line 2270 - classes/module/Module.php] - [4 Arguments]
• ModuleCore->getCurrentSubTemplate - [line 2316 - classes/module/Module.php] - [3 Arguments]
• ModuleCore->isCached - [line 3380 - modules/stmegamenu/stmegamenu.php] - [2 Arguments]
• StMegaMenu->hookDisplayHeader - [line 569 - classes/Hook.php] - [1 Arguments]
• HookCore::coreCallHook - [line 524 - classes/Hook.php] - [3 Arguments]
• HookCore::exec - [line 579 - classes/controller/FrontController.php] - [1 Arguments]
• FrontControllerCore->initContent - [line 11 - override/classes/controller/FrontController.php]
• FrontController->initContent - [line 37 - controllers/front/IndexController.php]
• IndexControllerCore->initContent - [line 15 - override/controllers/front/IndexController.php]
• IndexController->initContent - [line 180 - classes/controller/Controller.php]
• ControllerCore->run - [line 373 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 28 - index.php]

Edited January 28, 2016 by ifede84 (see edit history)

[tuk66]

Table 'supermar_scarpa.ps_smarty_lazy_cache' doesn't exist

 

The question is: why. Try to create it:

CREATE TABLE IF NOT EXISTS `ps_smarty_lazy_cache` (
  `template_hash` varchar(32) NOT NULL DEFAULT '',
  `cache_id` varchar(255) NOT NULL DEFAULT '',
  `compile_id` varchar(32) NOT NULL DEFAULT '',
  `filepath` varchar(255) NOT NULL DEFAULT '',
  `last_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`template_hash`,`cache_id`,`compile_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;