Hallo
Ubuntu 16.04, php 7.2.14, 17.1.20190111
beim Öffnen - Doppelklick - einer Adresse im Adressbuch wird folgender Fehler ausgegeben:
//
[07-Feb-2019 19:21:49 Europe/Berlin] Database error (EGroupware\Api\Db\Exception\InvalidSql): Invalid SQL: SELECT n_fn,org_name,contact_id AS user_id,
(
select concat(cal_start,":",egw_cal_user.cal_id,":",cal_recur_date)
from egw_cal_user
JOIN egw_cal_dates on egw_cal_dates.cal_id=egw_cal_user.cal_id and (cal_recur_date=0 or cal_recur_date=cal_start)
JOIN egw_cal ON egw_cal.cal_id=egw_cal_user.cal_id AND egw_cal.cal_deleted IS NULL
WHERE cal_user_type=“c” and cal_user_id=CAST(contact_id AS varchar) and cal_start < unix_timestamp(now()) AND egw_cal_user.cal_status != “R"
order by cal_start DESC Limit 1
) as last_event,
(
select concat(cal_start,”:",egw_cal_user.cal_id,":",cal_recur_date)
FROM egw_cal_user
JOIN egw_cal_dates on egw_cal_dates.cal_id=egw_cal_user.cal_id and (cal_recur_date=0 or cal_recur_date=cal_start)
JOIN egw_cal ON egw_cal.cal_id=egw_cal_user.cal_id AND egw_cal.cal_deleted IS NULL
WHERE cal_user_type=“c” and cal_user_id=CAST(contact_id AS varchar) and cal_start > unix_timestamp(now()) AND egw_cal_user.cal_status != “R"order by cal_recur_date ASC, cal_start ASC Limit 1
) as next_event
FROM egw_addressbook
WHERE contact_id IN (‘458’)
FEHLER: Spalte »:« existiert nicht
LINE 3: select concat(cal_start,”:",egw_cal_user.cal_id,":",cal_…
^ (-1)
//
Im Verlauf des heutigen Tages konnte ich Adressen öffnen ohne eine Fehlermeldung.
Nachdem ich eine bestehende Adresse kopiert, abgeändert und gespeichert habe, resultierte dieser Fehler.
hat jemand eine Idee, was hier passiert ist und wie ich das wieder weg bekommen.
vielen Dank für Eure Unterstützung.
