[BETA] [3.1] [3.2] Football Prediction League

[Mahony]

Hallo
Die Lösung für diese Probleme findest du hier >>> viewtopic.php?f=149&t=237029&p=1389812#p1389812


Grüße: Mahony

[DreamPromise]

Top ... scheint zu funktionieren.
Auch mit Version 7.3
1000 Dank

[Dr.Death]

php 7.3 solltest du nicht auf ein phpBB 3.2.5 loslassen....bleib bei 7.2

[DreamPromise]

Ich habe noch 3.2.2.
Mitten in der Football Saison möchte ich nicht Updaten.

[Mahony]

Für php 7.3.x ist das phpBB noch nicht offiziell als kompatibel erklärt worden.
Warum versucht es dann nur schon jeder damit?
Nicht alles, was brandneu ist, ist auch fehlerfrei und gut, erst recht nicht in einer Live Umgebung!

Das gilt dann natürlich auch für Vorgänger-Versionen von phpBB3.2.5

Grüße: Mahony

[nudels64]

Wir sind zu einem anderen Hoster umgezogen mit MySQL Version 8.0.13 und erhalten folgende Fehlermeldung, wenn ich auf die Tipprunde zugreifen möchte.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC, LOWER(u.username) ASC' at line 14 [1064]

SELECT r.status, r.rank, r.user_id, u.username, r.points, IF(r.win=0, '', r.win) AS win FROM phpbb_footb_rank_matchdays AS r LEFT Join phpbb_users AS u ON (r.user_id = u.user_id) WHERE r.season = 2019 AND r.league = 1 AND r.matchday = 23 AND r.status IN (2,3) ORDER BY rank ASC, LOWER(u.username) ASC

[Mahony]

Hallo
Versuche mal folgendes:

Suche in der /football/block/rank_matchday.php

Code: Alles auswählen

$sql = "SELECT
			r.status,
			r.rank,
			r.user_id,
			u.username,
			r.points,
			IF(r.win=0, '', r.win) AS win
		FROM  " . FOOTB_RANKS . ' AS r
		LEFT Join ' . USERS_TABLE . " AS u ON (r.user_id = u.user_id)
		WHERE r.season = $season 
			AND r.league = $league 
			AND r.matchday = $matchday 
			AND r.status IN (2,3)
		ORDER BY rank ASC, LOWER(u.username) ASC";

Ersetze mit

Code: Alles auswählen

$sql = "SELECT
			r.status,
			r.rank,
			r.user_id,
			u.username,
			r.points,
			IF(r.win=0, '', r.win) AS win
		FROM  " . FOOTB_RANKS . ' AS r
		LEFT Join ' . USERS_TABLE . " AS u ON (r.user_id = u.user_id)
		WHERE r.season = $season 
			AND r.league = $league 
			AND r.matchday = $matchday 
			AND r.status IN (2,3)
		ORDER BY r.rank ASC, LOWER(u.username) ASC";

Grüße: Mahony

[nudels64]

Danke MAhonny. Die Fehlermeldung bleibt leider:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank, r.user_id, u.username, u.user_colour, r.status AS stat' at line 2 [1064]

SQL

SELECT r.rank_total AS rank, r.user_id, u.username, u.user_colour, r.status AS status, r.points_total AS points, r.win_total AS win FROM phpbb_footb_rank_matchdays AS r LEFT JOIN phpbb_users AS u ON (r.user_id = u.user_id) WHERE r.season = 2019 AND r.league = 1 AND r.matchday = 23 AND r.status IN (2,3) ORDER BY points DESC, LOWER(u.username) ASC

[Mahony]

Hallo

Suche in der /football/block/rank_total.php

Code: Alles auswählen

$sql = 'SELECT
					r.rank_total AS rank,
					r.user_id,
					u.username,
					u.user_colour,
					r.status AS status,
					r.points_total AS points,
					r.win_total AS win
				FROM '. FOOTB_RANKS . ' AS r
				LEFT JOIN '. USERS_TABLE . " AS u ON (r.user_id = u.user_id)
				WHERE r.season = $season 
					AND r.league = $league 
					AND r.matchday = $rank_matchday 
					AND r.status IN (2,3)
				ORDER BY points DESC, LOWER(u.username) ASC";

Ersetze mit

Code: Alles auswählen

$sql = 'SELECT
					r.rank_total AS rank,
					r.user_id,
					u.username,
					u.user_colour,
					r.status AS status,
					r.points_total AS points,
					r.win_total AS win
				FROM '. FOOTB_RANKS . ' AS r
				LEFT JOIN '. USERS_TABLE . " AS u ON (r.user_id = u.user_id)
				WHERE r.season = $season 
					AND r.league = $league 
					AND r.matchday = $rank_matchday 
					AND r.status IN (2,3)
				ORDER BY r.points DESC, LOWER(u.username) ASC";

Grüße: Mahony

[nudels64]

Oops, ich hab Mist gemacht. Sorry. Die erste Änderung läuft bei Aufruf der Tipprunde. Jetzt hab ich noch eine Fehlermeldung beim Speichern der Spielplan Aktualisierungen (Ligadaten aktualisieren).

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank, 0.00 AS win, u.user_id, u.username AS username, SUM(IF(m.m' at line 2 [1064]

SQL

SELECT 1 AS rank, 0.00 AS win, u.user_id, u.username AS username, SUM(IF(m.match_no > 0, 1, 0)) AS matches, SUM(IF(b.goals_home = '' OR b.goals_guest = '', 1, 0)) AS nobet, SUM(IF(b.goals_home <> '' AND b.goals_guest <> '', IF((b.goals_home = m.goals_home) AND (b.goals_guest = m.goals_guest) , 1 , 0 ) , 0 ) ) AS direct_hit, SUM(IF(b.goals_home <> '' AND b.goals_guest <> '', IF((b.goals_home + 0 < b.goals_guest) <> (m.goals_home + 0 < m.goals_guest) OR (b.goals_home = b.goals_guest) <> (m.goals_home = m.goals_guest) OR (b.goals_home + 0 > b.goals_guest) <> (m.goals_home + 0 > m.goals_guest) , 0 , 1 ) , 0 ) ) AS tendency, SUM(IF(b.goals_home <> '' AND b.goals_guest <> '',IF(b.goals_home <> '' AND b.goals_guest <> '', IF((b.goals_home + 0 < b.goals_guest) <> (m.goals_home + 0 < m.goals_guest) OR (b.goals_home = b.goals_guest) <> (m.goals_home = m.goals_guest) OR (b.goals_home + 0 > b.goals_guest) <> (m.goals_home + 0 > m.goals_guest), 0, IF((b.goals_home = m.goals_home) AND (b.goals_guest = m.goals_guest), 10, IF((b.goals_home = b.goals_guest), 10 - ABS(b.goals_home - m.goals_home), IF(((10 - ABS(b.goals_home - m.goals_home) - ABS(b.goals_guest - m.goals_guest)) < 3), 3, 10 - ABS(b.goals_home - m.goals_home) - ABS(b.goals_guest - m.goals_guest) ) ) ) ), 0 ), 0 ) )AS points FROM phpbb_footb_matches AS m INNER JOIN phpbb_footb_bets AS b ON (b.season = m.season AND b.league = m.league AND b.match_no = m.match_no) INNER JOIN phpbb_users AS u ON (b.user_id = u.user_id) WHERE m.season = 2019 AND m.league = 1 AND m.matchday = 1 AND m.status IN (2,3) GROUP BY b.user_id ORDER BY points DESC, nobet ASC, username ASC