View Single Post
Old 11/12/2019, 05:48 PM   #8
UnknownGamer
Gangsta
 
UnknownGamer's Avatar
 
Join Date: Apr 2012
Location: 127.0.0.1
Posts: 516
Reputation: 37
Default Re: My server crash with mysql

Quote:
Originally Posted by MichaelScott View Post
If it helps, now it crashed from:
HTML Code:
[19:25:54] [debug] Server crashed while executing sang.amx
[19:25:54] [debug] AMX backtrace:
[19:25:54] [debug] #0 native mysql_format () in mysql_static.so
[19:25:54] [debug] #1 00254f34 in SaveVarzybos (playerid=0, 0, 0, 1143324020, 567, 289, 0, 0, 4, 6, ... <6317172 more arguments>) at lib/stocks.pwn:657
[19:25:54] [debug] #2 002f4ab4 in public PlayedMinute () at C:\Users\Aurimas\Desktop\SANG\gamemodes\sang.pwn:2391
The lines :
HTML Code:
657 : mysql_format(connectionHandle, SQLString, sizeof SQLString, "UPDATE `fishing_data` SET `fishesMoneyToday` = '%i' WHERE `belongs_to` = '%e'", PlayerDB[playerid][fishesMoneyToday], Vardas(playerid));
2391: if(PlayerDB[playerid][CantPlayBecouseOfBan] == true)
That version is way out-dated. Prefer, if possible, re-write to R41-4. We had this crash issue a lot with R39.
__________________
░ Ravens Roleplay [ MySQL ] [ YSI 4 ] [ Whirlpool ] [ SSCANF ] ░
░ Ravens RP Vehicle System 100% - Re-coded to Y_Iterators ░
░ Ravens RP MySQL - 100% BlueG R41-4 ░
░ Ravens RP STRCMP to Y_Commands - 100% ░
░ Ravens RP Dealership Systems Re-Done 100% to Dynamic Vehicles ░
░ Ravens RP AntiCheat - 100% Redone with FCLEO ░

░ Library's Used: Y_Iterate, Y_Inline, Y_Timers, Y_Commands, Y_Master, Y_Dialog, Y_Groups, Y_Hooks, Y_Utils, Y_VehicleData, Y_Va, BlueG MySQL R41-4, FCLEO, OPVD, SSCANF2, Progress2, EVF, [MV] Youtube, Whirlpool ░
UnknownGamer is offline   Reply With Quote