phpBB.de

Hegse hat geschrieben: Das Forum läuft bis auf die Football Extension ohne Probleme. Beim Aufruf des Tippspiels bekomme ich folgende Fehlermeldung:

Code: Alles auswählen

Allgemeiner Fehler
SQL ERROR [ mysqli ]

Expression #1 of ORDER BY clause is not in SELECT list, references column '*****_*****.m.match_datetime' which is not in SELECT list; this is incompatible with DISTINCT [3065]

SQL

SELECT DISTINCT m.league FROM phpbb3_footb_matches AS m INNER JOIN phpbb3_footb_bets AS b ON (b.season = m.season AND b.league = m.league AND b.user_id = 2) WHERE m.season = 2018 AND m.status in (0,1,2) ORDER BY m.match_datetime ASC LIMIT 1

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 999
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/ext/football/football/includes/functions.php
LINE: 1040
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/ext/football/football/controller/main.php
LINE: 229
CALL: current_league()

FILE: (not given by php)
LINE: (not given by php)
CALL: football\football\controller\main->handle()

FILE: [ROOT]/vendor/symfony/http-kernel/HttpKernel.php
LINE: 144
CALL: call_user_func_array()

FILE: [ROOT]/vendor/symfony/http-kernel/HttpKernel.php
LINE: 64
CALL: Symfony\Component\HttpKernel\HttpKernel->handleRaw()

FILE: [ROOT]/app.php
LINE: 35
CALL: Symfony\Component\HttpKernel\HttpKernel->handle()

		GROUP BY delivery, m.league
		ORDER BY delivery, m.league";

		GROUP BY m.season, m.league, m.matchday, l.league_name_short, matchday_name, delivery
		ORDER BY delivery, m.season, m.league";

theXME hat geschrieben:in zwei SQL-Statements ist das seit MySQL 8.0.2 reservierte Keyword "rank" enthalten (siehe https://dev.mysql.com/doc/refman/8.0/en/keywords.html), dadurch schlägt die Aktualisierung des Spielplans fehl, sofern bereits MySQL 8.0 verwendet wird.

Um das zu beheben, muss rank in Backticks (`) gesetzt werden - alternativ wäre vielleicht künftig auch eine Umbenennung möglich.

DreamPromise hat geschrieben:Das WM-Tippspiel habe ich so eingestellt das der Tipper selber beitreten kann.
Das aber funktioniert nicht.

Erst eine neue Saison erstellen dann neue Liga erstellen ... und dann ???

[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/db/driver/mysqli.php on line 317: mysqli_free_result(): Couldn't fetch mysqli_result
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_acp.php on line 137: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3268)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_acp.php on line 137: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3268)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_acp.php on line 137: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3268)