search

levelsranks / levels-ranks-core

Statistics plugin for servers on the Source Engine
GNU General Public License v3.0
73 stars 39 forks source link

Error SQL_TransactionFailure - You have an error in your SQL syntax #65

Open crashzk opened 2 years ago

crashzk commented 2 years ago

I've been getting the following error in my logs:

L 12/13/2021 - 13:57:47: [levelsranks.smx] SQL_TransactionFailure (1): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE `SteamID` = 'STEAM_1:1:422490984'' at line 1 (1)
L 12/13/2021 - 14:27:52: Error log file session closed.
L 12/13/2021 - 14:27:58: SourceMod error session started
L 12/13/2021 - 14:27:58: Info (map "de_dust2") (file "/home/clientes/OGP_User_Files/whmcs/2975/csgo/addons/sourcemod/logs/errors_20211213.log")
L 12/13/2021 - 14:27:58: [levelsranks.smx] SQL_TransactionFailure (1): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE `SteamID` = 'STEAM_1:0:544956619'' at line 1 (1)
L 12/13/2021 - 15:20:33: Error log file session closed.

sm plugins list:

[SM] Listing 95 plugins:
  01 "Basic Comm Control" (1.10.0.6513) by AlliedModders LLC
  02 "NoBots Enforcer" (1.0) by Nikooo777
  03 "SourceBans++ Discord" (1.7.0-51) by Kotik. Fork of RumbleFrog, SourceBans++ Dev Team.
  04 "[SWGM] Command Listener" (1.2fix) by Someone, crashzk
  05 "eItems" (0.20.3) by ESK0
  06 "Fix Hint Color Messages" (1.2.2 Franc1sco franug github version) by Phoenix (˙·٠●Феникс●٠·˙)
  07 "SourceBans++ Report Plugin" (1.7.0) by RumbleFrog, SourceBans++ Dev Team
  08 "AFK Manager" (4.3.0) by Rothgar
  09 "SourceTV / GOTV Protector" (1.0) by CrazyHackGUT aka Kruzya
  10 "SourceBans++: SourceComms" (1.7.0) by Alex, SourceBans++ Dev Team
  11 "Fun Commands" (1.10.0.6513) by AlliedModders LLC
  12 "SourceBans++: SourceSleuth" (1.7.0) by ecca, SourceBans++ Dev Team
  13 "Admin File Reader" (1.10.0.6513) by AlliedModders LLC
  14 "Reserved Slots" (1.10.0.6513) by AlliedModders LLC
  15 "[Levels Ranks] Core" (v3.1.7 Beta 1) by RoadSide Romeo & Wend4r
  16 "Steam Works Group Manager" (1.9fix) by Someone, crashzk
  17 "TecnoHard GC Level" (1.0.9) by abnerfs
  18 "Admin Menu" (1.10.0.6513) by AlliedModders LLC
  19 "Dano Só Granadas" (1.5.1) by abnerfs
  20 "Fun Votes" (1.10.0.6513) by AlliedModders LLC
  21 "Nextmap" (1.10.0.6513) by AlliedModders LLC
  22 "Basic Chat" (1.10.0.6513) by AlliedModders LLC
  23 "Default SM Text Replacer" (1.0) by Bacardi & Mitch - Edited: Cruze
  24 "[ ZK Servidores™ ] Block Commands" (1.1) by Geison, crashzk
  25 "TecnoHard TeamSelect Kick" (2.0.4fix) by abnerfs
  26 "Simple Stealth" (1.0) by Potatoz
  27 <Failed> "CS:GO Disable Agent Models" (1.1) by SAZONISCHE, 8guawong
  28 "[CS:GO] Franug Agents Chooser" (1.2.0) by Franc1sco franug, Romeo, TrueProfessional, Teamkiller324
  29 "No Dupe Account" (1.5.0) by azalty
  30 "[Server-Redirect+] Core" (3.0.1) by Natanel 'LuqS'
  31 "Anti-Flood" (1.10.0.6513) by AlliedModders LLC
  32 "[ANY] Chat Responder" (1.3.4) by Headline
  33 "Discord API" (0.1.106) by Deathknife
  34 "Admin Help" (1.10.0.6513) by AlliedModders LLC
  35 "[Lilac] Little Anti-Cheat" (1.7.1) by J_Tanzanite
  36 "SourceBans++: Main Plugin" (1.7.0) by SourceBans Development Team, SourceBans++ Dev Team
  37 <Failed> "eItems" (0.10) by ESK0 (Original author: SM9)
  38 "SwapTeam" (1.2.6fix) by MistaGee, Rogue, crashzk
  39 "SourceBans++: Admin Config Loader" (1.7.0) by AlliedModders LLC, SourceBans++ Dev Team
  40 "TecnoHard No Ready Kicker" (1.4fix2) by abnerfs
  41 "[ ZK Servidores™ ] Help Menu" (1.0.4) by chundo, emsit, joinedsenses, crashzk, biielzk
  42 "[LR] Module - Unusual Kills" (v3.1.6 SR2) by Wend4r
  43 "[LR] Module - Overlays" (v3.1) by RoadSide Romeo
  44 "[LR] Module - TOP by KDR" (v3.1.5) by Wend4r
  45 "[LR] Module - ExStats Maps" (3.1 F1) by RoadSide Romeo
  46 <Failed> "[LR] Module - ExStats GeoIP" (v3.1) by RoadSide Romeo
  47 "[LR] Module - ExStats Hits" (v3.1) by Wend4r
  48 "[LR] Module - ExStats Weapons" (v3.1) by RoadSide Romeo & Wend4r
  49 "Simple Chat Processor (Redux)" (2.3.0fix) by Simple Plugins, Mini
  50 "Voice of Agents" (2.0) by Romeo
  51 "[ ZK Servidores™ ] High Ping Kicker" (1.1) by Dr. Api, crashzk
  52 "CSGO Advanced Drop" (1.3.1) by Phoenix (DropsSummoner), oppa, crashzk
  53 "[Lilac] Auto SourceTV Recorder" (1.2.0) by J_Tanzanite
  54 "[ ZK Servidores™ ] View all skins seeds on the console (!ws)" (1.0.0) by biielzk, crashzk
  55 "Cronjobs" (2.0) by dordnung
  56 "SM Franug Valve Sprays CSGO" (2.0) by Franc1sco franug, Romeo, crashzk
  57 "Fix Competitive Warmup" (1.1) by Ilusion9
  58 "REGEX word filter" (1.2) by Twilight Suzuka
  59 "[VIP] Core" (3.1 DEV) by R1KO
  60 "[ ZK Servidores™ ] Console Ads" (1.1) by biielzk, crashzk
  61 "Weapons & Knives" (1.7.5) by kgns | oyunhost.net
  62 "[BFG] WarMod | TecnoHard" (20.07.15.1214 + 4.2.9) by Versatile_BFG, abnerfs, crashzk
  63 "TecnoHard™ Plugins Block" (1.2) by AbNeR @CSB
  64 "Basic Info Triggers" (1.10.0.6513) by AlliedModders LLC
  65 "[Discord] Map Notifications" (1.0.1) by Bara
  66 "AntiDLL Handler" (1.7) by JDW
  67 "Basic Votes" (1.10.0.6513) by AlliedModders LLC
  68 "[CS:GO] Disable end match nextmap vote" (30.3.2021) by Bacardi
  69 "TecnoHard Chat Tags" (1.7.1) by abnerfs
  70 "[Redirect] Core" (1.0.1 Alpha) by Wend4r
  71 "Chat Logging" (3.0) by R1KO
  72 "Player Analytics" (1.4.2) by Dr. McKay / Bara / sneaK
  73 "[ ZK Servidores™ ] Valve Menu" (1.0) by Franc1sco franug, crashzk
  74 "SourceBans++: Bans Checker" (1.7.0) by psychonic, Ca$h Munny, SourceBans++ Dev Team
  75 "MapChooser Extended" (1.10.2) by Powerlord, Zuko, and AlliedModders LLC
  76 "Sound Commands" (1.10.0.6513) by AlliedModders LLC
  77 "Client Preferences" (1.10.0.6513) by AlliedModders LLC
  78 "[CS:GO] Weapon Stickers" (1.3) by quasemago and z1ntex
  79 "Player Commands" (1.10.0.6513) by AlliedModders LLC
  80 "Console Say" (1.0.1) by abnerfs
  81 "Gloves" (1.0.5) by kgns | oyunhost.net
  82 "[VIP] Additional [For VIP_CORE 3.0]" (1.0.1) by Drumanid
  83 "[VIP] Admin" (1.2) by R1KO
  84 "[VIP] FakeRank" (1.0.2) by TiNiK
  85 "[VIP] Skybox" (1.2) by White Wolf, sekac, Rimmer, crashzk
  86 "[VIP] COIN" (2.0.2) by Pheonix (˙·٠●Феникс●٠·˙) & R1KO, pracc
  87 "[VIP] Exp Multiplier" (1.0) by R1KO (skype: vova.andrienko1)
  88 "[VIP] Stats" (2.6) by R1KO 
  89 "[VIP] Music Kit" (1.1.4) by Pheonix, Felya, crashzk
  90 "ServerAdvertisements3" (3.1.5) by ESK, Romeo
  91 "Fix Disconnect Reason" (1.0.0) by FroidGaming.net
  92 "[CS:GO] sv_password - bypass players and reserved cookie check" (23.2.2021) by Bacardi
  93 "Auto Change Map" (1.4) by Mleczam, crashzk
  94 "Tebex SourceMod" (0.0.1) by Tebex
  95 "Basic Commands" (1.10.0.6513) by AlliedModders LLC
Errors:
disable_agent_models.smx (CS:GO Disable Agent Models): Required extension "modelch" file("modelch.ext") not running
eItems.smx (eItems): unexpected error 23 in AskPluginLoad callback
levels_ranks/levelsranks_exstats_geoip.smx ([LR] Module - ExStats GeoIP): Native "GeoipCity" was not found
Loginlag commented 1 year ago

How did you fix this error ? Сould you tell me please a solution