- 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
The issue has been fixed. Please check it out
Everything seems to be ok with this issue. Thank you.