Csstatsx_sql SQL query failed

[Stas]

Ошибка

L 05/22/2019 - 18:07:13: [csstatsx_sql.amxx] SQL query failed
L 05/22/2019 - 18:07:13: [csstatsx_sql.amxx] [ 1104 ] The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay
L 05/22/2019 - 18:07:13: [csstatsx_sql.amxx] [ SQL ] DELETE `csstats`,`csstats_weapons`,`csstats_maps` FROM `csstats`LEFT JOIN `csstats_weapons` ON `csstats`.`id` = `csstats_weapons`.`player_id`LEFT JOIN `csstats_maps` ON `csstats`.`id` = `csstats_maps`.`player_id`WHERE `csstats`.`last_join` <= DATE_SUB(NOW(),INTERVAL 50 DAY);

ОС

Linux

Amx Mod X

AMX Mod X 1.9.0.5247

Билд

ReHLDS version: 3.6.0.671-dev

ReGamedll

ReGameDLL version: 5.7.0.330-dev

Версия Metamod

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

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

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

 [ 2] ReAuthCheck      RUN   -    reauthcheck_mm_i386.so                   v0.1.6          ini  Start Never

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

 [ 4] VoiceTranscoder  RUN   -    VoiceTranscoder.so                       v2017RC3        ini  ANY   ANY  

 [ 5] AMX Mod X        RUN   -    amxmodx_mm_i386.so                       v1.9.0.5247     ini  Start ANY  

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

 [ 7] WHBlocker        RUN   -    whblocker_mm_i386.so                     v1.5.696        ini  Chlvl ANY  

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

 [ 9] VTC AMXX API     RUN   -    VoiceTranscoderApiProvider_amxx_i386.so  v2017 RC        pl5  ANY   ANY  

 [10] ReAPI            RUN   -    reapi_amxx_i386.so                       v5.8.0.166-dev  pl5  ANY   Never

 [11] ReAimDetector    RUN   -    reaimdetector_amxx_i386.so               v0.2.2          pl5  ANY   Never

 [12] MySQL            RUN   -    mysql_amxx_i386.so                       v1.9.0.5247     pl5  ANY   ANY  

 [13] ReFullSlot       RUN   -    refullslot_amxx_i386.so                  v1.2            pl5  ANY   Never

 [14] SQLite           RUN   -    sqlite_amxx_i386.so                      v1.9.0.5247     pl5  ANY   ANY  

 [15] FakeMeta         RUN   -    fakemeta_amxx_i386.so                    v1.9.0.5247     pl5  ANY   ANY  

 [16] Ham Sandwich     RUN   -    hamsandwich_amxx_i386.so                 v1.9.0.5247     pl5  ANY   ANY  

 [17] Engine           RUN   -    engine_amxx_i386.so                      v1.9.0.5247     pl5  ANY   ANY  

 [18] CStrike          RUN   -    cstrike_amxx_i386.so                     v1.9.0.5247     pl5  ANY   ANY  

18 plugins, 18 running

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

[  1] Admin Loader            3.5         neygomon          admin_loader.am  running  

 [  2] DopBan                  3.0.3b      kanagava          dop_ban.amxx     running  

 [  3] FreshBans               1.4.0b      kanagava          fresh_bans_140.  running  

 [  4] ScreenMaker             1.1         neygomon          screen_maker.am  running  

 [  5] WebHS                   0.1         kanagava          fb_web_online.a  running  

 [  6] ReAimDetector API       0.2.1       ReHLDS Team       reaimdetector.a  running  

 [  7] Advanced Client Checke  0.3.6       Mistrick          cmdchecker.amxx  running  

 [  8] Ultimate Chats Control  4.7         neygomon          ucc.amxx         running  

 [  9] Advanced Experience Sy  0.5.9 [REA  serfreeman1337/s  aes_main.amxx    running  

 [ 10] AES: CStrike Addon      0.5.9 [REA  serfreeman1337/s  aes_exp_cstrike  running  

 [ 11] AES: Admin Tools        0.5.9 [REA  serfreeman1337/s  aes_exp_editor.  running  

 [ 12] AES: StatsX             0.5+1       serfreeman1337    aes_statsx_cstr  running  

 [ 13] AES: Informer           0.5.9 [REA  serfreeman1337/s  aes_informer.am  running  

 [ 14] Info Rank               0.4.5+1     ConnorMcLeod + i  info_rank.amxx   running  

 [ 15] CSStatsX SQL            0.7.4+2     serfreeman1337    csstatsx_sql.am  running  

 [ 16] Test Vip                0.1         ill               testvip_sql.amx  running  

 [ 17] [ReAPI]Vip Weapons      3.5         ill               Vip_Weapons.amx  running  

 [ 18] Vip drop take block     1.5         bionext           vip_drop_take_b  running  

 [ 19] Night Damager_Parashut  1.0         ill               NightLiteVip.am  stopped  

 [ 20] No Players Map          0.1         X-factor          no_players_map.  stopped  

 [ 21] Map Manager: Core       3.0.0       Mistrick          map_manager_cor  running  

 [ 22] Map Manager: Scheduler  0.1.0       Mistrick          map_manager_sch  running  

 [ 23] Map Manager: Rtv        0.0.4       Mistrick          map_manager_rtv  running  

 [ 24] Map Manager: Nominatio  0.0.8       Mistrick          map_manager_nom  running  

 [ 25] Map Manager: BlockList  0.0.3       Mistrick          map_manager_blo  running  

 [ 26] Map Manager: Online so  0.0.2       Mistrick          map_manager_onl  running  

 [ 27] Map Manager: Effects    0.0.8       Mistrick          map_manager_eff  running  

 [ 28] Map Manager: Informer   0.0.5       Mistrick          map_manager_inf  running  

 [ 29] Map Manager: Advanced   0.0.4       Mistrick          map_manager_adv  running  

 [ 30] MM block ext            0.0.1       dev-cs            map_manager_blo  running  

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

 [ 32] Menus Front-End         1.5         neugomon          menufront_end.a  running  

 [ 33] Admin Commands          1.9.0.5241  AMXX Dev Team     admincmd.amxx    running  

 [ 34] Players Menu            1.7         neugomon          players_menu.am  running  

 [ 35] Maps Menu               1.4.1+1     neugomon          mapsmenu.amxx    running  

 [ 36] Say me and Say hp       1.4         neygomon          sayme.amxx       running  

 [ 37] Stats Configuration     1.9.0.5241  AMXX Dev Team     statscfg.amxx    running  

 [ 38] CS Stats Logging        1.9.0.5241  AMXX Dev Team     stats_logging.a  running  

 [ 39] AdminFreeLook           1.0         ReHLDS Team       adminfreelook.a  running  

 [ 40] Lite Admin ESP          1.0         neygomon          admin_esp.amxx   running  

 [ 41] Ping Control            1.31        neygomon          Ping_Control.am  running  

 [ 42] Admin Models            1.2         pUzzlik           admin_models_v1  running  

 [ 43] resetscore(ReAPI)       1.0         Phantom           resetscore.amxx  running  

 [ 44] Weapon Restrict         1.7         s1lent            weapon_rest.amx  running  

 [ 45] Advert Messages         1.22        neygomon          adverts.amxx     running  

 [ 46] Demo Recorder           2.4.0       F@nt0M            demo_recorder.a  running  

 [ 47] Kills Counter           1.0         Safety1st         killscounter.am  running  

 [ 48] SF Warn Menu            0.1.4f      serfreeman1337    sf_admin_warns.  running  

 [ 49] AFK Control             1.4.1 [Rnd  neygomon          afk_control.amx  running  

 [ 50] Block Advert            1.4         neygomon          block_advert.am  running  

 [ 51] Flash Control           2.2         neygomon          flash_control.a  running  

 [ 52] Auto Team Balance Adva  1.5.1       Radius            auto_team_balan  running  

 [ 53] GameName Changer        1.0         neugomon          gamename_change  running  

 [ 54] [ReAPI] AWPoff          1.4.3       PAffAEJIkA :3     awp_off.amxx     running  

 [ 55] Killer ScreenFade       0.0.5       Vaqtincha         reapi_killer_sc  running  

 [ 56] Yet Another Voteban     1.8         AndrewZ/voed      yet_another_vot  running  

 [ 57] [ReAPI] Random Weapons  2.4.9       neugomon/h1k3     random_weapons_  running  

 [ 58] Custom Smoke            1.07        bionext           custom_smoke.am  running  

 [ 59] Lite Translit           2.8+3       neygomon          lite_translit.a  running  

 [ 60] Time Pause Plugins      1.0         maFFyoZZyk & Mak  time_pause_plug  running  

60 plugins, 58 running

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

serfreeman1337

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

CSstatsX SQL 0.7.4+2

Исходный код

Прикреплен

Вчера обновил плагин. Сначала все запустилось и работало несколько карт даже со старой статой. После выдало ошибку эту, ну я подумал, что нужно снести таблицы из БД. Сбросил стату, все с нуля. Все работало нормально почти сутки. Щас вот снова ошибка. Что не так, народ?
В старой стате не включал стату по картам. После обновления включил и таблицу из архива импортировал.

 

[BlackSignature]

serfreeman1337

 

[serfreeman1337]

Попробуй выполнить этот SQL запрос в БД:

CREATE INDEX player_id ON csstats_weapons (player_id);
CREATE INDEX player_id ON csstats_maps (player_id);

Спойлер: Если не помогло

отредактировать строчку #1375:

-- que_len += formatex(query[que_len],charsmax(query) - que_len,"DELETE `%s`",
++ que_len += formatex(query[que_len],charsmax(query) - que_len,"SET SQL_BIG_SELECTS=1;DELETE `%s`",

 

[Stas]

serfreeman1337, выполнил запрос:

CREATE INDEX player_id ON csstats_weapons(
player_id
);# MySQL вернула пустой результат (т.е. ноль строк).
CREATE INDEX player_id ON csstats_maps(
player_id
);# MySQL вернула пустой результат (т.е. ноль строк).

Перезагрузил сервак, пока что работает.