Проблема Спустя сутки и что то пошло не так

[AngryKitten 13]

Добрый день!Вчера решал проблему с Unknown,после чего вроде все работало но сегодня посмотрел логи и увидел вот это:

 

----------

Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3e, ©2005-2012 SA-MP Team

[12:09:03]
[12:09:03] Server Plugins
[12:09:03] --------------
[12:09:03] Loading plugin: streamer.so
[12:09:03]

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

[12:09:03] Loaded.
[12:09:03] Loading plugin: sscanf.so
[12:09:03]

[12:09:03] ===============================

[12:09:03] sscanf plugin loaded.

[12:09:03] © 2009 Alex "Y_Less" Cole

[12:09:03] 0.3d-R2 500 Players "dnee"

[12:09:03] ===============================

[12:09:03] Loaded.
[12:09:03] Loading plugin: mysql.so
[12:09:03] Failed (plugins/mysql.so: symbol __cxa_pure_virtual, version libmysqlclient_16 not defined in file libmysqlclient_r.so.16 with link time reference)
[12:09:03] Loading plugin: mysql_static.so
[12:09:03] >> plugin.mysql: R39-2 successfully loaded.
[12:09:03] Loaded.
[12:09:03] Loading plugin: FileFunctions.so
[12:09:03] Loaded.
[12:09:03] Loading plugin: antiattack.so
[12:09:03] Anti-Attack plugin by BJIADOKC loaded.
[12:09:03] Loaded.
[12:09:03] Loading plugin: CRP.so
[12:09:03]

[12:09:03] ______________________________________

[12:09:03] Convert Rus To Pwn v0.1.1 loaded
[12:09:03] ______________________________________

[12:09:03] By: Fro © Copyright 2009-2011
[12:09:03] ______________________________________

[12:09:03] Loaded.
[12:09:03] Loaded 6 plugins.

[12:09:04]
[12:09:04] Filterscripts
[12:09:04] ---------------
[12:09:04] Loading filterscript 'JunkBuster.amx'...
[12:09:04] [junkbuster] Loading JunkBuster...
[12:09:04]
[12:09:04] [junkbuster] Current JunkBuster configuration:
[12:09:04] [junkbuster] - WeaponHack = 1
[12:09:04] [junkbuster] - MoneyHack = 1
[12:09:04] [junkbuster] - Jetpack = 1
[12:09:04] [junkbuster] - HealthHack = 1
[12:09:04] [junkbuster] - ArmourHack = 1
[12:09:04] [junkbuster] - DriveBy = 3
[12:09:04] [junkbuster] - Spam = 0
[12:09:04] [junkbuster] - CommandSpam = 0
[12:09:04] [junkbuster] - BadWords = 1
[12:09:04] [junkbuster] - CarJackHack = 1
[12:09:04] [junkbuster] - TeleportHack = 1
[12:09:04] [junkbuster] - MaxPing = 800
[12:09:04] [junkbuster] - SpectateHack = 0
[12:09:04] [junkbuster] - Blacklist = 1
[12:09:04] [junkbuster] - IpBans = 1
[12:09:04] [junkbuster] - TempBans = 1
[12:09:04] [junkbuster] - SpawnKill = 3
[12:09:04] [junkbuster] - CapsLock = 0
[12:09:04] [junkbuster] - 3DSpeed = 0
[12:09:04] [junkbuster] - MaxSpeed = 230
[12:09:04] [junkbuster] - AdminImmunity = 1
[12:09:04] [junkbuster] - Advertisement = 0
[12:09:04] [junkbuster] - FreezeUpdate = 0
[12:09:04] [junkbuster] - SpawnTime = 10
[12:09:04] [junkbuster] - CheckpointTeleport = 1
[12:09:04] [junkbuster] - Airbrake = 10
[12:09:04] [junkbuster] - TankMode = 1
[12:09:04] [junkbuster] - WarnPlayers = 0
[12:09:04] [junkbuster] - SingleplayerCheats = 1
[12:09:04] [junkbuster] - MinFPS = 0
[12:09:04] [junkbuster] - DisableBadWeapons = 1
[12:09:04] [junkbuster] - CBug = 16
[12:09:04] [junkbuster] - AntiBugKill = 1
[12:09:04] [junkbuster] - NoReload = 20
[12:09:04] [junkbuster] - NoReloadForSawnOff = 4
[12:09:04] [junkbuster] - ActiveGMC = 2
[12:09:04] [junkbuster] - GMCBan = 0
[12:09:04] [junkbuster] - ServerSideHealth = 1
[12:09:04] [junkbuster] - CheckVMPos = 0
[12:09:04] [junkbuster] - QuickTurn = 1
[12:09:04] [junkbuster] - VehicleTeleport = 1
[12:09:04] [junkbuster] - Wallride = 170
[12:09:04] [junkbuster] - DisplayTextDraw = 1
[12:09:04] [junkbuster] - AFK = 20
[12:09:04] [junkbuster] - PickupTeleport = 1
[12:09:04] [junkbuster] - FlyHack = 20
[12:09:04] [junkbuster] - JunkBusterChrome = 1
[12:09:04] [junkbuster] - CheckWalkAnims = 1
[12:09:04] [junkbuster] - ReportMoneyHack = 1
[12:09:04] [junkbuster] - SpeedhackAdvanced = 10
[12:09:04] [junkbuster] - Joypad = 0
[12:09:04] [junkbuster] - ArmedVehicles = 0
[12:09:04] [junkbuster] - VehicleRepair = 2
[12:09:04] [junkbuster] - TuningHack = 1
[12:09:04] [junkbuster] - PayForGuns = 0
[12:09:04] [junkbuster] - SpawnVehicles = 0
[12:09:04] [junkbuster] - MaxTotalWarnings = 15
[12:09:04] [junkbuster] - TooManyWarningsAction = 1
[12:09:04] [junkbuster] - AirbrakeDetection = 1
[12:09:04] [junkbuster] - SpeedhackDetection = 0
[12:09:04]
[12:09:04] [junkbuster] 0 IP-bans have been loaded.
[12:09:04] [junkbuster] 0 temporary bans have been loaded.
[12:09:04] [junkbuster] 0 whitelist entries have been loaded.
[12:09:04] [junkbuster] 5 blacklist entries have been loaded.
[12:09:04] [junkbuster] 41 bad words have been loaded.
[12:09:04] [junkbuster] 4 forbidden weapons have been loaded.
[12:09:04] [junkbuster] JunkBuster has been configurated.
[12:09:04] [junkbuster] JunkBuster (v11) has successfully been loaded.
[12:09:04] Loading filterscript 'Keys.amx'...
[12:09:04] Loaded 2 filterscripts.

[12:09:04] OnGameo
[12:09:06] Дома успешно загружены!
[12:09:06] Number of vehicle models: 17
[12:09:33] Incoming connection: 5.153.178.46:53702
[12:09:34] [join] Robert_Carleone has joined the server (0:5.153.178.46)
[12:09:52] Сохранка 641
[12:09:52] [part] Robert_Carleone has left the server (0:1)

 

 

а вот mysql_log:

 

[11:17:33] [ERROR] mysql_tquery - callback parameter count does not match format specifier length
[11:17:33] [ERROR] CMySQLConnection::SetCharset - error 2019: Can't initialize character set utf8_bin (path: /usr/share/mysql/charsets/)
[11:17:33] [ERROR] CMySQLConnection::SetCharset - error 2019: Can't initialize character set utf8_bin (path: /usr/share/mysql/charsets/)
[11:17:33] [ERROR] CMySQLConnection::SetCharset - error 2019: Can't initialize character set utf8_bin (path: /usr/share/mysql/charsets/)
[11:17:52] [ERROR] CMySQLConnection::SetCharset - error 2019: Can't initialize character set utf8_bin (path: /usr/share/mysql/charsets/)
[11:17:52] [ERROR] mysql_tquery - callback parameter count does not match format specifier length
[11:17:52] [ERROR] CMySQLConnection::SetCharset - error 2019: Can't initialize character set utf8_bin (path: /usr/share/mysql/charsets/)
[11:17:52] [ERROR] CMySQLConnection::SetCharset - error 2019: Can't initialize character set utf8_bin (path: /usr/share/mysql/charsets/)
[11:17:52] [ERROR] CMySQLConnection::SetCharset - error 2019: Can't initialize character set utf8_bin (path: /usr/share/mysql/charsets/)
[11:23:27] [ERROR] CMySQLQuery::Execute[CheckIpToBan] - (error #1146) Table 'gs84.BannedIp' doesn't exist
[11:23:27] [ERROR] CMySQLQuery::Execute[OnMySQL_Query] - (error #1146) Table 'gs84.playerinfo' doesn't exist
[11:23:40] [ERROR] CMySQLQuery::Execute[] - (error #1146) Table 'gs84.playerinfo' doesn't exist
[11:26:39] [ERROR] CMySQLConnection::SetCharset - error 2019: Can't initialize character set utf8_bin (path: /usr/share/mysql/charsets/)
[11:26:39] [ERROR] CMySQLConnection::SetCharset - error 2019: Can't initialize character set utf8_bin (path: /usr/share/mysql/charsets/)
[11:26:39] [ERROR] CMySQLConnection::SetCharset - error 2019: Can't initialize character set utf8_bin (path: /usr/share/mysql/charsets/)
[11:26:39] [ERROR] mysql_tquery - callback parameter count does not match format specifier length
[11:26:39] [ERROR] CMySQLConnection::SetCharset - error 2019: Can't initialize character set utf8_bin (path: /usr/share/mysql/charsets/)
[11:36:24] [ERROR] CMySQLQuery::Execute[CheckIpToBan] - (error #1146) Table 'gs84.BannedIp' doesn't exist
[11:36:24] [ERROR] CMySQLQuery::Execute[OnMySQL_Query] - (error #1146) Table 'gs84.playerinfo' doesn't exist
[11:36:31] [ERROR] CMySQLQuery::Execute[] - (error #1146) Table 'gs84.playerinfo' doesn't exist
[12:09:04] [ERROR] CMySQLConnection::SetCharset - error 2019: Can't initialize character set utf8_bin (path: /usr/share/mysql/charsets/)
[12:09:04] [ERROR] mysql_tquery - callback parameter count does not match format specifier length
[12:09:04] [ERROR] CMySQLConnection::SetCharset - error 2019: Can't initialize character set utf8_bin (path: /usr/share/mysql/charsets/)
[12:09:04] [ERROR] CMySQLConnection::SetCharset - error 2019: Can't initialize character set utf8_bin (path: /usr/share/mysql/charsets/)
[12:09:04] [ERROR] CMySQLConnection::SetCharset - error 2019: Can't initialize character set utf8_bin (path: /usr/share/mysql/charsets/)
[12:09:36] [ERROR] CMySQLQuery::Execute[CheckIpToBan] - (error #1146) Table 'gs84.BannedIp' doesn't exist
[12:09:36] [ERROR] CMySQLQuery::Execute[OnMySQL_Query] - (error #1146) Table 'gs84.playerinfo' doesn't exist
[12:09:52] [ERROR] CMySQLQuery::Execute[] - (error #1146) Table 'gs84.playerinfo' doesn't exist

 

 

 

Вот уже не знаю как быть

[Marvellous 271]

@AngryKitten,Первое что заметил это стример! Подключи версию стримера который требует мод версии 2.6.1  и скинь строку подключенных плагинов! 

Так же замени свою строку на мою

mysql_function_query(dbHandle, "SET CHARACTER SET cp1251", false, "", "");

По поводу данной твоей ошибки

[11:36:24] [ERROR] CMySQLQuery::Execute[OnMySQL_Query] - (error #1146) Table 'gs84.playerinfo' doesn't exist

Означает что таблиц не в базе данных/не верно указаны названия

Изменено 17 декабря, 2016 пользователем Marvellous

[hteppl 214]

Ох,как же нагружен сервер.Зря ты это парень...

[AngryKitten 13]

@Marvellous,

idcon = mysql_connect(MySQL_HOST, MySQL_USER, MySQL_DATABASE, MySQL_PASS);

mysql_set_charset("utf8_bin");
mysql_function_query(1, "185.31.160.41" "gs84", false, "gs84", "GkVSRo2WVp");
mysql_function_query(1, "SET CHARACTER SET 'cp1251'", false, "", "");
new texts[256];
new tmphour, tmpminute, tmpsecond;
gettime(tmphour, tmpminute, tmpsecond);
FixHour(tmphour);
tmphour = shifthour;
ghour = tmphour;

SetWorldTime(tmphour);

 

 

echo Executing Server Config...
lanmode 0
rcon_password 123456
maxplayers 50
port
bind
hostname CRMP
gamemode0 new
plugins streamer.so sscanf.so mysql.so mysql_static.so FileFunctions.so antiattack.so CRP.so
filterscripts JunkBuster Keys
announce 0
query 1
weburl www.getservers.ru
maxnpc 0
onfoot_rate 40
incar_rate 40
weapon_rate 40
stream_distance 300.0
stream_rate 1000

 

[OlegDobritsa 19]

Тема похожа на сцену с хорора) 

[Marvellous 271]

@AngryKitten, А тут почему не изменил?

mysql_set_charset("utf8_bin"); 

На 

mysql_set_charset("cp1251");

и ты посмотрел у тебя есть вообще такая таблица есть в базе данных?

И после изменения теперь пришли лог баз данных

[AngryKitten 13]

@Marvellous,таблица есть,но не сохраняет данные!Залил пополненную баз,хотел войти на зареганый акк но вы не входит и не сохраняет данные !Дак вроде же заменил как ты сказал

[Marvellous 271]

@AngryKitten,Т.е ошибки все ушли да? Базу залил тоже под  cp1251 или под utf8_bin, от этого тоже зависит! Так же проверь еще раз пароль/пользователя/хост правильно ли вписаны или нет!

[Web 416]

CrashDetect в помощь и профайлером можно отследить особо ресурсо затратные колбэки

делов то