• 0
Koto_Kudo

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

Asked by Koto_Kudo ,

Question

Posted · Report post

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

 

 

0

Share this post

Link to post
Share on other sites
Лучший ответ

Опубликовал Koto_Kudo ,Posted

@MrGerst дело оказалось не в этом Нашел решение.
В базе - SQL -
SET @@GLOBAL.sql_mode= '';
SET @@SESSION.sql_mode= '';
(РАБОТАЕТ ТОЛЬКО ЕСЛИ ВЫ ГРАНД ЮЗЕР БАЗЫ [ГЛАВНЫЙ АДМИН] )
0
рейтинг
Перейти к сообщению

6 answers to this question

  • 0

TS Posted · Report post

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

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

0

Share this post

Link to post
Share on other sites
  • 0

TS Posted · Report post

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

0

Share this post

Link to post
Share on other sites
  • 0

Posted · Report post

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

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

 

0

Share this post

Link to post
Share on other sites
  • 0

TS Posted · Report post

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

0

Share this post

Link to post
Share on other sites
  • 0

Posted · Report post

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

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

 

0

Share this post

Link to post
Share on other sites
  • 0

Posted · Report post

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

0

Share this post

Link to post
Share on other sites
Guest
This topic is now closed to further replies.
Go To Question Listing Запуск серверов

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • Nik_Rofid
      Автомобильные номера
      By Nik_Rofid
      Здравствуйте, можно ли на сервере копии радмира сделать так, что бы на машину можно было установить конкретный номер например ставится на машу рандом номер а будет х777хх77
    • Fazovskiy_
      Помощь со сменой заработных плат на сервере
      By Fazovskiy_
      Приветствую хочу открыть данный мод дабы играть с друзьями сейчас столкнулся с проблемой при работе на подработках не выдается зарплата в копейках полазив в моде и бд нашёл из полезного только данную строку в моде 6574 или же give_kop(playerid,GetPVarInt(playerid,"JobY") ниже прикреплю файлы бд и мода и дам ссылку на целый мод для пробного запуска заранее спасибо за помощь (бд переименуйте на sql) ссылка на полный мод https://pawno-rus.ru/files/file/606-crmp-03e-akcent-rp-nastoyaschiy-mod-ckidka/?do=download&r=5201&confirm=1&t=1&csrfKey=23a7ad9fa7faeeae0f35a0a1c124d53d
      USSR.pwn
      BD.txt