• Пожалуйста, создайте название темы отражающее ее смысл
  • Для ускорения решения Вашего вопроса заполните обязательные поля и подробно опишите возникшую проблему

Помощь GameCMS API / stats / statsx

Yamiru

Yamiru

Участник
Сообщения
5
Реакции
-1
Баллы
1
GameCMS API / stats / statsx
 
Источник плагина (ссылка на сайт или тему)
[URL unfurl="true"]https://cs-games.club/index.php?resources/gamecms-api.4/[/URL]
[URL unfurl="true"]https://cs-games.club/index.php?resources/cmsstats-mysql.13/[/URL]
[URL unfurl="true"]https://cs-games.club/index.php?threads/cmsstats-statsx-paid.32/[/URL]
L 11/24/2020 - 19:07:54: -------- Mapchange to de_dust2_snow --------
L 11/24/2020 - 19:07:54: [MusicRoundEnd.amxx] File missing 'sound/MusicRoundEnd/DRAW/drawwav.wav'.
L 11/24/2020 - 19:07:54: [MusicRoundEnd.amxx] File missing 'sound/MusicRoundEnd/DRAW/drawmp3.mp3'.
L 11/24/2020 - 19:07:54: [gamecms_api_5.4.7.amxx] CmdAddUserGroup num 1, flags abcdefijlmntu
L 11/24/2020 - 19:07:54: [gamecms_api_5.4.7.amxx] CmdAddUserGroup num 3, flags abcdefijmnprtu
L 11/24/2020 - 19:07:54: [gamecms_api_5.4.7.amxx] CmdAddUserGroup num 4, flags abiqt
L 11/24/2020 - 19:07:54: [gamecms_api_5.4.7.amxx] CmdAddUserGroup num 10, flags abipt
L 11/24/2020 - 19:07:54: [gamecms_api_5.4.7.amxx] CmdAddUserGroup num 11, flags abiprt
L 11/24/2020 - 19:07:54: [gamecms_api_5.4.7.amxx] CmdAddUserGroup num 12, flags abcdefijmnqtu
L 11/24/2020 - 19:07:54: [gamecms_api_5.4.7.amxx] Reading GameCMS settings file... OK
L 11/24/2020 - 19:07:54: [cmsstats_mysql_1.17.2.amxx] CSX is NOT loaded
L 11/24/2020 - 19:07:54: [cmsstats_mysql_1.17.2.amxx] Command: CMSStats is Enabled
L 11/24/2020 - 19:07:54: [gamecms_api_5.4.7.amxx] Connection to the GameCMS database is established
L 11/24/2020 - 19:07:54: [gamecms_api_5.4.7.amxx] SELECT `id`, `name` FROM `users__groups`
L 11/24/2020 - 19:07:54: [gamecms_api_5.4.7.amxx] SELECT `a`.`id`, `a`.`name` as `auth`,`pass`, COALESCE(REPLACE(`ad`.`rights_und`,'none',`s`.`rights`),`ad`.`rights_und`) AS `flags`, `a`.`type`, `ending_date` as `expired`,`ad`.`id` AS `admin_service_id`,`ad`.`service`,`service_time`,`a`.`active`,`a`.`pause`, `s`.`name` as `service_name`, `cause`, UNIX_TIMESTAMP(`ending_date`) as `expunix`, UNIX_TIMESTAMP(NOW()) as `nowunix` FROM `admins` a LEFT JOIN `admins__services` ad ON `ad`.`admin_id`=`a`.`id`LEFT JOIN `servers` sr ON `server`=`sr`.`id` LEFT JOIN `services` s ON `ad`.`service`=`s`.`id`WHERE `sr`.`id` = '1' AND (UNIX_TIMESTAMP(`ending_date`) > UNIX_TIMESTAMP(NOW()) OR `ending_date` = '0000-00-00 00:00:00')
L 11/24/2020 - 19:07:54: [gamecms_api_5.4.7.amxx] "0" services was 'Loaded' from database. Total on server: "0" services.
L 11/24/2020 - 19:07:55: [amxbans_main.amxx] [AMXBans] AMXBans 6.13 je zapnute
L 11/24/2020 - 19:07:55: [amxbans_main.amxx] [AMXBans] Ziadne dovody neboli najdene v databaze. Boli nacitane staticke.
L 11/24/2020 - 19:07:57: [cmsstats_mysql_1.17.2.amxx] [STATUS] The plugin is successfully activated
L 11/24/2020 - 19:08:03: [gamecms_api_5.4.7.amxx] Searching user..- SELECT `users`.`id`, `login`, `users`.`name`, `birth`, `regdate`, `thanks`, `answers`, `proc`, `last_activity`, `reit`,`users`.`shilings`, `nick`, `game_time`, `prefix`,(SELECT COUNT(*) FROM `pm__dialogs` WHERE (`user_id1`=`users`.`id` or `user_id2`=`users`.`id`) AND (`new`=`users`.`id` or`new`='r'+`users`.`id`)) AS `new_messages`, `users__groups`.`name` as `group_name`, `users`.`rights`, `plugins_settings` , `game_money` ,`member_online`FROM `users` LEFT JOIN `users__groups` ON `users`.`rights`=`users__groups`.`id` WHERE (`users`.`steam_id` = 'STEAM_0:1:30916434' OR `users`.`steam_id` = '76561198022098597' OR `users`.`steam_api` = '76561198022098597'); UPDATE `users` SET `member_online` = '1' WHERE (`users`.`steam_id` = 'STEAM_0:1:30916434' OR `users`.`steam_id` = '76561198022098597' OR `users`.`steam_api` = '76561198022098597');
L 11/24/2020 - 19:08:03: [gamecms_api_5.4.7.amxx] [Error] Query error: Unknown column 'plugins_settings' in 'field list' (1054)
L 11/24/2020 - 19:08:03: [gamecms_api_5.4.7.amxx] SQL_NumResults null
L 11/24/2020 - 19:08:10: [gamecms_api_5.4.7.amxx] Searching user..- SELECT `users`.`id`, `login`, `users`.`name`, `birth`, `regdate`, `thanks`, `answers`, `proc`, `last_activity`, `reit`,`users`.`shilings`, `nick`, `game_time`, `prefix`,(SELECT COUNT(*) FROM `pm__dialogs` WHERE (`user_id1`=`users`.`id` or `user_id2`=`users`.`id`) AND (`new`=`users`.`id` or`new`='r'+`users`.`id`)) AS `new_messages`, `users__groups`.`name` as `group_name`, `users`.`rights`, `game_money` ,`member_online`FROM `users` LEFT JOIN `users__groups` ON `users`.`rights`=`users__groups`.`id` WHERE (`users`.`steam_id` = 'STEAM_0:1:523871090' OR `users`.`steam_id` = '76561199008007909' OR `users`.`steam_api` = '76561199008007909'); UPDATE `users` SET `member_online` = '1' WHERE (`users`.`steam_id` = 'STEAM_0:1:523871090' OR `users`.`steam_id` = '76561199008007909' OR `users`.`steam_api` = '76561199008007909');
L 11/24/2020 - 19:08:10: [gamecms_api_5.4.7.amxx] [Error] Query error: Unknown column 'game_money' in 'field list' (1054)
L 11/24/2020 - 19:08:10: [gamecms_api_5.4.7.amxx] SQL_NumResults null
L 11/24/2020 - 19:09:57: [cmsstats_mysql_1.17.2.amxx] [Error] Query error: Cannot add or update a child row: a foreign key constraint fails (`proserver_gamecms`.`weapon_knife`, CONSTRAINT `weapon_knife_ibfk_1` FOREIGN KEY (`authid`) REFERENCES `csstats_players` (`authid`) ON DELETE CASCADE ON UPDATE CASCADE) (1452)
L 11/24/2020 - 19:09:57: [cmsstats_mysql_1.17.2.amxx] [Error] Query error: Field 'teamkills' doesn't have a default value (1364)
L 11/24/2020 - 19:10:29: [cmsstats_mysql_1.17.2.amxx] [Error] Query error: Field 'teamkills' doesn't have a default value (1364)
L 11/24/2020 - 19:10:29: [cmsstats_mysql_1.17.2.amxx] [Error] Query error: Cannot add or update a child row: a foreign key constraint fails (`proserver_gamecms`.`weapon_knife`, CONSTRAINT `weapon_knife_ibfk_1` FOREIGN KEY (`authid`) REFERENCES `csstats_players` (`authid`) ON DELETE CASCADE ON UPDATE CASCADE) (1452)
L 11/24/2020 - 19:10:53: [gamecms_api_5.4.7.amxx] Searching user..- SELECT `users`.`id`, `login`, `users`.`name`, `birth`, `regdate`, `thanks`, `answers`, `proc`, `last_activity`, `reit`,`users`.`shilings`, `nick`, `game_time`, `prefix`,(SELECT COUNT(*) FROM `pm__dialogs` WHERE (`user_id1`=`users`.`id` or `user_id2`=`users`.`id`) AND (`new`=`users`.`id` or`new`='r'+`users`.`id`)) AS `new_messages`, `users__groups`.`name` as `group_name`, `users`.`rights`,`member_online`FROM `users` LEFT JOIN `users__groups` ON `users`.`rights`=`users__groups`.`id` WHERE (`users`.`steam_id` = 'STEAM_0:1:523871090' OR `users`.`steam_id` = '76561199008007909' OR `users`.`steam_api` = '76561199008007909'); UPDATE `users` SET `member_online` = '1' WHERE (`users`.`steam_id` = 'STEAM_0:1:523871090' OR `users`.`steam_id` = '76561199008007909' OR `users`.`steam_api` = '76561199008007909');
L 11/24/2020 - 19:10:53: [gamecms_api_5.4.7.amxx] [Error] Query error: Unknown column 'member_online' in 'field list' (1054)
L 11/24/2020 - 19:10:53: [gamecms_api_5.4.7.amxx] SQL_NumResults null
L 11/24/2020 - 19:14:13: [cmsstats_mysql_1.17.2.amxx] [Error] Query error: Field 'teamkills' doesn't have a default value (1364)
no error log
Список плагинов (amx_plugins)
[ 1] AMXBans Core 6.13 YamiKaitou amxbans_core.am running
[ 2] AMXBans Main 6.13 YamiKaitou amxbans_main.am running
[ 3] GameCMS_API 5.4.7 zhorzh78 gamecms_api_5.4 running
[ 4] Admin Commands 1.9.0.5271 AMXX Dev Team admincmd.amxx running
[ 5] Admin Help 1.9.0.5271 AMXX Dev Team adminhelp.amxx running
[ 6] Slots Reservation 1.9.0.5271 AMXX Dev Team adminslots.amxx running
[ 7] Multi-Lingual System 1.9.0.5271 AMXX Dev Team multilingual.am running
[ 8] Menus Front-End 1.9.0.5271 AMXX Dev Team menufront.amxx running
[ 9] Commands Menu 1.9.0.5271 AMXX Dev Team cmdmenu.amxx running
[ 10] Players Menu 1.9.0.5271 AMXX Dev Team plmenu.amxx running
[ 11] Maps Menu 1.9.0.5271 AMXX Dev Team mapsmenu.amxx running
[ 12] Plugin Menu 1.9.0.5271 AMXX Dev Team pluginmenu.amxx running
[ 13] Admin Chat 1.9.0.5271 AMXX Dev Team adminchat.amxx running
X[ 14] Anti Flood 1.9.0.5271 AMXX Dev Team antiflood.amxx running [ 15] Scrolling Message 1.9.0.5271 AMXX Dev Team scrollmsg.amxx running
[ 16] Info. Messages 1.9.0.5271 AMXX Dev Team imessage.amxx running
[ 17] Admin Votes 1.9.0.5271 AMXX Dev Team adminvote.amxx running
[ 18] NextMap 1.9.0.5271 AMXX Dev Team nextmap.amxx running
[ 19] Nextmap Chooser 1.9.0.5271 AMXX Dev Team mapchooser.amxx running
[ 20] TimeLeft 1.9.0.5271 AMXX Dev Team timeleft.amxx running
[ 21] Pause Plugins 1.9.0.5271 AMXX Dev Team pausecfg.amxx running
[ 22] Stats Configuration 1.9.0.5271 AMXX Dev Team statscfg.amxx running
[ 23] Music Round End 1.2.1 Jumper MusicRoundEnd.a running
[ 24] ReAimDetector API 0.2.2 ReHLDS Team reaimdetector.a running
[ 25] CMSStats_MySQL 1.17.2 / 2 zhorzh78 cmsstats_mysql_ running
[ 26] CMSStats_StatsX 1.04 / 03. AMXX Dev Team++ cmsstats_statsx running
[ 27] CMSStatsX_Configuratio 1.9.0.5229 AMXX Dev Team cmsstats_statsc running
27 plugins, 27 running
Список модулей (meta list)
[ 1] SafeNameAndChat RUN - SafeNameAndChat.so v1.1 ini ANY ANY
[ 2] Reunion RUN - reunion_mm_i386.so v0.1.0.92 ini Start Never
[ 3] ReAuthCheck RUN - reauthcheck_mm_i386.so v0.1.6 ini Start Never
[ 4] Rechecker RUN - rechecker_mm_i386.so v2.5 ini Chlvl ANY
[ 5] Revoice RUN - revoice_mm_i386.so v0.1.0.32 ini Start Never
[ 6] AMX Mod X RUN - amxmodx_mm_i386.so v1.9.0.5271 ini Start ANY
[ 7] ReSRDetector RUN - resrdetector_mm_i386.so v0.1.0 ini Chlvl ANY
[ 8] WHBlocker RUN - whblocker_mm_i386.so v1.5.697 ini Chlvl ANY
[ 9] ReSemiclip RUN - resemiclip_mm_i386.so v2.3.9 ini Chlvl ANY
[10] MySQL RUN - mysql_amxx_i386.so v1.9.0.5271 pl6 ANY ANY
[11] ReAPI RUN - reapi_amxx_i386.so v5.16.0.198-dev pl6 ANY Never
[12] ReAimDetector RUN - reaimdetector_amxx_i386.so v0.2.2 pl6 ANY Never
X[13] Engine RUN - engine_amxx_i386.so v1.9.0.5271 pl6 ANY ANY [14] Ham Sandwich RUN - hamsandwich_amxx_i386.so v1.9.0.5271 pl6 ANY ANY
[15] FakeMeta RUN - fakemeta_amxx_i386.so v1.9.0.5271 pl6 ANY ANY
15 plugins, 15 running
Сортировка по дате Сортировка по голосам
Yamiru написал(а):
L 11/24/2020 - 19:14:13: [cmsstats_mysql_1.17.2.amxx] [Error] Query error: Field 'teamkills' doesn't have a default value (1364)
Нажмите для раскрытия...

j9wEZ.png


Какое значение sql_mode?

Нужно убрать NO_AUTO_VALUE_ON_ZERO, если есть. Если нет, то удалить все и прописать только NO_ENGINE_SUBSTITUTION
 
Позитивный голос 0 Негативный голос
L 11/28/2020 - 22:22:47: [gamecms_api_5.4.7.amxx] Searching user..- SELECT `users`.`id`, `login`, `users`.`name`, `birth`, `regdate`, `thanks`, `answers`, `proc`, `last_activity`, `reit`,`users`.`shilings`, `nick`, `game_time`, `prefix`,(SELECT COUNT(*) FROM `pm__dialogs` WHERE (`user_id1`=`users`.`id` or `user_id2`=`users`.`id`) AND (`new`=`users`.`id` or`new`='r'+`users`.`id`)) AS `new_messages`, `users__groups`.`name` as `group_name`, `users`.`rights`, `plugins_settings` FROM `users` LEFT JOIN `users__groups` ON `users`.`rights`=`users__groups`.`id` WHERE (`users`.`steam_id` = 'STEAM_0:1:30916434' OR `users`.`steam_id` = '76561198022098597' OR `users`.`steam_api` = '76561198022098597');
L 11/28/2020 - 22:22:47: [gamecms_api_5.4.7.amxx] SQL_NumResults null
 
Позитивный голос 0 Негативный голос
Войдите или зарегистрируйтесь для ответа.
Назад
Сверху