On NomisCZ latest release, getting this error in scripts/logs/hlstats_27500_2019... How to fix what?
PHP Code:
DBD::mysql::st execute failed: Table 'hlstatsx.hlstats_Servers' doesn't exist at .//HLstats.plib line 213.
Unable to execute query (get_server_player_info):
SELECT
kills,
headshots,
suicides,
rounds,
ct_shots+ts_shots as shots,
ct_hits+ts_hits as hits
FROM
hlstats_Servers
WHERE
serverId=?
Table 'hlstatsx.hlstats_Servers' doesn't exist at .//HLstats.plib line 213.
hlstats.php?mode=playerinfo&player=3
PHP Code:
Database Error
Server Address: localhost
Server Username: root
Error Diagnostic:
Bad query.
Server Error: (1055) Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hlstats.hlstats_Weapons.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Last SQL Query:
hlstats_Events_Frags.weapon,
hlstats_Weapons.name,
COUNT(hlstats_Events_Frags.weapon) AS kills,
SUM(hlstats_Events_Frags.headshot=1) as headshots
FROM
hlstats_Events_Frags
LEFT JOIN
hlstats_Weapons
ON
hlstats_Weapons.code = hlstats_Events_Frags.weapon
WHERE
hlstats_Events_Frags.killerId=3
GROUP BY
hlstats_Events_Frags.weapon
ORDER BY
kills desc, headshots desc
LIMIT
1
Linear Mode
