Seit etwa 2-3 Tagen wirft das Forum nach abschicken eines Beitrags immer Fehlermeldungen:
Es sollte wirklich mal ein Wechsel der Forensoftware stattfinden.Error Message
DB ERROR 1055: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'db12955151-db62251.u.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
File: /is/htdocs/wp12955151_JTN45DK2GD/www/viscacha/addreply.php on line 318
Query:
SELECT t.id, t.topic, u.name, u.mail, u.language, COUNT(*) AS num
FROM v_abos AS a
LEFT JOIN v_user AS u ON u.id = a.mid
LEFT JOIN v_topics AS t ON t.id = a.tid
INNER JOIN v_replies AS r ON r.topic_id = t.id AND r.date >= u.lastvisit
WHERE a.type = '' AND a.tid = '11185' AND a.mid != '4958'
GROUP BY t.id HAVING num = 1
Error Details
File: /is/htdocs/wp12955151_JTN45DK2GD/www/viscacha/classes/database/mysqli.inc.php
Line: 169
Date: 2020-06-19 08:47:12 (CEST)
Code Snippet
00164
00165 $this->open();
00166
00167 $start = $this->benchmarktime();
00168
00169 $this->result = mysqli_query($this->conn, $sql) or trigger_error($this->error($sql), $errfunc);
00170
00171 $time = $this->benchmarktime() - $start;
00172 $this->dbqd[] = array(
00173 'query' => $sql,
00174 'time' => round($time, 5)
Backtrace
File: is/htdocs/wp12955151_JTN45DK2GD/www/viscacha/classes/database/mysqli.inc.php
Line: 169
Call: trigger_error('DB ERROR 1055: Expression #3 of SELECT list is not in GROUP BY c...', 256)
File: is/htdocs/wp12955151_JTN45DK2GD/www/viscacha/addreply.php
Line: 318
Call: DB->query(' SELECT t.id, t.topic, u.name, u.mail, u.language, COUNT(*)...')
Contact
Please notify the board administrator: r10@hae.de
Copyright
Powered by Viscacha 0.8.1.3
Copyright © 2004-2009, The Viscacha Project
Ich würde dabei auch helfen.
Visacha ist uralt, das immer noch zu betreiben ist ein großes Sicherheitsrisiko.
Die letzte Visacha Version ist von 2009.
Gruß
sven