phpBB.de

Glueckmacher hat geschrieben:Irgendwie habe ich da einen Denkfehler. Wieso lege ich den Abgabetermin auf den 5. Spieltag, wenn es bis zum 3. Spieltag möglich sein soll? Oder ein Tippfehler?

Glueckmacher hat geschrieben:Und noch ein Hinweis auf <br/>, das mehrfach in den Hilfezeilen vorkommt. Ich gehe mal davon aus, dass das nicht gewollt war.

Glueckmacher hat geschrieben: Da fällt mir gerade noch etwas auf. In der root/adm/style/acp_football_results.html steht ganz unten "!-- INCLUDE overall_footer.html -->". Ich gehe davon aus, dass es "<!-- INCLUDE overall_footer.html -->" sein müsste.

Hegse hat geschrieben:Erhalte jetzt folgende Fehlermeldung wenn ich z.B. auf die Tippseite gehe:

Code: Alles auswählen

SQL ERROR [ mysqli ]

Invalid utf8 character string: '�U�' [1300]

SQL

SELECT m.league, m.match_no, m.matchday, m.status, m.group_id, m.formula_home, m.formula_guest, t1.team_symbol AS home_symbol, t2.team_symbol AS guest_symbol, t1.team_id AS home_id, t2.team_id AS guest_id, t1.team_name AS home_name, t2.team_name AS guest_name, b.goals_home AS bet_home, b.goals_guest AS bet_guest, m.goals_home, m.goals_guest, CONCAT( CASE DATE_FORMAT(m.match_datetime,'%w') WHEN 0 THEN 'So' WHEN 1 THEN 'Mo' WHEN 2 THEN 'Di' WHEN 3 THEN 'Mi' WHEN 4 THEN 'Do' WHEN 5 THEN 'Fr' WHEN 6 THEN 'Sa' ELSE 'Error' END, DATE_FORMAT(m.match_datetime,' %d.%m. %H:%i') ) AS match_time, IF(((m.status = 2) OR (m.status = 3)),IF(b.goals_home <> '' AND b.goals_guest <> '', IF((b.goals_home < b.goals_guest) <> (m.goals_home < m.goals_guest) OR (b.goals_home = b.goals_guest)<>(m.goals_home = m.goals_guest) OR (b.goals_home>b.goals_guest)<>(m.goals_home>m.goals_guest), '', IF((b.goals_home = U�U� '' ), '' ) AS points 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.match_no = m.match_no AND b.user_id = 2) LEFT JOIN phpbb3_footb_teams AS t1 ON (t1.season = m.season AND t1.league = m.league AND t1.team_id = m.team_id_home) LEFT JOIN phpbb3_footb_teams AS t2 ON (t2.season = m.season AND t2.league = m.league AND t2.team_id = m.team_id_guest) WHERE m.season = 2010 AND m.league = 6 AND m.matchday = 1 GROUP BY m.match_no ORDER BY m.match_datetime ASC, m.match_no ASC

Einbaufehler von mir?

		case 3:
			$select_part = 	($sum ? "SUM(IF(b.goals_home <> '' AND b.goals_guest <> ''," : 'IF(((m.status = 2) OR (m.status = 3)),') .
								"IF(b.goals_home <> '' AND b.goals_guest <> '',
									IF((b.goals_home < b.goals_guest) <> ($creator.goals_home < $creator.goals_guest) OR (b.goals_home = b.goals_guest)<>($creator.goals_home = $creator.goals_guest) OR (b.goals_home>b.goals_guest)<>($creator.goals_home>$creator.goals_guest),
										" .($sum ? '0' : "''") . ",
										IF((b.goals_home = $creator.goals_home) AND (b.goals_guest = $creator.goals_guest),
											$points_result,
											$points_tendency
										)
									),
									" .($sum ? '0' : "''") . '
								),
								' .($sum ? '0' : "''") . "
							) " .($sum ? ')' : '') . 'AS points';
			break;

MySQL-ERROR
MySQL meldet:
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 'COLLATE utf8_bin NOT NULL, `result` varchar(255) COLLATE utf8

Fehler bei der Anfrage:
CREATE TABLE IF NOT EXISTS `probe_footb_extra` ( `season` smallint(4) unsigned NOT NULL DEFAULT '0', `league` tinyint(2) NOT NULL DEFAULT '0', `extra_no` smallint(4) unsigned NOT NULL DEFAULT '0', `question_type` tinyint(2) NOT NULL DEFAULT '1', `question` varchar(255) COLLATE utf8_bin NOT NULL, `result` varchar(255) COLLATE utf8_bin NOT NULL, `matchday` tinyint(2) NOT NULL DEFAULT '0', `matchday_eval` tinyint(2) NOT NULL DEFAULT '0', `extra_points` tinyint(2) NOT NULL DEFAULT '0', `extra_status` tinyint(2) NOT NULL DEFAULT '0', PRIMARY KEY (`season`,`league`,`extra_no`), KEY `matchday` (`matchday`), KEY `matchday_eval` (`matchday_eval`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
MySQL-ERROR
MySQL meldet:
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 'COLLATE utf8_bin NOT NULL, `bet_points` tinyint(2) NOT NULL D

Fehler bei der Anfrage:
CREATE TABLE IF NOT EXISTS `probe_footb_extra_bets` ( `season` smallint(4) unsigned NOT NULL DEFAULT '0', `league` tinyint(2) NOT NULL DEFAULT '0', `extra_no` smallint(4) unsigned NOT NULL DEFAULT '0', `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `bet` varchar(255) COLLATE utf8_bin NOT NULL, `bet_points` tinyint(2) NOT NULL DEFAULT '0', PRIMARY KEY (`season`,`league`,`extra_no`,`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Allgemeiner Fehler
SQL ERROR [ mysql4 ]

Table 'meineDB.FOOTB_EXTRA' doesn't exist [1146]

SQL

SELECT e.*, t1.team_name AS result_team FROM FOOTB_EXTRA AS e LEFT JOIN probe_footb_teams AS t1 ON (t1.season = e.season AND t1.league = e.league AND t1.team_id = e.result) WHERE e.season = 2010 AND e.league = 1 AND e.matchday_eval = 32 ORDER BY e.extra_no ASC

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/acp/acp_football_results.php
LINE: 502
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_football_results->main()

FILE: adm/index.php
LINE: 82
CALL: p_master->load_active()

Lösung: Die Datei constants.php wie bspw. in der MOD-Anleitung beschrieben bearbeiten.

Mahony hat geschrieben:Hallo
Schau mal hier SQL Error : 1146 Table 'xxx' doesn't exist.

Lösung: Die Datei constants.php wie bspw. in der MOD-Anleitung beschrieben bearbeiten.

Grüße: Mahony

football hat geschrieben:
[/code]
Neue Adminmodule über System - Administrations Bereich - MOD - Football hinzufügen und aktivieren:

Code: Alles auswählen

Spielplan Verwaltung -> Sondertipps verwalten
Tipprunden Konfiguration - > Benutzerhilfe