Bei mir lag es an der MySQL Einstellung "ONLY_FULL_GROUP_BY".
Ich habe in der content/sieger.php das SQL Statement in Zeile 59 von
- $sqlBonus = $CONFIG['MYSQL']['CONNECT']->query("SELECT (SELECT pkt FROM ". $CONFIG['MYSQL']['PREFIX'] ."bonus_punkte tb2 WHERE tb2.bid = tb1.bid AND tb1.date < tb2.date ORDER BY tb2.date ASC LIMIT 1) AS pkt FROM ". $CONFIG['MYSQL']['PREFIX'] ."bonus_tipps tb1 LEFT JOIN ". $CONFIG['MYSQL']['PREFIX'] ."bonus_answers tb3 ON tb3.bid = tb1.bid WHERE tb1.usr = " . $_SESSION['s_id'] . " AND tb3.answer IS NULL GROUP BY tb1.bid");
in
- $sqlBonus = $CONFIG['MYSQL']['CONNECT']->query("SELECT (SELECT pkt FROM ". $CONFIG['MYSQL']['PREFIX'] ."bonus_punkte tb2 WHERE tb2.bid = tb1.bid AND tb1.date < tb2.date ORDER BY tb2.date ASC LIMIT 1) AS pkt FROM ". $CONFIG['MYSQL']['PREFIX'] ."bonus_tipps tb1 LEFT JOIN ". $CONFIG['MYSQL']['PREFIX'] ."bonus_answers tb3 ON tb3.bid = tb1.bid WHERE tb1.usr = " . $_SESSION['s_id'] . " AND tb3.answer IS NULL GROUP BY tb1.bid, tb1.date");
geändert. Anschliessend funktionierte die Anzeige bei mir bestens.
Alternativ die ONLY_FULL_GROUP_BY Einstellung in MySQL (sql_mode) entfernen. Dies sollte ebenfalls funktionieren.