Message: Expression #10 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'rsdb.m.spw' 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 
  u.ID, 
  u.name, 
  u.vname, 
  u.datenschutz, 
  u.nick, 
  u.titel, 
  u.country, 
  u.elo as elo, 
  u.rstitel, 
  IF(m.spw = u.ID, m.nrw, m.nrs) AS nr, 
  IF(u.rstitelgueltigbis>NOW(), 1, 0) AS nochgueltig 
 FROM spiele AS m 
 LEFT JOIN user AS u ON (m.spw=u.ID OR m.sps=u.ID) 
 WHERE m.ID_turnier = 4 
 GROUP BY u.ID 
 ORDER BY u.nick '
### vardump end: SQL ###

#0 /home/data/remoteschach.de/www/weblib/dataset_db.lib.php(146): CDBConnectionMySql->query('SELECT \n u.ID,...', false, Array)
#1 /home/data/remoteschach.de/www/weblib/dataset_db.lib.php(106): CDataSetDB->open('SELECT \n u.ID,...', Array)
#2 /home/data/remoteschach.de/www/weblib/dataset_db.lib.php(273): CDataSetDB->__construct('SELECT \n u.ID,...', true, Array)
#3 /home/data/remoteschach.de/www/weblib/dbconnection_mysql.lib.php(278): CDataSetMySql->__construct('SELECT \n u.ID,...', true, Array)
#4 /home/data/remoteschach.de/www/turniere/inc/turnierstatus.lib.php(762): CDBConnectionMySql->createDataSet('SELECT \n u.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}