Timesheet: "Invalid SQL" Error after update to 1.8.005

mand 2013-10-03 16:42:57 UTC #1

Hello,

I am using Postgres 8.4 on Debian Squeeze.
after updating to 1.8.005, I receive the following error when selecting a time range (for instance “Last Month”) in the Timesheet app:

=====
Database error

Invalid SQL: (SELECT ,round(cast(ts_quantityts_unitprice AS numeric),2) AS ts_total,TO_CHAR((TIMESTAMP WITH TIME ZONE ‘epoch’ + (ts_start) * INTERVAL ‘1 sec’),‘YYYYMM’) AS ts_month,0 AS is_sum_month,TO_CHAR((TIMESTAMP WITH TIME ZONE ‘epoch’ + (ts_start) * INTERVAL ‘1 sec’),‘YYYY-MM-DD’) AS ts_day,0 AS is_sum_day FROM egw_timesheet WHERE (1380578400 <= ts_start AND ts_start < 1383260400) AND ts_owner=‘1024’ ORDER BY ts_start DESC)
UNION
(SELECT -2,’’,’’,’’,MIN(ts_start),SUM(ts_duration) AS ts_duration,0,0,NULL,0,0,0,0,0,SUM(round(cast(ts_quantityts_unitprice AS numeric),2)) AS ts_total,TO_CHAR((TIMESTAMP WITH TIME ZONE ‘epoch’ + (MIN(ts_start)) * INTERVAL ‘1 sec’),‘YYYYMM’),1 AS is_sum_month,TO_CHAR((TIMESTAMP WITH TIME ZONE ‘epoch’ + (MIN(ts_start)) * INTERVAL ‘1 sec’),‘YYYY-MM-DD’),0 AS is_sum_day FROM egw_timesheet WHERE (1380578400 <= ts_start AND ts_start < 1383260400) AND ts_owner=‘1024’ GROUP BY TO_CHAR((TIMESTAMP WITH TIME ZONE ‘epoch’ + (ts_start) * INTERVAL ‘1 sec’),‘YYYYMM’),-2,’’,0,NULL,ts_total,is_sum_month,‘YYYY-MM-DD’) )
UNION
(SELECT 0,’’,’’,’’,MIN(ts_start),SUM(ts_duration) AS ts_duration,0,0,NULL,0,0,0,0,0,SUM(round(cast(ts_quantityts_unitprice AS numeric),2)) AS ts_total,TO_CHAR((TIMESTAMP WITH TIME ZONE ‘epoch’ + (MIN(ts_start)) * INTERVAL ‘1 sec’),‘YYYYMM’),0 AS is_sum_month,TO_CHAR((TIMESTAMP WITH TIME ZONE ‘epoch’ + (MIN(ts_start)) * INTERVAL ‘1 sec’),‘YYYY-MM-DD’),1 AS is_sum_day FROM egw_timesheet WHERE (1380578400 <= ts_start AND ts_start < 1383260400) AND ts_owner=‘1024’ GROUP BY TO_CHAR((TIMESTAMP WITH TIME ZONE ‘epoch’ + (ts_start) * INTERVAL ‘1 sec’),‘YYYY-MM-DD’),0,’’,NULL,ts_total,‘YYYYMM’),is_sum_day ):
ERROR: syntax error at or near ")"
LINE 3: …‘YYYYMM’),-2,’’,0,NULL,ts_total,is_sum_month,‘YYYY-MM-DD’) )
^

I saw a similar bug on the mailing list and tried applying the changes to timesheet/inc/class.timesheet_bo.inc.php from r43654, but still get a (slightly different) “Invalid SQL” error.

Ralf_Becker_Stylite 2013-10-04 07:16:58 UTC #2

That’s fixed now in svn. Either wait for next maintenance package, use
daily snapshot from tomorrow or replace the files in following 2 commits:

Thanks for reporting the issue.

Ralf

Ralf Becker
Director Software Development

Stylite AG

Morschheimer Strasse 15 | Tel. +49 6352 70629 0
D-67292 Kirchheimbolanden | Fax. +49 6352 70629 30

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 31158 Kaiserslautern Germany

October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk

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