Вопросы

Доброго времени суток, подключил базу к моду, запускаю сервер, в server_log к базе подключается все( получает все бизнесы, дома и тд ), захожу на сервер, придумываю пароль, а перед выбором скина все зависает. Аккаунт в базе не появляется, уведомления с сервера идут ( о мп и тд). Если окно регистрации появилось, значит база подключилась, но аккаунт не регистрирует.

Спойлер


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

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

[15:34:07] filterscripts = ""  (string)
[15:34:07]
[15:34:07] Server Plugins
[15:34:07] --------------
[15:34:07]  Loading plugin: sscanf.so
[15:34:07]

[15:34:07]  ===============================

[15:34:07]       sscanf plugin loaded.     

[15:34:07]          Version:  2.8.3        

[15:34:07]   (c) 2018 Alex "Y_Less" Cole  

[15:34:07]  ===============================

[15:34:07]   Loaded.
[15:34:07]  Loading plugin: streamer.so
[15:34:07]

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

[15:34:07]   Loaded.
[15:34:07]  Loading plugin: mysql_static.so
[15:34:07]  >> plugin.mysql: R39-6 successfully loaded.
[15:34:07]   Loaded.
[15:34:07]  Loading plugin: pawncmd.so
[15:34:07] Pawn.CMD plugin v3.2.0 by urShadow has been loaded
[15:34:07]   Loaded.
[15:34:07]  Loading plugin: TOTP.so
[15:34:07] TOTP plugin v1.0.1 by Games loaded.
[15:34:07]   Loaded.
[15:34:07]  Loading plugin: mapandreas.so
[15:34:07]   Loaded.
[15:34:07]  Loading plugin: YSF.so
[15:34:07]
[15:34:07]  ==============================================
[15:34:07]  YSF 2.1 (compiled Nov 14 2020 15:44:52) loaded
[15:34:07]   (c) 2008 Alex "Y_Less" Cole
[15:34:07]   (c) 2010 - 2018 kurta999
[15:34:07]   (c) 2018 - 2020 IllidanS4
[15:34:07]  Server version: 0.3.7 R2-1 or R2-2, Linux
[15:34:07]  ==============================================
[15:34:07]
[15:34:07]   Loaded.
[15:34:07]  Loading plugin: CLA.so
[15:34:07]   Loaded.
[15:34:07]  Loading plugin: LauncherAddon.so
[15:34:08]
[15:34:08]  ========[ LauncherAddon 1.3 ]========
[15:34:08]    
[15:34:08]    Версия сервера: 0.3.7 R2
[15:34:08]    Операционная система: Linux
[15:34:08]    
[15:34:08]    (c) - legendabrn -
[15:34:08]    crack by vk.com/legendabrn
[15:34:08]    
[15:34:08]    Проверка активации...
[15:34:08]    Проверка активации успешно пройдена
[15:34:08]  ===============================
[15:34:08]   Loaded.
[15:34:08]  Loading plugin: pawnraknet.so
[15:34:08] [Pawn.RakNet] plugin v1.5.1 loading...
[15:34:08] [Pawn.RakNet]

    | Pawn.RakNet 1.5.1 | 2016 - 2021
    |--------------------------------
    | Author and maintainer: katursis


    | Compiled: Sep 26 2021 at 08:32:38
    |--------------------------------------------------------------
    | Repository: https://github.com/katursis/Pawn.RakNet
    |--------------------------------------------------------------
    | Wiki: https://github.com/katursis/Pawn.RakNet/wiki

[15:34:08]   Loaded.
[15:34:08]  Loading plugin: pawnbots.so
[15:34:08] Pawn.Bots plugin v0.2.1 by urShadow loaded
[15:34:08]   Loaded.
[15:34:08]  Loading plugin: FCNPC.so
[15:34:08]
[15:34:08] -------------------------------------------------
[15:34:08]      FCNPC - Fully Controllable NPC v2.0.4
[15:34:08]             GNU/Linux SA-MP 0.3.7 R2
[15:34:08]            Nov 17 2021 at 02:37:24
[15:34:08]
[15:34:08]   Author:       OrMisicL (2013 - 2015)
[15:34:08]   Continued by: ziggi    (2016 - present)
[15:34:08]
[15:34:08]   See full credits in the README.md file
[15:34:08] -------------------------------------------------
[15:34:08]
[15:34:08] Loading...
[15:34:08]
[15:34:08] -------------------------------------------------
[15:34:08]    ColAndreasv1.4.0
[15:34:08]
[15:34:08]    Created By:
[15:34:08]      [uL]Chris42O
[15:34:08]      [uL]Slice
[15:34:08]      [uL]Pottus
[15:34:08] -------------------------------------------------
[15:34:08]
[15:34:08] Loading...
[15:34:08] ColAndreas v1.4.0 Loaded.
[15:34:08]   Loaded.
[15:34:08]  Loaded 12 plugins.

[15:34:08]
[15:34:08] Filterscripts
[15:34:08] ---------------
[15:34:08]   Loaded 0 filterscripts.

[15:34:08] No collision data found.
[15:34:08]  
[15:34:08] --------------------------------------
[15:34:08]  Античит Nex-AC загружен!
[15:34:08]  Версия античита: 1.9.54
[15:34:08]  Автор: Nexius
[15:34:08] --------------------------------------

[15:34:08]   [DataBase Next]: Ошибок не выявлено, загрузка продолжается!
[15:34:08] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-[ Загрузка FilterScripts ]=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

[15:34:08]   Filterscript 'map.amx' unload failed.
[15:34:09] [Launcher Addon]: Warning - В загружаемом AMX не подключен инклуд LauncherAddon.inc
[15:34:09]   Filterscript 'map.amx' loaded.
[15:34:09]   Filterscript 'ilya.amx' unload failed.
[15:34:09] [Launcher Addon]: Warning - В загружаемом AMX не подключен инклуд LauncherAddon.inc
[15:34:09] [Chinoa Data] Всего было загружено 159/Unlimited Актеров.
[15:34:09] [Chinoa Data] Всего было загружено 709/Unlimited 3D Текстов.
[15:34:09] [Chinoa Data] Всего было загружено 141/Unlimited Пикапов.
[15:34:09] [Chinoa Data] Всего было загружено 143/Unlimited MapIcon.
[15:34:09] [Chinoa Data] Всего было загружено 347/Unlimited Area.
[15:34:09] [Chinoa Data] Всего было загружено 55/Unlimited (NoDynamic)
[15:34:09]  PawnShop`s: loaded.
[15:34:09]   Filterscript 'ilya.amx' loaded.
[15:34:09]   Filterscript 'hostname.amx' unload failed.
[15:34:09] [Launcher Addon]: Warning - В загружаемом AMX не подключен инклуд LauncherAddon.inc
[15:34:09] Server password has been removed.
[15:34:09] hostname.amx loaded!
[15:34:09]   Filterscript 'hostname.amx' loaded.
[15:34:09]   Filterscript 'pawnbots.amx' unload failed.
[15:34:09] [Launcher Addon]: Warning - В загружаемом AMX не подключен инклуд LauncherAddon.inc
[15:34:09] [Pawn.RakNet] DoAmxLoadImpl: Warning! You probably forgot to define FILTERSCRIPT in one of your filterscripts
[15:34:09]   Filterscript 'pawnbots.amx' loaded.
[15:34:09] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-[ Загрузка FilterScripts ]=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
[15:34:09] Server password has been removed.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:09] sscanf warning: String buffer overflow.
[15:34:10]   Загружено складов   ->  500/501
[15:34:10] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-[ Загрузка из базы данных ]=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
[15:34:10] [DataBase Next] Всего было загружено 1417/1550 домов.
[15:34:10] [DataBase Next] Всего было загружено 347/450 бизнесов
[15:34:10] [DataBase Next] Всего было создано 477 единиц транспорта.
[15:34:10] [DataBase Next] Было подгружено 68800 серверных объектов
[15:34:10] [DataBase Next] Было загружено 131/1024 серверных Зон (GangZone)
[15:34:10] [DataBase Next] Было подгружено 1779 иконок на Мини-карте
[15:34:10] [DataBase Next] Было загружено 5291 3D Textов.
[15:34:10] [DataBase Next] Было загружено/создано 000000 трейлеров.
[15:34:10] [DataBase Next] Тип подключения к базе данных 0
[15:34:10] [DataBase Next] [(Administrator)] Было загружено более 180 серверных команд для администрации.
[15:34:10] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-[ Загрузка из базы данных ]=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
[15:34:10] Log-DataBase was connection in: 35 ms! Unix_time: (1692362050)
[15:34:10] ilya.amx was database connect_id [2]
[15:34:10] Number of vehicle models: 71

Спойлер

[15:34:10 08/18/23] [ERROR] CMySQLQuery::Execute - (error #1054) Unknown column 'id' in 'order clause' (Query: "SELECT * FROM Reklama ORDER BY id")
[15:34:10 08/18/23] [WARNING] cache_get_row_count - no active cache
[15:34:10 08/18/23] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('22') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [ERROR] cache_get_row_int - invalid datatype
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('23') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('24') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('22') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [ERROR] cache_get_row_int - invalid datatype
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('23') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('24') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('22') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [ERROR] cache_get_row_int - invalid datatype
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('23') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('24') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('22') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [ERROR] cache_get_row_int - invalid datatype
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('23') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('24') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('22') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [ERROR] cache_get_row_int - invalid datatype
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('23') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('24') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('22') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [ERROR] cache_get_row_int - invalid datatype
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('23') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('24') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('22') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [ERROR] cache_get_row_int - invalid datatype
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('23') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('24') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('22') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [ERROR] cache_get_row_int - invalid datatype
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('23') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('24') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('22') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [ERROR] cache_get_row_int - invalid datatype
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('23') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('24') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('22') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [ERROR] cache_get_row_int - invalid datatype
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('23') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('24') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('22') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [ERROR] cache_get_row_int - invalid datatype
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('23') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('24') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('22') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [ERROR] cache_get_row_int - invalid datatype
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('23') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('24') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('22') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [ERROR] cache_get_row_int - invalid datatype
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('23') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('24') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('22') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [ERROR] cache_get_row_int - invalid datatype
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('23') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('24') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('22') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [ERROR] cache_get_row_int - invalid datatype
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('23') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('24') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('22') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [ERROR] cache_get_row_int - invalid datatype
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('23') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('24') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('22') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [ERROR] cache_get_row_int - invalid datatype
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('23') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('24') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('22') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [ERROR] cache_get_row_int - invalid datatype
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('23') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('24') (Query: "SELECT * FROM family ORDER BY id")
[15:34:10 08/18/23] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'desirelogs'@'185.105.88.79' (using password: YES)
[15:34:10 08/18/23] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'desirelogs'@'185.105.88.79' (using password: YES)
[15:34:10 08/18/23] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'desirelogs'@'185.105.88.79' (using password: YES)
[15:34:10 08/18/23] [ERROR] CMySQLConnection::Connect - (error #1045) Access denied for user 'desirelogs'@'185.105.88.79' (using password: YES)
[15:35:04 08/18/23] [ERROR] CMySQLQuery::Execute[OnPlayerRegisterMysql] - (error #1364) Field 'Exp' doesn't have a default value (Query: "INSERT INTO `accounts` (`NickName`,`Password`,`RegIP`,`Level`,`Sex`,`Race`,`Referal`,`Mail`,`Money`, `Bank`,`HouseKey`,`BankPass`,`SkillLevel`,`VirMoney`,`Merrit`,`datareg`) VALUE ('Koto_Kudoe', '7E077D5948D076A3A8ABBCBD5B99D25A', '109.197.207.167', '1', '1', '0', 'No Referal', 'No Mail Adress', '111111111', '0', '-1', '0', '1', '100000', 'None', '2023-8-18')")
[16:00:01 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('0') (Query: "SELECT `VIP` FROM accounts WHERE NickName = 'Danil_Test'")
[16:00:01 08/18/23] [ERROR] cache_get_row_int - invalid datatype
[16:00:01 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('0') (Query: "SELECT `VIP` FROM accounts WHERE NickName = 'Danil_Test'")
[16:00:01 08/18/23] [ERROR] cache_get_row_int - invalid datatype
[16:48:16 08/18/23] [ERROR] CMySQLQuery::Execute[OnPlayerRegisterMysql] - (error #1364) Field 'Exp' doesn't have a default value (Query: "INSERT INTO `accounts` (`NickName`,`Password`,`RegIP`,`Level`,`Sex`,`Race`,`Referal`,`Mail`,`Money`, `Bank`,`HouseKey`,`BankPass`,`SkillLevel`,`VirMoney`,`Merrit`,`datareg`) VALUE ('Ivan_Ravaelivich', '49FA34F0D7385AD945F85E4FFF95EA80', '87.117.189.58', '1', '1', '0', 'No Referal', 'No Mail Adress', '111111111', '0', '-1', '0', '1', '100000', 'None', '2023-8-18')")
[17:00:00 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('0') (Query: "SELECT `VIP` FROM accounts WHERE NickName = 'Danil_Test'")
[17:00:00 08/18/23] [ERROR] cache_get_row_int - invalid datatype
[17:00:00 08/18/23] [WARNING] CMySQLResult::GetRowData - invalid row ('0') or field index ('0') (Query: "SELECT `VIP` FROM accounts WHERE NickName = 'Danil_Test'")
[17:00:00 08/18/23] [ERROR] cache_get_row_int - invalid datatype

 

 

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

6 ответов на этот вопрос

  • 0

@MrGerst дело оказалось не в этом

Нашел решение.
В базе - SQL -
SET @@GLOBAL.sql_mode= '';
SET @@SESSION.sql_mode= '';
(РАБОТАЕТ ТОЛЬКО ЕСЛИ ВЫ ГРАНД ЮЗЕР БАЗЫ [ГЛАВНЫЙ АДМИН] )

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты
  • 0

Проблема не в моде, тк такое в каждом моде. Сервер запускаю на впс(3 гига, 2 ядра) с убунту 20.04. Скорее всего phpmyadmin настроен не так. Кто знает - помогите пожалуйста

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты
  • 0

@Koto_Kudo Написано же...

[17:00:00 08/18/23] [ERROR] cache_get_row_int - invalid datatype

 

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты
  • 0

@MrGerst Как это починить? В самой базе поменять кодировку?

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты
  • 0

@Koto_Kudo Если вбить в переводчик то можно получить 

cache_get_row_int - недопустимый тип данных

 

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты
  • 0

@Koto_Kudo Просьба поставить галочку что вы нашли решение.

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты
Эта тема закрыта для публикации ответов.

  • Последние посетители   0 пользователей онлайн

    Ни одного зарегистрированного пользователя не просматривает данную страницу

  • Похожий контент

    • От Sasha123452
      Это доработанный мод LINE RP, на сайте https://cp.castle-host.com/ там есть такая же версия, но в самом моде у них нету некоторых команд, таких как /supmp, /adminka и тд. Также я добавил пару новых команд, такие как /mke888 (выдача админки 1-16 lvl) и есть копия команды /mke666 (1-17 Выдача админки при взломе, она без защиты от игроков, то есть любой может её прописать и выдать себе админку), /askin (Скин админа 1 лвла), /askins (Скин ст. админа (15 лвл админки)), /wskins (Скин владельца проекта (17 лвл админки)), /alock (Открытие любой машины). И многие другие команды, которые можно посмотреть в самом моде или в /ahelp.
    • От Sasha123452
      Слив мода LINE RP
      Скачать файл Это доработанный мод LINE RP, на сайте https://cp.castle-host.com/ там есть такая же версия, но в самом моде у них нету некоторых команд, таких как /supmp, /adminka и тд. Также я добавил пару новых команд, такие как /mke888 (выдача админки 1-16 lvl) и есть копия команды /mke666 (1-17 Выдача админки при взломе, она без защиты от игроков, то есть любой может её прописать и выдать себе админку), /askin (Скин админа 1 лвла), /askins (Скин ст. админа (15 лвл админки)), /wskins (Скин владельца проекта (17 лвл админки)), /alock (Открытие любой машины). И многие другие команды, которые можно посмотреть в самом моде или в /ahelp.
      Добавил Sasha123452 Добавлено 14.10.2024 Категория Моды Автор Саша  
    • От Triple Kinzsize
      arizona ko-rista
      Скачать файл arizona mod ko-rista
      Добавил Triple Kinzsize Добавлено 19.12.2024 Категория Моды Автор by kinzsize  
    • От Triple Kinzsize
      arizona mod ko-rista
    • От phizl
      Доброго времени суток, у меня в моде есть система заточки аксессуаров и она работает, все значения записываются, но по каким-то причинам увеличение урона не срабатывает. У меня есть инклуд weapon-config, до этого в нём не было перехвата функции, я его сделал и по идее дефолтные паблики OnPlayerGiveDamage и OnPlayerTakeDamage щас срабатывают. Буду очень благодарен любой помощи! (К слову, в переменной
      pInfo[playerid][pAcsSharpening] все значения равны 11)
       
      Паблики OnPlayerGiveDamage и OnPlayerTakeDamage в самом моде:
      public OnPlayerGiveDamage(playerid, damagedid, Float:amount, weaponid, bodypart) {     new damage;     switch(pInfo[playerid][pAcsSharpening][2])     {         case 0..3: damage = 0;         case 4..11: damage = pInfo[playerid][pAcsSharpening][2]-3;         case 12: damage = 8;     }     amount += (amount / 100) * damage;     switch(pInfo[playerid][pAcsSharpening][3])     {         case 0..3: damage = 0;         case 4..11: damage = pInfo[playerid][pAcsSharpening][3]-3;         case 12: damage = 8;     }     amount += (amount / 100) * damage;     return 1; } public OnPlayerTakeDamage(playerid, issuerid, Float:amount, weaponid, bodypart) {     new nodamage;     if(pInfo[playerid][pAcsSharpening][1] != 0)     {         switch(pInfo[playerid][pAcsSharpening][1])         {             case 1..3: nodamage = 0;             case 4: nodamage = 2;             case 5: nodamage = 4;             case 6: nodamage = 5;             case 7: nodamage = 6;             case 8: nodamage = 8;             case 9: nodamage = 10;             case 10: nodamage = 12;             case 11,12: nodamage = 15;         }     }     if(pInfo[playerid][pAcsSharpening][4] != 0)     {         switch(pInfo[playerid][pAcsSharpening][4])         {             case 1..3: nodamage = 0;             case 4..11: nodamage = pInfo[playerid][pAcsSharpening][4]-2;             case 12: nodamage = 9;         }     }     new damage;     switch(pInfo[playerid][pAcsSharpening][2])     {         case 0..3: damage = 0;         case 4..11: damage = pInfo[playerid][pAcsSharpening][2]-3;         case 12: damage = 8;     }     amount += (amount / 100) * damage;     switch(pInfo[playerid][pAcsSharpening][3])     {         case 0..3: damage = 0;         case 4..11: damage = pInfo[playerid][pAcsSharpening][3]-3;         case 12: damage = 8;     }     amount += (amount / 100) * damage;     if(pInfo[playerid][pAcsSharpening][1] == 0 && pInfo[playerid][pAcsSharpening][4] == 1 || pInfo[playerid][pAcsSharpening][4] == 0 && pInfo[playerid][pAcsSharpening][2] == 1) amount -= (amount / 100) * nodamage;     if(pInfo[playerid][pAcsSharpening][4] == 1 && pInfo[playerid][pAcsSharpening][2] == 1) amount -= (amount / 100)*nodamage*2;     return 1; }  
      Эти же паблики, но в weapon-config с моим перехватом (расположен внизу каждого паблика), мало ли как-то не так сделал