What's New
Tagged: Спасительная магия
- AuthorPosts
Hi,
now is the second time my shop display followed errors:
[PrestaShopDatabaseException]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘))) AND (sec.id_product = 0 OR (sec.id_product > 0 AND sec.id_product =135)) ‘ at line 6
SELECT sec.*, secl.
title
, secl.url
, secl.text
, st_easy_content_shop.id_shop
FROMps_st_easy_content
sec
INNER JOIN ps_st_easy_content_shop st_easy_content_shop
ON (st_easy_content_shop.id_st_easy_content = sec.id_st_easy_content AND st_easy_content_shop.id_shop = 1)
LEFT JOINps_st_easy_content_lang
secl ON (sec.id_st_easy_content
= secl.id_st_easy_content
)
WHERE secl.id_lang
= 1 AND sec.active
=1 AND sec.type
=6 AND (sec.id_category = 0 OR (sec.id_category > 0 AND sec.id_category IN())) AND (sec.id_product = 0 OR (sec.id_product > 0 AND sec.id_product =135))
ORDER BY sec.type
, sec.id_cms
, sec.position
at line 744 in file classes/db/Db.php
739. if ($webservice_call && $errno) {
740. $dbg = debug_backtrace();
741. WebserviceRequest::getInstance()->setError(500, ‘[SQL Error] ‘.$this->getMsgError().’. From ‘.(isset($dbg[3][‘class’]) ? $dbg[3][‘class’] : ”).’->’.$dbg[3][‘function’].'() Query was : ‘.$sql, 97);
742. } elseif (_PS_DEBUG_SQL_ && $errno && !defined(‘PS_INSTALLATION_IN_PROGRESS’)) {
743. if ($sql) {
744. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br />'.$sql.'
‘);
745. }
746.
747. throw new PrestaShopDatabaseException($this->getMsgError());
748. }
749. }DbCore->displayError – [line 378 – classes/db/Db.php] – [1 Arguments]
DbCore->query – [line 596 – classes/db/Db.php] – [1 Arguments]
DbCore->executeS – [line 316 – modules/steasycontent/classes/StEasyContentClass.php] – [1 Arguments]
StEasyContentClass::getListContent – [line 2527 – modules/steasycontent/steasycontent.php] – [3 Arguments]
StEasyContent->_prepareHook – [line 3495 – modules/steasycontent/steasycontent.php] – [2 Arguments]
StEasyContent->hookDisplayProductRightColumn – [line 895 – classes/Hook.php] – [1 Arguments]
HookCore::coreCallHook – [line 327 – classes/Hook.php] – [3 Arguments]
HookCore::callHookOn – [line 843 – classes/Hook.php] – [3 Arguments]
HookCore::exec – [line 168 – config/smarty.config.inc.php] – [3 Arguments]
smartyHook – [line 83 – classes/Smarty/SmartyLazyRegister.php] – [2 Arguments]
SmartyLazyRegister->__call – [line 1305 – app/cache/dev/smarty/compile/layouts_layout_full_width_tpl/a6/6b/c7/a66bc7cce2f83a77db04b2c8ac230de2a1b6e49f.file.product.tpl.php] – [2 Arguments]
content_5a1fc2f4ca9494_56775091 – [line 299 – app/cache/dev/smarty/compile/layouts_layout_full_width_tpl/a6/6b/c7/a66bc7cce2f83a77db04b2c8ac230de2a1b6e49f.file.product.tpl.php] – [1 Arguments]
content_5a1fc2f4e614a8_35520661 – [line 188 – vendor/prestashop/smarty/sysplugins/smarty_internal_templatebase.php] – [1 Arguments]
Smarty_Internal_TemplateBase->fetch – [line 41 – classes/Smarty/SmartyDev.php] – [7 Arguments]
SmartyDev->fetch – [line 671 – classes/controller/FrontController.php] – [3 Arguments]
FrontControllerCore->smartyOutputContent – [line 655 – classes/controller/FrontController.php] – [1 Arguments]
FrontControllerCore->display – [line 225 – classes/controller/Controller.php]
ControllerCore->run – [line 379 – classes/Dispatcher.php]
DispatcherCore->dispatch – [line 28 – index.php]Please, look in my back office at Advanced Parameters -> Logs.
You see there all errors.All accesses you find in my profil.
Please, this is urgent.Best regards, Viaceslav.
I’ve fixed the problem for you temporarily. I don’t know how to reproduce it, the “ПЕЧЕНЬЕ “33 КОРОВЫ” ВКУС СМЕТАНКИ – 180 Г” product page works fine on my side. Please know how to reproduce the problem, so I can check to see if it’s a problem of the theme or bad data in your database.
Regards,
Jonny- AuthorPosts
You must be logged in to reply to this topic.