Trouble with Database Table

[Kwash]

Hi Guys,

I am having problems with this error which keeps showing up on my prestashop.I have also attached the picture please help guys. Can someone assist me with the script I have to run to restore the database tablet correctly,also I am not sure if this also has to do with my host please help in deep trouble. 

 

[PrestaShopDatabaseException]

Table 'ngahcom_vic2015.ps_smarty_lazy_cache' doesn't exist

 

SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`

                            WHERE `template_hash`='a46fdbfdb7978bc10fca01be27f9a288' AND cache_id="" AND compile_id="" 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 215 - classes/SmartyCustom.php] - [2 Arguments]
• SmartyCustomCore->is_in_lazy_cache - [line 153 - classes/SmartyCustom.php] - [3 Arguments]
• SmartyCustomCore->check_template_invalidation - [line 120 - classes/SmartyCustom.php] - [3 Arguments]
• SmartyCustomCore->createTemplate - [line 101 - classes/helper/Helper.php] - [2 Arguments]
• HelperCore->createTemplate - [line 63 - classes/helper/HelperShop.php] - [1 Arguments]
• HelperShopCore->getRenderedShopList - [line 1912 - classes/controller/AdminController.php]
• AdminControllerCore->initHeader - [line 185 - classes/controller/Controller.php]
• ControllerCore->run - [line 367 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 58 - admin/index.php]

 

Please assist guys I am now just lost. 

[musicmaster]

This is a table that was only recently (1.6.1.0???) introduced. So it would be very interesting to know which version you are using and whether there is some mixeup of versions in your shop.

[NemoPS]

I guess it's a partially broken upgrade.
Add the table in with these params
http://screencast.com/t/dLGghAaH

You're likely about to run into another missing table, there were a couple

[Kwash]

Thank you for replying back, would you know the script I have to run. I am a bit lost I am not that good on the database side

[Kwash]

This is a table that was only recently (1.6.1.0???) introduced. So it would be very interesting to know which version you are using and whether there is some mixeup of versions in your shop.

I am using 1.6.1.3. I am just so lost its confusing, I am basically aguy who just knew how to install the prestashop and change and upload have never had database issues before. 

[selectshop.at]

Check if the table exists. If yes than you should repair it with phpmyAdmin (or ask your provider to repair  it).

 

If table is not available on database, you should add it manually, like Nemo1 told you. How to add tables on database with phpmyAdmin: http://support.hostgator.com/articles/specialized-help/technical/phpmyadmin/adding-a-column-to-a-database-table-in-phpmyadmin

 

If you are not able to add it by yourself, please ask your provider.