[OnQueryError] SQL ERROR. QUERY: SET character_set_connection = 'cp1251'

DEM00 · 11 Апр 2022

Всем привет, столкнулся с данной проблемой в логах. Так же не появляется окно регистрации на сервере.

PHP:

SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team

[15:23:41]
[15:23:41] Server Plugins
[15:23:41] --------------
[15:23:41]  Loading plugin: crashdetect.so
[15:23:41]   CrashDetect plugin 4.19.4
[15:23:41]   Loaded.
[15:23:41]  Loading plugin: filemanager.so
[15:23:41] ******************
[15:23:41] ** FILE MANAGER **
[15:23:41] **    Loaded    **
[15:23:41] ** Version 1.5 **
[15:23:41] ******************
[15:23:41]   Loaded.
[15:23:41]  Loading plugin: gvar.so
[15:23:41]

*** GVar Plugin v1.3 by Incognito loaded ***

[15:23:41]   Loaded.
[15:23:41]  Loading plugin: mysql.so
[15:23:41]  >> plugin.mysql: R41-4 successfully loaded.
[15:23:41]   Loaded.
[15:23:41]  Loading plugin: pawncmd.so
[15:23:41] Pawn.CMD plugin v3.2.0 by urShadow has been loaded
[15:23:41]   Loaded.
[15:23:41]  Loading plugin: pawnraknet.so
[15:23:41] [Pawn.RakNet]

    | Pawn.RakNet 1.4.1 | 2016 - 2020
    |--------------------------------
    | Author and maintainer: urShadow


    | Compiled: Jun 18 2020 at 11:28:17
    |--------------------------------------------------------------
    | Forum thread: https://forum.wiki.pawno-info.ru/showthread.php?t=640306
    |--------------------------------------------------------------
    | Repository: https://github.com/urShadow/Pawn.RakNet
    |--------------------------------------------------------------
    | Wiki: https://github.com/urShadow/Pawn.RakNet/wiki

[15:23:41]   Loaded.
[15:23:41]  Loading plugin: pawnregex.so
[15:23:41] [Pawn.Regex] plugin v1.1.3 by urShadow loaded
[15:23:41]   Loaded.
[15:23:41]  Loading plugin: profiler.so
[15:23:41]   Profiler plugin 2.15.3
[15:23:41]   Loaded.
[15:23:41]  Loading plugin: sscanf.so
[15:23:41]

[15:23:41]  ===============================

[15:23:41]       sscanf plugin loaded.     

[15:23:41]          Version:  2.8.3       

[15:23:41]   (c) 2018 Alex "Y_Less" Cole 

[15:23:41]  ===============================

[15:23:41]   Loaded.
[15:23:41]  Loading plugin: streamer.so
[15:23:41]

*** Streamer Plugin v2.9.4 by Incognito loaded ***

[15:23:41]   Loaded.
[15:23:41]  Loading plugin: TOTP.so
[15:23:41] TOTP plugin v1.0.1 by Games loaded.
[15:23:41]   Loaded.
[15:23:41]  Loaded 11 plugins.

[15:23:41]
[15:23:41] Filterscripts
[15:23:41] ---------------
[15:23:41]   Loading filterscript 'rega_KYPE.amx'...
[15:23:41]   Loaded 1 filterscripts.

[15:23:41] 
[15:23:41] --------------------------------------
[15:23:41]  Античит Nex-AC загружен!
[15:23:41]  Версия античита: 1.9.53
[15:23:41]  Автор: Nexius
[15:23:41] --------------------------------------

[15:23:41] [Загрузка ...] БД MYSQL успешно соединено! (СЕРВЕР [ОСНОВНОЙ] | 1)
[15:23:41] [Загрузка ...] Транспорт успешно загружен (0 шт.)
[15:23:41] [Загрузка ...] ТС фракций успешно загружено (0 шт.)
[15:23:41] [Загрузка ...] Фриз банд/мафий успешно загружен (0 шт.)
[15:23:41] Домов в базе не найдено
[15:23:41] [Загрузка ...] Дома успешно загружены (0 шт.)
[15:23:41] Отелей в базе не найдено
[15:23:41] [Загрузка ...] Отели успешно загружены (0 шт.)
[15:23:41] Аэропорты в базе не найдены
[15:23:41] [Загрузка ...] Аэропорты успешно загружены (0 шт.)
[15:23:41] [Загрузка ...] Аэропланы успешно загружены (0 шт.)
[15:23:41] Семьи в базе не найдены
[15:23:41] [Загрузка ...] Семьи успешно загружены (0 шт.)
[15:23:41] Номеров в отелях в базе не найдены
[15:23:41] [Загрузка ...] Комнаты в отеле успешно загружены (0 шт.)
[15:23:41] Кол-во БИНТ'ов в базе не совпадает с предопределным количеством
[15:23:41] [Загрузка ...] Интереьры бизнесов успешно загружены (0 шт.)
[15:23:41] Не обнаружено func бизнесов в базе
[15:23:41] [Загрузка ...] Функции бизнеса успешно загружена (0 шт.)
[15:23:41] Не обнаружено бизнесов в базе
[15:23:41] [Загрузка ...] Бизнесы успешно загружены (0 шт.)
[15:23:41] [Загрузка ...] Зеленые зоны успешно загружены (0 шт.)
[15:23:41] [Загрузка ...] ГангЗоны успешно загружены (0 шт.)
[15:23:41] [Загрузка ...] Фракции успешно загружены (0 шт.)
[15:23:41] [Загрузка ...] Дипломатия успешно загружена (0 шт.)
[15:23:41] [Загрузка ...] Античит успешно загружен (0 шт.)
[15:23:41] [Загрузка ...] Черный рынок успешно загружен (0 шт.)
[15:23:41] [Загрузка ...] Лаборатории успешно загружены (0 шт.)
[15:23:41] [Загрузка ...] Экономика успешно загружена
[15:23:41] Не обнаружено ATMS в базе
[15:23:41] [Загрузка ...] Банкоматы успешно загружены (0 шт.)
[15:23:41] [Загрузка ...] Голосование загружено
[15:23:41] [Загрузка ...] Оружие фракций успешно загружены
[15:23:41] Билборды не найдены
[15:23:41] [Объекты ...] Динамических объектов: (19832 шт.)
[15:23:41] [Объекты ...] Статических объектов: (120 шт.)
[15:23:41] _______________________________________________________
[15:23:41]                                                       
[15:23:41]  dev by: glvde. | vk.com/way_dev                         
[15:23:41]  aurora project © 2021, inc. all rights reserved.       
[15:23:41] _______________________________________________________
[15:23:41] Number of vehicle models: 109
[15:23:41] [OnQueryError] SQL ERROR. QUERY:
[15:23:41] SET CHARACTER SET 'utf8'
[15:23:41] [OnQueryError] SQL ERROR. QUERY:
[15:23:41] SET NAMES 'utf8'
[15:23:41] [OnQueryError] SQL ERROR. QUERY:
[15:23:41] SET character_set_client = 'cp1251'
[15:23:41] [OnQueryError] SQL ERROR. QUERY:
[15:23:41] SET character_set_connection = 'cp1251'
[15:23:41] [OnQueryError] SQL ERROR. QUERY:
[15:23:41] SET character_set_results = 'cp1251'
[15:23:41] [OnQueryError] SQL ERROR. QUERY:
[15:23:41] SET SESSION collation_connection = 'utf8_general_ci'
[15:23:41] [OnQueryError] SQL ERROR. QUERY:
[15:23:41] UPDATE `accounts` SET `online_status` = '1001'
[15:23:41] [OnQueryError] SQL ERROR. QUERY:
[15:23:41] ALTER TABLE `accounts` ALTER `pCash` SET DEFAULT '0'
[15:23:41] [OnQueryError] SQL ERROR. QUERY:
[15:23:41] ALTER TABLE `accounts` ALTER `pLevel` SET DEFAULT '0'
[15:23:41] [OnQueryError] SQL ERROR. QUERY:
[15:23:41] UPDATE `reports` SET `count` = '0' WHERE `id` = 1
[15:24:41] [OnQueryError] SQL ERROR. QUERY:
[15:24:41] UPDATE `reports` SET `count` = '0' WHERE `id` = 1
[15:24:43] [connection] 85.172.94.254:4311 requests connection cookie.
[15:24:44] [connection] incoming connection: 85.172.94.254:4311 id: 0
[15:24:44] [join] Dem_Deveiro has joined the server (0:85.172.94.254)
[15:24:44] [OnQueryError] SQL ERROR. QUERY:
[15:24:44] SELECT * FROM `banip` WHERE `IP` = '85.172.94.254' LIMIT 1
[15:24:51] [OnQueryError] SQL ERROR. QUERY:
[15:24:51] SELECT `pID`, `pKey`, `pKeyip`, `GoogleCode`, `pGoogle`, `pvIp` FROM `accounts` WHERE `Name` = 'Dem_Deveiro' LIMIT 1
[15:24:57] [part] Dem_Deveiro has left the server (0:1)
[15:24:57] [OnQueryError] SQL ERROR. QUERY:
[15:24:57] UPDATE `accounts` SET `pOnline` = '11-04-2022' WHERE `pID` = '0' LIMIT 1
[15:24:57] [OnQueryError] SQL ERROR. QUERY:
[15:24:57] UPDATE `accounts` SET `online_status` = '1001' WHERE pID = '0'
[15:25:41] [OnQueryError] SQL ERROR. QUERY:
[15:25:41] UPDATE `reports` SET `count` = '0' WHERE `id` = 1
[15:26:41] [OnQueryError] SQL ERROR. QUERY:
[15:26:41] UPDATE `reports` SET `count` = '0' WHERE `id` = 1
[15:27:41] [OnQueryError] SQL ERROR. QUERY:
[15:27:41] UPDATE `reports` SET `count` = '0' WHERE `id` = 1
[15:28:41] [OnQueryError] SQL ERROR. QUERY:
[15:28:41] UPDATE `reports` SET `count` = '0' WHERE `id` = 1
[15:29:41] [OnQueryError] SQL ERROR. QUERY:
[15:29:41] UPDATE `reports` SET `count` = '0' WHERE `id` = 1
[15:30:41] [OnQueryError] SQL ERROR. QUERY:
[15:30:41] UPDATE `reports` SET `count` = '0' WHERE `id` = 1
[15:31:41] [OnQueryError] SQL ERROR. QUERY:
[15:31:41] UPDATE `reports` SET `count` = '0' WHERE `id` = 1
[15:32:41] [OnQueryError] SQL ERROR. QUERY:
[15:32:41] UPDATE `reports` SET `count` = '0' WHERE `id` = 1
[15:33:41] [OnQueryError] SQL ERROR. QUERY:
[15:33:41] UPDATE `reports` SET `count` = '0' WHERE `id` = 1
[15:34:41] [OnQueryError] SQL ERROR. QUERY:
[15:34:41] UPDATE `reports` SET `count` = '0' WHERE `id` = 1
[15:35:41] [OnQueryError] SQL ERROR. QUERY:
[15:35:41] UPDATE `reports` SET `count` = '0' WHERE `id` = 1
[15:36:41] [OnQueryError] SQL ERROR. QUERY:
[15:36:41] UPDATE `reports` SET `count` = '0' WHERE `id` = 1
[15:37:41] [OnQueryError] SQL ERROR. QUERY:
[15:37:41] UPDATE `reports` SET `count` = '0' WHERE `id` = 1
[15:38:41] [OnQueryError] SQL ERROR. QUERY:
[15:38:41] UPDATE `reports` SET `count` = '0' WHERE `id` = 1
[15:39:41] [OnQueryError] SQL ERROR. QUERY:
[15:39:41] UPDATE `reports` SET `count` = '0' WHERE `id` = 1
[15:40:41] [OnQueryError] SQL ERROR. QUERY:
[15:40:41] UPDATE `reports` SET `count` = '0' WHERE `id` = 1
[15:41:41] [OnQueryError] SQL ERROR. QUERY:
[15:41:41] UPDATE `reports` SET `count` = '0' WHERE `id` = 1
[15:42:41] [OnQueryError] SQL ERROR. QUERY:
[15:42:41] UPDATE `reports` SET `count` = '0' WHERE `id` = 1
[15:43:41] [OnQueryError] SQL ERROR. QUERY:
[15:43:41] UPDATE `reports` SET `count` = '0' WHERE `id` = 1
[15:44:41] [OnQueryError] SQL ERROR. QUERY:
[15:44:41] UPDATE `reports` SET `count` = '0' WHERE `id` = 1

[OnQueryError] SQL ERROR. QUERY: SET character_set_connection = 'cp1251'

DEM00

Дебютант