Hallo, ich bekomme bei Veröffentlichung des Geburtstagsmoduls von JSM einen SQL Fehler. Projekt, Teams, Spieler sind alle ordnungsgemäß erstellt.
Der Rest der Website wird nicht mehr angezeigt - nur noch eine weiße Seite und in der Mitte unten stehende Fehlermeldung
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 ':sg-sv-motor-altenburg) AND pt.project_id IN (3:koestritzer-liga-15-16) GROUP BY' at line 8 SQL=SELECT p.id, p.birthday, p.firstname, p.nickname, p.lastname,p.picture AS default_picture, p.country,DATE_FORMAT(p.birthday, '%m-%d')AS daymonth,YEAR( CURRENT_DATE( ) ) as year,(YEAR( CURRENT_DATE( ) ) - YEAR( p.birthday ) + IF(DATE_FORMAT(CURDATE(), '%m.%d') > DATE_FORMAT(p.birthday, '%m.%d'), 1, 0)) AS age,DATE_FORMAT(p.birthday,'%Y-%m-%d') AS date_of_birth,stp.picture,(TO_DAYS(DATE_ADD(p.birthday, INTERVAL (YEAR(CURDATE()) - YEAR(p.birthday) + IF(DATE_FORMAT(CURDATE(), '%m.%d') > DATE_FORMAT(p.birthday, '%m.%d'), 1, 0)) YEAR)) - TO_DAYS( CURDATE())+0) AS days_to_birthday,'person' AS func_to_call, '' project_id, '' team_id,'pid' AS id_to_append, 1 AS type,st.team_id, pt.project_id,CONCAT_WS(':',pro.id,pro.alias) AS project_slug,CONCAT_WS(':',p.id,p.alias) AS person_slug,CONCAT_WS(':',t.id,t.alias) AS team_slug FROM #__sportsmanagement_person AS p INNER JOIN #__sportsmanagement_season_team_person_id as stp ON stp.person_id = p.id INNER JOIN #__sportsmanagement_season_team_id as st ON st.team_id = stp.team_id INNER JOIN #__sportsmanagement_project_team as pt ON st.id = pt.team_id INNER JOIN #__sportsmanagement_project AS pro ON pro.id = pt.project_id INNER JOIN #__sportsmanagement_team AS t ON t.id = st.team_id WHERE p.published = 1 AND p.birthday != '0000-00-00' AND stp.persontype = 1 AND st.team_id IN (11:sg-sv-motor-altenburg) AND pt.project_id IN (3:koestritzer-liga-15-16) GROUP BY p.id HAVING days_to_birthday <= 0 ORDER BY days_to_birthday ASC LIMIT 0, 2
Hier die Meldung, was könnte da defekt sein?
Joomla 3.5.1 JSM aktuell aus dem Github.
Danke Gruß Frank