Fatal error: Uncaught PrestaShopDatabaseException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) ORDER BY sms.`position`
LIMIT 1' at line 7<br /><br /><pre>
SELECT sms.*, smsl.*
,IF(image_multi_lang<>"" && !ISNULL(image_multi_lang), image_multi_lang, image_lang_default) AS image_multi_lang
FROM `8uhat_st_page_banner` sms
LEFT JOIN `8uhat_st_page_banner_lang` smsl ON (sms.`id_st_page_banner` = smsl.`id_st_page_banner` AND smsl.`id_lang` = 1)
INNER JOIN 8uhat_st_page_banner_shop st_page_banner_shop
ON (st_page_banner_shop.id_st_page_banner = sms.id_st_page_banner AND st_page_banner_shop.id_shop = 1)
WHERE 1 AND sms.`active`=1 AND sms.`item_k`=1 AND (sms.`show_subcate` = 0 AND sms.`item_v`="63" OR sms.`show_subcate` = 1 AND sms.`item_v` IN()) ORDER BY sms.`position`
LIMIT 1
</pre> in /var/www/vhosts/ladydee-yarn.com/httpdocs/classes/db/Db.php:757
Stack trace:
#0 /var/www/vhosts/ladydee-yarn.com/httpdocs/classes/db/Db.php(369): DbCore->displayError()
#1 /var/www/vhosts/ladydee-yarn.com/httpdocs/classes/db/Db.php(598): DbCore->query()
#2 /var/www/vhosts/ladydee-yarn.com/httpdocs/modules/stpagebanner/classes/StPageBannerClass.php(186): DbCore->executeS()
#3 /var/www/vhosts/ladydee-yarn.com/httpdocs/modules/stpagebanner/stpagebanner.php(1420): StPageBannerClass::getAll()
#4 /var/www/vhosts/ladydee-yarn.com/httpdocs/modules/stpagebanner/stpagebanner.php(1541): StPageBanner->_prepareHook()
#5 /var/www/vhosts/ladydee-yarn.com/httpdocs/classes/Hook.php(1212): StPageBanner->hookDisplayBreadcrumb()
#6 /var/www/vhosts/ladydee-yarn.com/httpdocs/classes/Hook.php(447): HookCore::coreCallHook()
#7 /var/www/vhosts/ladydee-yarn.com/httpdocs/classes/Hook.php(1107): HookCore::callHookOn()
#8 /var/www/vhosts/ladydee-yarn.com/httpdocs/config/smarty.config.inc.php(193): HookCore::exec()
#9 /var/www/vhosts/ladydee-yarn.com/httpdocs/classes/Smarty/SmartyLazyRegister.php(61): smartyHook()
#10 /var/www/vhosts/ladydee-yarn.com/httpdocs/var/cache/dev/smarty/compile/pandalayouts_layout_full_width_tpl/f9/a7/8a/f9a78a0f344fcd3e4dcdb0aeea5a5bcc7bb02340_2.file.layout-both-columns.tpl.php(305): SmartyLazyRegister->__call()
#11 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php(248): Block_6423667746aebf329889638_27187020->callBlock()
#12 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php(184): Smarty_Internal_Runtime_Inheritance->callBlock()
#13 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php(156): Smarty_Internal_Runtime_Inheritance->process()
#14 /var/www/vhosts/ladydee-yarn.com/httpdocs/var/cache/dev/smarty/compile/pandalayouts_layout_full_width_tpl/f9/a7/8a/f9a78a0f344fcd3e4dcdb0aeea5a5bcc7bb02340_2.file.layout-both-columns.tpl.php(92): Smarty_Internal_Runtime_Inheritance->instanceBlock()
#15 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php(123): content_6aebf329901723_38729859()
#16 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php(114): Smarty_Template_Resource_Base->getRenderedTemplateCode()
#17 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php(217): Smarty_Template_Compiled->render()
#18 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php(386): Smarty_Internal_Template->render()
#19 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php(115): Smarty_Internal_Template->_subTemplateRender()
#20 /var/www/vhosts/ladydee-yarn.com/httpdocs/var/cache/dev/smarty/compile/pandalayouts_layout_full_width_tpl/5d/11/ad/5d11ad7d9365c4922fb783ae29bf2ea180e86cd6_2.file.layout-full-width.tpl.php(50): Smarty_Internal_Runtime_Inheritance->endChild()
#21 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php(123): content_6aebf32984fa10_83526352()
#22 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php(114): Smarty_Template_Resource_Base->getRenderedTemplateCode()
#23 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php(217): Smarty_Template_Compiled->render()
#24 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php(386): Smarty_Internal_Template->render()
#25 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php(115): Smarty_Internal_Template->_subTemplateRender()
#26 /var/www/vhosts/ladydee-yarn.com/httpdocs/var/cache/dev/smarty/compile/pandalayouts_layout_full_width_tpl/e7/9e/b0/e79eb0ec542535e8faae9bd18c3c28c55a386d3e_2.file.product.tpl.php(53): Smarty_Internal_Runtime_Inheritance->endChild()
#27 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php(123): content_6aebf5a5bdd277_75716591()
#28 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php(114): Smarty_Template_Resource_Base->getRenderedTemplateCode()
#29 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php(217): Smarty_Template_Compiled->render()
#30 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php(238): Smarty_Internal_Template->render()
#31 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php(116): Smarty_Internal_TemplateBase->_execute()
#32 /var/www/vhosts/ladydee-yarn.com/httpdocs/classes/Smarty/SmartyDev.php(20): Smarty_Internal_TemplateBase->fetch()
#33 /var/www/vhosts/ladydee-yarn.com/httpdocs/classes/controller/FrontController.php(773): SmartyDev->fetch()
#34 /var/www/vhosts/ladydee-yarn.com/httpdocs/classes/controller/FrontController.php(757): FrontControllerCore->smartyOutputContent()
#35 /var/www/vhosts/ladydee-yarn.com/httpdocs/classes/controller/Controller.php(328): FrontControllerCore->display()
#36 /var/www/vhosts/ladydee-yarn.com/httpdocs/classes/Dispatcher.php(508): ControllerCore->run()
#37 /var/www/vhosts/ladydee-yarn.com/httpdocs/index.php(66): DispatcherCore->dispatch()
#38 {main}
Next PrestaShop\PrestaShop\Core\Exception\CoreException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) ORDER BY sms.`position`
LIMIT 1' at line 7<br /><br /><pre>
SELECT sms.*, smsl.*
,IF(image_multi_lang<>"" && !ISNULL(image_multi_lang), image_multi_lang, image_lang_default) AS image_multi_lang
FROM `8uhat_st_page_banner` sms
LEFT JOIN `8uhat_st_page_banner_lang` smsl ON (sms.`id_st_page_banner` = smsl.`id_st_page_banner` AND smsl.`id_lang` = 1)
INNER JOIN 8uhat_st_page_banner_shop st_page_banner_shop
ON (st_page_banner_shop.id_st_page_banner = sms.id_st_page_banner AND st_page_banner_shop.id_shop = 1)
WHERE 1 AND sms.`active`=1 AND sms.`item_k`=1 AND (sms.`show_subcate` = 0 AND sms.`item_v`="63" OR sms.`show_subcate` = 1 AND sms.`item_v` IN()) ORDER BY sms.`position`
LIMIT 1
</pre> in /var/www/vhosts/ladydee-yarn.com/httpdocs/classes/Hook.php:469
Stack trace:
#0 /var/www/vhosts/ladydee-yarn.com/httpdocs/classes/Hook.php(1107): HookCore::callHookOn()
#1 /var/www/vhosts/ladydee-yarn.com/httpdocs/config/smarty.config.inc.php(193): HookCore::exec()
#2 /var/www/vhosts/ladydee-yarn.com/httpdocs/classes/Smarty/SmartyLazyRegister.php(61): smartyHook()
#3 /var/www/vhosts/ladydee-yarn.com/httpdocs/var/cache/dev/smarty/compile/pandalayouts_layout_full_width_tpl/f9/a7/8a/f9a78a0f344fcd3e4dcdb0aeea5a5bcc7bb02340_2.file.layout-both-columns.tpl.php(305): SmartyLazyRegister->__call()
#4 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php(248): Block_6423667746aebf329889638_27187020->callBlock()
#5 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php(184): Smarty_Internal_Runtime_Inheritance->callBlock()
#6 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php(156): Smarty_Internal_Runtime_Inheritance->process()
#7 /var/www/vhosts/ladydee-yarn.com/httpdocs/var/cache/dev/smarty/compile/pandalayouts_layout_full_width_tpl/f9/a7/8a/f9a78a0f344fcd3e4dcdb0aeea5a5bcc7bb02340_2.file.layout-both-columns.tpl.php(92): Smarty_Internal_Runtime_Inheritance->instanceBlock()
#8 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php(123): content_6aebf329901723_38729859()
#9 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php(114): Smarty_Template_Resource_Base->getRenderedTemplateCode()
#10 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php(217): Smarty_Template_Compiled->render()
#11 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php(386): Smarty_Internal_Template->render()
#12 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php(115): Smarty_Internal_Template->_subTemplateRender()
#13 /var/www/vhosts/ladydee-yarn.com/httpdocs/var/cache/dev/smarty/compile/pandalayouts_layout_full_width_tpl/5d/11/ad/5d11ad7d9365c4922fb783ae29bf2ea180e86cd6_2.file.layout-full-width.tpl.php(50): Smarty_Internal_Runtime_Inheritance->endChild()
#14 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php(123): content_6aebf32984fa10_83526352()
#15 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php(114): Smarty_Template_Resource_Base->getRenderedTemplateCode()
#16 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php(217): Smarty_Template_Compiled->render()
#17 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php(386): Smarty_Internal_Template->render()
#18 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php(115): Smarty_Internal_Template->_subTemplateRender()
#19 /var/www/vhosts/ladydee-yarn.com/httpdocs/var/cache/dev/smarty/compile/pandalayouts_layout_full_width_tpl/e7/9e/b0/e79eb0ec542535e8faae9bd18c3c28c55a386d3e_2.file.product.tpl.php(53): Smarty_Internal_Runtime_Inheritance->endChild()
#20 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php(123): content_6aebf5a5bdd277_75716591()
#21 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php(114): Smarty_Template_Resource_Base->getRenderedTemplateCode()
#22 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php(217): Smarty_Template_Compiled->render()
#23 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php(238): Smarty_Internal_Template->render()
#24 /var/www/vhosts/ladydee-yarn.com/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php(116): Smarty_Internal_TemplateBase->_execute()
#25 /var/www/vhosts/ladydee-yarn.com/httpdocs/classes/Smarty/SmartyDev.php(20): Smarty_Internal_TemplateBase->fetch()
#26 /var/www/vhosts/ladydee-yarn.com/httpdocs/classes/controller/FrontController.php(773): SmartyDev->fetch()
#27 /var/www/vhosts/ladydee-yarn.com/httpdocs/classes/controller/FrontController.php(757): FrontControllerCore->smartyOutputContent()
#28 /var/www/vhosts/ladydee-yarn.com/httpdocs/classes/controller/Controller.php(328): FrontControllerCore->display()
#29 /var/www/vhosts/ladydee-yarn.com/httpdocs/classes/Dispatcher.php(508): ControllerCore->run()
#30 /var/www/vhosts/ladydee-yarn.com/httpdocs/index.php(66): DispatcherCore->dispatch()
#31 {main}
thrown in /var/www/vhosts/ladydee-yarn.com/httpdocs/classes/Hook.php on line 469