search

peace-maker / smrpg

A generic RPG plugin for SourceMod
87 stars 39 forks source link

[BUG] sm_effects & sm_rpg #303

Closed crashzk closed 5 years ago

crashzk commented 5 years ago

I am with the latest versions of SourceMod & Metamod.

SourceMod: 1.9 - build 6261 - Linux
Metamod: 1.10 - build 966 - Linux

And with them began to appear some errors in the logs of my servers.

L 12/04/2018 - 10:02:36: [SM] Exception reported: Handle a3081188 is invalid (error 1)
L 12/04/2018 - 10:02:36: [SM] Blaming: smrpg_effects.smx
L 12/04/2018 - 10:02:36: [SM] Call stack trace:
L 12/04/2018 - 10:02:36: [SM]   [0] CloseHandle
L 12/04/2018 - 10:02:36: [SM]   [1] Line 248, /home/travis/build/peace-maker/smrpg/build/addons/sourcemod/scripting/include/smlib/general.inc::ClearHandle
L 12/04/2018 - 10:02:36: [SM]   [2] Line 39, smrpg_effects/ignite.sp::ResetIgniteClient
L 12/04/2018 - 10:02:36: [SM]   [3] Line 107, smrpg_effects.sp::Event_OnPlayerDeath

L 12/04/2018 - 10:04:41: [smrpg.smx] Error executing query 4 of 14 queries: Incorrect string value: '\xF0\x9F\x92\x80JK...' for column 'name' at row 1

The complete error log is attached: errors_20181204.log

Here is the list of server plugins:

[SM] Listing 147 plugins:
  01 "[Store] NoScope Credits" (1.2) by Cruze
  02 "csgotokens.com token changer" (1.5.0) by Adi - live4net
  03 "Player-Teleport by Dr. HyperKiLLeR" (1.2.1) by Dr. HyperKiLLeR
  04 "SM:RPG" (1.0-custom) by Jannik "Peace-Maker" Hartung, SeLfkiLL
  05 "Store - Trade System" (1.0) by Zephyrus
  06 "SM Franug CS:GO Stat Trak" (ZK Servidores v1.4.1) by Franc1sco franug
  07 "Dice SM" (1.7) by Popoklopsi edit Cruze
  08 "Player Respawn" (1.6) by Rogue
  09 "OVERWATCH:Buttons" (1.0) by Potatoz
  10 "SourceBans++: Main Plugin" (1.6.3_abner_2) by SourceBans Development Team, SourceBans++ Dev Team, AbNeR_CSS
  11 "SourceTV / GOTV Protector" (1.0) by CrazyHackGUT aka Kruzya
  12 "AFK Manager" (4.3.0) by Rothgar
  13 "Fun Votes" (1.9.0.6252) by AlliedModders LLC
  14 "SM Franug CS:GO NameTag" (ZK Servidores v2.0) by Franc1sco franug
  15 "[CSS/CS:GO] AbNeR ResetScore" (1.5fix) by AbNeR_CSS
  16 "CS:GO Movement Unlocker" (1.0) by Peace-Maker
  17 "[ ZK Servidores ] - Block Commands" (1.0) by crashzk
  18 "SourceBans++: Admin Config Loader" (1.6.3) by AlliedModders LLC, SourceBans++ Dev Team
  19 "Smart URL Remover" (1.6.2) by Totenfluch [Fix by Agent Wesker]
  20 "Basic Chat" (1.9.0.6252) by AlliedModders LLC
  21 "Paintball" (1.2.0) by otstrel.ru Team
  22 "SM:RPG > Effect Hub" (1.0-534) by Peace-Maker
  23 "SM Franug Valve Sprays" (1.5.3) by Franc1sco Steam: franug
  24 "[CS:GO/CSS] TecnoHard™ Clan Stats" (2.0) by MMYTH e AbNeR @CSB
  25 "MyJailbreak - Core" (Beta 14.0-58f4b42) by shanapu
  26 "[CSGO] Restart Round" (1.1) by NiGhT_CSGO - Edited: SaBaToN, crashzk e biielzk
  27 "SM Jailed Reasons" (v1.0) by Franc1sco steam: franug
  28 "SourceBans++: Bans Checker" (1.6.3) by psychonic, Ca$h Munny, SourceBans++ Dev Team
  29 "SM Franug Name Reward" (1.0) by Franc1sco franug
  30 "SM:RPG > Command List" (1.0-534) by Jannik "Peace-Maker" Hartung
  31 "Basic Comm Control" (1.9.0.6252) by AlliedModders LLC
  32 "SourceBans++: SourceSleuth" (1.6.3) by ecca, SourceBans++ Dev Team
  33 "TecnoHard™ Freeday" (1.3fix) by AbNeR @CSB
  34 "SM Franug Auras with particles" (1.0) by Franc1sco franug
  35 "TecnoHard™ Lasers" (1.2_tecnohard2018) by AbNeR @CSB
  36 "TecnoHard™ Dedurar" (1.0) by AbNeR @CSB - Edited: biielzk, crashzk
  37 "SM:RPG > Counter-Strike Experience Module" (1.0-534) by Jannik "Peace-Maker" Hartung, SeLfkiLL
  38 "OVERWATCH:Chat" (1.0) by Potatoz
  39 "Simple Chat Processor (Redux)" (2.1.0) by Simple Plugins, Mini
  40 "SourceBans++ Report Plugin" (1.6.3) by RumbleFrog, SourceBans++ Dev Team
  41 "VAC Status Checker" (2.2.0) by Stevo.TVR
  42 "Basic Votes" (1.9.0.6252) by AlliedModders LLC
  43 "CS:GO GiveNamedItem Hook Franug Edition" (6.1 private version) by Franc1sco franug and Neuro Toxin
  44 "Throwing Knives" (23-3-2016) by original by meng, Bacardi, Franc1sco franug
  45 "ServerAdvertisements3" (3.1.3) by ESK0
  46 "SM:RPG > Credit Gifting" (1.0-534) by Peace-Maker
  47 "SM:RPG Upgrade > Reduced Gravity" (1.0-534) by Jannik "Peace-Maker" Hartung
  48 "SM:RPG Upgrade > Adrenaline" (1.0-534) by Peace-Maker
  49 "SM:RPG Upgrade > Fire Grenade" (1.0-534) by Jannik "Peace-Maker" Hartung
  50 "SM:RPG Upgrade > Frost Pistol" (1.0-534) by Jannik "Peace-Maker" Hartung
  51 "SM:RPG Upgrade > Health regeneration" (1.0-534) by Jannik "Peace-Maker" Hartung
  52 "SM:RPG Upgrade > Medic" (1.0-534) by Jannik "Peace-Maker" Hartung
  53 "SM:RPG Upgrade > Increase Clipsize" (1.0-534) by Peace-Maker
  54 "SM:RPG Upgrade > Impulse" (1.0-534) by Jannik "Peace-Maker" Hartung
  55 "SM:RPG Upgrade > Firerate" (1.0-534) by Peace-Maker
  56 "SM:RPG Upgrade > Armor+" (1.0-534) by Jannik "Peace-Maker" Hartung
  57 "SM:RPG Upgrade > Ice Stab" (1.0-534) by Jannik "Peace-Maker" Hartung
  58 "SM:RPG Upgrade > Vampire" (1.0-534) by Jannik "Peace-Maker" Hartung
  59 "SM:RPG Upgrade > Reduced Fall Damage" (1.0-534) by Peace-Maker
  60 "SM:RPG Upgrade > Denial" (1.0-534) by Jannik "Peace-Maker" Hartung
  61 "SM:RPG Upgrade > Ice Grenade" (1.0-534) by Peace-Maker
  62 "SM:RPG Upgrade > Fast Reload" (1.0-534) by Peace-Maker
  63 "SM:RPG Upgrade > Armor regeneration" (1.0-534) by Jannik "Peace-Maker" Hartung
  64 "SM:RPG Upgrade > Health+" (1.0-534) by Jannik "Peace-Maker" Hartung
  65 "SM:RPG Upgrade > Speed+" (1.0-534) by Jannik "Peace-Maker" Hartung
  66 "SM:RPG Upgrade > Antidote" (1.0-534) by Peace-Maker
  67 "SM:RPG Upgrade > Stealth" (1.0-534) by Jannik "Peace-Maker" Hartung
  68 "SM:RPG Upgrade > Bouncy Bullets" (1.0-534) by Peace-Maker
  69 "SM:RPG Upgrade > Resupply" (1.0-534) by Jannik "Peace-Maker" Hartung
  70 "SM:RPG Upgrade > Antiflash" (1.0-534) by Peace-Maker
  71 "SM:RPG Upgrade > Damage+" (1.0-534) by Jannik "Peace-Maker" Hartung
  72 "SM:RPG Upgrade > Fire Pistol" (1.0-534) by Jannik "Peace-Maker" Hartung
  73 "SM:RPG Upgrade > Grenade Resupply" (1.0-534) by Jannik "Peace-Maker" Hartung
  74 "SM:RPG Upgrade > Armor Helmet" (1.0-534) by Peace-Maker
  75 "SM:RPG Upgrade > Long Jump" (1.0-534) by Jannik "Peace-Maker" Hartung
  76 "SM Valve Gloves" (3.0) by Franc1sco franug and hadesownage
  77 "[CS:GO] Fake Competitive Ranks/Coins/Profile" (1.5.2) by By: Laam4 - Edited: crashzk
  78 "Map Nominations Extended" (1.10.0) by Powerlord and AlliedModders LLC
  79 "Basic Info Triggers" (1.9.0.6252) by AlliedModders LLC
  80 "TecnoHard™ Motd" (1.1) by AbNeR @CSB
  81 "TecnoHard Chat Tags" (1.5.3) by AbNeR @CSB
  82 "OVERWATCH:Death" (1.0) by Potatoz
  83 "SM CS:GO Weapon Paints" (ZK Servidores v6.9) by Franc1sco franug
  84 "SM CS:GO Franug Knives" (ZK Servidores 4.0) by Franc1sco franug
  85 "Limit Ban Duration" (1.0.2_abner_2) by Twisted|Panda, AbNeR_CSS
  86 "Store - The Resurrection" (1.1) by Zephyrus
  87 "[CS:S/CS:GO] No Fall Damage" (1.0) by alexip121093 & Neoxx
  88 "LR - Flying knife fight" (1.0) by KeidaS and Franc1sco franug
  89 "Laser Letters" (1.1) by Franc1sco steam: franug
  90 "Last Request: Throwingknives battle" (1.0.1) by Franc1sco franug
  91 "SM Franug Wings" (3.3.2) by Franc1sco franug - Edited: crashzk e biielzk
  92 "SM Franug Hats" (3.3.2) by Franc1sco franug
  93 "Anti-Flood" (1.9.0.6252) by AlliedModders LLC
  94 "Player Commands" (1.9.0.6252) by AlliedModders LLC
  95 "SwapTeam" (1.2.6) by Rogue - Originally by MistaGee
  96 "[ ZK Servidores ] - Block Tag Grupos" (1.0) by crashzk
  97 "SM:RPG > Ban players" (1.0-534) by Peace-Maker
  98 "CSGO Items" (1.5.0) by SM9
  99 "Ragdoll Modifications" (1.2.4) by Twisted|Panda
  100 "ENT_Hosties(v2.3)" (Entity) by databomb & Entity
  101 "SourceBans++ Discord Plugin" (1.1.0) by RumbleFrog, SourceBans++ Dev Team
  102 "Fun Commands" (1.9.0.6252) by AlliedModders LLC
  103 "fix_knives.smx"
  104 "Music Kits" (1.0.0) by Bara
  105 "SM:RPG > Disable experience" (1.0-534) by Jannik "Peace-Maker" Hartung
  106 "SM Wear option for Weapon Paints" (1.0.1 private version) by Franc1sco franug
  107 "REGEX word filter" (1.2) by Twilight Suzuka
  108 "Bad name kick / ban" (1.0.0) by 2NASTY4U
  109 "SourceBans++: SourceComms" (1.6.3) by Alex, SourceBans++ Dev Team
  110 "TecnoHard™ Xerife" (1.10_fix) by AbNeR @CSB
  111 "[ ZK SERVIDORES ] - SM:RPG XP FLAG" (1.0) by Jannik, Peace-Maker, Hartung, biielzk
  112 "SM:RPG > Turbo Mode" (1.0-custom) by Jannik "Peace-Maker" Hartung
  113 "[ANY] Gifts" (2.3) by Zephyrus
  114 "Thirdperson | Mirrow Mode" (1.11) by Zephyrus
  115 "SM Franug Trails with particles" (1.0) by Franc1sco franug
  116 "CSGOItems Item Log" (0.1) by SM9
  117 "Basic Commands" (1.9.0.6252) by AlliedModders LLC
  118 "OVERWATCH:Nades" (1.0) by Potatoz
  119 "MapChooser Extended" (1.10.2) by Powerlord, Zuko, and AlliedModders LLC
  120 "Updater" (1.2.2) by GoD-Tony
  121 "RankMe" (3.0.3.Kento.29.2) by lok1, Scooby, Kento, pracc, Kxnrl, CrazyHackGUT
  122 "VoiceAnnounceEx" (2.1.2) by Franc1sco franug, Mini and GoD-Tony
  123 "CT Ban - Max Bans" (1.0.0) by databomb
  124 "Client Execute" (1.0.3) by dubbeh
  125 "Skybox" (1.01) by Deathknife
  126 "Parachute for Zephyrus Store" (1.2) by shanapu
  127 "TeamChange Unlimited" (1.2.2) by Sheepdude
  128 "Nextmap" (1.9.0.6252) by AlliedModders LLC
  129 "SM Access By Steam Group" (1.3) by Franc1sco franug
  130 "[Any] Deluxe Godmode" (2.3.2) by DarthNinja
  131 "Sound Commands" (1.9.0.6252) by AlliedModders LLC
  132 "SM First Person View Models Interface" (3.1) by Franc1sco franug
  133 "Last-Request: LEADERBOARD" (1.0) by IT-KiLLER
  134 "DR.API SHOW DAMAGE" (1.1.5) by Dr. Api
  135 "Rock The Vote Extended" (1.10.0) by Powerlord and AlliedModders LLC
  136 "Admin Help" (1.9.0.6252) by AlliedModders LLC
  137 "Admin File Reader" (1.9.0.6252) by AlliedModders LLC
  138 "DR.API HIGH PING KICKER" (1.0.2) by Dr. Api
  139 "CT Ban" (2.0.3) by databomb
  140 "SM FPVMI - Custom Weapons Menu" (3.1) by Franc1sco franug
  141 "SM:RPG > Reset interval" (1.0-534) by Jannik "Peace-Maker" Hartung
  142 "[CS:GO/CSS] AbNeR Round End Sounds" (3.6.2) by AbNeR_CSS
  143 "Give Weapon" (2.0) by Author: Kiske - Edited: crashzk & biielzk
  144 "Client Preferences" (1.9.0.6252) by AlliedModders LLC
  145 "Admin Menu" (1.9.0.6252) by AlliedModders LLC
  146 "TecnoHard™ Rendição" (1.2) by AbNeR @CSB
  147 "TecnoHard™ Plugins Block" (1.2) by AbNeR @CSB
crashzk commented 5 years ago

I would have other issues with one of the same problem: #302

peace-maker commented 5 years ago

The first error is already tracked in the other issue as you noticed. Please don't open duplicate issues and don't combine multiple things into one issue. It's hard to keep track when I can close the issue.

The SQL error is related to the charset of your tables and your sourcemod version. SourceMod 1.10 updated the mysql client libraries which add support for the charset required to store those 4-byte characters. So update SourceMod. Make sure your tables use the utf8mb4 charset as well (smrpg should have converted them correctly, but just make sure).