Re: [eGroupWare-users] Error updating Calendar to 14.3.002

[Ralf B. <rb...@st...>]

Hi WTJarryd,

I have the same SQL error from a PostgreSQL user. Do you use PostgreSQL
or MySQL?

Ralf

Am 12.11.15 um 12:17 schrieb WTJarryd:
> Hello. I keep getting an sql syntax error when trying to update the calendar
> app.
>
> The error is:
>
> Invalid SQL: SELECT egw_cal_user.cal_id AS cal_id,egw_cal_user.cal_user_id
> AS cal_user_id,egw_cal_user.cal_user_attendee AS cal_user_attendee
> FROM egw_cal_user
> JOIN egw_cal_user user ON user.cal_id=egw_cal_user.cal_id AND
> user.cal_user_type='e' AND user.cal_user_id=egw_cal_user.cal_user_id AND
> user.cal_user_attendee IS NULL
> WHERE egw_cal_user.cal_user_type='e' AND egw_cal_user.cal_user_attendee IS
> NOT NULL
> GROUP BY
> egw_cal_user.cal_id,egw_cal_user.cal_user_id,egw_cal_user.cal_user_attendee
> ERROR:  syntax error at or near "user"
> LINE 3: JOIN egw_cal_user user ON user.cal_id=egw_cal_user.cal_id AN...
>
> Can someone assist me with this issue? 
>
> If I change the "JOIN egw_cal_user user ON" to "JOIN egw_cal_user ON" or
> "JOIN user ON" then it gives me the following error:
>
> Invalid SQL: SELECT egw_cal_user.cal_id AS cal_id,egw_cal_user.cal_user_id
> AS cal_user_id,egw_cal_user.cal_user_attendee AS cal_user_attendee
> FROM egw_cal_user
> JOIN egw_cal_user ON user.cal_id=egw_cal_user.cal_id AND
> user.cal_user_type='e' AND user.cal_user_id=egw_cal_user.cal_user_id AND
> user.cal_user_attendee IS NULL
> WHERE egw_cal_user.cal_user_type='e' AND egw_cal_user.cal_user_attendee IS
> NOT NULL
> GROUP BY
> egw_cal_user.cal_id,egw_cal_user.cal_user_id,egw_cal_user.cal_user_attendee
> ERROR:  syntax error at or near "."
> LINE 3: JOIN egw_cal_user ON user.cal_id=egw_cal_user.cal_id AND use
>
>
>
> --
> View this message in context: http://egroupware.219119.n3.nabble.com/Error-updating-Calendar-to-14-3-002-tp4010025.html
> Sent from the egroupware-users mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> _______________________________________________
> eGroupWare-users mailing list
> eGr...@li...
> https://lists.sourceforge.net/lists/listinfo/egroupware-users


-- 
Ralf Becker
Director Software Development

Stylite AG

Isaac-Fulda-Allee 9 | Tel. +49 6131 32702-0
D-55124 Mainz       | Fax. +49 6131 32702-70

Email: rb...@st...

www.stylite.de | www.egroupware.org

Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller
Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer

VAT DE214280951 | Registered HRB 46224 Mainz Germany