search

TheDoctor0 / CSGOMod

CS:GO Mod for Counter-Strike 1.6 (AMXX 1.8.3 / 1.9 / 1.10).
MIT License
59 stars 35 forks source link

Problem with loading all CS:GO plugins after map change #145

Closed Happy2906 closed 2 years ago

Happy2906 commented 3 years ago

Hi,

I am using and older release 1.0 - 1.4 and I have a small problem with loading all CS GO plugins after a map change. Due to high volume of players (20+), the server seems to load quite slowly. When the map change occurs and the map changes, everything is fine until choosing a team and starting the first round. The skins does not load, the HUD does not appear, commands does not work and the main problem is with the accounts. The login / sign in / account menu shows after good 10-15 seconds after starting the first round and this is so annoying, because it shows itself in the middle of the round while shooting at someone. I have tried changing the databases but with no effect. I have no idea what might be causing this problem.

Here are some stats from the server - CPU In Out Uptime Users FPS Players 34.00 166.58 284.54 82 272 1863.27 22

The server and the databases are in good condition, so I have no idea what might be causing the problem. If you find a minute, please reply as soon as possible, as I have been using this CSGO Mod for good couple of years. Thanks,

TheDoctor0 commented 2 years ago

Hello @Happy2906. I was using the 1.4 version on a server with 32 slots that most of the time was full and there was no such issue.

How many players do you have in your database? It's possible that queries are slower because there is just a lot of data. To improve it you can try executing this to create indexes that will speed up lookups by player name:

CREATE INDEX name_index ON csgo_accounts (name);
CREATE INDEX name_index ON csgo_hud (name);
CREATE INDEX name_index ON csgo_ranks (name);
CREATE INDEX name_index ON csgo_skins (name);
CREATE INDEX name_index ON csgo_data (name);
CREATE INDEX name_index ON csgo_clans_members (name);
Happy2906 commented 2 years ago

Hi,

I am using 1.1 version of the engine. I could not add these to the database, as if came up with an error that the key name is duplicate.

SQL query:

CREATE INDEX name_index ON csgo_accounts (name) MySQL said: Documentation

1061 - Duplicate key name 'name_index'

CREATE INDEX name_index ON csgo_accounts (name); CREATE INDEX name_index ON csgo_hud (name);

The rest of the indexes were created succesfully. Here is a screenshot of the databases including all data.

https://i.imgur.com/5GKksoB.png

Happy2906 commented 2 years ago

Just to let you know, this is my list of plugins that I'm currently using. They are quite mixed up from different releases - 

 [  7] CS:GO Mod               1.1         O'Zone            csgo_core_nowe_  running  
 [  8] CS:GO Clans             2.5.9       O'Zone            csgh_clans_nowe  running  
 [  9] CSGO: Rangi             2.0         Pawel             csgo_ranks.amxx  debug    
 [ 10] CS:GO Rank System       2.5.9       O'Zone            ranks_csgo_nowe  running  
 [ 11] CS:GO Accounts          2.5.9       O'Zone            csgo_accounts_h  running  
 [ 12] CS:GO Nades             1.4         O'Zone            csgo_nades.amxx  running  
 [ 13] CS:GO VIP & SVIP        2.5.9       O'Zone            csgo_vip_hades.  running  
 [ 14] CS:GO Server Menu       1.1         O'Zone            csgo_server_men  running  
 [ 15] CS:GO Transfer          1.1         O'Zone            csgo_transfer.a  running  
 [ 16] CS:GO Assist and Reven  1.1         O'Zone            csgo_assist_rev  running  
 [ 17] CS:GO Operations        2.0         O'Zone            csgo_operacje2.  running  
 [ 18] CS:GO Molotov           1.1         DynamicBits & O'  csgo_molotov.am  running  
 [ 19] CS:GO Smoke             1.1         Numb & O'Zone     csgo_smoke.amxx  running  
 [ 20] CS:GO Zeus              1.1         wopox1337 & O'Zo  csgo_zeus.amxx   running  
 [ 21] CS:GO Run Boost         1.1         O'Zone            csgo_runboost.a  running  
 [ 22] CS:GO Inspect           1.1         O'Zone            csgo_inspect.am  running  
 [ 23] CS:GO Unprecacher       1.1         O'Zone            csgo_unprecache  running  
 [ 24] CS:GO StatTrak          2.0         O'Zone            csgo_stattrak.a  running

Do you think by any chance, there might a problem with loadings all the files / database, because I'm using a mix of the plugins?

/edit Quick question that I forgot to ask. I have server on pukawka.pl. Do you think, there might be a problem with the server itself which is causing all the slow loading?

czarintax commented 2 years ago

Hello.

First of all, i want to thank to @TheDoctor0 for creating this awesome mod!

I'm running this mod with its latest version on a full server with 32 slots with a total of 10k players for about a month now. I had to make a lot of changes in the mod to make it work on xash3d engine without any problem, and i've succeed it. I can tell that everthing is working properly as so far. Except, i am getting one error from the clan system which is below. I did a multiple changes on trying to fix the problem but the error still remains. I'd appreciate if anyone of you could give me a hand to fix this small issue. Thanks!

[CS:GO Clans] Query failed. [1062] Duplicate entry 'stonz_lox-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
Happy2906 commented 2 years ago

Hi @Czarintax,

I had the same problem with my clan from the version 2.5.9. I have deleted the member from the whole database and it worked. Use the search bar, it helps alot 😁

czarintax commented 2 years ago

Hi @Czarintax,

I had the same problem with my clan from the version 2.5.9. I have deleted the member from the whole database and it worked. Use the search bar, it helps alot 😁

It doesn't impact all of the players though. But everyday i get this error atleast a couple times with different players. What is the cause of this problem? I have to solve it completly. But i don't understand, the table columns and the primary keys are exactly the same with the other tables like csgo_data and csgo_accounts(i don't use account system). But the error accours only in the clan system. Do you have any other idea?


L 10/16/2021 - 05:04:40: [CS:GO Clans] Query failed. [1062] Duplicate entry 'sai_-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/16/2021 - 07:16:27: [CS:GO Clans] Query failed. [1062] Duplicate entry '^6Sefyn-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/16/2021 - 07:21:30: [CS:GO Clans] Query failed. [1062] Duplicate entry '^6Sefyn-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/16/2021 - 08:16:12: [CS:GO Clans] Query failed. [1062] Duplicate entry 'sai_-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/16/2021 - 09:15:40: [CS:GO Clans] Query failed. [1062] Duplicate entry '[QQR] Steep BoY-VALVE_XASH_8548f7743ac55a64a999ed44d1abe0ce' for key 'PRIMARY'
L 10/16/2021 - 09:15:40: [CS:GO Clans] Query failed. [1062] Duplicate entry '[QQR] Steep BoY-VALVE_XASH_8548f7743ac55a64a999ed44d1abe0ce' for key 'PRIMARY'
L 10/16/2021 - 12:03:54: [CS:GO Clans] Query failed. [1062] Duplicate entry 'sai_-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/16/2021 - 12:06:37: [CS:GO Clans] Query failed. [1062] Duplicate entry '^6Sefyn (1)-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/16/2021 - 12:08:45: [CS:GO Clans] Query failed. [1062] Duplicate entry '^6Sefyn-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/16/2021 - 12:17:37: [CS:GO Clans] Query failed. [1062] Duplicate entry '^6Sefyn-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/16/2021 - 12:30:33: [CS:GO Clans] Query failed. [1062] Duplicate entry '^6Sefyn-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/16/2021 - 12:31:51: [CS:GO Clans] Query failed. [1062] Duplicate entry '^6Sefyn-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/16/2021 - 12:33:55: [CS:GO Clans] Query failed. [1062] Duplicate entry 'sai_-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/16/2021 - 12:43:59: [CS:GO Clans] Query failed. [1062] Duplicate entry '^6Sefyn-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/16/2021 - 16:06:52: [CS:GO Clans] Query failed. [1062] Duplicate entry 'sai_-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/16/2021 - 16:09:12: [CS:GO Clans] Query failed. [1062] Duplicate entry '^6Sefyn-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/16/2021 - 16:39:48: [CS:GO Clans] Query failed. [1062] Duplicate entry '^6Sefyn-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/17/2021 - 04:08:11: [CS:GO Clans] Query failed. [1062] Duplicate entry '^6Sefyn-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/17/2021 - 05:28:21: [CS:GO Clans] Query failed. [1062] Duplicate entry '^6Sefyn-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/17/2021 - 05:31:55: [CS:GO Clans] Query failed. [1062] Duplicate entry '^6Sefyn-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/17/2021 - 06:38:52: [CS:GO Clans] Query failed. [1062] Duplicate entry '^6Sefyn-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/17/2021 - 07:10:15: [CS:GO Clans] Query failed. [1062] Duplicate entry '^6Sefyn-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/17/2021 - 07:55:20: [CS:GO Clans] Query failed. [1062] Duplicate entry '^6Sefyn-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/17/2021 - 08:07:21: [CS:GO Clans] Query failed. [1062] Duplicate entry 'sai_-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/17/2021 - 10:50:55: [CS:GO Clans] Query failed. [1062] Duplicate entry '^6Sefyn-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/17/2021 - 11:02:51: [CS:GO Clans] Query failed. [1062] Duplicate entry '^6Sefyn-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/17/2021 - 12:46:46: [CS:GO Clans] Query failed. [1062] Duplicate entry 'sai_-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/17/2021 - 15:27:19: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1GoLose^3fast^6_^5zag^2burs-VALVE_XASH_6649678e40be19933ad7f2f3' for key 'PRIMARY'
L 10/17/2021 - 15:27:19: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1GoLose^3fast^6_^5zag^2burs-VALVE_XASH_6649678e40be19933ad7f2f3' for key 'PRIMARY'
L 10/19/2021 - 02:42:49: [CS:GO Clans] Query failed. [1062] Duplicate entry '^6Sefyn-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/19/2021 - 05:53:14: [CS:GO Clans] Query failed. [1062] Duplicate entry '^0x_infernuS'KG | ^3gallo-VALVE_XASH_fafa405bf083da073c40d48e591' for key 'PRIMARY'
L 10/19/2021 - 06:08:20: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1L|^2K|^3S ^0sai_-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/19/2021 - 06:18:21: [CS:GO Clans] Query failed. [1062] Duplicate entry '^3SamiOZAN YT-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/19/2021 - 06:23:24: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1L|^2K|^3S ^0sai_-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/19/2021 - 06:28:16: [CS:GO Clans] Query failed. [1062] Duplicate entry 'KiLiPRO cfg 2020#-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/19/2021 - 06:38:06: [CS:GO Clans] Query failed. [1062] Duplicate entry 'KiLiPRO cfg 2020#-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/19/2021 - 06:49:31: [CS:GO Clans] Query failed. [1062] Duplicate entry 'KiLiPRO cfg 2020#-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/19/2021 - 06:51:13: [CS:GO Clans] Query failed. [1062] Duplicate entry 'KiLiPRO cfg 2020#-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/19/2021 - 09:20:18: [CS:GO Clans] Query failed. [1062] Duplicate entry '^0[^3L  K  S^0]^1 s_a_I-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c' for key 'PRIMARY'
L 10/19/2021 - 10:34:03: [CS:GO Clans] Query failed. [1062] Duplicate entry '^0[^3L  K  S^0]^1 s_a_I-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c' for key 'PRIMARY'
L 10/19/2021 - 12:07:56: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1L|^2K|^3S ^0A L P H A-VALVE_XASH_5feaf4f8d916c585295e3b5ed6704' for key 'PRIMARY'
L 10/19/2021 - 12:07:56: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1L|^2K|^3S ^0A L P H A-VALVE_XASH_5feaf4f8d916c585295e3b5ed6704' for key 'PRIMARY'
L 10/19/2021 - 12:12:48: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1L|^2K|^3S ^1s_a_l-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/19/2021 - 12:13:09: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1L|^2K|^3S ^1s_a_l-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/19/2021 - 12:24:29: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1L|^2K|^3S ^1s_a_l-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/19/2021 - 12:24:49: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1L|^2K|^3S ^1s_a_l-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/19/2021 - 12:42:44: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1L|^2K|^3S ^1s_a_l-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/19/2021 - 21:36:41: [CS:GO Clans] Query failed. [1062] Duplicate entry '1-VALVE_XASH_84b237a1db22da7e7a83a68b6abe9674' for key 'PRIMARY'
L 10/19/2021 - 21:36:41: [CS:GO Clans] Query failed. [1062] Duplicate entry '1-VALVE_XASH_84b237a1db22da7e7a83a68b6abe9674' for key 'PRIMARY'
L 10/20/2021 - 13:09:54: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8x.infernus | ^2A^3L^5A^1N^8YT-VALVE_XASH_6c740be13137c10aff533' for key 'PRIMARY'
L 10/20/2021 - 13:09:54: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8x.infernus | ^2A^3L^5A^1N^8YT-VALVE_XASH_6c740be13137c10aff533' for key 'PRIMARY'
L 10/21/2021 - 03:15:10: [CS:GO Clans] Query failed. [1062] Duplicate entry 'Apple Cake-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/21/2021 - 03:35:41: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1L|^2K|^3S ^0sai_-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/21/2021 - 03:36:46: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1L|^2K|^3S ^0sai_-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/21/2021 - 04:39:57: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1L|^2K|^3S ^0sai_-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/21/2021 - 04:54:28: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1L|^2K|^3S ^0sai_-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/21/2021 - 04:57:58: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1L|^2K|^3S ^0sai_-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/21/2021 - 05:03:18: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1L|^2K|^3S ^0sai_-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/21/2021 - 05:13:39: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1L|^2K|^3S ^0sai_-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/21/2021 - 05:14:51: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1L|^2K|^3S ^0sai_-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/21/2021 - 05:32:19: [CS:GO Clans] Query failed. [1062] Duplicate entry '^3RinGo-VALVE_XASH_5f4e0bb20979986bd96ad78ed5a57c29' for key 'PRIMARY'
L 10/21/2021 - 05:32:19: [CS:GO Clans] Query failed. [1062] Duplicate entry '^3RinGo-VALVE_XASH_5f4e0bb20979986bd96ad78ed5a57c29' for key 'PRIMARY'
L 10/21/2021 - 07:11:54: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1L|^2K|^3S ^0sai_-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/21/2021 - 11:06:05: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1L|^2K|^3S ^0sai_-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/21/2021 - 11:08:53: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1L|^2K|^3S ^0sai_-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/21/2021 - 12:22:31: [CS:GO Clans] Query failed. [1062] Duplicate entry 'KiLiPRO cfg-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/21/2021 - 12:38:57: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8zegback-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/21/2021 - 12:41:56: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8zegback-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/21/2021 - 12:52:48: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8zegback-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/21/2021 - 13:05:16: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8zegback-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/21/2021 - 13:06:38: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8zegback-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/21/2021 - 13:07:15: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8zegback-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/21/2021 - 13:09:21: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8zegback-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/21/2021 - 13:16:00: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8zegback-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/21/2021 - 13:16:40: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8zegback-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/21/2021 - 14:26:52: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8zegback-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/21/2021 - 21:01:59: [CS:GO Clans] Query failed. [1062] Duplicate entry '^2f^1a^5f^9a-VALVE_XASH_2f4a942d58e94abb8036ff16bbaf2c97' for key 'PRIMARY'
L 10/22/2021 - 00:23:09: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8-Epedimack-^1ImmortlOLD-VALVE_XASH_931861d293c2d247c43e5e6b7f2' for key 'PRIMARY'
L 10/22/2021 - 00:23:09: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8-Epedimack-^1ImmortlOLD-VALVE_XASH_931861d293c2d247c43e5e6b7f2' for key 'PRIMARY'
L 10/22/2021 - 02:52:17: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8zegback-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/22/2021 - 03:11:38: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8zegback-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/22/2021 - 03:20:00: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8zegback-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/22/2021 - 04:24:00: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8zegback-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/22/2021 - 04:52:25: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8zegback-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/22/2021 - 05:04:59: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8zegback-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/22/2021 - 06:23:55: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8zegback-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/22/2021 - 06:37:15: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8zegback-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/22/2021 - 07:01:22: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8zegback-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/22/2021 - 08:02:18: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8zegback-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/22/2021 - 08:33:49: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8zegback-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/22/2021 - 08:43:38: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8zegback-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/22/2021 - 08:45:01: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8zegback-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/22/2021 - 12:06:53: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8zegback-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/22/2021 - 12:38:33: [CS:GO Clans] Query failed. [1062] Duplicate entry 'KiLiPRO cfg-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/22/2021 - 12:42:51: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8zegback-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/22/2021 - 13:05:08: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8zegback-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/22/2021 - 13:09:51: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8zegback-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/22/2021 - 13:12:19: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8zegback-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/22/2021 - 16:50:31: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8zegback-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/22/2021 - 17:27:56: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1F^5___^7D-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/23/2021 - 02:52:14: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1F^5___^7D-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/23/2021 - 03:16:06: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1F^5___^7D-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/23/2021 - 03:18:28: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1L|^2K|^3S ^0sai-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/23/2021 - 03:46:47: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1L|^2K|^3S ^0sai-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/23/2021 - 04:03:15: [CS:GO Clans] Query failed. [1062] Duplicate entry '^0[^3L   K  S^0]^1S   A   I-VALVE_XASH_93bbebab5b65847e5bd56b90c' for key 'PRIMARY'
L 10/23/2021 - 04:11:50: [CS:GO Clans] Query failed. [1062] Duplicate entry '^0[^3L   K  S^0]^1S   A   I-VALVE_XASH_93bbebab5b65847e5bd56b90c' for key 'PRIMARY'
L 10/23/2021 - 05:18:04: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1F^5___^7D-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/23/2021 - 05:38:12: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1F^5___^7D-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/23/2021 - 08:30:32: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1F^5___^7D-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/23/2021 - 08:48:08: [CS:GO Clans] Query failed. [1062] Duplicate entry '^0L   K   S ^1S A I-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/23/2021 - 12:36:32: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1F^5___^7D-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/23/2021 - 15:31:32: [CS:GO Clans] Query failed. [1062] Duplicate entry '^0 L   K   S ^1 S A I___-VALVE_XASH_93bbebab5b65847e5bd56b90cc52' for key 'PRIMARY'
L 10/24/2021 - 13:28:01: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1F^5___^7D-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/24/2021 - 14:25:21: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1F^5___^7D-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/24/2021 - 16:26:47: [CS:GO Clans] Query failed. [1062] Duplicate entry '^0L   K   S ^1S A I-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/24/2021 - 16:30:28: [CS:GO Clans] Query failed. [1062] Duplicate entry '^0L   K   S ^1S A I-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/24/2021 - 16:44:16: [CS:GO Clans] Query failed. [1062] Duplicate entry '^0L   K   S ^1S A I-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/25/2021 - 04:52:37: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1F^5___^7D-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/25/2021 - 05:01:13: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1F^5___^7D-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/25/2021 - 05:13:30: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1 s   a   i-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/25/2021 - 06:00:29: [CS:GO Clans] Query failed. [1062] Duplicate entry '^2NonstopFern-VALVE_XASH_6183c32f7c7d73f1c0a077a6fead3110' for key 'PRIMARY'
L 10/25/2021 - 07:04:01: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1[DX]-^5S.W.A.T-VALVE_XASH_465cbe08541d32a38464da1d02832785' for key 'PRIMARY'
L 10/25/2021 - 07:10:22: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1F^5___^7D-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/25/2021 - 08:30:51: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1s    a   i-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/25/2021 - 08:52:25: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1s   a   i-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/25/2021 - 09:00:57: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1F^5___^7D-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/25/2021 - 09:11:34: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1F^5___^7D-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/25/2021 - 09:18:59: [CS:GO Clans] Query failed. [1062] Duplicate entry '^7Fan ^4Cxr-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/25/2021 - 09:26:39: [CS:GO Clans] Query failed. [1062] Duplicate entry '^7Fan ^4Cxr-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/25/2021 - 09:38:07: [CS:GO Clans] Query failed. [1062] Duplicate entry '^7Fan ^4Cxr-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/25/2021 - 09:45:48: [CS:GO Clans] Query failed. [1062] Duplicate entry '^7Fan ^4Cxr-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/25/2021 - 09:49:44: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1s   a   i-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/25/2021 - 10:16:13: [CS:GO Clans] Query failed. [1062] Duplicate entry '^3[^2ES.MS^2^3] ^6HACKER-VALVE_XASH_75a6270f3ade4f006670d8d40c87' for key 'PRIMARY'
L 10/25/2021 - 10:54:59: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1F^5___^7D-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/25/2021 - 17:21:49: [CS:GO Clans] Query failed. [1062] Duplicate entry '^5~^4/^8/^9SAS^6UKE^4/^8/^5~^8-VALVE_XASH_c11aac970684ad1c657db4' for key 'PRIMARY'
L 10/25/2021 - 21:28:18: [CS:GO Clans] Query failed. [1062] Duplicate entry '[QQR] Steep BoY-VALVE_XASH_8548f7743ac55a64a999ed44d1abe0ce' for key 'PRIMARY'
L 10/25/2021 - 22:36:36: [CS:GO Clans] Query failed. [1062] Duplicate entry 'JERICHO-VALVE_XASH_88ea886b7651c2acadccac8f3b617918' for key 'PRIMARY'
L 10/25/2021 - 22:36:52: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8-Epedimack-^1ImmortlOLD-VALVE_XASH_931861d293c2d247c43e5e6b7f2' for key 'PRIMARY'
L 10/25/2021 - 22:37:48: [CS:GO Clans] Query failed. [1062] Duplicate entry '^0TeRmInAtOr-VALVE_XASH_bf3d9fd3c1b7e23a8cd338be42024d1c' for key 'PRIMARY'
L 10/25/2021 - 22:38:37: [CS:GO Clans] Query failed. [1062] Duplicate entry '^4NOOB^1MASTER-VALVE_XASH_09137a339342f950cb6bace7835ca770' for key 'PRIMARY'
L 10/26/2021 - 03:18:51: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1F^5___^7D-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/26/2021 - 03:20:05: [CS:GO Clans] Query failed. [1062] Duplicate entry '^4L1QUID^0|^1S A I_-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/26/2021 - 03:34:39: [CS:GO Clans] Query failed. [1062] Duplicate entry '^4L1QUID^0|^1S A I_-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/26/2021 - 03:45:47: [CS:GO Clans] Query failed. [1062] Duplicate entry '^4L1QUID^0|^1S A I_-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/26/2021 - 04:04:30: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1F^5___^7D-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/26/2021 - 04:07:33: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1F^5___^7D-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/26/2021 - 05:23:09: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1F^5___^7D-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/26/2021 - 06:19:15: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1F^5___^7D-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/26/2021 - 06:41:57: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1s^2a^3I^0PRO-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/26/2021 - 06:50:47: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1s^2a^3I^0PRO-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/26/2021 - 06:57:34: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1s^2a^3I^0PRO-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/26/2021 - 10:42:25: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1s a i_-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/26/2021 - 11:43:04: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1sai_-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/26/2021 - 12:04:19: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1F^5___^7D-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/26/2021 - 12:10:11: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1F^5___^7D-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/26/2021 - 12:34:39: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1F^5___^7D-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/26/2021 - 14:46:02: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1sai_-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/27/2021 - 02:35:24: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1[DX]-^5S.W.A.T-VALVE_XASH_465cbe08541d32a38464da1d02832785' for key 'PRIMARY'
L 10/28/2021 - 15:48:58: [CS:GO Clans] Query failed. [1062] Duplicate entry 'bsssssssssssssss-VALVE_XASH_4a44267b2fc6d70d93b3ea06faf6ebe7' for key 'PRIMARY'
L 10/28/2021 - 15:49:10: [CS:GO Clans] Query failed. [1062] Duplicate entry 'spy-VALVE_XASH_81c9d0cf33568d2f63ef83a1161980bd' for key 'PRIMARY'
L 10/29/2021 - 15:46:41: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1sai_-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/29/2021 - 15:58:35: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1sai_-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/30/2021 - 00:11:07: [CS:GO Clans] Query failed. [1062] Duplicate entry 'Cyber7-VALVE_XASH_d25d5b23bfd07a41c4c31a2d7c6fdcf9' for key 'PRIMARY'
L 10/30/2021 - 00:42:13: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8-Epedimack-^1ImmortlOLD-VALVE_XASH_931861d293c2d247c43e5e6b7f2' for key 'PRIMARY'
L 10/30/2021 - 00:45:40: [CS:GO Clans] Query failed. [1062] Duplicate entry '^5PatienceClips YT-VALVE_XASH_9587e1e496c6762d4047de937c620c24' for key 'PRIMARY'
L 10/30/2021 - 00:51:01: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8-Epedimack-^1ImmortlOLD-VALVE_XASH_931861d293c2d247c43e5e6b7f2' for key 'PRIMARY'
L 10/30/2021 - 01:10:14: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1Youtube ^2iVqnir-VALVE_XASH_e8ff2b48519b5655b0f96b9ee9fa2723' for key 'PRIMARY'
L 10/30/2021 - 02:00:31: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8-Epedimack-^1ImmortlOLD-VALVE_XASH_931861d293c2d247c43e5e6b7f2' for key 'PRIMARY'
L 10/30/2021 - 03:06:39: [CS:GO Clans] Query failed. [1062] Duplicate entry 'stonz_lox-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/30/2021 - 04:01:15: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1sai_-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/30/2021 - 04:49:34: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8-Epedimack-^1ImmortlOLD-VALVE_XASH_931861d293c2d247c43e5e6b7f2' for key 'PRIMARY'
L 10/30/2021 - 05:25:09: [CS:GO Clans] Query failed. [1062] Duplicate entry 'stonz_lox-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/30/2021 - 05:42:08: [CS:GO Clans] Query failed. [1062] Duplicate entry '^0x_infernuZ^1' King_|DaRk-VALVE_XASH_a41c84cbd075639766e63e01cd' for key 'PRIMARY'
L 10/30/2021 - 05:46:05: [CS:GO Clans] Query failed. [1062] Duplicate entry '^0x_infernuZ^1' King_|DaRk-VALVE_XASH_a41c84cbd075639766e63e01cd' for key 'PRIMARY'
L 10/30/2021 - 06:25:51: [CS:GO Clans] Query failed. [1062] Duplicate entry '^0x_infernuZ^1' King_|DaRk-VALVE_XASH_a41c84cbd075639766e63e01cd' for key 'PRIMARY'
L 10/30/2021 - 06:28:35: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8-Epedimack-^1ImmortlOLD-VALVE_XASH_931861d293c2d247c43e5e6b7f2' for key 'PRIMARY'
L 10/30/2021 - 06:30:42: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8-Epedimack-^1ImmortlOLD-VALVE_XASH_931861d293c2d247c43e5e6b7f2' for key 'PRIMARY'
L 10/30/2021 - 07:13:32: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8-Epedimack-^1ImmortlOLD-VALVE_XASH_931861d293c2d247c43e5e6b7f2' for key 'PRIMARY'
L 10/30/2021 - 07:54:57: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8-Epedimack-^1ImmortlOLD-VALVE_XASH_931861d293c2d247c43e5e6b7f2' for key 'PRIMARY'
L 10/30/2021 - 07:57:08: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1sai_-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/30/2021 - 08:14:14: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1sai_-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/30/2021 - 08:20:49: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8-Epedimack-^1ImmortlOLD-VALVE_XASH_931861d293c2d247c43e5e6b7f2' for key 'PRIMARY'
L 10/30/2021 - 11:10:13: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1sai_-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/30/2021 - 11:37:37: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1sai-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/30/2021 - 11:45:42: [CS:GO Clans] Query failed. [1062] Duplicate entry '^1F^-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/30/2021 - 16:39:22: [CS:GO Clans] Query failed. [1062] Duplicate entry '^6Sefyn-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/30/2021 - 16:50:01: [CS:GO Clans] Query failed. [1062] Duplicate entry '^7Fan ^4Cxr-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/30/2021 - 23:26:48: [CS:GO Clans] Query failed. [1062] Duplicate entry '^8-Epedimack-^1ImmortlOLD-VALVE_XASH_931861d293c2d247c43e5e6b7f2' for key 'PRIMARY'
L 10/31/2021 - 01:54:21: [CS:GO Clans] Query failed. [1062] Duplicate entry 'SHI    NO    NUMA-VALVE_XASH_050ce0cb1d0142ed005c73bf2ec36163' for key 'PRIMARY'
L 10/31/2021 - 07:09:09: [CS:GO Clans] Query failed. [1062] Duplicate entry 'L1QUID^0|^1sai_-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/31/2021 - 07:18:46: [CS:GO Clans] Query failed. [1062] Duplicate entry 'L1QUID^0|^1sai_-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/31/2021 - 07:39:26: [CS:GO Clans] Query failed. [1062] Duplicate entry '^6oo^1-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/31/2021 - 11:27:26: [CS:GO Clans] Query failed. [1062] Duplicate entry '^6oo^1-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'
L 10/31/2021 - 11:29:12: [CS:GO Clans] Query failed. [1062] Duplicate entry '^6oo^1-VALVE_XASH_93bbebab5b65847e5bd56b90cc52c5d1' for key 'PRIMARY'```
TheDoctor0 commented 2 years ago

@Czarintax, did you change the query that adds a row to the csgo_clans_members table? By using INSERT IGNORE INTO instead of INSERT INTO you can fix this error.

TheDoctor0 commented 2 years ago

Quick question that I forgot to ask. I have a server on pukawka.pl. Do you think, there might be a problem with the server itself which is causing all the slow loading? @Happy2906, I haven't used Pukawka in a while but if they cut corners by reducing the resources available for MySQL servers that they offer, then it may be a reason why it's working so slow on your server.

You can try to migrate just the database to another provider and compare the performance. If you have a forum running on MySQL database you can even try to use it as a test.

Btw, I have a question for you: why are you still using the older version of the mod? If you don't want submodels you can disable them inside a core plugin and use it as in 1.4 and below.

// Uncomment to disable support for skins based on submodels
//#define DISABLE_SUBMODELS
czarintax commented 2 years ago

@Czarintax, did you change the query that adds a row to the csgo_clans_members table? By using INSERT IGNORE INTO instead of INSERT INTO you can fix this error.

Hey @TheDoctor0

The query was already set to INSERT IGNORE INTO as default.

Is there any other solution?

I'm using MySQL ver 5.7.34

Thanks in advance!

TheDoctor0 commented 2 years ago

@Czarintax do you have any other INSERT queries? With INSERT IGNORE MySQL only generated a warning, not an error and that should not cause the query to fail.

czarintax commented 2 years ago

@Czarintax do you have any other INSERT queries? With INSERT IGNORE MySQL only generated a warning, not an error and that should not cause the query to fail.

You mean inside the same function?

The query for csgo_clans_applications is also declared as INSERT IGNORE

public load_clan_data_handle(failState, Handle:query, error[], errorNum, tempId[], dataSize)
{
    if (failState) {
        log_to_file("csgo-error.log", "[CS:GO Clans] Data SQL Error: %s (%d)", error, errorNum);

        return;
    }

    new id = tempId[0];

    if (SQL_MoreResults(query)) {
        new csgoClan[clanInfo];

        csgoClan[CLAN_ID] = SQL_ReadResult(query, SQL_FieldNameToNum(query, "id"));

        if (!check_clan_loaded(csgoClan[CLAN_ID])) {
            SQL_ReadResult(query, SQL_FieldNameToNum(query, "name"), csgoClan[CLAN_NAME], charsmax(csgoClan[CLAN_NAME]));

            csgoClan[CLAN_LEVEL] = SQL_ReadResult(query, SQL_FieldNameToNum(query, "level"));
            csgoClan[CLAN_KILLS] = SQL_ReadResult(query, SQL_FieldNameToNum(query, "kills"));
            csgoClan[CLAN_WINS] = SQL_ReadResult(query, SQL_FieldNameToNum(query, "wins"));
            csgoClan[CLAN_MEMBERS] = SQL_ReadResult(query, SQL_FieldNameToNum(query, "members"));

            SQL_ReadResult(query, SQL_FieldNameToNum(query, "money"), csgoClan[CLAN_MONEY]);

            csgoClan[CLAN_STATUS] = _:TrieCreate();

            ArrayPushArray(csgoClans, csgoClan);

            new queryData[192];

            formatex(queryData, charsmax(queryData), "SELECT * FROM `csgo_clans_wars` WHERE clan = '%i' AND started = '1'", csgoClan[CLAN_ID]);

            SQL_ThreadQuery(sql, "load_wars_data_handle", queryData);
        }

        playerData[id][CLAN] = csgoClan[CLAN_ID];

        new status = SQL_ReadResult(query, SQL_FieldNameToNum(query, "flag"));

        switch (saveType) {
            case SAVE_NAME: TrieSetCell(Trie:get_clan_info(playerData[id][CLAN], CLAN_STATUS), playerData[id][NAME], status);
            case SAVE_XASH_ID: {
                TrieSetCell(Trie:get_clan_info(playerData[id][CLAN], CLAN_STATUS), playerData[id][XASH_ID], status);

                new playerName[32];

                SQL_ReadResult(query, SQL_FieldNameToNum(query, "nick"), playerName, charsmax(playerName));

                if (!equal(playerData[id][NAME], playerName)) {
                    new queryData[512];

                    formatex(queryData, charsmax(queryData), "UPDATE `csgo_clans_members` SET `name` = ^"%s^" WHERE `xashid` = ^"%s^"", playerData[id][SAFE_NAME], playerData[id][XASH_ID]);

                    SQL_ThreadQuery(sql, "ignore_handle", queryData);

                    formatex(queryData, charsmax(queryData), "UPDATE `csgo_clans_applications` SET `name` = ^"%s^" WHERE `xashid` = ^"%s^"", playerData[id][SAFE_NAME], playerData[id][XASH_ID]);

                    SQL_ThreadQuery(sql, "ignore_handle", queryData);
                }
            }
        }
    } else {
        new queryData[512];

        formatex(queryData, charsmax(queryData), "INSERT IGNORE INTO `csgo_clans_members` (`name`, `xashid`) VALUES (^"%s^", ^"%s^")", playerData[id][SAFE_NAME], playerData[id][XASH_ID]);

        SQL_ThreadQuery(sql, "ignore_handle", queryData);
    }

    set_bit(id, loaded);
}

csgo_clans.zip

Happy2906 commented 2 years ago

You can try to migrate just the database to another provider and compare the performance. If you have a forum running on MySQL database you can even try to use it as a test.

I have tested the server on multiple databases. I have switched all the plugins to version 1.4 and everything seems to be working fine. My server is currently connected to database on cyberfolks hosting and I can't see anymore problems with the accounts system and I also did not get any complaints from the players. One thing I have noticed, which is to do with the database as well ( I think), is that in the first round, not all skins are loading. After the first round, everything goes back to normal. Do you think, I should add all the indexes to the database that you have provided above ? Is this going to help even in the smallest percentage?

Btw, I have a question for you: why are you still using the older version of the mod?

I am using the older version as I have edited some of your plugins, just to make my players more happier and give them what they wanted. I had the latest version a year ago for almost a month, and there was this bug with all the skins when you were observing a player so I decided that I will move back to the previous version. There was few more minor problems / bugs with the mod, so I decided that I cannot risk to lose most of my players. Don't get me wrong, I still appreciate your effort that you have put into mod and I hope it's only going to get better.

I have the latest version installed on my Dev server, so if I find anything unusual, I will let you know.

Wish you all the best!

Happy2906 commented 2 years ago

Seems like the problem is sorted out when I switched to version 1.4. You can close the issue.

Thanks for your help, much appreciated 👍

czarintax commented 2 years ago

Happy to hear your problem was resolved!

Still, no solution to my problem though ^^

TheDoctor0 commented 2 years ago

Hello again @Czarintax! Sorry for the long wait, currently I have very limited time, so the CS:GO mod is pretty much on hold.

Regarding your issue, I assume that your MySQL is running in a strict mode and a warning from INSERT IGNORE INTO query is being reported as an error. You can try to change the query to:

formatex(queryData, charsmax(queryData), "INSERT INTO `csgo_clans_members` (`name`, `xashid`) VALUES (^"%s^", ^"%s^") ON DUPLICATE KEY UPDATE name=name", playerData[id][SAFE_NAME], playerData[id][XASH_ID]);
czarintax commented 2 years ago

Hello again @Czarintax! Sorry for the long wait, currently I have very limited time, so the CS:GO mod is pretty much on hold.

Regarding your issue, I assume that your MySQL is running in a strict mode and a warning from INSERT IGNORE INTO query is being reported as an error. You can try to change the query to:

formatex(queryData, charsmax(queryData), "INSERT INTO `csgo_clans_members` (`name`, `xashid`) VALUES (^"%s^", ^"%s^") ON DUPLICATE KEY UPDATE name=name", playerData[id][SAFE_NAME], playerData[id][XASH_ID]);

Hi! Thanks for your reply.

I've tried your solution but now i'm getting another error:

[CS:GO Clans] Query failed. [1364] Field 'clan' doesn't have a default value

TheDoctor0 commented 2 years ago

@Czarintax, I checked the table structure and yes, the clan field does not have a default value. In that case, you can try with:

INSERT INTO `csgo_clans_members` (`name`, `xashid`, `clan`) VALUES (^"%s^", ^"%s^", 0) ON DUPLICATE KEY UPDATE name=name
czarintax commented 2 years ago

@Czarintax, I checked the table structure and yes, the clan field does not have a default value. In that case, you can try with:

INSERT INTO `csgo_clans_members` (`name`, `xashid`, `clan`) VALUES (^"%s^", ^"%s^", 0) ON DUPLICATE KEY UPDATE name=name

Thank you, I will try it out and observe if the first error occurs again.

czarintax commented 2 years ago

I sadly have to inform that the error is still continues to occur.

TheDoctor0 commented 2 years ago

@Czarintax, I must say that it is really weird that those warnings are still being treated as errors - even after those query changes.

MySQL 5.7 is the first version with strict mode enabled by default and that's what causes these problems. You can either try to disable it or just ignore those "errors" as those have no real effect.

czarintax commented 2 years ago

@Czarintax, I must say that it is really weird that those warnings are still being treated as errors - even after those query changes.

MySQL 5.7 is the first version with strict mode enabled by default and that's what causes these problems. You can either try to disable it or just ignore those "errors" as those have no real effect.

Yes, i have disabled strict mode and the error disappeared. But that's not the actual case i guess, players are still facing the same problem. Not always but oftenly; when they create or join a clan, they're no longer a member when they reconnect to the server. The clan still exists in the database, but with 0 members.