Database Error when trying to modify the time of a previously created event

Anthony_Messina 2009-07-31 16:42:39 UTC #1

I have created the following tracker item:
http://www.egroupware.org:80/egroupware/index.php?menuaction=tracker.tracker_ui.edit&tr_id=2202

Is anyone else having this problem in trunk?

I create any event in the calendar. When I want to edit the event and modify
the start time, I am presented with the following error (PostgreSQL):

Database error

Invalid SQL: UPDATE egw_cal_user SET cal_recur_date=cal_recur_date+10800 WHERE
cal_id=669 AND cal_recur_date != 0 ORDER BY cal_recur_date DESC:
ERROR: syntax error at or near "ORDER"
LINE 1: …te+10800 WHERE cal_id=669 AND cal_recur_date != 0 ORDER BY c…
^

Click here to resume your eGroupWare Session.

And of course, the update of the event fails.

Also, even when I remove the “ORDER BY…” and run the UPDATE command, the
event does not get modified.

–
Anthony - http://messinet.com - http://messinet.com/~amessina/gallery
8F89 5E72 8DF0 BCF0 10BE 9967 92DC 35DC B001 4A4E

Anthony_Messina 2009-08-07 19:11:22 UTC #2

I have created the following tracker item:
http://www.egroupware.org:80/egroupware/index.php?menuaction=tracker.tracke
r_ui.edit&tr_id=2202

Is anyone else having this problem in trunk?

I create any event in the calendar. When I want to edit the event and
modify the start time, I am presented with the following error
(PostgreSQL):

Database error

Invalid SQL: UPDATE egw_cal_user SET cal_recur_date=cal_recur_date+10800
WHERE cal_id=669 AND cal_recur_date != 0 ORDER BY cal_recur_date DESC:
ERROR: syntax error at or near "ORDER"
LINE 1: …te+10800 WHERE cal_id=669 AND cal_recur_date != 0 ORDER BY c…
^

Click here to resume your eGroupWare Session.

And of course, the update of the event fails.

Also, even when I remove the “ORDER BY…” and run the UPDATE command, the
event does not get modified.

Well, at least one other user is seeing this with PostgreSQL:
http://www.egroupware.org/egroupware/index.php?menuaction=tracker.tracker_ui.edit&tr_id=2202

Anyone else have an idea of how to fix this? I cannot ever change the time of
an event with this issue

Also, the problem still exists for me with svn trunk @r27614 (today).

–
Anthony - http://messinet.com - http://messinet.com/~amessina/gallery
8F89 5E72 8DF0 BCF0 10BE 9967 92DC 35DC B001 4A4E

jaytraxx 2009-08-08 16:46:43 UTC #3

Hi folks,

did you run setup and upgraded your databases? The database layout of
calendar changed the last few commits and therefor you have to upgrade
your databases.

christian

Anthony Messina schrieb:

I have created the following tracker item:
http://www.egroupware.org:80/egroupware/index.php?menuaction=tracker.tracke
r_ui.edit&tr_id=2202

Is anyone else having this problem in trunk?

I create any event in the calendar. When I want to edit the event and
modify the start time, I am presented with the following error
(PostgreSQL):

Database error

Invalid SQL: UPDATE egw_cal_user SET cal_recur_date=cal_recur_date+10800
WHERE cal_id=669 AND cal_recur_date != 0 ORDER BY cal_recur_date DESC:
ERROR: syntax error at or near "ORDER"
LINE 1: …te+10800 WHERE cal_id=669 AND cal_recur_date != 0 ORDER BY c…
^

Click here to resume your eGroupWare Session.

And of course, the update of the event fails.

Also, even when I remove the “ORDER BY…” and run the UPDATE command, the
event does not get modified.

Well, at least one other user is seeing this with PostgreSQL:
http://www.egroupware.org/egroupware/index.php?menuaction=tracker.tracker_ui.edit&tr_id=2202

Anyone else have an idea of how to fix this? I cannot ever change the time of
an event with this issue

Also, the problem still exists for me with svn trunk @r27614 (today).

Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what’s new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what’s new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

Anthony_Messina 2009-08-09 01:32:16 UTC #4

I sure did, that’s why I’m a bit confused. I ran through setup and upgraded
applications, but to no avail. I assume you are NOT having this issue then?

Ralf_Becker_6 2009-08-09 07:52:34 UTC #5

Hi Anthony,

found and fixed the problem:

wrong SQL (UPDATE with ORDER BY) was introduce in SyncML-1.2 patch, no
idea what the idea behind was …

Ralf

Anthony Messina schrieb:

I sure did, that’s why I’m a bit confused. I ran through setup and upgraded
applications, but to no avail. I assume you are NOT having this issue then?

From: “Christian Binder” christian@jaytraxx.de
To: egroupware-developers@lists.sourceforge.net
Date: Sat, 08 Aug 2009 18:46:43 +0200

Hi folks,

did you run setup and upgraded your databases? The database layout of
calendar changed the last few commits and therefor you have to upgrade
your databases.

christian

Anthony Messina schrieb:

I have created the following tracker item:

http://www.egroupware.org:80/egroupware/index.php?menuaction=tra
cker.tracke
r_ui.edit&tr_id=2202

Is anyone else having this problem in trunk?

I create any event in the calendar. When I want to edit the event and
modify the start time, I am presented with the following error
(PostgreSQL):

Database error

Invalid SQL: UPDATE egw_cal_user SET
cal_recur_date=cal_recur_date+10800
WHERE cal_id=669 AND cal_recur_date != 0 ORDER BY cal_recur_date DESC:
ERROR: syntax error at or near "ORDER"
LINE 1: …te+10800 WHERE cal_id=669 AND cal_recur_date != 0 ORDER BY
c…
^

Click here to resume your eGroupWare Session.

And of course, the update of the event fails.

Also, even when I remove the “ORDER BY…” and run the UPDATE command,
the

event does not get modified.
Well, at least one other user is seeing this with PostgreSQL:

http://www.egroupware.org/egroupware/index.php?menuaction=tracker.
tracker_ui.edit&tr_id=2202

Anyone else have an idea of how to fix this? I cannot ever change the
time of

an event with this issue

Also, the problem still exists for me with svn trunk @r27614 (today).

Let Crystal Reports handle the reporting - Free Crystal Reports 2008
30-Day

trial. Simplify your report design, integration and deployment - and
focus

on
what you do best, core application coding. Discover what’s new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net

https://lists.sourceforge.net/lists/listinfo/egroupware-developers

Let Crystal Reports handle the reporting - Free Crystal Reports 2008
30-Day
trial. Simplify your report design, integration and deployment - and focus
on
what you do best, core application coding. Discover what’s new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

–
Ralf Becker
Director Software Development

Stylite GmbH
[open style of IT]

Morschheimer Strasse 15
67292 Kirchheimbolanden

fon +49 (0) 6352 70629-0
fax +49 (0) 6352 70629-30
mailto: rb@stylite.de

www.stylite.de
www.egroupware.org

Geschäftsführer Andre Keller, Gudrun Müller,
Nigel Vickers und Ralf Becker
Registergericht Kaiserslautern HRB 30575
Umsatzsteuer-Id / VAT-Id: DE214280951

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

Anthony_Messina 2009-08-10 00:24:42 UTC #6

Hi Anthony,

found and fixed the problem:

wrong SQL (UPDATE with ORDER BY) was introduce in SyncML-1.2 patch, no
idea what the idea behind was …

Ralf

Thanks, Ralf. I appreciate it. -A

–
Anthony - http://messinet.com - http://messinet.com/~amessina/gallery
8F89 5E72 8DF0 BCF0 10BE 9967 92DC 35DC B001 4A4E