Всего выполнено запросов: 24 шт. за 0.0076 сек. Развернуть Закрыть

# Запрос номер 1: SELECT @@sql_mode (0.0002 sec ) /var/www/html/mg-core/lib/db.php (line 49)

# Запрос номер 2: SET @@sql_mode='NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION' (0.0001 sec ) /var/www/html/mg-core/lib/db.php (line 59)

# Запрос номер 5: SELECT `value` FROM `mg_setting` WHERE `option` = 'useDefaultSettings' (0.0002 sec ) /var/www/html/mg-core/lib/mg.php (line 1096)

# Запрос номер 6: SELECT `option`, `value` FROM `mg_setting` (0.0009 sec ) /var/www/html/mg-core/lib/mg.php (line 1103)

Ошибка в SQL запросе: SELECT REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(mg_user.phone, '+', ''), ' ', ''), '-', ''), '(', ''), ')', '') as phone, mg_user.id as user_id, mg_order.id as order_id FROM mg_user JOIN mg_order ON REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(mg_order.phone, '+', ''), ' ', ''), '-', ''), '(', ''), ')', '') = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(mg_user.phone, '+', ''), ' ', ''), '-', ''), '(', ''), ')', '') WHERE mg_order.phone <> '' AND mg_order.status_id IN (2,3,5) AND mg_order.add_date BETWEEN DATE('2024-06-01') AND DATE('2024-06-30')
Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '='

/var/www/html/mg-pages/check-correction.php (line 23)

/var/www/html/mg-core/lib/mg.php (line 3222)

/var/www/html/mg-core/lib/mg.php (line 1632)

/var/www/html/mg-core/mg-start.php (line 71)

/var/www/html/mg-core/index-start.php (line 128)

/var/www/html/index.php (line 6)