Natanel-Shitrit / Server-Redirect-Plus

'Server-Redirect+' is an interactive, auto-updated Server-List that can contain all of your CS:GO game servers.
https://forums.alliedmods.net/showthread.php?t=322904
GNU General Public License v3.0
6 stars 3 forks source link

DEV branch version does not work #8

Closed crashzk closed 3 years ago

crashzk commented 3 years ago

I'm using the dev branch version, and it's getting the following error:

ServerRedirectCore.smx ([Server-Redirect+] Core): Something is wrong with the Database, Error in T_OnServerSearchReceived: Unknown column 'steam_id' in 'field list'

sm plugins list:

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

Database I created a new one, from scratch and nothing.

When I use the !servers command inside the server nothing happens.

sm exts list:

[SM] Displaying 25 extensions:
[01] Automatic Updater (1.10.0.6502): Updates SourceMod gamedata files
[02] Webternet (1.10.0.6502): Extension for interacting with URLs
[03] Lobby Session Fixer (1.0.2): Fixes error when player is having an invalid session
[04] BanId Fix (1.0): Correcting 'Ghost players' error
[05] SDK Tools (1.10.0.6502): Source SDK Tools
[06] BinTools (1.10.0.6502): Low-level C/C++ Calling API
[07] CS Tools (1.10.0.6502): CS extended functionality
[08] Regex (1.10.0.6502): Provides regex natives for plugins
[09] Client Preferences (1.10.0.6502): Saves client preference settings
[10] SQLite (1.10.0.6502): SQLite Driver
[11] Top Menus (1.10.0.6502): Creates sorted nested menus
[12] PTaH (1.1.3): Additional CS:GO Hooks and Natives
[13] SDK Hooks (1.10.0.6502): Source SDK Hooks
[14] SteamWorks Extension (1.2.3): Exposes SteamWorks functions to Developers
[15] DHooks (2.2.0-detours16): Dynamic Hooks
[16] REST in Pawn (1.3.0): Provides HTTP and JSON natives for plugins
[17] Source Scramble (0.6.0): Tools for working with memory.
[18] SMJansson (2.6.0/1): JSON parser/writer
[19] cURL Extension (1.3.0.0): cURL Extension
[20] SMbz2 (0.0.3): Very basic extension to de/compress bz2 files
[21] GeoIP (1.10.0.6502): Geographical IP information
[22] Zip (0.1.0): Zip file compression extension
[23] AntiDLL (1.3): Mini protection against internal cheats
[24] System2 (3.3.2): HTTP/FTP Request and System API for Sourcemod
[25] MySQL-DBI (1.10.0.6502): MySQL driver implementation for DBI
Natanel-Shitrit commented 3 years ago

Please delete your old database after you upgrade from main branch to dev. The structure is not the same, and the plugin doesn't handle those cases.

Natanel-Shitrit commented 3 years ago

(The plugin should create the new database by itself, no manual querying required, just deleting)

crashzk commented 3 years ago

So I deleted the database completely, tables and everything.

In any case I deleted it again and I will test it here.