From: WTJarryd <ja...@wo...> - 2015-11-12 11:32:37
|
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. |
From: Ralf B. <rb...@st...> - 2015-11-12 13:24:59
Attachments:
signature.asc
|
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 |
From: WTJarryd <ja...@wo...> - 2015-11-12 13:57:58
|
Hello Ralf. I use PostgreSQL -- View this message in context: http://egroupware.219119.n3.nabble.com/Error-updating-Calendar-to-14-3-002-tp4010025p4010027.html Sent from the egroupware-users mailing list archive at Nabble.com. |
From: WTJarryd <ja...@wo...> - 2015-11-12 14:48:45
|
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. -- View this message in context: http://egroupware.219119.n3.nabble.com/Error-updating-Calendar-to-14-3-002-tp4010025p4010028.html Sent from the egroupware-users mailing list archive at Nabble.com. |
From: Ralf B. <rb...@st...> - 2015-11-13 08:55:04
Attachments:
signature.asc
|
Hi WTJarryd, Am 12.11.15 um 15:48 schrieb 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. -- 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 |