Problem with dopban / mysql query

[Kobra]

Ошибка

Problem with dopban / mysql query / access manager

ОС

Linux

Amx Mod X

AMX Mod X 1.9.0.5294 (http://www.amxmodx.org)

Authors:

        David "BAILOPAN" Anderson, Pavol "PM OnoTo" Marko

        Felix "SniperBeamer" Geyer, Jonny "Got His Gun" Bergstrom

        Lukasz "SidLuke" Wlasinski, Christian "Basic-Master" Hammacher

        Borja "faluco" Ferrer, Scott "DS" Ehlert

Compiled: Dec  3 2021 15:54:56

Built from: https://github.com/alliedmodders/amxmodx/commit/363871a

Build ID: 5294:363871a

Core mode: JIT+ASM32

Билд

version

Protocol version 48

Exe version 1.1.2.7/Stdio (cstrike)

ReHLDS version: 3.12.0.780-dev

Build date: 16:20:56 Sep 19 2022 (3082)

Build from: https://github.com/dreamstalker/rehlds/commit/d6ebe82

ReGamedll

ReGameDLL version: 5.21.0.576-dev

Build date: 08:31:59 Mar 11 2023

Build from: https://github.com/s1lentq/ReGameDLL_CS/commit/8ff30b4

Версия Metamod

Metamod-r v1.3.0.131, API (5:13)

Metamod-r build: 18:51:02 Jul 11 2022

Metamod-r from: https://github.com/theAsmodai/metamod-r/commit/adc9414

Список метамодулей

Currently loaded plugins:

      description       stat pend  file                        vers             src  load  unload

 [ 1] Reunion           RUN   -    reunion_mm_i386.so          v0.1.0.137       ini  Start Never

 [ 2] SafeNameAndChat   RUN   -    SafeNameAndChat.so          v1.2 Beta 3      ini  ANY   ANY  

 [ 3] VoiceTranscoder   RUN   -    VoiceTranscoder.so          v2017RC5         ini  ANY   ANY  

 [ 4] AMX Mod X         RUN   -    amxmodx_mm_i386.so          v1.9.0.5294      ini  Start ANY  

 [ 5] Print Center Fix  RUN   -    printcenterfix_mm_i386.so   v2.0.1           ini  ANY   ANY  

 [ 6] Rechecker         RUN   -    rechecker_mm_i386.so        v2.5             ini  Chlvl ANY  

 [ 7] ReSemiclip        RUN   -    resemiclip_mm_i386.so       v2.3.9           ini  Chlvl ANY  

 [ 8] ReSRDetector      RUN   -    resrdetector_mm_i386.so     v0.1.0           ini  Chlvl ANY  

 [ 9] WHBlocker         RUN   -    whblocker_mm_i386.so        v1.5.697         ini  Chlvl ANY  

 [10] HitBox Fix        RUN   -    hitbox_fix_mm_i386.so       v1.1.1           ini  Start ANY  

 [11] SQLite            RUN   -    sqlite_amxx_i386.so         v1.9.0.5294      pl4  ANY   ANY  

 [12] Hide Cvars        RUN   -    hidecvars_amxx_i386.so      v1.0             pl4  ANY   ANY  

 [13] Ham Sandwich      RUN   -    hamsandwich_amxx_i386.so    v1.9.0.5294      pl4  ANY   ANY  

 [14] FakeMeta          RUN   -    fakemeta_amxx_i386.so       v1.9.0.5294      pl4  ANY   ANY  

 [15] CSX               RUN   -    csx_amxx_i386.so            v1.9.0.5294      pl4  ANY   ANY  

 [16] ReAPI             RUN   -    reapi_amxx_i386.so          v5.22.0.254-dev  pl4  ANY   Never

 [17] ReAimDetector     RUN   -    reaimdetector_amxx_i386.so  v0.2.2           pl4  ANY   Never

 [18] Engine            RUN   -    engine_amxx_i386.so         v1.9.0.5294      pl4  ANY   ANY  

 [19] CStrike           RUN   -    cstrike_amxx_i386.so        v1.9.0.5294      pl4  ANY   ANY  

 [20] GeoIP             RUN   -    geoip_amxx_i386.so          v1.9.0.5294      pl4  ANY   ANY  

 [21] MySQL             RUN   -    mysql_amxx_i386.so          v1.9.0.5294      pl4  ANY   ANY  

 [22] Fun               RUN   -    fun_amxx_i386.so            v1.9.0.5294      pl4  ANY   ANY  

22 plugins, 22 running

Список плагинов

Currently loaded plugins:

       name                    version     author            file             status   

 [  1] GSClient Auth           1.0         Dev-MS.ru         gsclient.amxx    running  

 [  2] Slay Losers             1.2.0       [email protected]   slay_losers.amx  running  

 [  3] Hide HUD/Menu on Vote   1.2.2       d3m37r4           hide_hud_and_me  running  

 [  4] ReAimDetector API       0.2.2       ReHLDS Team       reaimdetector.a  running  

 [  5] Access Manager          1.0.0       mx?!              AccessManager.a  debug    

 [  6] [Advanced Slot Reserva  2.2         Shadows Adi       advanced_slot_r  running  

 [  7] Frags Counter           1.0         CHEL74            frags_counter.a  running  

 [  8] Mute Weapon Shots       0.2         RauliTop          mute_weapon_sho  running  

 [  9] Advanced Spam Nick Cha  0.2         Fullserver        advanced_spam_n  running  

 [ 10] [ReAPI] Anti overflow   1.0         Some Author       antioverflow.am  running  

 [ 11] [190] VIP RBS           22.12.08BE  SKAJIbnEJIb       vip_rbs.amxx     running  

 [ 12] FreshBans               1.4.8b      kanagava          fresh_bans_148-  running  

 [ 13] WebHS                   0.1         kanagava          fb_web_online.a  running  

 [ 14] fb_forwards             0.1.4       Kanagava & Realu  fb_forwards.amx  running  

 [ 15] DopBan                  3.0.8b      kanagava          dopban308.amxx   stopped  

 [ 16] Write MS                0.1         ill               log_ms.amxx      running  

 [ 17] [190] Damager RBS       20.06.06    SKAJIbnEJIb       damager_rbs.amx  running  

 [ 18] Private Message: Core   1.5         Denzer            private_message  running  

 [ 19] Private Message: Loggi  1.3         Denzer            private_message  running  

 [ 20] Lite Night Mode         1.0         neugomon ?        cnightmode.amxx  running  

 [ 21] Command Restrictions    2.0         OciXCrom          crx_command_res  running  

 [ 22] Admin Commands          1.9.0.5294  AMXX Dev Team     admincmd.amxx    running  

 [ 23] Admin Help              1.9.0.5294  AMXX Dev Team     adminhelp.amxx   running  

 [ 24] Multi-Lingual System    1.9.0.5294  AMXX Dev Team     multilingual.am  running  

 [ 25] Menus Front-End         1.9.0.5294  AMXX Dev Team     menufront.amxx   running  

 [ 26] Commands Menu           1.9.0.5294  AMXX Dev Team     cmdmenu.amxx     running  

 [ 27] Players Menu            1.9.0.5294  AMXX Dev Team     plmenu.amxx      running  

 [ 28] Plugin Menu             1.9.0.5294  AMXX Dev Team     pluginmenu.amxx  running  

 [ 29] [190] Stimulation RBS   20.06.06    SKAJIbnEJIb       stimulation_rbs  running  

 [ 30] Pause Plugins           1.9.0.5294  AMXX Dev Team     pausecfg.amxx    running  

 [ 31] Stats Configuration     20.06.06    SKAJIbnEJIb & AM  statscfg_rbs.am  running  

 [ 32] [190] Skill ELO         22.11.15    SKAJIbnEJIb       skill_elo.amxx   running  

 [ 33] [183] StatsX Unlimited  22.12.08    SKAJIbnEJIb       statsx_unlimite  running  

 [ 34] [190] StatsX RBS        21.03.23    SKAJIbnEJIb & AM  statsx_rbs.amxx  running  

 [ 35] [190] CsStats MySQL     22.11.15    SKAJIbnEJIb       csstats_mysql.a  running  

 [ 36] Items Restrict          1.1         s1lent            items_restrict.  running  

 [ 37] Ping Faker              1.5a        MeRcyLeZZ         pingfaker_count  running  

 [ 38] Blinding Time           0.0.1       Albertio          cflash.amxx      running  

 [ 39] Unlimited Choose Team   1.0         Javekson          unlimited_choos  running  

 [ 40] Last Maps Time          0.0.1       Exolent           last_maps_time.  running  

 [ 41] MOTD Commands           1.3         OciXCrom          crx_motdcommand  running  

 [ 42] Invisible Spectator     1.0         ReHLDS Team       invisible_spect  running  

 [ 43] Advanced Kill Assists   1.3c        Xelson            next21_kill_ass  running  

 [ 44] SHOW IP + LAST IP       2.0         Alka + x          amx_showip_last  running  

 [ 45] Reklama                 09.07.2019  mx?!              reklama.amxx     running  

 [ 46] Reset Score             1.4.4       Radius            reset_score.amx  running  

 [ 47] CFG Slash               1.0         aNNakin           cfg_slash.amxx   running  

 [ 48] Server Menu             1.5.0       F@nt0M            server_menu.amx  running  

 [ 49] Admin Commands Log      1.2         w0w               admin_commands_  running  

 [ 50] DemoRecoder             1.1         neygomon          amx_demorec.amx  running  

 [ 51] [190] Cvar On Map       20.06.06    SKAJIbnEJIb       cvar_on_map.amx  running  

 [ 52] Whatsapp_Group_Request  3.2         CrAzY MaN         whatsapp_group_  running  

 [ 53] [ReAPI] AdminFreeLook   1.0         ReHLDS Team       adminfreelook.a  running  

 [ 54] [190] Warmup RBS        21.03.23    SKAJIbnEJIb       warmup_rbs.amxx  running  

 [ 55] Trial Access            1.0.0       mx?!              trial_access.am  running  

 [ 56] [190] Ultimate Flags    22.11.15    SKAJIbnEJIb       ultimate_flags.  running  

 [ 57] Hide                    1.1         xPaw              hidexpaw.amxx    running  

 [ 58] Hostname Timeleft       1.0         xPaw              HostnameTimelef  running  

 [ 59] [ReAPI] Block 'Fire in  0.0.1       sergrib           simpleblockfith  running  

 [ 60] Online Logger           1.0.3       mx?!              online_logger.a  running  

 [ 61] M_AntiRusher            2.83        Miczu             xPaw_Antirusher  running  

 [ 62] Wasted Time             1.3.0       Javekson          wasted_time.amx  running  

 [ 63] Color Flash Screen      1.6.4       Radius (Stimul i  color_flash_scr  running  

 [ 64] Announcer Killstreak    2.1         Jumper & mx?!     Announcer_Kills  running  

 [ 65] Admin Groups            1.2         OciXCrom          crx_admingroups  running  

 [ 66] AFK Control             1.0         mx?!              afk_control.amx  running  

 [ 67] AMX Immunity            3.0         eVeste            imuneoff.amxx    running  

 [ 68] [GeoIP] Connect Info    1.0         s1lent            geoipconnect.am  running  

 [ 69] unknown                 unknown     unknown           fake.amxx        running  

 [ 70] Unreal Spawn Fixer      1.1         karaulov          unreal_spawn_fi  running  

 [ 71] [190] VoteBan RBS       20.06.06    SKAJIbnEJIb       voteban_rbs.amx  running  

 [ 72] [ReAPI:AMXX] Buy Nades  0.2         F@nt0M            Buy_Nades_Timeo  running  

 [ 73] Adverts hud             1.0.1       cpctrl            adverts_hud.amx  running  

 [ 74] Custom skies            0.0.1       Nordic Warrior    CustomSkies.amx  running  

 [ 75] HPP_BLOCK               1.1         UNKNOWN + bristo  hpp_blocker.amx  running  

 [ 76] recoil_manager          1.0.0       fl0wer            recoil_manager.  running  

 [ 77] [190] Ultimate Informe  21.03.23    SKAJIbnEJIb       ultimate_inform  running  

 [ 78] [190] Bets RBS          20.10.24BE  SKAJIbnEJIb       bets_rbs.amxx    running  

 [ 79] [190] BonusMenu RBS     22.12.07BE  SKAJIbnEJIb       bonusmenu_rbs.a  running  

 [ 80] [190] Jobs RBS          22.11.15    SKAJIbnEJIb       jobs_rbs.amxx    running  

 [ 81] [190] Whois RBS         22.11.15    SKAJIbnEJIb       whois_rbs.amxx   running  

 [ 82] [190] Army Ranks Ultim  20.06.06    SKAJIbnEJIb       army_ranks_ulti  running  

 [ 83] Team Control            1.6.8       Radius            team_control.am  running  

 [ 84] Plugins Core            1.5.0       Radius            plugins_core.am  running  

 [ 85] Fall Damage HP Restore  0.0.1       Vaqtincha         FallDamageHpRes  running  

 [ 86] Language set            1.0         Kobra             land2.amxx       running  

 [ 87] Team Flash Control      1.6.0       Radius            team_flash_cont  running  

 [ 88] ChatAdditions: Core     607b9b5     Sergey Shorokhov  ChatAdditions_C  running  

 [ 89] ChatAdditions: CSBans   fea4441     Sergey Shorokhov  CA_Storage_CSBa  running  

 [ 90] CA: Mute                fea4441     Sergey Shorokhov  CA_Mute.amxx     running  

 [ 91] CA Addon: Death mute    fea4441     Sergey Shorokhov  CA_Addon_DeathM  debug    

 [ 92] CA Addon: Rank restric  fea4441     steelzzz          CA_Addon_RankRe  debug    

 [ 93] CA Addon: Request UnGA  fea4441     steelzzz          CA_Addon_Reques  running  

 [ 94] CA: VoteGAG             1.0.0-alph  Sergey Shorokhov  CA_Addon_VoteGa  running  

 [ 95] CA: Gag                 fea4441     Sergey Shorokhov  CA_Gag.amxx      running  

 [ 96] unknown                 unknown     unknown           antibind.amxx    running  

 [ 97] [190] Chat RBS          22.12.07BE  SKAJIbnEJIb       chat_rbs.amxx    running  

 [ 98] [190] Chat Addons       20.06.06    SKAJIbnEJIb       chat_addons.amx  running  

 [ 99] [190] AdminChat RBS     22.11.15    SKAJIbnEJIb       adminchat_rbs.a  running  

 [100] Revive Teammates: Core  0.11.0      ufame & Albertio  rt_core.amxx     debug    

 [101] Revive Teammates: Plan  0.11.0      ufame & Albertio  rt_planting.amx  running  

 [102] Revive Teammates: Rest  0.11.0      ufame & Albertio  rt_restrictions  running  

 [103] Revive Teammates: Time  0.11.0      ufame & Albertio  rt_timer.amxx    running  

 [104] Revive Teammates: Effe  0.11.0      ufame & Albertio  rt_effects.amxx  running  

 [105] Revive Teammates: Bonu  0.11.0      ufame & Albertio  rt_bonus.amxx    running  

 [106] Map Manager: Core       3.1.5       Mistrick          map_manager_cor  running  

 [107] Map Manager: Scheduler  0.1.11      Mistrick          map_manager_sch  running  

 [108] Admin Mapmenu           0.5.3       d3m37r4           admin_mapmenu.a  running  

 [109] Map Manager: Rtv        0.1.3       Mistrick          map_manager_rtv  running  

 [110] Map Manager: Nominatio  0.3.1-79ed  Mistrick          map_manager_nom  running  

 [111] Map Manager: BlockList  0.0.4       Mistrick          map_manager_blo  running  

 [112] Map Manager: Online so  0.0.4       Mistrick          map_manager_onl  running  

 [113] Map Manager: Effects    0.1.1       Mistrick          map_manager_eff  running  

 [114] Map Manager: Informer   0.0.5       Mistrick          map_manager_inf  running  

 [115] Map Manager: Advanced   0.1.0       Mistrick          map_manager_adv  running  

 [116] Map Manager: Priority   0.0.2       Mistrick          map_manager_pri  running  

 [117] Map Manager: Online ch  1.0.0       Sergey Shorokhov  map_manager_onl  running  

 [118] unknown                 unknown     unknown           kobra_rtv_maps.  running  

 [119] MapBalance              1.0         BlackSignature    MapBalance.amxx  running  

 [120] AWP Restrictions        1.5.1       Radius            awp_restriction  running  

 [121] [190] C4 Destroyer      22.12.07BE  SKAJIbnEJIb       c4_destroyer.am  running  

 [122] Style C4 Timer          3.0         OciXCrom          crx_c4timer.amx  running  

 [123] Walkguard               1.0.0       mx?!              walkguard.amxx   running  

123 plugins, 122 running

Автор плагина

mazdan

Версия плагина

3.0.8b

Исходный код

-

Good morning !
I am using dopban and Access Manager 1.0.0 from mx?! with mysql.Everything worked fine until 06.05(a week ago) when these two plugins stopped working correctly , both throwing query errors while every other plugin using the same mysql database (fresh bans,army ranks,csstats mysql etc) work perfectly fine.I am out of ideas what would be the cause,I mention that the database is hosted on another machine with debian11 installed following the Nordic Warrior tutorial from here : https://dev-cs.ru/threads/21647/

Here are some screens with the errors:

1. https://prnt.sc/kTsRhQO1vYNQ
   
   
2. https://prnt.sc/CLUGH0ngvtX4
3. L 05/07/2023 - 21:37:18: [DB]TQUERY_FAILED no such table: db_dyncookie #1 3
   
   
4. L 05/13/2023 - 11:38:08: [SQLITE] Invalid info tuple handle: 4
   L 05/13/2023 - 11:38:08: [AMXX] Displaying debug trace (plugin "AccessManager.amxx", version "1.0.0")
   L 05/13/2023 - 11:38:08: [AMXX] Run time error 10: native error (native "SQL_ThreadQuery")
   L 05/13/2023 - 11:38:08: [AMXX] [0] AccessManager.sma::func_MakeQuery (line 1139)
   L 05/13/2023 - 11:38:08: [AMXX] [1] AccessManager.sma::func_LoadAdminsSql (line 330)
   L 05/13/2023 - 11:38:08: [AMXX] [2] AccessManager.sma::func_InitSQL (line 216)
   L 05/13/2023 - 11:38:08: [AMXX] [3] AccessManager.sma::task_InitSystem (line 178)

 

[Limbooc]

Попробуй FreshBans поставить выше Access Manager 1.0.0 т.к. fbans_sql_connected сначала отрабатывает из форварда FB

 

[Kobra]

It was sqlite's fault,I'm such an idiot. Apparently mysql and sqlite cannot work together.