hi,
I noticed this in my logs. With error of Illegal mix of collations, not sure why I’m getting this now for the 1st time, never seen a DB related error prior to this. my site has been running on yii2 for 2 years already.
Think someone trying to to attack my site, any tips on what to do, or extra yii2 settings i should set?
I’m using AWS EC2 and RDS
2023-10-24 05:24:21 [103.XXX.XXX.XXX][-][-][error][yii\db\Exception] PDOException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb3_general_ci,COERCIBLE) for operation '=' in /var/www/html/vendor/yiisoft/yii2/db/Command.php:1320
Stack trace:
#0 /var/www/html/vendor/yiisoft/yii2/db/Command.php(1320): PDOStatement->execute()
#1 /var/www/html/vendor/yiisoft/yii2/db/Command.php(1186): yii\db\Command->internalExecute()
#2 /var/www/html/vendor/yiisoft/yii2/db/Command.php(443): yii\db\Command->queryInternal()
#3 /var/www/html/vendor/yiisoft/yii2/db/Query.php(304): yii\db\Command->queryScalar()
#4 /var/www/html/vendor/yiisoft/yii2/web/DbSession.php(185): yii\db\Query->scalar()
#5 [internal function]: yii\web\DbSession->readSession()
#6 /var/www/html/vendor/yiisoft/yii2/web/Session.php(149): session_start()
#7 /var/www/html/vendor/yiisoft/yii2/web/Session.php(750): yii\web\Session->open()
#8 /var/www/html/frontend/components/GlobalClass.php(25): yii\web\Session->has()
#9 /var/www/html/vendor/yiisoft/yii2/base/BaseObject.php(109): app\components\GlobalClass->init()
#10 [internal function]: yii\base\BaseObject->__construct()
#11 /var/www/html/vendor/yiisoft/yii2/di/Container.php(411): ReflectionClass->newInstanceArgs()
#12 /var/www/html/vendor/yiisoft/yii2/di/Container.php(170): yii\di\Container->build()
#13 /var/www/html/vendor/yiisoft/yii2/BaseYii.php(365): yii\di\Container->get()
#14 /var/www/html/vendor/yiisoft/yii2/di/ServiceLocator.php(137): yii\BaseYii::createObject()
#15 /var/www/html/vendor/yiisoft/yii2/base/Module.php(766): yii\di\ServiceLocator->get()
#16 /var/www/html/vendor/yiisoft/yii2/base/Application.php(311): yii\base\Module->get()
#17 /var/www/html/vendor/yiisoft/yii2/web/Application.php(69): yii\base\Application->bootstrap()
#18 /var/www/html/vendor/yiisoft/yii2/base/Application.php(271): yii\web\Application->bootstrap()
#19 /var/www/html/vendor/yiisoft/yii2/base/BaseObject.php(109): yii\base\Application->init()
#20 /var/www/html/vendor/yiisoft/yii2/base/Application.php(204): yii\base\BaseObject->__construct()
#21 /var/www/html/frontend/web/index.php(79): yii\base\Application->__construct()
#22 {main}
Next yii\db\Exception: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb3_general_ci,COERCIBLE) for operation '='
The SQL being executed was: SELECT `data` FROM `yiisession` WHERE `expire`>1698096261 AND `id`='1\0����%27%22' in /var/www/html/vendor/yiisoft/yii2/db/Schema.php:676
Stack trace:
#0 /var/www/html/vendor/yiisoft/yii2/db/Command.php(1325): yii\db\Schema->convertException()
#1 /var/www/html/vendor/yiisoft/yii2/db/Command.php(1186): yii\db\Command->internalExecute()
#2 /var/www/html/vendor/yiisoft/yii2/db/Command.php(443): yii\db\Command->queryInternal()
#3 /var/www/html/vendor/yiisoft/yii2/db/Query.php(304): yii\db\Command->queryScalar()
#4 /var/www/html/vendor/yiisoft/yii2/web/DbSession.php(185): yii\db\Query->scalar()
#5 [internal function]: yii\web\DbSession->readSession()
#6 /var/www/html/vendor/yiisoft/yii2/web/Session.php(149): session_start()
#7 /var/www/html/vendor/yiisoft/yii2/web/Session.php(750): yii\web\Session->open()
#8 /var/www/html/frontend/components/GlobalClass.php(25): yii\web\Session->has()
#9 /var/www/html/vendor/yiisoft/yii2/base/BaseObject.php(109): app\components\GlobalClass->init()
#10 [internal function]: yii\base\BaseObject->__construct()
#11 /var/www/html/vendor/yiisoft/yii2/di/Container.php(411): ReflectionClass->newInstanceArgs()
#12 /var/www/html/vendor/yiisoft/yii2/di/Container.php(170): yii\di\Container->build()
#13 /var/www/html/vendor/yiisoft/yii2/BaseYii.php(365): yii\di\Container->get()
#14 /var/www/html/vendor/yiisoft/yii2/di/ServiceLocator.php(137): yii\BaseYii::createObject()
#15 /var/www/html/vendor/yiisoft/yii2/base/Module.php(766): yii\di\ServiceLocator->get()
#16 /var/www/html/vendor/yiisoft/yii2/base/Application.php(311): yii\base\Module->get()
#17 /var/www/html/vendor/yiisoft/yii2/web/Application.php(69): yii\base\Application->bootstrap()
#18 /var/www/html/vendor/yiisoft/yii2/base/Application.php(271): yii\web\Application->bootstrap()
#19 /var/www/html/vendor/yiisoft/yii2/base/BaseObject.php(109): yii\base\Application->init()
#20 /var/www/html/vendor/yiisoft/yii2/base/Application.php(204): yii\base\BaseObject->__construct()
#21 /var/www/html/frontend/web/index.php(79): yii\base\Application->__construct()
#22 {main}
Additional Information:
Array
(
[0] => HY000
[1] => 1267
[2] => Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb3_general_ci,COERCIBLE) for operation '='
)
2023-10-24 05:24:21 [103.114.160.223][-][-][info][application] $_GET = []
$_POST = []
$_FILES = []
$_COOKIE = [
'bla-frontend' => '1\0����%27%22'
'_fbp' => 'fb.1.1698068586937.1808644828'
'__hstc' => '109001565.757f2929aca955f3d41aea01ad2053da.1698068589599.1698068589599.1698068589599.1'
'hubspotutk' => '757f2929aca955f3d41aea01ad2053da'
'__hssrc' => '1'
'__hssc' => '109001565.13.1698068589600'
]