500 - JDatabaseMySQLi::query: 1064 - 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 '*,p.name AS project_name,pers.lastname as referee_name ,playground.name AS playg' at line 1 SQL=SELECT m.*, DATE_FORMAT(m.time_present, "%H:%i") time_present, t1.id AS team1, t2.id AS team2, r.roundcode, pt1.division_id, r.id roundid, r.project_id,r.name, p.timezone, p.name,p.league_id as league_id,p.season_id, l.id as league_id,l.name as league_name, s.id as season_id,s.name as season_name, r.round_date_first as wk_datum_von, r.round_date_last as wk_datum_bis, p.name AS project_name,pers.lastname as referee_name*,p.name AS project_name,pers.lastname as referee_name ,playground.name AS playground_name,playground.short_name AS playground_short_name FROM j25_joomleague_match AS m INNER JOIN j25_joomleague_round r ON m.round_id=r.id INNER JOIN j25_joomleague_project_team AS pt1 ON m.projectteam1_id=pt1.id INNER JOIN j25_joomleague_team AS t1 ON t1.id=pt1.team_id INNER JOIN j25_joomleague_project_team AS pt2 ON m.projectteam2_id=pt2.id INNER JOIN j25_joomleague_team AS t2 ON t2.id=pt2.team_id INNER JOIN j25_joomleague_project AS p ON p.id=r.project_id INNER JOIN j25_joomleague_league AS l ON p.league_id=l.id INNER JOIN j25_joomleague_season AS s ON p.season_id=s.id INNER JOIN j25_joomleague_match_referee AS mref ON mref.match_id=m.id INNER JOIN j25_joomleague_project_referee AS pref ON pref.id=mref.project_referee_id INNER JOIN j25_joomleague_person AS pers ON pers.id=pref.person_id INNER JOIN j25_joomleague_match_referee AS mref ON mref.match_id=m.id INNER JOIN j25_joomleague_project_referee AS pref ON pref.id=mref.project_referee_id INNER JOIN j25_joomleague_person AS pers ON pers.id=pref.person_id LEFT JOIN j25_joomleague_playground AS playground ON playground.id=m.playground_id WHERE m.published=1 AND ((t1.id= 105 AND m.team1_result < m.team2_result) OR (t2.id= 105 AND m.team1_result > m.team2_result)) AND mref.project_referee_id=105 AND p.season_id=9 AND (t1.id=105 OR t2.id=105) GROUP BY m.id ORDER BY r.roundcode ASC,m.match_date,m.match_number

Die Seite kann nicht angezeigt werden, weil:

  1. Ein veraltetes Lesezeichen
  2. Eine Suchmaschine hat einen veralteten Index der Website
  3. Eine falsche Adresse
  4. Kein Zugriff auf diese Seite!
  5. Die angefragte Quelle wurde nicht gefunden!
  6. Während der Anfrage ist ein Fehler aufgetreten!

Bitte eine der folgenden Seiten ausprobieren:

Bei Problemen ist der Administrator dieser Website zuständig..

JDatabaseMySQLi::query: 1064 - 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 '*,p.name AS project_name,pers.lastname as referee_name ,playground.name AS playg' at line 1 SQL=SELECT m.*, DATE_FORMAT(m.time_present, "%H:%i") time_present, t1.id AS team1, t2.id AS team2, r.roundcode, pt1.division_id, r.id roundid, r.project_id,r.name, p.timezone, p.name,p.league_id as league_id,p.season_id, l.id as league_id,l.name as league_name, s.id as season_id,s.name as season_name, r.round_date_first as wk_datum_von, r.round_date_last as wk_datum_bis, p.name AS project_name,pers.lastname as referee_name*,p.name AS project_name,pers.lastname as referee_name ,playground.name AS playground_name,playground.short_name AS playground_short_name FROM j25_joomleague_match AS m INNER JOIN j25_joomleague_round r ON m.round_id=r.id INNER JOIN j25_joomleague_project_team AS pt1 ON m.projectteam1_id=pt1.id INNER JOIN j25_joomleague_team AS t1 ON t1.id=pt1.team_id INNER JOIN j25_joomleague_project_team AS pt2 ON m.projectteam2_id=pt2.id INNER JOIN j25_joomleague_team AS t2 ON t2.id=pt2.team_id INNER JOIN j25_joomleague_project AS p ON p.id=r.project_id INNER JOIN j25_joomleague_league AS l ON p.league_id=l.id INNER JOIN j25_joomleague_season AS s ON p.season_id=s.id INNER JOIN j25_joomleague_match_referee AS mref ON mref.match_id=m.id INNER JOIN j25_joomleague_project_referee AS pref ON pref.id=mref.project_referee_id INNER JOIN j25_joomleague_person AS pers ON pers.id=pref.person_id INNER JOIN j25_joomleague_match_referee AS mref ON mref.match_id=m.id INNER JOIN j25_joomleague_project_referee AS pref ON pref.id=mref.project_referee_id INNER JOIN j25_joomleague_person AS pers ON pers.id=pref.person_id LEFT JOIN j25_joomleague_playground AS playground ON playground.id=m.playground_id WHERE m.published=1 AND ((t1.id= 105 AND m.team1_result < m.team2_result) OR (t2.id= 105 AND m.team1_result > m.team2_result)) AND mref.project_referee_id=105 AND p.season_id=9 AND (t1.id=105 OR t2.id=105) GROUP BY m.id ORDER BY r.roundcode ASC,m.match_date,m.match_number

Call stack
# Function Location
1 JSite->dispatch() /kunden/shg24.com/ligaverwaltung/index.php:42
2 JComponentHelper::renderComponent() /kunden/shg24.com/ligaverwaltung/includes/application.php:194
3 JComponentHelper::executeComponent() /kunden/shg24.com/ligaverwaltung/libraries/joomla/application/component/helper.php:348
4 require_once() /kunden/shg24.com/ligaverwaltung/libraries/joomla/application/component/helper.php:380
5 JController->execute() /kunden/shg24.com/ligaverwaltung/components/com_joomleague/joomleague.php:28
6 JoomleagueController->display() /kunden/shg24.com/ligaverwaltung/libraries/joomla/application/component/controller.php:761
7 JoomleagueController->showprojectheading() /kunden/shg24.com/ligaverwaltung/components/com_joomleague/controller.php:20
8 JController->display() /kunden/shg24.com/ligaverwaltung/components/com_joomleague/controller.php:25
9 JoomleagueViewTeamPlan->display() /kunden/shg24.com/ligaverwaltung/libraries/joomla/application/component/controller.php:722
10 JoomleagueModelTeamPlan->getMatchesRefering() /kunden/shg24.com/ligaverwaltung/components/com_joomleague/extensions/schuetzenliga/views/teamplan/view.html.php:38
11 JoomleagueModelTeamPlan->_getResultsPlan() /kunden/shg24.com/ligaverwaltung/components/com_joomleague/extensions/schuetzenliga/models/teamplan.php:171
12 JDatabase->loadObjectList() /kunden/shg24.com/ligaverwaltung/components/com_joomleague/extensions/schuetzenliga/models/teamplan.php:266
13 JDatabaseMySQLi->execute() /kunden/shg24.com/ligaverwaltung/libraries/joomla/database/database.php:1126
14 JError::raiseError() /kunden/shg24.com/ligaverwaltung/libraries/joomla/database/database/mysqli.php:396
15 JError::raise() /kunden/shg24.com/ligaverwaltung/libraries/joomla/error/error.php:224

Joomla!-Debug-Konsole

Fehler

Sitzung

Profil zum Laufzeitverhalten

Speichernutzung

Datenbankabfragen