search

etoa / etoa-gui

EtoA Game GUI
https://etoa.ch
GNU Affero General Public License v3.0
10 stars 7 forks source link

fixed specialists page sql query error: ERROR 1140 (42000)… #550

Closed river-etoa closed 2 years ago

river-etoa commented 2 years ago

In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column (...)

error gets thrown when opening specialist page normally.

fix: improved query by adding group by for what is assumed to be the intended operation of the countUsersWithSpecialists() function