Re: 14.1 SQL error on opening Projects - Still errors

teplcon 2014-09-30 15:37:22 UTC #1

Ralf,

Thanks for the reply. Downloaded and installed the file. Now I’m getting
this error:

Tue Sep 30 2014 11:19:11 GMT-0400 (Eastern Standard Time)

error

Ajax request to

/egroupware/json.php?menuaction=projectmanager.jdots_framework.ajax_exec.template

failed:

error

Subject:
Re: [eGroupWare-users] 14.1 SQL error on opening Projects
From:
Ralf Becker rb@stylite.de
Date:
9/29/2014 1:43 PM

To:
discussions and questions from users and for users of eGroupWare
egroupware-users@lists.sourceforge.net

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 Am 29.09.14 17:44, schrieb Tom
Plancon:

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…

–
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-30 15:49:36 UTC #2

Hi Tom,

Ralf,

Thanks for the reply. Downloaded and installed the file. Now I’m
getting this error:

Tue Sep 30 2014 11:19:11 GMT-0400 (Eastern Standard Time)

error

Ajax request to

/egroupware/json.php?menuaction=projectmanager.jdots_framework.ajax_exec.template

failed:

error
Looks like a server-side error, have a look in Apache error-log, when it
happens.

Ralf

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_ready.js,phpgwapi
/js/jsap
i/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_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
.debug@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,phpgwap
i/js/jsa
pi/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_dragdrop.js,phpgwapi/js/egw_action/egw_dra
gdrop_dh
tmlx_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:2199:78
json_request.prototype.sendRequest/this.request<.error@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/e
gw_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_action/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:2601:2
jQuery.Callbacks/fire@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_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_ac
tion_dra
gdrop.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:212:278
jQuery.Callbacks/self.fireWith@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:217:198
done@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_fil
es.js,ph
pgwapi/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_dragdrop.js,phpgwapi/js/egw_a
ction/eg
w_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:610:211
.send/callback@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_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_dragdrop.js,phpgwapi/js/egw_action/
egw_drag
drop_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:630:15

Subject:
Re: [eGroupWare-users] 14.1 SQL error on opening Projects
From:
Ralf Becker rb@stylite.de
Date:
9/29/2014 1:43 PM

To:
discussions and questions from users and for users of eGroupWare
egroupware-users@lists.sourceforge.net

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 Am 29.09.14 17:44,
schrieb Tom Plancon:
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…

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/

Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&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