• 0
Koto_Kudo

Не регает аккаунт

Question

Доброго времени суток, подключил базу к моду, запускаю сервер, в 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

 

 

Share this post


Link to post
Share on other sites

6 answers to this question

  • 0

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

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

Share this post


Link to post
Share on other sites
  • 0

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

Share this post


Link to post
Share on other sites
  • 0

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

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

 

Share this post


Link to post
Share on other sites
  • 0

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

Share this post


Link to post
Share on other sites
  • 0

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

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

 

Share this post


Link to post
Share on other sites
  • 0

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

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • kekkomomek1941
      By kekkomomek1941
      Всем привет, вот ошибки, понятия не имею как их исправить, кто может - помогите пожалуйста
      arizona.pwn(92829) : error 001: expected token: ";", but found ":"
      arizona.pwn(92829) : error 029: invalid expression, assumed zero
      arizona.pwn(92799) : error 002: only a single statement (or expression) can follow each "case"
      arizona.pwn(92829) : error 014: invalid statement; not in switch
      arizona.pwn(92829) : fatal error 107: too many error messages on one line
      Вот все строчки с ошибками
       
       
    • KenzoSam
      By KenzoSam
      Всем привет,писал код на инвентарь,появились ошибки которые я незнаю как убрать.
      Компилятор:
      C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\gamemodes\byreytiz.pwn(39) : warning 201: redefinition of constant/macro (symbol "FOREACH_I_Bot") C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\gamemodes\byreytiz.pwn(40) : warning 201: redefinition of constant/macro (symbol "FOREACH_I_Character") C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\pawno\include\brnotification.inc(24) : warning 234: function is deprecated (symbol "BS_Send") Use PR_SendPacket instead C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\pawno\include\customhud.inc(83) : warning 234: function is deprecated (symbol "BS_Send") Use PR_SendPacket instead C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\pawno\include\customhud.inc(327) : warning 234: function is deprecated (symbol "BS_Send") Use PR_SendPacket instead C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\pawno\include\customhud.inc(342) : warning 234: function is deprecated (symbol "BS_Send") Use PR_SendPacket instead C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\pawno\include\customhud.inc(398) : warning 234: function is deprecated (symbol "BS_Send") Use PR_SendPacket instead C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\pawno\include\customtune.inc(211) : warning 234: function is deprecated (symbol "BS_Send") Use PR_SendPacket instead C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\pawno\include\customtune.inc(272) : warning 234: function is deprecated (symbol "BS_Send") Use PR_SendPacket instead C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\pawno\include\customtune.inc(721) : warning 234: function is deprecated (symbol "BS_Send") Use PR_SendPacket instead C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\gamemodes\byreytiz.pwn(119) : warning 201: redefinition of constant/macro (symbol "M_DIALOG_DialogForPlayer") C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\gamemodes\byreytiz.pwn(8763) : loose indentation C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\gamemodes\byreytiz.pwn(8773) : loose indentation C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\gamemodes\byreytiz.pwn(9869) : symbol is assigned a value that is never used: "carid" C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\gamemodes\byreytiz.pwn(10671) : symbol is assigned a value that is never used: "color2" C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\gamemodes\byreytiz.pwn(10670) : symbol is assigned a value that is never used: "color1" C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\gamemodes\byreytiz.pwn(10818) : loose indentation C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\gamemodes\byreytiz.pwn(10816) : symbol is assigned a value that is never used: "job_car" C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\gamemodes\byreytiz.pwn(13444) : symbol is assigned a value that is never used: "carid" C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\gamemodes\byreytiz.pwn(13461) : symbol is assigned a value that is never used: "s" C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\gamemodes\byreytiz.pwn(13946) : symbol is assigned a value that is never used: "randomize" C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\gamemodes\byreytiz.pwn(14713) : warning 216: nested comment C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\gamemodes\byreytiz.pwn(25414) : loose indentation C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\gamemodes\byreytiz.pwn(25410) : symbol is assigned a value that is never used: "action_id" C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\gamemodes\byreytiz.pwn(25409) : symbol is assigned a value that is never used: "action_type" C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\gamemodes\byreytiz.pwn(25597) : loose indentation C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\gamemodes\byreytiz.pwn(25595) : symbol is assigned a value that is never used: "action_id" C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\gamemodes\byreytiz.pwn(25594) : symbol is assigned a value that is never used: "action_type" C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\gamemodes\byreytiz.pwn(30735) : loose indentation C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\gamemodes\byreytiz.pwn(30755) : loose indentation C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\gamemodes\byreytiz.pwn(30768) : loose indentation C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\gamemodes\byreytiz.pwn(30824) : loose indentation C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\gamemodes\byreytiz.pwn(30822) : symbol is assigned a value that is never used: "fmt_text" C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\gamemodes\byreytiz.pwn(30850) : loose indentation C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\gamemodes\byreytiz.pwn(30848) : symbol is assigned a value that is never used: "fmt_text" C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\gamemodes\byreytiz.pwn(34053) : error 017: undefined symbol "playertextid" C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\gamemodes\byreytiz.pwn(34053) : warning 215: expression has no effect C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\gamemodes\byreytiz.pwn(34053) : error 001: expected token: ";", but found "]" C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\gamemodes\byreytiz.pwn(34053) : error 029: invalid expression, assumed zero C:\Users\asus\OneDrive\Ðàáî÷èé ñòîë\byreytiz\gamemodes\byreytiz.pwn(34053) : fatal error 107: too many error messages on one line Compilation aborted. Pawn compiler 3.2.3664          Copyright (c) 1997-2016, ITB CompuPhase 4 Errors. Код(только ошибок):
      public OnPlayerClickTextDraw(playerid, Text:clickedid) {     for(new i=0; i < 97; i++)     {         if(playertextid == inv_TD[playerid][i])//34053 на эту стройку пищит         {             if(PlayerInfo[playerid][Inv][i] == 1649)             {                 if(GetPVarInt(playerid, "ClickInv") == -1)                 {                     new id_inv = GetPVarInt(playerid, "ClickInv");                     PlayerTextDrawSetPriviewModel(playerid, inv_TD[playerid][id_inv], 1649);                     PlayerTextDrawSetPriviewModel(playerid, inv_TD[playerid][i], PlayerInfo[playerid][Inv][i]);                     PlayerInfo[playerid][Inv][i] = PlayerInfo[playerid][Inv][id_inv];                     PlayerInfo[playerid][Inv][id_inv] = 1649;                     SetRotInv(playerid, i, PlayerInfo[playerid][Inv][i];                     SetRotInv(playerid, id_td, PlayerInfo[playerid][Inv][id_inv];                     UpdateInv(playerid, id_inv, 1);                     UpdateInv(playerid, i, 1);                     SetPVarInt(playerid, "ClickInv", -1);                 }             }             else             {                 if(GetPVarInt(playerid, "ClickInv") == -1)                 {                     SetPVarInt(playerid, "ClickInv", i);                     UpdateInv(playerid, i, 2);                 }             }                 else                 {                     if(GetPVarInt(playerid, "ClickInv") == i)                     {                         SetPVarInt(playerid, "ClickInv", -1);                         UpdateInv(playerid, i, 1);                     }                 }         }     }     if(playertextid == InvText[playerid[4])     {         if(GetPVarInt(playerid, "ClickInv") != -1)         {         new id_inv = GetPVarInt(playerid, "ClickInv");         PlayerInfo[playerid][Inv][id_inv] = 1649;         PlayerTextDrawSetPriviewModel(playerid, inv_TD[playerid][id_inv], PlayerInfo[playerid][Inv][id_inv];         SetRotInv(playerid, id_inv, PlayerInfo[playerid][Inv][id_inv]);         UpdateInv(playerid, id_inv, 1);         SetPVarInt(playerid, "ClickInv", -1);         SendClientMessage(playerid, 0xFFFFFFF, "[Èíâåíòàðü]: Äàííûé ïðåäìåò áûë óñïåøíî óäàëåí!");     }     }      Помогите плиз,буду благодарен