14.1 SQL error on opening Projects

teplcon 2014-09-29 15:44:22 UTC #1

Hello,

I’m running 14.1 on CentOS_6 with postgresql 9.2. When I open Projects
I’m getting the following 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,CASE WHEN
link_app1=‘projectmanager’ AND link_id1=CAST(pm_id AS varchar) THEN
link_app2 ELSE link_app1 END AS pe_app,CASE WHEN
link_app1=‘projectmanager’ AND link_id1=CAST(pm_id AS varchar) THEN
link_id2 ELSE link_id1 END AS pe_app_id,link_remark AS pe_remark FROM
egw_pm_elements ,egw_links WHERE pe_id=link_id AND (pm_id IS NULL AND
pe_status != ‘ignore’)
ERROR: column “egw_links.link_app1” must appear in the GROUP BY clause
or be used in an aggregate function
LINE 1: …d,MAX(pe_planned_end) AS pe_planned_end,CASE WHEN link_app1=…
^ (-1)

The page will then open, but if I try to add a new project, nothing
happens except a red blinking icon which shows this error:

TypeError: app.projectmanager is undefined

–
myEMAILsignature Thomas Plancon
CAD/IT Manager

B K A Architects, Inc.
142 Crescent Street
Brockton, MA 02302

tel: 508 . 583 . 5603 ext 313
fax: 508 . 584 . 2914
www.bkaarchitects.com http://www.bkaarchs.com/

Ralf_Becker_Stylite 2014-09-29 17:43:44 UTC #2

Hi Tom,

that one is fixed since today:

http://svn.stylite.de/viewvc/egroupware?revision=48782&view=revision

Either wait for next package or download the file (click on filename and
then download) and replace it in your system.

Let me know if replacing the file fixes the problem for you.

Ralf

Hello,

I’m running 14.1 on CentOS_6 with postgresql 9.2. When I open Projects
I’m getting the following 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,CASE WHEN link_app1=‘projectmanager’ AND
link_id1=CAST(pm_id AS varchar) THEN link_app2 ELSE link_app1 END AS
pe_app,CASE WHEN link_app1=‘projectmanager’ AND link_id1=CAST(pm_id AS
varchar) THEN link_id2 ELSE link_id1 END AS pe_app_id,link_remark AS
pe_remark FROM egw_pm_elements ,egw_links WHERE pe_id=link_id AND
(pm_id IS NULL AND pe_status != ‘ignore’)
ERROR: column “egw_links.link_app1” must appear in the GROUP BY
clause or be used in an aggregate function
LINE 1: …d,MAX(pe_planned_end) AS pe_planned_end,CASE WHEN link_app1=…
^ (-1)

The page will then open, but if I try to add a new project, nothing
happens except a red blinking icon which shows this error:

TypeError: app.projectmanager is undefined

log_on_client@http://10.10.10.93/egroupware/phpgwapi/inc/min/?b=egroupware&f=phpgwapi/js/jquery/jquery.js,phpgwapi/js/jquery/jquery-ui.js,phpgwapi/js/jsapi/jsapi.js,phpgwapi/js/egw_json.js,phpgwapi/js/jsapi/egw_core.js,phpgwapi/js/jsapi/egw_debug.js,phpgwapi/js/jsapi/egw_preferences.js,phpgwapi/js/jsapi/egw_utils.js,phpgwapi/js/jsapi
/egw_rea
dy.js,phpgwapi/js/jsapi/egw_files.js,phpgwapi/js/jsapi/egw_lang.js,phpgwapi/js/jsapi/egw_links.js,phpgwapi/js/jsapi/egw_open.js,phpgwapi/js/jsapi/egw_user.js,phpgwapi/js/jsapi/egw_config.js,phpgwapi/js/jsapi/egw_images.js,phpgwapi/js/jsapi/egw_jsonq.js,phpgwapi/js/jsapi/egw_json.js,phpgwapi/js/jsapi/egw_store.js,phpgwapi/js/jsapi/egw_tooltip.js,phpgwapi/js/jsapi/egw_css.js,phpgwapi/js/jquery/jquery-ui-timepicker-addon.js,phpgwapi/js/jsapi/egw_calendar.js,phpgwapi/js/jsapi/egw_data.js,phpgwapi/js/jsapi/egw_tail.js,phpgwapi/js/jsapi/egw_inheritance.js,phpgwapi/js/jsapi/egw_message.js,phpgwapi/js/jsapi/app_base.js,phpgwapi/js/dhtmlxtree/codebase/dhtmlxcommon.js,phpgwapi/js/dhtmlxtree/sources/dhtmlxtree.js,phpgwapi/js/dhtmlxtree/sources/ext/dhtmlxtree_json.js,phpgwapi/js/egw_action/egw_action_common.js,phpgwapi/js/egw_action/egw_action.js,phpgwapi/js/egw_action/egw_keymanager.js,phpgwapi/js/egw_action/egw_menu.js,phpgwapi/js/egw_action/egw_action_popup.js,phpgwapi/js/egw_action/e
gw_actio
n_dragdrop.js,phpgwapi/js/egw_action/egw_dragdrop_dhtmlx_tree.js,phpgwapi/js/dhtmlxMenu/sources/dhtmlxmenu.js,phpgwapi/js/dhtmlxMenu/sources/ext/dhtmlxmenu_ext.js,phpgwapi/js/egw_action/egw_menu_dhtmlx.js&1411480878:2144:6
@http://10.10.10.93/egroupware/phpgwapi/inc/min/?b=egroupware&f=phpgwapi/js/jquery/jquery.js,phpgwapi/js/jquery/jquery-ui.js,phpgwapi/js/jsapi/jsapi.js,phpgwapi/js/egw_json.js,phpgwapi/js/jsapi/egw_core.js,phpgwapi/js/jsapi/egw_debug.js,phpgwapi/js/jsapi/egw_preferences.js,phpgwapi/js/jsapi/egw_utils.js,phpgwapi/js/jsapi/egw_ready.js,phpgwapi/js/jsapi/egw_files.js,phpgwapi/js/jsapi
/egw_lan
g.js,phpgwapi/js/jsapi/egw_links.js,phpgwapi/js/jsapi/egw_open.js,phpgwapi/js/jsapi/egw_user.js,phpgwapi/js/jsapi/egw_config.js,phpgwapi/js/jsapi/egw_images.js,phpgwapi/js/jsapi/egw_jsonq.js,phpgwapi/js/jsapi/egw_json.js,phpgwapi/js/jsapi/egw_store.js,phpgwapi/js/jsapi/egw_tooltip.js,phpgwapi/js/jsapi/egw_css.js,phpgwapi/js/jquery/jquery-ui-timepicker-addon.js,phpgwapi/js/jsapi/egw_calendar.js,phpgwapi/js/jsapi/egw_data.js,phpgwapi/js/jsapi/egw_tail.js,phpgwapi/js/jsapi/egw_inheritance.js,phpgwapi/js/jsapi/egw_message.js,phpgwapi/js/jsapi/app_base.js,phpgwapi/js/dhtmlxtree/codebase/dhtmlxcommon.js,phpgwapi/js/dhtmlxtree/sources/dhtmlxtree.js,phpgwapi/js/dhtmlxtree/sources/ext/dhtmlxtree_json.js,phpgwapi/js/egw_action/egw_action_common.js,phpgwapi/js/egw_action/egw_action.js,phpgwapi/js/egw_action/egw_keymanager.js,phpgwapi/js/egw_action/egw_menu.js,phpgwapi/js/egw_action/egw_action_popup.js,phpgwapi/js/egw_action/egw_action_dragdrop.js,phpgwapi/js/egw_action/egw_dragdrop_dhtm
lx_tree.
js,phpgwapi/js/dhtmlxMenu/sources/dhtmlxmenu.js,phpgwapi/js/dhtmlxMenu/sources/ext/dhtmlxmenu_ext.js,phpgwapi/js/egw_action/egw_menu_dhtmlx.js&1411480878:2184:39
jQuery.event.dispatch@http://10.10.10.93/egroupware/phpgwapi/inc/min/?b=egroupware&f=phpgwapi/js/jquery/jquery.js,phpgwapi/js/jquery/jquery-ui.js,phpgwapi/js/jsapi/jsapi.js,phpgwapi/js/egw_json.js,phpgwapi/js/jsapi/egw_core.js,phpgwapi/js/jsapi/egw_debug.js,phpgwapi/js/jsapi/egw_preferences.js,phpgwapi/js/jsapi/egw_utils.js,phpgwapi/js/jsapi/egw_read
y.js,php
gwapi/js/jsapi/egw_files.js,phpgwapi/js/jsapi/egw_lang.js,phpgwapi/js/jsapi/egw_links.js,phpgwapi/js/jsapi/egw_open.js,phpgwapi/js/jsapi/egw_user.js,phpgwapi/js/jsapi/egw_config.js,phpgwapi/js/jsapi/egw_images.js,phpgwapi/js/jsapi/egw_jsonq.js,phpgwapi/js/jsapi/egw_json.js,phpgwapi/js/jsapi/egw_store.js,phpgwapi/js/jsapi/egw_tooltip.js,phpgwapi/js/jsapi/egw_css.js,phpgwapi/js/jquery/jquery-ui-timepicker-addon.js,phpgwapi/js/jsapi/egw_calendar.js,phpgwapi/js/jsapi/egw_data.js,phpgwapi/js/jsapi/egw_tail.js,phpgwapi/js/jsapi/egw_inheritance.js,phpgwapi/js/jsapi/egw_message.js,phpgwapi/js/jsapi/app_base.js,phpgwapi/js/dhtmlxtree/codebase/dhtmlxcommon.js,phpgwapi/js/dhtmlxtree/sources/dhtmlxtree.js,phpgwapi/js/dhtmlxtree/sources/ext/dhtmlxtree_json.js,phpgwapi/js/egw_action/egw_action_common.js,phpgwapi/js/egw_action/egw_action.js,phpgwapi/js/egw_action/egw_keymanager.js,phpgwapi/js/egw_action/egw_menu.js,phpgwapi/js/egw_action/egw_action_popup.js,phpgwapi/js/egw_action/egw_action
_dragdro
p.js,phpgwapi/js/egw_action/egw_dragdrop_dhtmlx_tree.js,phpgwapi/js/dhtmlxMenu/sources/dhtmlxmenu.js,phpgwapi/js/dhtmlxMenu/sources/ext/dhtmlxmenu_ext.js,phpgwapi/js/egw_action/egw_menu_dhtmlx.js&1411480878:309:372
jQuery.event.add/elemData.handle@http://10.10.10.93/egroupware/phpgwapi/inc/min/?b=egroupware&f=phpgwapi/js/jquery/jquery.js,phpgwapi/js/jquery/jquery-ui.js,phpgwapi/js/jsapi/jsapi.js,phpgwapi/js/egw_json.js,phpgwapi/js/jsapi/egw_core.js,phpgwapi/js/jsapi/egw_debug.js,phpgwapi/js/jsapi/egw_preferences.js,phpgwapi/js/jsapi/egw_utils.js,phpg
wapi/js/
jsapi/egw_ready.js,phpgwapi/js/jsapi/egw_files.js,phpgwapi/js/jsapi/egw_lang.js,phpgwapi/js/jsapi/egw_links.js,phpgwapi/js/jsapi/egw_open.js,phpgwapi/js/jsapi/egw_user.js,phpgwapi/js/jsapi/egw_config.js,phpgwapi/js/jsapi/egw_images.js,phpgwapi/js/jsapi/egw_jsonq.js,phpgwapi/js/jsapi/egw_json.js,phpgwapi/js/jsapi/egw_store.js,phpgwapi/js/jsapi/egw_tooltip.js,phpgwapi/js/jsapi/egw_css.js,phpgwapi/js/jquery/jquery-ui-timepicker-addon.js,phpgwapi/js/jsapi/egw_calendar.js,phpgwapi/js/jsapi/egw_data.js,phpgwapi/js/jsapi/egw_tail.js,phpgwapi/js/jsapi/egw_inheritance.js,phpgwapi/js/jsapi/egw_message.js,phpgwapi/js/jsapi/app_base.js,phpgwapi/js/dhtmlxtree/codebase/dhtmlxcommon.js,phpgwapi/js/dhtmlxtree/sources/dhtmlxtree.js,phpgwapi/js/dhtmlxtree/sources/ext/dhtmlxtree_json.js,phpgwapi/js/egw_action/egw_action_common.js,phpgwapi/js/egw_action/egw_action.js,phpgwapi/js/egw_action/egw_keymanager.js,phpgwapi/js/egw_action/egw_menu.js,phpgwapi/js/egw_action/egw_action_popup.js,phpgwapi/js
/egw_act
ion/egw_action_dragdrop.js,phpgwapi/js/egw_action/egw_dragdrop_dhtmlx_tree.js,phpgwapi/js/dhtmlxMenu/sources/dhtmlxmenu.js,phpgwapi/js/dhtmlxMenu/sources/ext/dhtmlxmenu_ext.js,phpgwapi/js/egw_action/egw_menu_dhtmlx.js&1411480878:282:114

–
myEMAILsignature Thomas Plancon
CAD/IT Manager

B K A Architects, Inc.
142 Crescent Street
Brockton, MA 02302

tel: 508 . 583 . 5603 ext 313
fax: 508 . 584 . 2914
www.bkaarchitects.com http://www.bkaarchs.com/

Slashdot TV. Videos for Nerds. Stuff that Matters.
http://pubads.g.doubleclick.net/gampad/clk?id=160591471&iu=/4140/ostg.clktrk

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

–
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