search

NomisCZ / hlstatsx-community-edition

HLstatsX Community Edition - PHP 7 and GeoIP2 supported
GNU General Public License v2.0
83 stars 50 forks source link

Database Error. Error Diagnostic: Bad query. #64

Closed Denis-Raev closed 4 years ago

Denis-Raev commented 4 years ago

Freshly baked web part and database, but this problem immediately. Screenshot_10 Last SQL Query: SELECT 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=8 GROUP BY hlstats_Events_Frags.weapon ORDER BY kills desc, headshots desc LIMIT 1 How to solve a problem?

NomisCZ commented 4 years ago

Hello, the same problem has been solved here: https://github.com/NomisCZ/hlstatsx-community-edition/issues/51#issuecomment-612946161

Denis-Raev commented 4 years ago

Thank you so much!