Good afternoon,
I have been playing with timesheet to see how it will work when used in connection with addressbook and project manager. After I created one entry, I got this error:
Database error
Invalid SQL: SELECT SUM(pe_completion * (CASE WHEN pe_share IS NULL AND pe_planned_time IS NULL AND pe_replanned_time IS NULL THEN 240 WHEN pe_share IS NULL AND pe_planned_time IS NULL THEN pe_replanned_time WHEN pe_share IS NULL THEN pe_planned_time ELSE pe_share END)) AS pe_sum_completion_shares,SUM(CASE WHEN pe_completion IS NULL THEN NULL ELSE (CASE WHEN pe_share IS NULL AND pe_planned_time IS NULL AND pe_replanned_time IS NULL THEN 240 WHEN pe_share IS NULL AND pe_planned_time IS NULL THEN pe_replanned_time WHEN pe_share IS NULL THEN pe_planned_time ELSE pe_share END) END) AS pe_total_shares,SUM(pe_used_time) AS pe_used_time,SUM(pe_planned_time) AS pe_planned_time,SUM(pe_replanned_time) AS pe_replanned_time,SUM(pe_used_budget) AS pe_used_budget,SUM(pe_planned_budget) AS pe_planned_budget,MIN(pe_real_start) AS pe_real_start,MIN(pe_planned_start) AS pe_planned_start,MAX(pe_real_end) AS pe_real_end,MAX(pe_planned_end) AS pe_planned_end FROM egw_pm_elements ,egw_links WHERE
pe_id=link_id AND (pm_id=20 AND pe_status != ‘ignore’) HAVING pe_app='timesheet’
Unknown column ‘pe_app’ in ‘having clause’ (1054)
Click here to resume your eGroupWare Session.
This happened, when I had created project, further a sub-project within that one and created new timesheet entry with link to addressbook contact. The timesheet entry exists in a list of the project and this error appears, when clicked on it to open it. now it seems, i am not able to open it, view it or delete it.
egroupware 14.1 sits on ubuntu 14.04 server on local LAN.
any ideas?
thank you.
daniel
Infragistics Professional
Build stunning WinForms apps today!
Reboot your WinForms applications with our WinForms controls.
Build a bridge from your legacy apps to the future.
http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users
