[Mordekay]

I'm getting this error on every map change:

L 01/26/2021 - 18:52:56: [gungame.amxx] Could not execute query [INSERT INTO `gg_stats` (authid,name,timestamp,wins,points,streak,serverip) VALUES ('BOT','Deadlynome','1611683576','0','21','0','89.163.190.40:27515'),('BOT','Firestorm','1611683576','0','21','0','89.163.190.40:27515'),('BOT','bussemann','1611683576','0',] -- err #1062 [Duplicate entry 'BOT-89.163.190.40:27515' for key 'PRIMARY']

status

18:56:15 hostname:  die-lappenbude.de gungame
         version :  48/1.1.2.7/Stdio 8684 secure  (10)
         tcp/ip  :  89.163.190.40:27515
         map     :  de_dust at: 0 x, 0 y, 0 z
         players :  18 active (32 max)
         
         #      name userid uniqueid frag time ping loss adr
         # 1 "Death Knight" 384 BOT  52 15:32:59    0    0
         # 2 "Deadlynome" 385 BOT  54 15:32:59    0    0
         # 3 "Firestorm" 386 BOT  53 15:32:59    0    0
         # 4 "bussemann" 387 BOT  56 15:32:59    0    0
         # 5   "wind" 388 BOT  56 15:32:59    0    0
         # 6  "Tator" 389 BOT  50 15:32:59    0    0
         # 7 "Twinner" 390 BOT  63 15:32:59    0    0
         # 8 "alldritc" 391 BOT  61 15:32:59    0    0
         # 9 "Counter123" 392 BOT  54 15:32:59    0    0
         #10 "waeldreegia" 393 BOT  47 15:32:59    0    0
         #11 "DarkWarrior" 394 BOT  54 15:32:59    0    0
         #12 "Wangmaste" 395 BOT  55 15:32:59    0    0
         #13 "ksqueakj" 396 BOT  49 15:32:59    0    0
         #14 "Mushlafa" 397 BOT  60 15:32:59    0    0
         #15 "Whatever" 398 BOT  57 15:32:59    0    0
         #16 "DrEdGe FuEgO" 399 BOT  52 15:32:59    0    0
         #17  "kirby" 400 BOT  61 15:32:59    0    0
         #18  "Major" 401 BOT  51 15:32:59    0    0
         18 users

meta list

18:57:41 Currently loaded plugins:
               description      stat pend  file              vers      src  load  unlod
          [ 1] YaPB             RUN   -    yapb.so           v4.2.597  ini  Chlvl ANY  
          [ 2] AMX Mod X        RUN   -    amxmodx_mm_i386.  v1.9.0.5  ini  Start ANY  
          [ 3] Fun              RUN   -    fun_amxx_i386.so  v1.9.0.5  pl2  ANY   ANY  
          [ 4] CStrike          RUN   -    cstrike_amxx_i38  v1.9.0.5  pl2  ANY   ANY  
          [ 5] CSX              RUN   -    csx_amxx_i386.so  v1.9.0.5  pl2  ANY   ANY  
          [ 6] MySQL            RUN   -    mysql_amxx_i386.  v1.9.0.5  pl2  ANY   ANY  
          [ 7] Ham Sandwich     RUN   -    hamsandwich_amxx  v1.9.0.5  pl2  ANY   ANY  
          [ 8] FakeMeta         RUN   -    fakemeta_amxx_i3  v1.9.0.5  pl2  ANY   ANY  
          [ 9] CURL AMXX        RUN   -    curl_amxx_i386.s  v1.1.1    pl2  ANY   ANY  
         9 plugins, 9 running

amxx list

18:58:27 Currently loaded plugins:
                name                    version     author            file             status   
          [  1] AMXBans Core            6.13        YamiKaitou        amxbans_core.am  running  
          [  2] AMXBans Main            6.13        YamiKaitou        amxbans_main.am  running  
          [  3] Admin Commands          1.9.0.5235  AMXX Dev Team     admincmd.amxx    running  
          [  4] Admin Help              1.9.0.5235  AMXX Dev Team     adminhelp.amxx   running  
          [  5] Slots Reservation       1.9.0.5235  AMXX Dev Team     adminslots.amxx  running  
          [  6] Multi-Lingual System    1.9.0.5235  AMXX Dev Team     multilingual.am  running  
          [  7] Menus Front-End         1.9.0.5235  AMXX Dev Team     menufront.amxx   running  
          [  8] Commands Menu           1.9.0.5235  AMXX Dev Team     cmdmenu.amxx     running  
          [  9] Players Menu            1.9.0.5235  AMXX Dev Team     plmenu.amxx      running  
          [ 10] Maps Menu               1.9.0.5235  AMXX Dev Team     mapsmenu.amxx    running  
          [ 11] Plugin Menu             1.9.0.5235  AMXX Dev Team     pluginmenu.amxx  running  
          [ 12] Admin Chat              1.9.0.5235  AMXX Dev Team     adminchat.amxx   running  
          [ 13] Anti Flood              1.9.0.5235  AMXX Dev Team     antiflood.amxx   running  
          [ 14] Scrolling Message       1.9.0.5235  AMXX Dev Team     scrollmsg.amxx   running  
18:58:27  [ 15] Info. Messages          1.9.0.5235  AMXX Dev Team     imessage.amxx    running  
          [ 16] Admin Votes             1.9.0.5235  AMXX Dev Team     adminvote.amxx   running  
          [ 17] Nextmap Chooser         1.9.0.5235  AMXX Dev Team     mapchooser.amxx  running  
          [ 18] TimeLeft                1.9.0.5235  AMXX Dev Team     timeleft.amxx    running  
          [ 19] Pause Plugins           1.9.0.5235  AMXX Dev Team     pausecfg.amxx    running  
          [ 20] Stats Configuration     1.9.0.5235  AMXX Dev Team     statscfg.amxx    running  
          [ 21] StatsX                  1.9.0.5235  AMXX Dev Team     statsx.amxx      running  
          [ 22] CS Misc. Stats          1.9.0.5235  AMXX Dev Team     miscstats.amxx   debug    
          [ 23] CS Stats Logging        1.9.0.5235  AMXX Dev Team     stats_logging.a  running  
          [ 24] Anti Silent-run         1.2         Numb              antisilentrun.a  running  
          [ 25] Lame Connection Punish  1.2         MeRcyLeZZ         lame_connection  running  
          [ 26] Files Check             1.0         ConnorMcLeod      filescheck.amxx  running  
          [ 27] GunGame AMXX            2.13c       Avalanche         gungame.amxx     running  
          [ 28] HLstatsX CE Ingame Plu  1.6.19 (HL  psychonic         hlstatsx_comman  running  
          [ 29] Ultimate Gore           1.6         JTP10181          amx_gore_ultima  running  
18:58:27  [ 30] VAC Ban Status          0.4         bugsy             vacbans.amxx     running  
          [ 31] AMXBans Flagged         6.13        YamiKaitou        amxbans_freeze.  running  
          [ 32] AMXBans Flagged         6.13        YamiKaitou        amxbans_flagged  running  
         32 plugins, 32 running

I'm using the original gungame 2.13c except added 2 letters in client_disconnected-funktion to prevent the warning.

[Shadows Adi]

The error provides from duplicate entry:

"[Duplicate entry 'BOT-89.163.190.40:27515' for key 'PRIMARY']"

Because Bots have as steamid 'BOT' and a PRIMARY KEY in MySQL can't be duplicated: PRIMARY KEY(`authid`,`serverip`) see line 8467 in gungame.sma.

[Mordekay]

How to fix it?

[Shadows Adi]

Well, try setting PRIMARY KEY(`authid`,`serverip`) in PRIMARY KEY(`name`,`serverip`)

[Mordekay]

If I could change the code I would not have asked (or not here but in scripting help)

EDIT: Memo to self: read the f**ing cvars:

Originally Posted by cvars gg_ignore_bots (default: 0) If set to 1, bot wins and points are not saved. If set to 2, bots can't even trigger a win, unless there are no human players in the server, in addition to their wins and points not being saved.

So: solved