sesma schrieb: Hallo,
ich hab die heute die neuste JSM version aus dem Github hochgeladen, jetzt kommt folgender fehler:
"1054 - Unknown column 'match_date_notime' in 'order clause' SQL=SELECT m.id,m.id as match_id,m.projectteam1_id,m.projectteam2_id,m.round_id,m.team1_result,m.team2_result,m.team1_result_split,m.team2_result_split,m.match_result_detail,m.match_result_type,m.crowd,m.show_report,m.playground_id ,r.name,m.match_date AS match_date,m.match_timestamp,UTC_TIMESTAMP() AS currenttime,p.name AS pname,p.current_round,p.id AS project_id,p.timezone,p.game_parts,p.ordering,t1.id as team1_id,t2.id as team2_id,IF (mref.project_referee_id > 0, concat(person.lastname, ', ', person.firstname), '') AS refname,CONCAT_WS( ':', p.id, p.alias ) AS project_slug,CONCAT_WS( ':', r.id, r.alias ) AS round_slug,CONCAT_WS(':',m.id,CONCAT_WS("_",t1.alias,t2.alias)) AS match_slug ,m.match_date AS alreadyplayed FROM #__sportsmanagement_match AS m INNER JOIN #__sportsmanagement_round AS r ON m.round_id = r.id INNER JOIN #__sportsmanagement_project AS p ON p.id = r.project_id LEFT JOIN #__sportsmanagement_project_team AS pt1 ON m.projectteam1_id = pt1.id LEFT JOIN #__sportsmanagement_project_team AS pt2 ON m.projectteam2_id = pt2.id LEFT JOIN #__sportsmanagement_season_team_id AS st1 ON st1.id = pt1.team_id LEFT JOIN #__sportsmanagement_season_team_id AS st2 ON st2.id = pt2.team_id LEFT JOIN #__sportsmanagement_team AS t1 ON t1.id = st1.team_id LEFT JOIN #__sportsmanagement_club AS c1 ON c1.id = t1.club_id LEFT JOIN #__sportsmanagement_team AS t2 ON t2.id = st2.team_id LEFT JOIN #__sportsmanagement_club AS c2 ON c2.id = t2.club_id LEFT JOIN #__sportsmanagement_playground AS playground ON playground.id = m.playground_id LEFT JOIN #__sportsmanagement_match_referee AS mref ON mref.match_id = m.id LEFT JOIN #__sportsmanagement_project_referee AS pref ON pref.id = mref.project_referee_id LEFT JOIN #__sportsmanagement_season_person_id AS sp ON pref.person_id = sp.id LEFT JOIN #__sportsmanagement_person AS person ON person.id = sp.person_id WHERE p.published = 1 AND m.published = 1 AND m.team1_result IS NOT NULL AND ( m.match_timestamp >= 1488630084 AND m.match_timestamp <= 1489234884 ) AND p.id IN ( 3,2 ) ORDER BY match_date_notime, p.ordering ASC LIMIT 18"
url zur seite:
alltimesoocer.de
PS.: der euer Bugtracker wird micht angezeigt mit einer PHP version fehlermeldung (ist nur ein hinweis, keine kritik)
mfg sesma
(Sebastian Smarsly)
Ein Schuß ins blaue. Hast du mal die Optionen aufgerufen und gespeichert?
