Message: Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'rsdb.a.elo' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Datei: /home/data/remoteschach.de/www/weblib/dbconnection_mysql.lib.php
Zeile: 193

### vardump start: SQL ###
'SELECT 
  a.ID_user AS ID, 
  u.name, 
  u.vname, 
  u.datenschutz, 
  u.nick, 
  u.titel, 
  IF(a.elo < 0, -a.elo, NULL) AS elo, 
  u.country, 
  u.rstitel, 
  a.nr, 
  a.einsatz, 
  IF(u.rstitelgueltigbis > NOW(), 1, 0) AS nochgueltig 
 FROM auslosung AS a 
 INNER JOIN user as u ON u.ID = a.ID_user 
 WHERE a.ID_turnier = 4874 
  AND a.gruppe=\'A\' 
 GROUP BY a.ID_user 
 ORDER BY a.nr 
'
### vardump end: SQL ###

#0 /home/data/remoteschach.de/www/weblib/dataset_db.lib.php(146): CDBConnectionMySql->query('SELECT \n a.ID_...', false, Array)
#1 /home/data/remoteschach.de/www/weblib/dataset_db.lib.php(106): CDataSetDB->open('SELECT \n a.ID_...', Array)
#2 /home/data/remoteschach.de/www/weblib/dataset_db.lib.php(273): CDataSetDB->__construct('SELECT \n a.ID_...', true, Array)
#3 /home/data/remoteschach.de/www/weblib/dbconnection_mysql.lib.php(278): CDataSetMySql->__construct('SELECT \n a.ID_...', true, Array)
#4 /home/data/remoteschach.de/www/turniere/inc/turnierstatus.lib.php(762): CDBConnectionMySql->createDataSet('SELECT \n a.ID_...')
#5 /home/data/remoteschach.de/www/turniere/inc/turnierstatus.lib.php(767): CTurnierTableSinglePlayer->buildPlayerdataset()
#6 /home/data/remoteschach.de/www/turniere/inc/turnierstatus.lib.php(377): CTurnierTableSinglePlayer->buildPlayerArray()
#7 /home/data/remoteschach.de/www/turniere/inc/turnierstatus.lib.php(985): CTurnierTableSinglePlayer->retrieveResultData()
#8 /home/data/remoteschach.de/www/turniere/inc/turnierstatus.lib.php(470): CTurnierTableSinglePlayer->writeOverviewView()
#9 /home/data/remoteschach.de/www/turniere/inc/turnierstatus.lib.php(633): CTurnierTableSinglePlayer->writeView('overview')
#10 /home/data/remoteschach.de/www/turniere/inc/turnierstatus_std.inc.php(13): CTurnierTableSinglePlayer->writeTournamentTable()
#11 /home/data/remoteschach.de/www/turniere/inc/turnierstatus.inc.php(64): include('/home/data/remo...')
#12 /home/data/remoteschach.de/www/turniere/turnierstatus.php(38): include('/home/data/remo...')
#13 {main}