CSStatx SQL: Про

S

Somon007

Сообщения
32
Реакции
1
Ошибка
L 10/29/2024 - 19:05:49: [csstatsx_sql.amxx] SQL query failed
L 10/29/2024 - 19:05:49: [csstatsx_sql.amxx] [ 1067 ] Invalid default value for 'last_join'
L 10/29/2024 - 19:05:49: [csstatsx_sql.amxx] [ SQL ] CREATE TABLE IF NOT EXISTS `csstats` (`id` int(11) NOT NULL AUTO_INCREMENT,`steamid` varchar(30) NOT NULL,`name` varchar(32) NOT NULL,`ip` varchar(16) NOT NULL,`skill` float NOT NULL DEFAULT '0.0',`kills` int(11) NOT NULL DEFAULT '0',`deaths` int(11) NOT NULL DEFAULT '0',`hs` int(11) NOT NULL DEFAULT '0',`tks` int(11) NOT NULL DEFAULT '0',`shots` int(11) NOT NULL DEFAULT '0',`hits` int(11) NOT NULL DEFAULT '0',`dmg` int(11) NOT NULL DEFAULT '0',`bombdef` int(11) NOT NULL DEFAULT '0',`bombdefused` int(11) NOT NULL DEFAULT '0',`bombplants` int(11) NOT NULL DEFAULT '0',`bombexplosions` int(11) NOT NULL DEFAULT '0',`h_0` int(11) NOT NULL DEFAULT '0',`h_1` int(11) NOT NULL DEFAULT '0',`h_2` int(11) NOT NULL DEFAULT '0',`h_3` int(11) NOT NULL DEFAULT '0',`h_4` int(11) NOT NULL DEFAULT '0',`h_5` int(11) NOT NULL DEFAULT '0',`h_6` int(11) NOT NULL DEFAULT '0',`h_7` int(11) NOT NULL DEFAULT '0',`connection_time` int(11) NOT NULL DEFAULT '0',`connects` int(11) NOT NULL DEFAULT '0',`roundt` int(11) NOT NULL DEFAULT '0',`wint` int(11) NOT NULL DEFAULT '0',`roundct` int(11) NOT NULL DEFAULT '0',`winct` int(11) NOT NULL DEFAULT '0',`assists` int(11) NOT NULL DEFAULT '0',`first_join` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,`last_join` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',`session_id` int(11) DEFAULT NULL,`session_map` varchar(32) DEFAULT NULL,PRIMARY KEY (id),KEY `steamid` (`steamid`(16)),KEY `name` (`name`(16)),KEY `ip` (`ip`)) DEFAULT CHARSET=
ОС
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
Билд
Protocol version 48

Exe version 1.1.2.7/Stdio (cstrike)

ReHLDS version: 3.13.0.788-dev

Build date: 07:36:33 Jul 12 2023 (3378)

Build from: https://github.com/dreamstalker/rehlds/commit/f955b07
ReGamedll
ReGameDLL version: 5.26.0.668-dev

Build date: 19:02:48 Dec 31 2023

Build from: https://github.com/s1lentq/ReGameDLL_CS/commit/d3c0ec8
Версия Metamod
Metamod v1.21p37  2013/05/30 (5:13)

by Will Day

   http://www.metamod.org/

 Patch: Metamod-P (mm-p) v37

 by Jussi Kivilinna

    http://metamod-p.sourceforge.net/

compiled: May 30 2013, 11:41:16 EET (optimized)
Список метамодулей
[ 1] SafeNameAndChat  RUN   -    SafeNameAndChat.  v1.2 Bet  ini   ANY   ANY

 [ 2] Reunion          RUN   -    reunion_0.1.0.92  v0.1.92d  ini   Start Never

 [ 3] ReAuthCheck      RUN   -    reauthcheck_mm_i  v0.1.6    ini   Start Never

 [ 4] VoiceTranscoder  RUN   -    VoiceTranscoder.  v2017RC5  ini   ANY   ANY

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

 [ 6] Rechecker        RUN   -    rechecker_mm_i38  v2.7      ini   Chlvl ANY

 [ 7] WHBlocker        RUN   -    whblocker_mm_i38  v1.5.697  ini   Chlvl ANY

 [ 8] ReSemiclip       RUN   -    resemiclip_mm_i3  v2.4.3    ini   Chlvl ANY

 [ 9] HitBox Fix       RUN   -    hitbox_fix_mm_i3  v1.1.5    ini   Start ANY

 [10] AGuard           RUN   -    AGuard_mm_i386.s  v1.6      ini   Chlvl Never

 [11] mmtimer          fail load  mmtimer_i386.so   v1.6      ini   ANY   Never

 [12] YaPB             RUN   -    yapb.so           v4.3.734  ini   Chlvl ANY

 [13] CStrike          RUN   -    cstrike_amxx_i38  v1.9.0.5  pl5   ANY   ANY

 [14] MySQL            RUN   -    mysql_amxx_i386.  v1.9.0.5  pl5   ANY   ANY

 [15] SQLite           RUN   -    sqlite_amxx_i386  v1.9.0.5  pl5   ANY   ANY

 [16] ReAPI            RUN   -    reapi_amxx_i386.  v5.24.0.  pl5   ANY   Never

 [17] ReAimDetector    RUN   -    reaimdetector_am  v0.2.2    pl5   ANY   Never

 [18] FakeMeta         RUN   -    fakemeta_amxx_i3  v1.9.0.5  pl5   ANY   ANY

 [19] Fun              RUN   -    fun_amxx_i386.so  v1.9.0.5  pl5   ANY   ANY

 [20] Ham Sandwich     RUN   -    hamsandwich_amxx  v1.9.0.5  pl5   ANY   ANY

 [21] CSX              RUN   -    csx_amxx_i386.so  v1.9.0.5  pl5   ANY   ANY

 [22] Engine           RUN   -    engine_amxx_i386  v1.9.0.5  pl5   ANY   ANY

 [23] ReCSDM           RUN   -    csdm_amxx_i386.s  v3.6      pl5   ANY   ANY
Список плагинов
name                    version     author            file             status

 [  1] AMXBans: Core           Gm 1.6      Larte Team        amxbans_core.am  running

 [  2] AMXBans: Main           Gm 1.6      Larte Team        amxbans_main.am  running

 [  3] AMXBans: Freeze         Gm 1.6      Larte Team        amxbans_freeze.  running

 [  4] AMXBans: Flagged        Gm 1.6      Larte Team        amxbans_flagged  running

 [  5] AMXBans: Screens        Gm 1.6      Larte Team        amxbans_ssban.a  running

 [  6] FreshBans               1.4.8b      kanagava          fresh_bans_148-  running

 [  7] [VIP] Models            1.0.0       @emmajule         vip_models.amxx  running

 [  8] ChangeModel (free) for  1.0         Pain96            z_changemodels.  running

 [  9] AES: VIP&ADMIN Flags A  1.0         t3ddy             z_admin_top.amx  running

 [ 10] Camera Changer          1.3         Bl0ck             Camera_Changer.  running

 [ 11] Spam & Mat Control      0.4         Freedo.m          sm_control.amxx  running

 [ 12] Hats                    1.0         trofian           hat.amxx         running

 [ 13] Reset Score             0.2         Silenttt / CepeH  z_rs.amxx        running

 [ 14] AES: Shoulder Marks     0.1         serfreeman1337    army_scapular.a  running

 [ 15] xREDIRECT               1.0.4b      x0R               xredirect-beta.  running

 [ 16] Register System         5.0         m0skVi4a ;]       RegisterSystem.  running

 [ 17] Back Weapons            1.1         Cheap_Suit        backweapons.amx  running

 [ 18] AutoGameMenu            1.0         t3ddy [csaden.ru  z_game_menu.amx  running

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

 [ 20] Advanced Gag            1.9.0       neygomon          amx_gag.amxx     running

 [ 21] Scrolling Message       1.9.0.5294  AMXX Dev Team     scrollmsg.amxx   running

 [ 22] Info. Messages          1.9.0.5294  AMXX Dev Team     imessage.amxx    running

 [ 23] VOTEBAN_BY_SLIMSHADY    3.0         SLIMSHADY_MOD     voteban_by_slim  running

 [ 24] Best Player Notice      1.0         Leo_[BH]          best_player_not  running

 [ 25] Admin Commands          1.9.0.5271  AMXX Dev Team     admincmd.amxx    running

 [ 26] Admin Chat              1.10.0.546  AMXX Dev Team     adminchat.amxx   running

 [ 27] Admin Votes             1.9.0.5294  AMXX Dev Team     adminvote.amxx   running

 [ 28] Admin Help              1.9.0.5271  AMXX Dev Team     adminhelp.amxx   running

 [ 29] Slots Reservation       1.9.0.5294  AMXX Dev Team     adminslots.amxx  running

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

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

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

 [ 33] Teleport Menu           1.9.0.5294  AMXX Dev Team     telemenu.amxx    running

 [ 34] Punisher-Mod            0.1         {HOJ} Batman(edi  unlimitedAmmo.a  running

 [ 35] Maps Menu               1.9.0.5271  AMXX Dev Team     mapsmenu.amxx    running

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

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

 [ 38] Server Menu             1.0         CrAsH             server_menu.amx  running

 [ 39] Block Commands          0.0.2       Albertio          block_commands.  running

 [ 40] Game Namer              1.1         NeuroToxin        game_name_chang  running

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

 [ 42] Invisible Spectator     1.0         ReHLDS Team       invisible_spect  running

 [ 43] fb_forwards             0.1.8       Mazdan & Neugomo  fb_forwards.amx  running

 [ 44] Vampire                 1.0c        Shalfey           vampire.amxx     running

 [ 45] Ping Faker              1.5a        MeRcyLeZZ         pingfaker.amxx   running

 [ 46] AFK Control             2.1.0       @emmajule         afk_control.amx  debug

 [ 47] Ping Control            1.2         mx?!              ping_control.am  running

 [ 48] Show Damage             1.0         neygomon          damager.amxx     running

 [ 49] Autobinds               1.0         t3ddy [csaden.ru  z_autobinds.amx  running

 [ 50] Admin Groups            1.2         OciXCrom          crx_admingroups  running

 [ 51] Reklama                 20.05.2020  mx?!              reklama.amxx     running

 [ 52] Hostname Timeleft       1.0         xPaw              HostnameTimelef  running

 [ 53] HUD_Adverts             1.3.1       pUzzlik           hud_adverts.amx  running

 [ 54] Weapon Icon             1.2         hoboman313/Zenix  weapon_icon.amx  running

 [ 55] Ultimate Gore           1.5         JTP10181          amx_gore_ultima  running

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

 [ 57] Advanced Experience Sy  0.5 Vega    serfreeman1337    aes_main.amxx    running

 [ 58] AES: CStrike Addon      0.5 Vega    serfreeman1337    aes_exp_cstrike  running

 [ 59] AES: Informer           0.5 Vega    serfreeman1337    aes_informer.am  running

 [ 60] AES: Admin Tools        0.5 Vega    serfreeman1337    aes_exp_editor.  running

 [ 61] MEDAL TOP CSADEN        1.0         t3ddy             top_medal.amxx   running

 [ 62] AES: HUD Player Info    1.0         t3ddy [csaden.ru  aes_hud_info_t3  running

 [ 63] AES: Player Menu        1.0         t3ddy             aes_help_menu.a  running

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

 [ 65] Killa HP                1.6         jas0n             killa_hp_v2.amx  running

 [ 66] AES: Status Rank Info   1.0         t3ddy [csaden.ru  z_status.amxx    running

 [ 67] Map Manager: Core       3.1.4       Mistrick          map_manager_cor  running

 [ 68] Map Manager: Scheduler  0.1.9       Mistrick          map_manager_sch  running

 [ 69] Map Manager: Rtv        0.1.1       Mistrick          map_manager_rtv  running

 [ 70] Map Manager: Nominatio  0.2.0       Mistrick          map_manager_nom  running

 [ 71] Map Manager: Effects    0.1.0       Mistrick          map_manager_eff  running

 [ 72] Map Manager: Informer   0.0.5       Mistrick          map_manager_inf  running

 [ 73] Map Manager: Sounds     0.0.1       Mistrick          map_manager_sou  running

 [ 74] Map Manager: BlockList  0.0.4       Mistrick          map_manager_blo  running

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

 [ 76] Chat Manager            1.1.2-16    Mistrick          chatmanager.amx  running

 [ 77] Map Spawns Editor       1.0.16      iG_os             map_spawns_edit  running

 [ 78] FullSpawns              1.0         Eg@r4$il{         FullSpawns.amxx  running

 [ 79] Ultimate Sounds         1.7         Dizzy / Bmann_42  ultimate_sounds  running

 [ 80] Grenade Trail           1.0         Jim               grenade_trail.a  running

 [ 81] Advanced Tracers        0.1         [email protected]  advanced_tracer  running

 [ 82] AES: Status Info        0.1         serfreeman1337    aes_status_info  running

 [ 83] ReCSDM Main             3.6         ReCSDM Team       csdm_main.amxx   running

 [ 84] CSDM Equip              2.1.1       CSDM Team         csdm_equip.amxx  running

 [ 85] CSDM Mod                2.1.1       CSDM Team         csdm_spawn_pres  running

 [ 86] ReCSDM Misc             3.6         ReCSDM Team       csdm_misc.amxx   running

 [ 87] ReCSDM Protection       3.6         BAILOPAN          csdm_protection  running

 [ 88] ReCSDM FFA              3.6         ReCSDM Team       csdm_ffa.amxx    running

 [ 89] CSDM Spawn Editor       2.1.1       CSDM Team         spawn_editor.am  running

89 plugins, 89 running
Автор плагина
serfreeman1337
Версия плагина
0.7.4+2fix
Исходный код
закреплен
Перенес сервер с Windows на Linux/Ubuntu Dekstop. Установил MySQL 8.0 версии так как старую версию не как не смог установить. Теперь проблема в том что при подключении к базе данных (или импорта) таблицы csstatsx выходить ошибка:

L 10/29/2024 - 19:18:54: [csstatsx_sql.amxx] SQL query failed
L 10/29/2024 - 19:18:54: [csstatsx_sql.amxx] [ 1067 ] Invalid default value for 'last_join'
L 10/29/2024 - 19:18:54: [csstatsx_sql.amxx] [ SQL ] CREATE TABLE IF NOT EXISTS csstats (id int(11) NOT NULL AUTO_INCREMENT,steamid varchar(30) NOT NULL,name varchar(32) NOT NULL,ip varchar(16) NOT NULL,skill float NOT NULL DEFAULT '0.0',kills int(11) NOT NULL DEFAULT '0',deaths int(11) NOT NULL DEFAULT '0',hs int(11) NOT NULL DEFAULT '0',tks int(11) NOT NULL

Кто сталкивался с данной проблемой? Как решить эту проблему?
 
В этой теме было размещено решение! Перейти к решению.

Вложения

D1esel

D1esel

Сообщения
168
Реакции
51
Помог
6 раз(а)
удали если есть таблицу csstats
и создай ее заново следующим запросом
Код: 
CREATE TABLE `csstats` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `steamid` varchar(30) NOT NULL,
    `name` varchar(32) NOT NULL,
    `ip` varchar(16) NOT NULL,
    `skill` float NOT NULL DEFAULT '0.0',
    `kills` int(11) NOT NULL DEFAULT '0',
    `deaths` int(11) NOT NULL DEFAULT '0',
    `hs` int(11) NOT NULL DEFAULT '0',
    `tks` int(11) NOT NULL DEFAULT '0',
    `shots` int(11) NOT NULL DEFAULT '0',
    `hits` int(11) NOT NULL DEFAULT '0',
    `dmg` int(11) NOT NULL DEFAULT '0',
    `bombdef` int(11) NOT NULL DEFAULT '0',
    `bombdefused` int(11) NOT NULL DEFAULT '0',
    `bombplants` int(11) NOT NULL DEFAULT '0',
    `bombexplosions` int(11) NOT NULL DEFAULT '0',
    `h_0` int(11) NOT NULL DEFAULT '0',
    `h_1` int(11) NOT NULL DEFAULT '0',
    `h_2` int(11) NOT NULL DEFAULT '0',
    `h_3` int(11) NOT NULL DEFAULT '0',
    `h_4` int(11) NOT NULL DEFAULT '0',
    `h_5` int(11) NOT NULL DEFAULT '0',
    `h_6` int(11) NOT NULL DEFAULT '0',
    `h_7` int(11) NOT NULL DEFAULT '0',
    `connection_time` int(11) NOT NULL DEFAULT '0',
    `connects` INT NOT NULL DEFAULT '0',
    `roundt` INT NOT NULL DEFAULT '0',
    `wint` INT NOT NULL DEFAULT '0',
    `roundct` INT NOT NULL DEFAULT '0',
    `winct` INT NOT NULL DEFAULT '0',
    `assists` INT NOT NULL DEFAULT '0',
    `first_join` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `last_join` timestamp NULL DEFAULT NULL,
    `session_id` int(11) DEFAULT NULL,
    `session_map` varchar(32) DEFAULT NULL,
    PRIMARY KEY (id),
    KEY `steamid` (`steamid`(16)),
    KEY `name` (`name`(16)),
    KEY `ip` (`ip`)
) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
 
L

lol cek

Сообщения
265
Реакции
0
Предупреждения
2
Помог
5 раз(а)
Somon007, замени систему бана, за основу возьми lite bans либо fresh bans, а то потом будешь писать почему не работают баны на сервере
 
L

lol cek

Сообщения
265
Реакции
0
Предупреждения
2
Помог
5 раз(а)
Somon007, не стоит. Замени gm bans на cs bans. Gm bans старый а cs bans свежий
 
Войдите или зарегистрируйтесь для ответа.

Пользователи, просматривающие эту тему

Сейчас на форуме нет ни одного пользователя.
Всего: 1 (пользователей: 0, гостей: 1)
Сверху Снизу