• Priority: 0
  • Status: Closed
  • Theme: Alysum
  • Assigned To: Marek
  • Private: No
  • Open Date: 12.01.18, 13:13
  • Opened by: Jean-Pierre
  • Closed by: Marek
  • Closed on: 14.01.18, 23:46
  • Reason: Closed
  • Comment: Glad to help!

Ticket #11405 - Wishlist table missing in database - error Prestashop Database exception

Hello Marek,

The actual website is lilichic.com (new name more classy) which redirects to liliblingbling.com (old oscommerce site) until the website works well.
I have now migrated to Prestashop 1.6.1.17 and I have made a redirection to liliblingbling.com (I use www.lilichic.com/index.php for the website in Prestashop)

Facing problem with wishlist (table missing in the database)

A) When I activate a product carousel in the menu setting then I have a problem with a table missing in the database.
If I disable the products carousel than I don’t have this error with the wishlist table anymore :

B) (the wishlist does not work in the website)

[PrestaShopDatabaseException]



Table 'lilichic_pres504.psw7_wishlist' doesn't exist


SELECT `id_wishlist` FROM `psw7_wishlist` WHERE `id_customer` = 0

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

786.         if ($webservice_call && $errno) {
787.             $dbg = debug_backtrace();
788.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$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 643 - classes/db/Db.php] - [1 Arguments]
DbCore->executeS - [line 380 - modules/pk_productscarousel_single/pk_productscarousel_single.php] - [1 Arguments]
pk_productscarousel_single->getUserWishlists - [line 256 - modules/pk_productscarousel_single/pk_productscarousel_single.php] - [3 Arguments]
pk_productscarousel_single->getmodulescontent - [line 332 - modules/pk_productscarousel_single/pk_productscarousel_single.php] - [1 Arguments]
pk_productscarousel_single->hooknarrow_top - [line 591 - classes/Hook.php] - [1 Arguments]
HookCore::coreCallHook - [line 546 - classes/Hook.php] - [3 Arguments]
HookCore::exec - [line 207 - config/smarty.config.inc.php] - [3 Arguments]
smartyHook - [line - ] - [2 Arguments]
call_user_func_array - [line 270 - config/smarty.config.inc.php] - [2 Arguments]
SmartyLazyRegister->__call - [line 56 - tools/smarty/sysplugins/smarty_internal_templatebase.php(157) : eval()'d code] - [2 Arguments]
Warning: file(/home/lilichic/public_html/tools/smarty/sysplugins/smarty_internal_templatebase.php(157) : eval()'d code): failed to open stream: No such file or directory in /home/lilichic/public_html/classes/exception/PrestaShopException.php on line 103

Warning: array_slice() expects parameter 1 to be array, boolean given in /home/lilichic/public_html/classes/exception/PrestaShopException.php on line 110
SmartyLazyRegister->smartyHook - [line 56 - tools/smarty/sysplugins/smarty_internal_templatebase.php(157) : eval()'d code] - [2 Arguments]
Warning: file(/home/lilichic/public_html/tools/smarty/sysplugins/smarty_internal_templatebase.php(157) : eval()'d code): failed to open stream: No such file or directory in /home/lilichic/public_html/classes/exception/PrestaShopException.php on line 103

Warning: array_slice() expects parameter 1 to be array, boolean given in /home/lilichic/public_html/classes/exception/PrestaShopException.php on line 110
content_5a565dc9b95c05_81971839 - [line 188 - tools/smarty/sysplugins/smarty_internal_templatebase.php] - [1 Arguments]
Smarty_Internal_TemplateBase->fetch - [line 317 - classes/SmartyCustom.php] - [7 Arguments]
Smarty_Custom_Template->fetch - [line 303 - tools/smarty/sysplugins/smarty_internal_template.php] - [7 Arguments]
Smarty_Internal_Template->getSubTemplate - [line 35 - tools/smarty/sysplugins/smarty_internal_templatebase.php(157) : eval()'d code] - [7 Arguments]
Warning: file(/home/lilichic/public_html/tools/smarty/sysplugins/smarty_internal_templatebase.php(157) : eval()'d code): failed to open stream: No such file or directory in /home/lilichic/public_html/classes/exception/PrestaShopException.php on line 103

Warning: array_slice() expects parameter 1 to be array, boolean given in /home/lilichic/public_html/classes/exception/PrestaShopException.php on line 110
content_5a565dc8ed57e5_74444185 - [line 188 - tools/smarty/sysplugins/smarty_internal_templatebase.php] - [1 Arguments]
Smarty_Internal_TemplateBase->fetch - [line 110 - classes/SmartyCustom.php] - [7 Arguments]
SmartyCustomCore->fetch - [line 529 - classes/controller/Controller.php] - [1 Arguments]
ControllerCore->smartyOutputContent - [line 723 - classes/controller/FrontController.php] - [1 Arguments]
FrontControllerCore->display - [line 209 - classes/controller/Controller.php]
ControllerCore->run - [line 367 - classes/Dispatcher.php]
DispatcherCore->dispatch - [line 28 - index.php]

All login (ftp, bo is in the detail of the account)

Comments

Marek 13 Jan 2018, 12:15

The issue has been fixed. Please check it out

Jean-Pierre 14 Jan 2018, 19:34

Everything seems to be ok with this issue. Thank you.