{"action":"created","issue":{"url":"https://api.github.com/repos/Bara/TroubleinTerroristTown/issues/316","repository_url":"https://api.github.com/repos/Bara/TroubleinTerroristTown","labels_url":"https://api.github.com/repos/Bara/TroubleinTerroristTown/issues/316/labels{/name}","comments_url":"https://api.github.com/repos/Bara/TroubleinTerroristTown/issues/316/comments","events_url":"https://api.github.com/repos/Bara/TroubleinTerroristTown/issues/316/events","html_url":"https://github.com/Bara/TroubleinTerroristTown/issues/316","id":319366727,"number":316,"title":"SQL Error in Error Logs","user":{"login":"jljr222","id":3527321,"avatar_url":"https://avatars3.githubusercontent.com/u/3527321?v=4","gravatar_id":"","url":"https://api.github.com/users/jljr222","html_url":"https://github.com/jljr222","followers_url":"https://api.github.com/users/jljr222/followers","following_url":"https://api.github.com/users/jljr222/following{/other_user}","gists_url":"https://api.github.com/users/jljr222/gists{/gist_id}","starred_url":"https://api.github.com/users/jljr222/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jljr222/subscriptions","organizations_url":"https://api.github.com/users/jljr222/orgs","repos_url":"https://api.github.com/users/jljr222/repos","events_url":"https://api.github.com/users/jljr222/events{/privacy}","received_events_url":"https://api.github.com/users/jljr222/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-05-01T23:55:35Z","updated_at":"2018-05-02T08:27:03Z","closed_at":null,"author_association":"NONE","body":"> L 05/01/2018 - 05:55:41: [ttt_shop.smx] (SQL_AlterCreditsColumn) Query failed: duplicate column name: credits\r\n\r\nHere's is a list what we need:\r\n- Version of MetaMod: 1.10.7-dev\r\n- Version of SourceMod: 1.9.0.6226\r\n- List of your extensions:\r\n```\r\n[01] Automatic Updater (1.9.0.6226): Updates SourceMod gamedata files\r\n[02] Webternet (1.9.0.6226): Extension for interacting with URLs\r\n[03] Accelerator (2.3.2): SRCDS Crash Handler\r\n[04] cURL Extension (1.3.0.0): cURL Extension\r\n[05] CS Tools (1.9.0.6226): CS extended functionality\r\n[06] BinTools (1.9.0.6226): Low-level C/C++ Calling API\r\n[07] SDK Tools (1.9.0.6226): Source SDK Tools\r\n[08] Client Preferences (1.9.0.6226): Saves client preference settings\r\n[09] MySQL-DBI (1.9.0.6226): MySQL driver implementation for DBI\r\n[10] DHooks (2.0.6): Dynamic Hooks\r\n[11] SDK Hooks (1.9.0.6226): Source SDK Hooks\r\n[12] SteamWorks Extension (1.2.2): Exposes SteamWorks functions to Developers\r\n[13] GeoIP (1.9.0.6226): Geographical IP information\r\n[14] Regex (1.9.0.6226): Provides regex natives for plugins\r\n[15] Top Menus (1.9.0.6226): Creates sorted nested menus\r\n[16] <OPTIONAL> file \"steamtools.ext.so\": csgo/addons/sourcemod/extensions/steamtools.ext.so: cannot open shared object file: No such file or directory\r\n[17] Socket (3.0.1): Socket extension for SourceMod\r\n[18] SQLite (1.9.0.6226): SQLite Driver\r\n```\r\n- Version of TTT: 2.1588\r\n- List of your plugins:\r\n```\r\n  01 \"SourceBans++: SourceSleuth\" (1.6.3) by ecca, SourceBans++ Dev Team\r\n  02 \"Advanced Parachute\" (1.0) by ESK0\r\n  03 \"BSP ConVar Allower\" (0.1) by SHUFEN from POSSESSION.tokyo\r\n  04 \"TOGs Rank Glows\" (1.2.0) by That One Guy\r\n  05 \"Custom Player Skins (Core)\" (1.4) by Mitchell, Root\r\n  06 \"Server Clean Up _Xnet CS:GO\" (1.2.2) by Jamster\r\n  07 \"ServerAdvertisements3\" (3.1.3) by ESK0\r\n  08 \"Admin File Reader\" (1.9.0.6226) by AlliedModders LLC\r\n  09 \"The Void\" (0.4) by SM9 (xCoderx) - FragDeluxe.com\r\n  10 \"Admin Help\" (1.9.0.6226) by AlliedModders LLC\r\n  11 \"Admin Menu\" (1.9.0.6226) by AlliedModders LLC\r\n  12 \"Voice Hud\" (1.7) by Agent Wesker\r\n  13 \"Anti-Flood\" (1.9.0.6226) by AlliedModders LLC\r\n  14 \"[CSGO] Advanced Admin\" (1.6.3) by PeEzZ\r\n  15 \"[CSGO] Advanced Admin\" (1.6.4) by PeEzZ\r\n  16 \"TOG's Connect Messages\" (5.6.2) by That One Guy\r\n  17 \"Auto Change Map If Server Emty\" (1.0) by Tomasz 'anacron' Motylinski\r\n  18 \"Trouble in Terrorist Town - Icons\" (2.1588) by TTT-Contributors\r\n  19 \"Trouble in Terrorist Town\" (2.1588) by TTT-Contributors\r\n  20 \"CS:GO particle auto-precacher\" (1.2.4) by Copypaste Slim\r\n  21 \"Trouble in Terrorist Town - TA-Grenade\" (2.1588) by Bara, zipcore & Neuro Toxin\r\n  22 \"Basic Chat\" (1.9.0.6226) by AlliedModders LLC\r\n  23 \"Trouble in Terrorist Town - Items: Taser\" (2.1588) by TTT-Contributors\r\n  24 \"Basic Comm Control\" (1.9.0.6226) by AlliedModders LLC\r\n  25 \"CowAntiCheat\" (1.16) by CodingCow\r\n  26 \"Basic Commands\" (1.9.0.6226) by AlliedModders LLC\r\n  27 \"VoiceAnnounceEx\" (2.1.2) by Franc1sco franug, Mini and GoD-Tony\r\n  28 \"Basic Info Triggers\" (1.9.0.6226) by AlliedModders LLC\r\n  29 \"Basic Votes\" (1.9.0.6226) by AlliedModders LLC\r\n  30 \"Self-Mute Intelligence\" (1.5.2) by IT-KiLLER and (Otokiru, edit 93x, Accelerator)\r\n  31 \"Block messages\" (1.0.0) by Bara\r\n  32 \"Trouble in Terrorist Town - Parachute\" (2.1543) by TTT-Contributors\r\n  33 \"CallAdmin\" (0.1.5) by Impact, Popoklopsi\r\n  34 \"Trouble in Terrorist Town - Items: ID\" (2.1588) by TTT-Contributors\r\n  35 \"TTT Statistics\" (1.0.0) by Keith Warren (Shaders Allen)\r\n  36 \"Trouble in Terrorist Town - Hud\" (2.1588) by TTT-Contributors\r\n  37 \"Client Preferences\" (1.9.0.6226) by AlliedModders LLC\r\n  38 \"Trouble in Terrorist Town - Knockout\" (2.1588) by TTT-Contributors\r\n  39 \"Trouble in Terrorist Town - Items: Random Teleporter\" (2.1588) by TTT-Contributors\r\n  40 \"Trouble in Terrorist Town - Teleporter\" (2.1588) by TTT-Contributors\r\n  41 \"Discord API\" (1.0) by .#Zipcore, Credits: Shavit, bara, ImACow and Phire\r\n  42 \"Trouble in Terrorist Town - Items: Martydom\" (2.1588) by TTT-Contributors\r\n  43 \"Discord: CallAdmin\" (1.1) by .#Zipcore\r\n  44 \"Trouble in Terrorist Town - Models\" (2.1588) by Bara\r\n  45 \"Discord: SourceBans\" (1.0) by .#Zipcore\r\n  46 \"Sound Commands\" (1.9.0.6226) by AlliedModders LLC\r\n  47 \"Discord: SourceComms\" (1.1) by .#Zipcore\r\n  48 \"Trouble in Terrorist Town - Poison Smoke\" (2.1588) by TTT-Contributors\r\n  49 \"Easy Web Shortcuts\" (1.00) by Invex | Byte\r\n  50 \"Trouble in Terrorist Town - Radar\" (2.1588) by TTT-Contributors\r\n  51 \"Force Map End\" (1.1) by Zipcore, 1NutWunDeR\r\n  52 \"Trouble in Terrorist Town - Radio\" (2.1588) by TTT-Contributors\r\n  53 \"Fun Commands\" (1.9.0.6226) by AlliedModders LLC\r\n  54 \"Trouble in Terrorist Town - Tracer\" (2.1588) by bbs.93x.net & zipcore\r\n  55 \"Fun Votes\" (1.9.0.6226) by AlliedModders LLC\r\n  56 \"Weapon Clean up\" (1.0) by CS:GO Port Team\r\n  57 \"Futuristic Grenades v1.3.2\" (1.3.4) by Rachnus\r\n  58 \"TOGs Chat Tags\" (4.10.1) by That One Guy\r\n  59 \"Game_Player_Equip Fix\" (1.1.1) by Mitch\r\n  60 \"MapChooser Extended\" (1.10.2) by Powerlord, Zuko, and AlliedModders LLC\r\n  61 \"SourceBans++: SourceComms\" (1.6.3) by Alex, SourceBans++ Dev Team\r\n  62 \"Mapchooser Extended Sounds\" (1.10.3) by Powerlord\r\n  63 \"Trouble in Terrorist Town - Round End Sounds\" (2.1588) by Bara (& AbNeR_CSS)\r\n  64 \"Nav Cycler\" (1.0) by MasterOfTheXP\r\n  65 \"Trouble in Terrorist Town - Traitor Doors\" (2.1588) by zipcore\r\n  66 \"Nextmap\" (1.9.0.6226) by AlliedModders LLC\r\n  67 \"Trouble in Terrorist Town - Shop\" (2.1588) by TTT-Contributors\r\n  68 \"No Weapon Fix\" (3.2) by .#Zipcore\r\n  69 \"Map Nominations Extended\" (1.10.0) by Powerlord and AlliedModders LLC\r\n  70 \"Trouble in Terrorist Town - Shop Discounts\" (2.1588) by TTT-Contributors\r\n  71 \"Player Commands\" (1.9.0.6226) by AlliedModders LLC\r\n  72 \"Trouble in Terrorist Town - Silent AWP\" (2.1588) by TTT-Contributors\r\n  73 \"Radio Spam Block\" (1.0.1csgofix) by exvel,TonyBaretta\r\n  74 \"Server Redirect: Ask connect in chat\" (0.2.5) by H3bus\r\n  75 \"SourceBans++: Main Plugin\" (1.6.3) by SourceBans Development Team, SourceBans++ Dev Team\r\n  76 \"Server Redirect: Ask connect in console\" (0.2.5) by H3bus\r\n  77 \"Trouble in Terrorist Town - Spec Menu\" (2.1588) by TTT-Contributors\r\n  78 \"Reserved Slots\" (1.9.0.6226) by AlliedModders LLC\r\n  79 \"Rock The Vote Extended\" (1.10.0) by Powerlord and AlliedModders LLC\r\n  80 \"Trouble in Terrorist Town - Sprint\" (2.1584) by TTT-Contributors\r\n  81 \"SourceBans++: Admin Config Loader\" (1.6.3) by AlliedModders LLC, SourceBans++ Dev Team\r\n  82 \"Trouble in Terrorist Town - SQL Manager\" (2.1588) by TTT-Contributors\r\n  83 \"SourceBans++: Bans Checker\" (1.6.3) by psychonic, Ca$h Munny, SourceBans++ Dev Team\r\n  84 \"Auto File Loader\" (1.0.3) by Keith Warren (Drixevel)\r\n  85 \"Trouble in Terrorist Town - Items: Fake Body\" (2.1588) by TTT-Contributors\r\n  86 \"Trouble in Terrorist Town - Items: Healthshot\" (2.1588) by TTT-Contributors\r\n  87 \"Trouble in Terrorist Town - Items: Ice Knife\" (2.1588) by TTT-Contributors\r\n  88 \"Trouble in Terrorist Town - Health/Hurt Stations\" (2.1588) by TTT-Contributors\r\n  89 \"Updater\" (1.3.0) by GoD-Tony (Updated by jballou)\r\n  90 \"Trouble in Terrorist Town - Glow\" (2.1584) by Bara & zipcore\r\n  91 \"Trouble in Terrorist Town - Grabber Mod\" (2.1588) by TTT-Contributors\r\n  92 \"Trouble in Terrorist Town - Hide Radar\" (2.1588) by TTT-Contributors\r\n  93 \"Trouble in Terrorist Town - Overlays\" (2.1588) by TTT-Contributors\r\n  94 \"Server Redirect\" (0.2.6) by H3bus\r\n  95 \"[CS:GO] Damage Text\" (1.2) by Kento, Kxnrl, IT-KiLLER\r\n  96 \"Trouble in Terrorist Town - Talk Override\" (2.1588) by TTT-Contributors\r\n  97 \"Trouble in Terrorist Town - Items: Wallhack\" (2.1588) by TTT-Contributors\r\n  98 \"Trouble in Terrorist Town - Items: Weapons\" (2.1588) by TTT-Contributors\r\n  99 \"Trouble in Terrorist Town - Blackout\" (2.1588) by TTT-Contributors\r\n  100 \"Trouble in Terrorist Town - Buy Roles\" (2.1588) by TTT-Contributors\r\n  101 \"Trouble in Terrorist Town - C4 & Jihad\" (2.1588) by TTT-Contributors\r\n  102 \"Trouble in Terrorist Town - Crash Catcher\" (2.1588) by TTT-Contributors\r\n  103 \"Trouble in Terrorist Town - Decoy Body\" (2.1588) by TTT-Contributors\r\n  104 \"Trouble in Terrorist Town - Items: Decoy Teleporter\" (2.1588) by TTT-Contributors\r\n  105 \"Trouble in Terrorist Town - Dna Scanner\" (2.1588) by TTT-Contributors\r\n  106 \"SourceBans++ Report Plugin\" (1.6.3) by RumbleFrog, SourceBans++ Dev Team\r\n  107 \"[TTT] Punishments\" (1.0.0) by Keith Warren (Shaders Allen)\r\n  108 \"[ANY] VGUI URL Cache Buster\" (3.1.2) by nosoop (and various bits from Invex | Byte, Boomix)\r\n  109 \"Flashlight\" (1.3.63) by Mitch\r\n```"},"comment":{"url":"https://api.github.com/repos/Bara/TroubleinTerroristTown/issues/comments/385902303","html_url":"https://github.com/Bara/TroubleinTerroristTown/issues/316#issuecomment-385902303","issue_url":"https://api.github.com/repos/Bara/TroubleinTerroristTown/issues/316","id":385902303,"user":{"login":"Bara","id":17928280,"avatar_url":"https://avatars1.githubusercontent.com/u/17928280?v=4","gravatar_id":"","url":"https://api.github.com/users/Bara","html_url":"https://github.com/Bara","followers_url":"https://api.github.com/users/Bara/followers","following_url":"https://api.github.com/users/Bara/following{/other_user}","gists_url":"https://api.github.com/users/Bara/gists{/gist_id}","starred_url":"https://api.github.com/users/Bara/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Bara/subscriptions","organizations_url":"https://api.github.com/users/Bara/orgs","repos_url":"https://api.github.com/users/Bara/repos","events_url":"https://api.github.com/users/Bara/events{/privacy}","received_events_url":"https://api.github.com/users/Bara/received_events","type":"User","site_admin":false},"created_at":"2018-05-02T08:27:03Z","updated_at":"2018-05-02T08:27:03Z","author_association":"OWNER","body":"Which mysql version do you have? I can't reproduce this with 10.1.29-MariaDB but i could update thequery like this one:\r\n`SET @shopCredits = (SELECT IF(\r\n    (SELECT COUNT(*)\r\n        FROM INFORMATION_SCHEMA.COLUMNS\r\n        WHERE table_name = 'ttt'\r\n        AND table_schema = DATABASE()\r\n        AND column_name = 'credits'\r\n    ) > 0,\r\n    \"SELECT 1\",\r\n    \"ALTER TABLE ttt ADD COLUMN `credits` INT(11) NOT NULL DEFAULT 0\"\r\n));\r\n\r\nPREPARE shopStatement FROM @shopCredits;\r\nEXECUTE shopStatement;\r\nDEALLOCATE PREPARE shopStatement;`"}}
{"actor":{"display_login":"Bara"}}