Error updating Calendar to 14.3.002

WTJarryd 2015-11-12 11:17:14 UTC #1

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

Ralf_Becker_Stylite 2015-11-12 13:24:49 UTC #2

Hi WTJarryd,

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

Ralf

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
eGroupWare-users@lists.sourceforge.net
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@stylite.de

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

WTJarryd 2015-11-12 13:57:51 UTC #3

Hello Ralf.

I use PostgreSQL

WTJarryd 2015-11-12 14:48:37 UTC #4

Ralf can you tell me what tables are being joined?

Looking through the sql statement and the database, there is no user table. There is a egw_cal_user.
The error is with all the user.cal_id, user.cal_user_type,etc., calls.

Ralf_Becker_Stylite 2015-11-13 08:54:56 UTC #5

Hi WTJarryd,

Ralf can you tell me what tables are being joined?

Looking through the sql statement and the database, there is no user table.
user is used as an alias for the seconded joined egw_cal_user, but
"user" is a reserved word in PostgreSQL (not in MySQL)

Problem is fixed by using an other alias (now “euser”). Please replace
following file in your installation:

https://svn.stylite.de/egroupware/branches/14.2/calendar/setup/tables_update.inc.php
Save it under /usr/share/egroupware/calendar/setup/ and run update again
via logging into Setup (https://domain.com/egroupware/setup/) under
[Manage applications]. Thanks for reporting the issue. Ralf

There is a egw_cal_user.
The error is with all the user.cal_id, user.cal_user_type,etc., calls.