Проблема с сайтами Панель DirectAdmin

Правила раздела: faq.php?mode=okay
Модератор: Модераторы

reteri
reteri
Репутация: 3
Сообщения: 90
Зарегистрирован: 02.05.2018
С нами: 5 лет 10 месяцев

Сообщение #1 reteri » 05.10.2020, 15:48

На сервере обновилась Панель DirectAdmin (LiteSpeed V7.6 Web Server), сайт на 3 версии выдает ошибку

Код: Выделить всё

Plugin tag 'fast_order_btn' already registered #0 /home/site/public_html/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php(277): Smarty_Internal_Method_RegisterPlugin->registerPlugin(Object(Smarty), 'function', 'fast_order_btn', Object(Closure), true, NULL) #1 /home/site/public_html/Okay/Core/Design.php(318): Smarty_Internal_TemplateBase->registerPlugin('function', 'fast_order_btn', Object(Closure)) #2 /home/site/public_html/Okay/Core/Design.php(288): Okay\Core\Design->registerSmartyPlugins() #3 /home/site/public_html/Okay/Core/Adapters/Response/Html.php(36): Okay\Core\Design->fetch('page.tpl') #4 /home/site/public_html/Okay/Core/Response.php(125): Okay\Core\Adapters\Response\Html->send(Array) #5 /home/site/public_html/Okay/Core/Router.php(231): Okay\Core\Response->sendContent() #6 /home/site/public_html/vendor/bramus/router/src/Bramus/Router/Router.php(300): Okay\Core\Router->Okay\Core\{closure}() #7 /home/site/public_html/Okay/Core/Router.php(232): Bramus\Router\Router->run(Object(Closure)) #8 /home/site/public_html/index.php(62): Okay\Core\Router->run() #9 {main}

на 2 версии не выводит банеры.
Чистая установка на версии 3 вывод ошибка HTTP ERROR 500.
Перенес сайт на локалку все работает.
На другом хостинге с DirectAdmin (LiteSpeed V7.6), на 3 версии так же ошибка HTTP ERROR 500, 2 версии не выводит банеры, на cPanel устанавливает нормально.

Что может быть?

reteri
reteri
Репутация: 3
Сообщения: 90
Зарегистрирован: 02.05.2018
С нами: 5 лет 10 месяцев

Сообщение #2 reteri » 06.10.2020, 17:07

Еще один хостер проверил проблема осталась, тп утверждает что связывайтесь с разработчиками, так как все движки устанавливаются и работают.
Кто то может ответить в чем причина, что ваша CMS несовместима с DirectAdmin?

zyxer M
zyxer M
Возраст: 32
Репутация: 77
Сообщения: 419
Зарегистрирован: 03.02.2016
С нами: 8 лет 1 месяц
Откуда: Днепр

Сообщение #3 zyxer » 07.10.2020, 07:29

Попробуйте закомментировать в файле Okay/Core/Entity/CRUD.php и Okay/Entities/OrderHistoryEntity.php строку $this->select->cache();
Всё сказанное мной, является лично моим мнением, и не является официальной позицией OkayCMS

reteri
reteri
Репутация: 3
Сообщения: 90
Зарегистрирован: 02.05.2018
С нами: 5 лет 10 месяцев

Сообщение #4 reteri » 07.10.2020, 10:09

zyxer писал(а):Попробуйте закомментировать в файле Okay/Core/Entity/CRUD.php и Okay/Entities/OrderHistoryEntity.php строку $this->select->cache();
Спасибо, ошибки ушли, работает, но нет вывода банеров в 3 и 2 версиях.

zyxer M
zyxer M
Возраст: 32
Репутация: 77
Сообщения: 419
Зарегистрирован: 03.02.2016
С нами: 8 лет 1 месяц
Откуда: Днепр

Сообщение #5 zyxer » 07.10.2020, 10:28

покажите что в логах
Всё сказанное мной, является лично моим мнением, и не является официальной позицией OkayCMS

reteri
reteri
Репутация: 3
Сообщения: 90
Зарегистрирован: 02.05.2018
С нами: 5 лет 10 месяцев

Сообщение #6 reteri » 07.10.2020, 12:36

zyxer писал(а):покажите что в логах
В логах только такие ошибки:

Код: Выделить всё

Creating default object from empty value in /home/public_html/view/IndexView.php on line 180
Invalid argument supplied for foreach() in /home/public_html/view/IndexView.php on line 89

zyxer M
zyxer M
Возраст: 32
Репутация: 77
Сообщения: 419
Зарегистрирован: 03.02.2016
С нами: 8 лет 1 месяц
Откуда: Днепр

Сообщение #7 zyxer » 07.10.2020, 12:38

я за другие логи. В тройке это Okay/log
Всё сказанное мной, является лично моим мнением, и не является официальной позицией OkayCMS

reteri
reteri
Репутация: 3
Сообщения: 90
Зарегистрирован: 02.05.2018
С нами: 5 лет 10 месяцев

Сообщение #8 reteri » 07.10.2020, 12:59

Последние логи

Код: Выделить всё

2020-10-07 15:06:52] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 72 Okay\Core\Database->__construct(); ReflectionClass->newInstanceArgs();-line 152 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 32  [] []
[2020-10-07 15:06:52] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1064 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 ') ORDER BY     IF(stock=0, 0, 1) DESC,     `v`.`position`,     `v`.`id`' at line 23" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 60 Okay\Core\Entity\Entity->find();-line 64 Okay\Entities\VariantsEntity->find();-line 137 Okay\Helpers\ProductsHelper->attachVariants();-line 93 Okay\Modules\OkayCMS\GoogleMerchant\Controllers\GoogleMerchantController->render(); call_user_func_array();-line 290 Okay\Core\Router->createControllerInstance();-line 222 Okay\Core\Router->Okay\Core\{closure}(); call_user_func_array();-line 379 Bramus\Router\Router->invoke();-line 361 Bramus\Router\Router->handle();-line 287 Bramus\Router\Router->run();-line 232 Okay\Core\Router->run();-line 62  [] []
[2020-10-07 15:06:52] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1064 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 ') GROUP BY     `fv`.`id`,     `l`.`value`,     `l`.`translit` ORDER BY     `fv`.' at line 14" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 60 Okay\Core\Entity\Entity->find();-line 105 Okay\Entities\FeaturesValuesEntity->find();-line 166 Okay\Helpers\ProductsHelper->attachFeatures();-line 96 Okay\Modules\OkayCMS\GoogleMerchant\Controllers\GoogleMerchantController->render(); call_user_func_array();-line 290 Okay\Core\Router->createControllerInstance();-line 222 Okay\Core\Router->Okay\Core\{closure}(); call_user_func_array();-line 379 Bramus\Router\Router->invoke();-line 361 Bramus\Router\Router->handle();-line 287 Bramus\Router\Router->run();-line 232 Okay\Core\Router->run();-line 62  [] []
[2020-10-07 15:16:40] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 72 Okay\Core\Database->__construct(); ReflectionClass->newInstanceArgs();-line 152 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 32  [] []
[2020-10-07 15:16:40] channel-name.ERROR: Sql query error: "SQLSTATE[HY000]: General error: 3685 Illegal argument to a regular expression." Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 60 Okay\Core\Entity\Entity->find();-line 91 Okay\Modules\OkayCMS\Banners\Extenders\FrontExtender->init();-line 29 Okay\Modules\OkayCMS\Banners\Extenders\FrontExtender->__construct(); ReflectionClass->newInstanceArgs();-line 152 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 45 Okay\Core\ServiceLocator->getService();-line 30 Okay\Core\Modules\Extender\ChainExtender->execute();-line 24 Okay\Core\Modules\Extender\ExtenderFacade->execute();-line 151 Okay\Helpers\MetadataHelpers\CommonMetadataHelper->getParts();-line 156 Okay\Helpers\MetadataHelpers\CommonMetadataHelper->compileMetadata();-line 109 Okay\Helpers\MetadataHelpers\CommonMetadataHelper->getH1();-line 130 Okay\Helpers\MainHelper->commonAfterControllerProcedure();-line 139 Okay\Controllers\AbstractController->afterController(); call_user_func_array();-line 292 Okay\Core\Router->createControllerInstance();-line 222 Okay\Core\Router->Okay\Core\{closure}(); call_user_func_array();-line 379 Bramus\Router\Router->invoke();-line 361 Bramus\Router\Router->handle();-line 287 Bramus\Router\Router->run();-line 232 Okay\Core\Router->run();-line 62  [] []
[2020-10-07 15:16:41] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 72 Okay\Core\Database->__construct(); ReflectionClass->newInstanceArgs();-line 152 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 32  [] []
[2020-10-07 15:16:41] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 72 Okay\Core\Database->__construct(); ReflectionClass->newInstanceArgs();-line 152 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 32  [] []
[2020-10-07 15:21:51] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 72 Okay\Core\Database->__construct(); ReflectionClass->newInstanceArgs();-line 152 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 32  [] []
[2020-10-07 15:21:51] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1064 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 ') ORDER BY     IF(stock=0, 0, 1) DESC,     `v`.`position`,     `v`.`id`' at line 23" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 60 Okay\Core\Entity\Entity->find();-line 64 Okay\Entities\VariantsEntity->find();-line 137 Okay\Helpers\ProductsHelper->attachVariants();-line 93 Okay\Modules\OkayCMS\GoogleMerchant\Controllers\GoogleMerchantController->render(); call_user_func_array();-line 290 Okay\Core\Router->createControllerInstance();-line 222 Okay\Core\Router->Okay\Core\{closure}(); call_user_func_array();-line 379 Bramus\Router\Router->invoke();-line 361 Bramus\Router\Router->handle();-line 287 Bramus\Router\Router->run();-line 232 Okay\Core\Router->run();-line 62  [] []
[2020-10-07 15:21:51] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1064 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 ') GROUP BY     `fv`.`id`,     `l`.`value`,     `l`.`translit` ORDER BY     `fv`.' at line 14" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 60 Okay\Core\Entity\Entity->find();-line 105 Okay\Entities\FeaturesValuesEntity->find();-line 166 Okay\Helpers\ProductsHelper->attachFeatures();-line 96 Okay\Modules\OkayCMS\GoogleMerchant\Controllers\GoogleMerchantController->render(); call_user_func_array();-line 290 Okay\Core\Router->createControllerInstance();-line 222 Okay\Core\Router->Okay\Core\{closure}(); call_user_func_array();-line 379 Bramus\Router\Router->invoke();-line 361 Bramus\Router\Router->handle();-line 287 Bramus\Router\Router->run();-line 232 Okay\Core\Router->run();-line 62  [] []
[2020-10-07 15:25:57] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 72 Okay\Core\Database->__construct(); ReflectionClass->newInstanceArgs();-line 152 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 32  [] []
[2020-10-07 15:25:57] channel-name.ERROR: Sql query error: "SQLSTATE[HY000]: General error: 3685 Illegal argument to a regular expression." Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 60 Okay\Core\Entity\Entity->find();-line 91 Okay\Modules\OkayCMS\Banners\Extenders\FrontExtender->init();-line 29 Okay\Modules\OkayCMS\Banners\Extenders\FrontExtender->__construct(); ReflectionClass->newInstanceArgs();-line 152 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 45 Okay\Core\ServiceLocator->getService();-line 30 Okay\Core\Modules\Extender\ChainExtender->execute();-line 24 Okay\Core\Modules\Extender\ExtenderFacade->execute();-line 151 Okay\Helpers\MetadataHelpers\CommonMetadataHelper->getParts();-line 156 Okay\Helpers\MetadataHelpers\CommonMetadataHelper->compileMetadata();-line 109 Okay\Helpers\MetadataHelpers\CommonMetadataHelper->getH1();-line 130 Okay\Helpers\MainHelper->commonAfterControllerProcedure();-line 139 Okay\Controllers\AbstractController->afterController(); call_user_func_array();-line 292 Okay\Core\Router->createControllerInstance();-line 222 Okay\Core\Router->Okay\Core\{closure}(); call_user_func_array();-line 379 Bramus\Router\Router->invoke();-line 361 Bramus\Router\Router->handle();-line 287 Bramus\Router\Router->run();-line 232 Okay\Core\Router->run();-line 62  [] []
[2020-10-07 15:25:59] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 72 Okay\Core\Database->__construct(); ReflectionClass->newInstanceArgs();-line 152 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 32  [] []
[2020-10-07 15:25:59] channel-name.ERROR: Sql query error: "SQLSTATE[HY000]: General error: 3685 Illegal argument to a regular expression." Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 60 Okay\Core\Entity\Entity->find();-line 91 Okay\Modules\OkayCMS\Banners\Extenders\FrontExtender->init();-line 29 Okay\Modules\OkayCMS\Banners\Extenders\FrontExtender->__construct(); ReflectionClass->newInstanceArgs();-line 152 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 45 Okay\Core\ServiceLocator->getService();-line 30 Okay\Core\Modules\Extender\ChainExtender->execute();-line 24 Okay\Core\Modules\Extender\ExtenderFacade->execute();-line 151 Okay\Helpers\MetadataHelpers\CommonMetadataHelper->getParts();-line 156 Okay\Helpers\MetadataHelpers\CommonMetadataHelper->compileMetadata();-line 109 Okay\Helpers\MetadataHelpers\CommonMetadataHelper->getH1();-line 130 Okay\Helpers\MainHelper->commonAfterControllerProcedure();-line 139 Okay\Controllers\AbstractController->afterController(); call_user_func_array();-line 292 Okay\Core\Router->createControllerInstance();-line 222 Okay\Core\Router->Okay\Core\{closure}(); call_user_func_array();-line 379 Bramus\Router\Router->invoke();-line 361 Bramus\Router\Router->handle();-line 287 Bramus\Router\Router->run();-line 232 Okay\Core\Router->run();-line 62  [] []
[2020-10-07 15:36:52] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 72 Okay\Core\Database->__construct(); ReflectionClass->newInstanceArgs();-line 152 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 32  [] []
[2020-10-07 15:36:52] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1064 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 ') ORDER BY     IF(stock=0, 0, 1) DESC,     `v`.`position`,     `v`.`id`' at line 23" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 60 Okay\Core\Entity\Entity->find();-line 64 Okay\Entities\VariantsEntity->find();-line 137 Okay\Helpers\ProductsHelper->attachVariants();-line 93 Okay\Modules\OkayCMS\GoogleMerchant\Controllers\GoogleMerchantController->render(); call_user_func_array();-line 290 Okay\Core\Router->createControllerInstance();-line 222 Okay\Core\Router->Okay\Core\{closure}(); call_user_func_array();-line 379 Bramus\Router\Router->invoke();-line 361 Bramus\Router\Router->handle();-line 287 Bramus\Router\Router->run();-line 232 Okay\Core\Router->run();-line 62  [] []
[2020-10-07 15:36:52] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1064 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 ') GROUP BY     `fv`.`id`,     `l`.`value`,     `l`.`translit` ORDER BY     `fv`.' at line 14" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 60 Okay\Core\Entity\Entity->find();-line 105 Okay\Entities\FeaturesValuesEntity->find();-line 166 Okay\Helpers\ProductsHelper->attachFeatures();-line 96 Okay\Modules\OkayCMS\GoogleMerchant\Controllers\GoogleMerchantController->render(); call_user_func_array();-line 290 Okay\Core\Router->createControllerInstance();-line 222 Okay\Core\Router->Okay\Core\{closure}(); call_user_func_array();-line 379 Bramus\Router\Router->invoke();-line 361 Bramus\Router\Router->handle();-line 287 Bramus\Router\Router->run();-line 232 Okay\Core\Router->run();-line 62  [] []
[2020-10-07 15:51:51] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 72 Okay\Core\Database->__construct(); ReflectionClass->newInstanceArgs();-line 152 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 32  [] []
[2020-10-07 15:51:52] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1064 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 ') ORDER BY     IF(stock=0, 0, 1) DESC,     `v`.`position`,     `v`.`id`' at line 23" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 60 Okay\Core\Entity\Entity->find();-line 64 Okay\Entities\VariantsEntity->find();-line 137 Okay\Helpers\ProductsHelper->attachVariants();-line 93 Okay\Modules\OkayCMS\GoogleMerchant\Controllers\GoogleMerchantController->render(); call_user_func_array();-line 290 Okay\Core\Router->createControllerInstance();-line 222 Okay\Core\Router->Okay\Core\{closure}(); call_user_func_array();-line 379 Bramus\Router\Router->invoke();-line 361 Bramus\Router\Router->handle();-line 287 Bramus\Router\Router->run();-line 232 Okay\Core\Router->run();-line 62  [] []
[2020-10-07 15:51:52] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1064 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 ') GROUP BY     `fv`.`id`,     `l`.`value`,     `l`.`translit` ORDER BY     `fv`.' at line 14" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 60 Okay\Core\Entity\Entity->find();-line 105 Okay\Entities\FeaturesValuesEntity->find();-line 166 Okay\Helpers\ProductsHelper->attachFeatures();-line 96 Okay\Modules\OkayCMS\GoogleMerchant\Controllers\GoogleMerchantController->render(); call_user_func_array();-line 290 Okay\Core\Router->createControllerInstance();-line 222 Okay\Core\Router->Okay\Core\{closure}(); call_user_func_array();-line 379 Bramus\Router\Router->invoke();-line 361 Bramus\Router\Router->handle();-line 287 Bramus\Router\Router->run();-line 232 Okay\Core\Router->run();-line 62  [] []


в логах во 2 версии

Код: Выделить всё

07.10.2020 15:56:00
Error (3685) Illegal argument to a regular expression.
SELECT * FROM ok_banners WHERE 1 AND group_id='group1'  AND visible=1 AND (categories regexp '[[:<:]](17)[[:>:]]' OR show_all_pages=1) LIMIT 1


Главное что это только с этой панелью такое.

zyxer M
zyxer M
Возраст: 32
Репутация: 77
Сообщения: 419
Зарегистрирован: 03.02.2016
С нами: 8 лет 1 месяц
Откуда: Днепр

Сообщение #9 zyxer » 07.10.2020, 13:10

эта и предыдущая ошибки связанны с MySQL 8, честно говоря, в окае еще не делалась совместимость с восьмеркой. Если есть возможность, понизьте версию MySQL, если же нет, будем с вами продолжать выискивать нерабочие места )

Данная ошибка говорит что текущий вариант регулярного выражения не поддерживается 8-й версией мускула. Если возможности понизить версию мускула нет, я позже постараюсь дать решение, если же есть - понизьте, а этот фикс выйдет позже в релизе
Всё сказанное мной, является лично моим мнением, и не является официальной позицией OkayCMS

reteri
reteri
Репутация: 3
Сообщения: 90
Зарегистрирован: 02.05.2018
С нами: 5 лет 10 месяцев

Сообщение #10 reteri » 07.10.2020, 14:34

zyxer писал(а):эта и предыдущая ошибки связанны с MySQL 8, честно говоря, в окае еще не делалась совместимость с восьмеркой. Если есть возможность, понизьте версию MySQL, если же нет, будем с вами продолжать выискивать нерабочие места )

Данная ошибка говорит что текущий вариант регулярного выражения не поддерживается 8-й версией мускула. Если возможности понизить версию мускула нет, я позже постараюсь дать решение, если же есть - понизьте, а этот фикс выйдет позже в релизе

Нет возможности понизить MySQL

Еще проверил DirectAdmin Версия сервера: 10.2.33-MariaDB такая же проблема, а вот cPanel Версия сервера: 10.2.33-MariaDB все нормально.

DirectAdmin

Код: Выделить всё

Apache/2
Версия клиента базы данных: libmysql - mysqlnd 5.0.12-dev - 20150407
PHP расширение: mysqli curl  mbstring
Версия PHP: 7.3.22

cPanel

Код: Выделить всё

cpsrvd 11.90.0.14
Версия клиента базы данных: libmysql - 5.6.43
PHP расширение: mysqli curl mbstring
Версия PHP: 7.3.6

zyxer M
zyxer M
Возраст: 32
Репутация: 77
Сообщения: 419
Зарегистрирован: 03.02.2016
С нами: 8 лет 1 месяц
Откуда: Днепр

Сообщение #11 zyxer » 15.10.2020, 07:51

в файле Okay/Modules/OkayCMS/Banners/Entities/BannersEntity.php замените строку

Код: Выделить всё

$showFilterArray[$k] = $k." regexp '[[:<:]]({$showOnEntitiesIds[$k]})[[:>:]]'";

на

Код: Выделить всё

$showFilterArray[$k] = $k." regexp '\\\\b{$showOnEntitiesIds[$k]}\\\\b'";
Всё сказанное мной, является лично моим мнением, и не является официальной позицией OkayCMS

reteri
reteri
Репутация: 3
Сообщения: 90
Зарегистрирован: 02.05.2018
С нами: 5 лет 10 месяцев

Сообщение #12 reteri » 15.10.2020, 19:12

zyxer писал(а):в файле Okay/Modules/OkayCMS/Banners/Entities/BannersEntity.php замените строку

Код: Выделить всё

$showFilterArray[$k] = $k." regexp '[[:<:]]({$showOnEntitiesIds[$k]})[[:>:]]'";

на

Код: Выделить всё

$showFilterArray[$k] = $k." regexp '\\\\b{$showOnEntitiesIds[$k]}\\\\b'";

Спасибо, помогло для 3 версии.

Для 2 версии применил такой вариант для отображения банеров.
в папке api файл Banners.php заменил

Код: Выделить всё

$show_filter_array[$k] = $this->db->placehold($k." regexp '[[:<:]](?)[[:>:]]'", intval($show_filter_array[$k]));

на строку

Код: Выделить всё

$show_filter_array[$k] = $this->db->placehold($k." regexp '\\\\b\\\\b'", intval($show_filter_array[$k]));


Не знаю правильное ли решение, но банеры выводит.

Constantin83
Constantin83
Репутация: 0
Сообщения: 1
Зарегистрирован: 22.10.2020
С нами: 3 года 5 месяцев

Сообщение #13 Constantin83 » 22.10.2020, 21:40

reteri писал(а):Последние логи

Код: Выделить всё

2020-10-07 15:06:52] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 72 Okay\Core\Database->__construct(); ReflectionClass->newInstanceArgs();-line 152 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 32  [] []
[2020-10-07 15:06:52] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1064 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 ') ORDER BY     IF(stock=0, 0, 1) DESC,     `v`.`position`,     `v`.`id`' at line 23" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 60 Okay\Core\Entity\Entity->find();-line 64 Okay\Entities\VariantsEntity->find();-line 137 Okay\Helpers\ProductsHelper->attachVariants();-line 93 Okay\Modules\OkayCMS\GoogleMerchant\Controllers\GoogleMerchantController->render(); call_user_func_array();-line 290 Okay\Core\Router->createControllerInstance();-line 222 Okay\Core\Router->Okay\Core\{closure}(); call_user_func_array();-line 379 Bramus\Router\Router->invoke();-line 361 Bramus\Router\Router->handle();-line 287 Bramus\Router\Router->run();-line 232 Okay\Core\Router->run();-line 62  [] []
[2020-10-07 15:06:52] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1064 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 ') GROUP BY     `fv`.`id`,     `l`.`value`,     `l`.`translit` ORDER BY     `fv`.' at line 14" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 60 Okay\Core\Entity\Entity->find();-line 105 Okay\Entities\FeaturesValuesEntity->find();-line 166 Okay\Helpers\ProductsHelper->attachFeatures();-line 96 Okay\Modules\OkayCMS\GoogleMerchant\Controllers\GoogleMerchantController->render(); call_user_func_array();-line 290 Okay\Core\Router->createControllerInstance();-line 222 Okay\Core\Router->Okay\Core\{closure}(); call_user_func_array();-line 379 Bramus\Router\Router->invoke();-line 361 Bramus\Router\Router->handle();-line 287 Bramus\Router\Router->run();-line 232 Okay\Core\Router->run();-line 62  [] []
[2020-10-07 15:16:40] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 72 Okay\Core\Database->__construct(); ReflectionClass->newInstanceArgs();-line 152 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 32  [] []
[2020-10-07 15:16:40] channel-name.ERROR: Sql query error: "SQLSTATE[HY000]: General error: 3685 Illegal argument to a regular expression." Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 60 Okay\Core\Entity\Entity->find();-line 91 Okay\Modules\OkayCMS\Banners\Extenders\FrontExtender->init();-line 29 Okay\Modules\OkayCMS\Banners\Extenders\FrontExtender->__construct(); ReflectionClass->newInstanceArgs();-line 152 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 45 Okay\Core\ServiceLocator->getService();-line 30 Okay\Core\Modules\Extender\ChainExtender->execute();-line 24 Okay\Core\Modules\Extender\ExtenderFacade->execute();-line 151 Okay\Helpers\MetadataHelpers\CommonMetadataHelper->getParts();-line 156 Okay\Helpers\MetadataHelpers\CommonMetadataHelper->compileMetadata();-line 109 Okay\Helpers\MetadataHelpers\CommonMetadataHelper->getH1();-line 130 Okay\Helpers\MainHelper->commonAfterControllerProcedure();-line 139 Okay\Controllers\AbstractController->afterController(); call_user_func_array();-line 292 Okay\Core\Router->createControllerInstance();-line 222 Okay\Core\Router->Okay\Core\{closure}(); call_user_func_array();-line 379 Bramus\Router\Router->invoke();-line 361 Bramus\Router\Router->handle();-line 287 Bramus\Router\Router->run();-line 232 Okay\Core\Router->run();-line 62  [] []
[2020-10-07 15:16:41] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 72 Okay\Core\Database->__construct(); ReflectionClass->newInstanceArgs();-line 152 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 32  [] []
[2020-10-07 15:16:41] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 72 Okay\Core\Database->__construct(); ReflectionClass->newInstanceArgs();-line 152 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 32  [] []
[2020-10-07 15:21:51] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 72 Okay\Core\Database->__construct(); ReflectionClass->newInstanceArgs();-line 152 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 32  [] []
[2020-10-07 15:21:51] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1064 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 ') ORDER BY     IF(stock=0, 0, 1) DESC,     `v`.`position`,     `v`.`id`' at line 23" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 60 Okay\Core\Entity\Entity->find();-line 64 Okay\Entities\VariantsEntity->find();-line 137 Okay\Helpers\ProductsHelper->attachVariants();-line 93 Okay\Modules\OkayCMS\GoogleMerchant\Controllers\GoogleMerchantController->render(); call_user_func_array();-line 290 Okay\Core\Router->createControllerInstance();-line 222 Okay\Core\Router->Okay\Core\{closure}(); call_user_func_array();-line 379 Bramus\Router\Router->invoke();-line 361 Bramus\Router\Router->handle();-line 287 Bramus\Router\Router->run();-line 232 Okay\Core\Router->run();-line 62  [] []
[2020-10-07 15:21:51] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1064 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 ') GROUP BY     `fv`.`id`,     `l`.`value`,     `l`.`translit` ORDER BY     `fv`.' at line 14" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 60 Okay\Core\Entity\Entity->find();-line 105 Okay\Entities\FeaturesValuesEntity->find();-line 166 Okay\Helpers\ProductsHelper->attachFeatures();-line 96 Okay\Modules\OkayCMS\GoogleMerchant\Controllers\GoogleMerchantController->render(); call_user_func_array();-line 290 Okay\Core\Router->createControllerInstance();-line 222 Okay\Core\Router->Okay\Core\{closure}(); call_user_func_array();-line 379 Bramus\Router\Router->invoke();-line 361 Bramus\Router\Router->handle();-line 287 Bramus\Router\Router->run();-line 232 Okay\Core\Router->run();-line 62  [] []
[2020-10-07 15:25:57] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 72 Okay\Core\Database->__construct(); ReflectionClass->newInstanceArgs();-line 152 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 32  [] []
[2020-10-07 15:25:57] channel-name.ERROR: Sql query error: "SQLSTATE[HY000]: General error: 3685 Illegal argument to a regular expression." Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 60 Okay\Core\Entity\Entity->find();-line 91 Okay\Modules\OkayCMS\Banners\Extenders\FrontExtender->init();-line 29 Okay\Modules\OkayCMS\Banners\Extenders\FrontExtender->__construct(); ReflectionClass->newInstanceArgs();-line 152 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 45 Okay\Core\ServiceLocator->getService();-line 30 Okay\Core\Modules\Extender\ChainExtender->execute();-line 24 Okay\Core\Modules\Extender\ExtenderFacade->execute();-line 151 Okay\Helpers\MetadataHelpers\CommonMetadataHelper->getParts();-line 156 Okay\Helpers\MetadataHelpers\CommonMetadataHelper->compileMetadata();-line 109 Okay\Helpers\MetadataHelpers\CommonMetadataHelper->getH1();-line 130 Okay\Helpers\MainHelper->commonAfterControllerProcedure();-line 139 Okay\Controllers\AbstractController->afterController(); call_user_func_array();-line 292 Okay\Core\Router->createControllerInstance();-line 222 Okay\Core\Router->Okay\Core\{closure}(); call_user_func_array();-line 379 Bramus\Router\Router->invoke();-line 361 Bramus\Router\Router->handle();-line 287 Bramus\Router\Router->run();-line 232 Okay\Core\Router->run();-line 62  [] []
[2020-10-07 15:25:59] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 72 Okay\Core\Database->__construct(); ReflectionClass->newInstanceArgs();-line 152 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 32  [] []
[2020-10-07 15:25:59] channel-name.ERROR: Sql query error: "SQLSTATE[HY000]: General error: 3685 Illegal argument to a regular expression." Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 60 Okay\Core\Entity\Entity->find();-line 91 Okay\Modules\OkayCMS\Banners\Extenders\FrontExtender->init();-line 29 Okay\Modules\OkayCMS\Banners\Extenders\FrontExtender->__construct(); ReflectionClass->newInstanceArgs();-line 152 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 45 Okay\Core\ServiceLocator->getService();-line 30 Okay\Core\Modules\Extender\ChainExtender->execute();-line 24 Okay\Core\Modules\Extender\ExtenderFacade->execute();-line 151 Okay\Helpers\MetadataHelpers\CommonMetadataHelper->getParts();-line 156 Okay\Helpers\MetadataHelpers\CommonMetadataHelper->compileMetadata();-line 109 Okay\Helpers\MetadataHelpers\CommonMetadataHelper->getH1();-line 130 Okay\Helpers\MainHelper->commonAfterControllerProcedure();-line 139 Okay\Controllers\AbstractController->afterController(); call_user_func_array();-line 292 Okay\Core\Router->createControllerInstance();-line 222 Okay\Core\Router->Okay\Core\{closure}(); call_user_func_array();-line 379 Bramus\Router\Router->invoke();-line 361 Bramus\Router\Router->handle();-line 287 Bramus\Router\Router->run();-line 232 Okay\Core\Router->run();-line 62  [] []
[2020-10-07 15:36:52] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 72 Okay\Core\Database->__construct(); ReflectionClass->newInstanceArgs();-line 152 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 32  [] []
[2020-10-07 15:36:52] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1064 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 ') ORDER BY     IF(stock=0, 0, 1) DESC,     `v`.`position`,     `v`.`id`' at line 23" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 60 Okay\Core\Entity\Entity->find();-line 64 Okay\Entities\VariantsEntity->find();-line 137 Okay\Helpers\ProductsHelper->attachVariants();-line 93 Okay\Modules\OkayCMS\GoogleMerchant\Controllers\GoogleMerchantController->render(); call_user_func_array();-line 290 Okay\Core\Router->createControllerInstance();-line 222 Okay\Core\Router->Okay\Core\{closure}(); call_user_func_array();-line 379 Bramus\Router\Router->invoke();-line 361 Bramus\Router\Router->handle();-line 287 Bramus\Router\Router->run();-line 232 Okay\Core\Router->run();-line 62  [] []
[2020-10-07 15:36:52] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1064 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 ') GROUP BY     `fv`.`id`,     `l`.`value`,     `l`.`translit` ORDER BY     `fv`.' at line 14" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 60 Okay\Core\Entity\Entity->find();-line 105 Okay\Entities\FeaturesValuesEntity->find();-line 166 Okay\Helpers\ProductsHelper->attachFeatures();-line 96 Okay\Modules\OkayCMS\GoogleMerchant\Controllers\GoogleMerchantController->render(); call_user_func_array();-line 290 Okay\Core\Router->createControllerInstance();-line 222 Okay\Core\Router->Okay\Core\{closure}(); call_user_func_array();-line 379 Bramus\Router\Router->invoke();-line 361 Bramus\Router\Router->handle();-line 287 Bramus\Router\Router->run();-line 232 Okay\Core\Router->run();-line 62  [] []
[2020-10-07 15:51:51] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 72 Okay\Core\Database->__construct(); ReflectionClass->newInstanceArgs();-line 152 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 32  [] []
[2020-10-07 15:51:52] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1064 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 ') ORDER BY     IF(stock=0, 0, 1) DESC,     `v`.`position`,     `v`.`id`' at line 23" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 60 Okay\Core\Entity\Entity->find();-line 64 Okay\Entities\VariantsEntity->find();-line 137 Okay\Helpers\ProductsHelper->attachVariants();-line 93 Okay\Modules\OkayCMS\GoogleMerchant\Controllers\GoogleMerchantController->render(); call_user_func_array();-line 290 Okay\Core\Router->createControllerInstance();-line 222 Okay\Core\Router->Okay\Core\{closure}(); call_user_func_array();-line 379 Bramus\Router\Router->invoke();-line 361 Bramus\Router\Router->handle();-line 287 Bramus\Router\Router->run();-line 232 Okay\Core\Router->run();-line 62  [] []
[2020-10-07 15:51:52] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1064 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 ') GROUP BY     `fv`.`id`,     `l`.`value`,     `l`.`translit` ORDER BY     `fv`.' at line 14" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 106 Okay\Core\Database->query();-line 60 Okay\Core\Entity\Entity->find();-line 105 Okay\Entities\FeaturesValuesEntity->find();-line 166 Okay\Helpers\ProductsHelper->attachFeatures();-line 96 Okay\Modules\OkayCMS\GoogleMerchant\Controllers\GoogleMerchantController->render(); call_user_func_array();-line 290 Okay\Core\Router->createControllerInstance();-line 222 Okay\Core\Router->Okay\Core\{closure}(); call_user_func_array();-line 379 Bramus\Router\Router->invoke();-line 361 Bramus\Router\Router->handle();-line 287 Bramus\Router\Router->run();-line 232 Okay\Core\Router->run();-line 62  [] []


в логах во 2 версии
paris cdg car service

Код: Выделить всё

07.10.2020 15:56:00
Error (3685) Illegal argument to a regular expression.
SELECT * FROM ok_banners WHERE 1 AND group_id='group1'  AND visible=1 AND (categories regexp '[[:<:]](17)[[:>:]]' OR show_all_pages=1) LIMIT 1


Главное что это только с этой панелью такое.
Здравствуйте, я давно искал это руководство, о котором вы здесь говорите, чтобы распечатать или взять напрокат, если хотите

igor25
igor25

Сообщение #14 igor25 » 08.02.2021, 18:46

для версии 4 такая же ошибка (((
Smarty: Plugin tag 'fast_order_btn' already registered

Код: Выделить всё

[2021-02-08 20:34:10] channel-name.ERROR: Sql query error: "SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'agro.os.position' which is not in SELECT list; this is incompatible with DISTINCT" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 101 Okay\Core\Database->query();-line 94 Okay\Core\Entity\Entity->find();-line 49 Okay\Admin\Helpers\BackendMainHelper->evensCounters();-line 186 Okay\Admin\Controllers\IndexAdmin->onInit(); call_user_func_array();-line 186  [] []
[2021-02-08 20:34:13] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 101 Okay\Core\Database->query();-line 65 Okay\Core\Database->__construct(); ReflectionClass->newInstanceArgs();-line 152 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 175 Okay\Core\OkayContainer\OkayContainer->resolveArguments();-line 149 Okay\Core\OkayContainer\OkayContainer->createService();-line 69 Okay\Core\OkayContainer\OkayContainer->get();-line 34  [] []
[2021-02-08 20:34:13] channel-name.ERROR: Sql query error: "SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'agro.m.position' which is not in SELECT list; this is incompatible with DISTINCT" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 101 Okay\Core\Database->query();-line 94 Okay\Core\Entity\Entity->find();-line 147 Okay\Entities\ModulesEntity->installedFullModuleNames();-line 85 Okay\Entities\ModulesEntity->findNotInstalled();-line 342 Okay\Core\Modules\Modules->indexingNotInstalledModules();-line 184 Okay\Core\Router->Okay\Core\{closure}(); call_user_func_array();-line 388 Bramus\Router\Router->invoke();-line 370 Bramus\Router\Router->handle();-line 287 Bramus\Router\Router->run();-line 224 Okay\Core\Router->run();-line 67  [] []
[2021-02-08 20:34:13] channel-name.CRITICAL: Plugin tag 'fast_order_btn' already registered #0 /var/www/mydomain.com/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php(277): Smarty_Internal_Method_RegisterPlugin->registerPlugin(Object(Smarty), 'function', 'fast_order_btn', Object(Closure), true, NULL) #1 /var/www/mydomain.com/Okay/Core/Design.php(391): Smarty_Internal_TemplateBase->registerPlugin('function', 'fast_order_btn', Object(Closure)) #2 /var/www/mydomain.com/Okay/Core/Design.php(336): Okay\Core\Design->registerSmartyPlugins() #3 /var/www/mydomain.com/Okay/Helpers/MainHelper.php(274): Okay\Core\Design->fetch('menu.tpl') #4 /var/www/mydomain.com/Okay/Controllers/AbstractController.php(117): Okay\Helpers\MainHelper->setDesignDataProcedure() #5 [internal function]: Okay\Controllers\AbstractController->onInit(Object(Okay\Core\Design), Object(Okay\Core\Request), Object(Okay\Core\Response), Object(Okay\Core\Settings), Object(Okay\Core\Config), Object(Okay\Core\EntityFactory), Object(Okay\Core\Router), Object(Okay\Core\Cart), Object(Okay\Core\Comparison), Object(Okay\Core\WishList), Object(Okay\Helpers\MainHelper), Object(Okay\Helpers\CommonHelper), Object(Okay\Helpers\UserHelper)) #6 /var/www/mydomain.com/Okay/Core/Router.php(279): call_user_func_array(Array, Array) #7 /var/www/mydomain.com/Okay/Core/Router.php(214): Okay\Core\Router->createControllerInstance('\\Okay\\Controlle...', 'render', Array, Array, Array) #8 [internal function]: Okay\Core\Router->Okay\Core\{closure}() #9 /var/www/mydomain.com/vendor/bramus/router/src/Bramus/Router/Router.php(388): call_user_func_array(Object(Closure), Array) #10 /var/www/mydomain.com/vendor/bramus/router/src/Bramus/Router/Router.php(370): Bramus\Router\Router->invoke(Object(Closure), Array) #11 /var/www/mydomain.com/vendor/bramus/router/src/Bramus/Router/Router.php(287): Bramus\Router\Router->handle(Array, true) #12 /var/www/mydomain.com/Okay/Core/Router.php(224): Bramus\Router\Router->run(Object(Closure)) #13 /var/www/mydomain.com/index.php(67): Okay\Core\Router->run() #14 {main} [] []

Slik
Slik
Репутация: 0
Сообщения: 27
Зарегистрирован: 15.08.2017
С нами: 6 лет 7 месяцев

Сообщение #15 Slik » 10.02.2021, 09:02

Попробуйте добавить в my.cnf следующее, в секцию [mysqld]

Код: Выделить всё

sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

Мне на 8-й версии MySQL помогло.

natalipso22
natalipso22

Ошибка

Сообщение #16 natalipso22 » 29.03.2023, 15:56

Добрый день!

Выдает ошибку? Подскажите что делать.

[2023-03-28 22:02:35] channel-name.ERROR: Sql query error: "SQLSTATE[42000]: Syntax error or access violation: 1064 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 ')' at line 8" Query trace: PDOStatement->execute();-line 558 Aura\Sql\AbstractExtendedPdo->perform();-line 101 Okay\Core\Database->query();-line 70 Okay\Core\QueryFactory\AbstractQuery->results();-line 670 Okay\Admin\Helpers\BackendOrdersHelper->deleteDiscounts();-line 102 Okay\Admin\Controllers\OrderAdmin->fetch(); call_user_func_array();-line 191 [] []


Название раздела: Вопросы по работе с OkayCMS
Правила раздела: faq.php?mode=okay

Быстрый ответ


Введите код в точности так, как вы его видите. Регистр символов не имеет значения.
Код подтверждения

   

Вернуться в «Вопросы по работе с OkayCMS»

Кто сейчас на форуме (по активности за 5 минут)

Сейчас этот раздел просматривают: 25 гостей