Сообщение #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
Главное что это только с этой панелью такое.
Здравствуйте, я давно искал это руководство, о котором вы здесь говорите, чтобы распечатать или взять напрокат, если хотите
[quote="reteri"]Последние логи[code]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 [] []
[/code]
в логах во 2 версии
[url=https://www.shuttle-paris-airports.com/cdg-paris-transfer]paris cdg car service[/url] [code]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[/code]
Главное что это только с этой панелью такое.[/quote]
Здравствуйте, я давно искал это руководство, о котором вы здесь говорите, чтобы распечатать или взять напрокат, если хотите