Message: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'rsdb.u.von'; 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 
 IF (u.von <= \'2018-12-05\' AND u.bis >= \'2026-01-11\', 0, 
 GREATEST(0,
  ( 
   FLOOR((+ UNIX_TIMESTAMP(\'2026-01-11 11:06\') 
          - GREATEST(UNIX_TIMESTAMP(\'2018-12-05 22:32\'), 
                     IF (ug.ID > 0, 
                         UNIX_TIMESTAMP(LEAST(DATE_ADD(ug.bis, INTERVAL 1 DAY), 
                                              \'2026-01-11 11:06\')), 
                         0) 
                    ) 
         )/86400) 
   - SUM( 
        IF(u.ID>0 AND (ug.ID IS NULL OR ug.bis < u.bis), 
           GREATEST(0, 
               IF (\'2026-01-11\' <= u.bis AND \'2026-01-11\'>=u.von AND TIME(\'2026-01-11 11:06\') < TIME(\'2018-12-05 22:32\'), 0, 1) 
               + TO_DAYS(LEAST(GREATEST(IF(ug.ID IS NULL, 0, ug.bis), u.bis), \'2026-01-11\')) 
               - TO_DAYS(GREATEST(u.von, \'2018-12-05\', IF(ug.ID IS NULL, 0, DATE_ADD(ug.bis, INTERVAL 1 DAY)))) 
           ),
           0 
          ) 
        ) 
   + IF(GREATEST(\'2018-12-05\', IF(ug.bis IS NOT NULL, ug.bis, 0)) >= u.von 
        AND GREATEST(\'2018-12-05\', IF(ug.bis IS NOT NULL, ug.bis, 0)) <= u.bis 
        AND TIME(GREATEST(\'2018-12-05 22:32\', IF(ug.bis IS NOT NULL, ug.bis, 0))) > TIME(\'2026-01-11 11:06\'), 
      1, 
      0) 
  ) 
 )) AS bz, 
  SUM( 
        IF(u.ID>0 AND (ug.ID IS NULL OR ug.bis<u.bis), 
          GREATEST(0, 
             1 + ( 
               + TO_DAYS(LEAST(GREATEST(IF(ug.ID IS NULL, 0, ug.bis), u.bis), \'2026-01-11\')) 
               - TO_DAYS(GREATEST(u.von, \'2018-12-05\', IF(ug.ID IS NULL, 0, ug.bis))) 
             ) 
           ),
           0 
          ) 
    ) as urlaubused 
 , SUM( 
     IF(ug.ID > 0, 
       1 + ( 
         + TO_DAYS(GREATEST(\'2018-12-05 22:32\', LEAST(\'2026-01-11\', ug.bis))) 
         - TO_DAYS(\'2018-12-05 22:32\') 
       ),
       0 
      ) 
    ) as urlaub_g 
FROM user p 
LEFT JOIN urlaub ug ON ug.ID_user = 2253 
 AND ug.ID_turnier IS NULL 
 AND ug.von <= \'2018-12-05\' 
 AND ug.bis >= \'2018-12-05\' 
LEFT JOIN urlaub u ON u.ID_user = p.ID
 AND u.ID_turnier IS NULL 
 AND (u.von <= \'2026-01-11\' AND u.bis >= \'2018-12-05\') 
WHERE p.ID=5954 
'
### vardump end: SQL ###

#0 /home/data/remoteschach.de/www/weblib/dbconnection.lib.php(293): CDBConnectionMySql->query('SELECT \n IF (u....', false, Array)
#1 /home/data/remoteschach.de/www/base/inc/dbutil.lib.php(176): CDBConnection->getSingleLineBySql('SELECT \n IF (u....')
#2 /home/data/remoteschach.de/www/util/inc/bedenkzeit.lib.php(213): holeEinzelZeileObjectBySQL('SELECT \n IF (u....')
#3 /home/data/remoteschach.de/www/util/inc/bedenkzeit.lib.php(47): GetBedenkzeitVersion2('5954', '2253', 0, 0, '2018-12-05 22:3...', 0, 0, '2026-01-11 11:0...')
#4 /home/data/remoteschach.de/www/util/inc/gamelist.lib.php(550): GetBedenkzeit('5954', '2253', '2018-06-25 03:4...', 0, 0, '2018-12-05 22:3...', 0, 0)
#5 /home/data/remoteschach.de/www/weblib/list.lib.php(141): CGameList->cb_aktbz(Object(CColumn))
#6 /home/data/remoteschach.de/www/weblib/list.lib.php(316): CColumn->getFormattedContent()
#7 /home/data/remoteschach.de/www/weblib/list.lib.php(1036): CColumn->writeCellContent()
#8 /home/data/remoteschach.de/www/weblib/list.lib.php(935): CList->writeRow(23)
#9 /home/data/remoteschach.de/www/util/inc/gamelist.lib.php(905): CList->writeList()
#10 /home/data/remoteschach.de/www/util/inc/gamelist.lib.php(1093): CGameList2->writeGameList(Object(stdClass))
#11 /home/data/remoteschach.de/www/turniere/inc/turnierstatus.inc.php(101): CGameList2->writeList(Array)
#12 /home/data/remoteschach.de/www/turniere/turnierstatus.php(38): include('/home/data/remo...')
#13 {main}