#67 timestamp with time zone
Error saving data on the server side.
Send error message to ]project-open[ for incident reporting?
Please see our privacy statementy for details.
Server error while saving: Error updating im_timesheet_task: 'Database oper
ation "dml" failed (exception ERROR, "ERROR: invalid input syntax for type
timestamp with time zone: "2021-03-02 23:59:00+05.5"
LINE 1: ...es_planned = NULL, description = NULL, end_date = '2021-03-0...
^
")
ERROR: invalid input syntax for type timestamp with time zone: "2021-03-02
23:59:00+05.5"
LINE 1: ...es_planned = NULL, description = NULL, end_date = '2021-03-0...
^
SQL: update im_projects set company_id = '8720', cost_bills_planned = NULL,
cost_cache_dirty = NULL, cost_expenses_planned = NULL, description = NULL,
end_date = '2021-03-02 23:59:00+05.5', milestone_p = NULL, note = NULL, on
_track_status_id = '66', parent_id = NULL, percent_completed = '0', project
_lead_id = '8869', project_name = 'sonar dome11', project_nr = '2021_0002',
project_status_id = '76', project_type_id = '2501', project_wbs = NULL, so
rt_order = '0', start_date = '2021-03-02 00:00:00+05.5' where project_id =
'53529''
Related
Discussion
Anonymous
Hi,
This is an old version of ]project-open[.
The problem is the Indian IST time zone which is GMT+5.5, which is not accepted by PostgreSQL that way.
The latest ]po[ V5.1 includes a fix for this issue. Please upgrade.
Cheers
Frank
Dear Sir,
I have tried searching for version 5.1 windows installer but all I could find was VMware installer.
Could you Please shred me link is available.
From: Frank Bergmann fraber@users.sourceforge.net
Sent: 02 March 2021 06:33 PM
To: [project-open:support-requests] 67@support-requests.project-open.p.re.sourceforge.net
Subject: [project-open:support-requests] #67 timestamp with time zone
Hi,
This is an old version of ]project-open[.
The problem is the Indian IST time zone which is GMT+5.5, which is not accepted by PostgreSQL that way.
The latest ]po[ V5.1 includes a fix for this issue. Please upgrade.
Cheers
Frank
[support-requests:#67]https://sourceforge.net/p/project-open/support-requests/67/ timestamp with time zone
Status: open
Group: v1.0_(example)
Created: Tue Mar 02, 2021 07:29 AM UTC by Sandeep Jadhav
Last Updated: Tue Mar 02, 2021 07:29 AM UTC
Owner: nobody
Error saving data on the server side.
Send error message to ]project-open[ for incident reporting?
Please see our privacy statementy for details.
Server error while saving: Error updating im_timesheet_task: 'Database oper
ation "dml" failed (exception ERROR, "ERROR: invalid input syntax for type
timestamp with time zone: "2021-03-02 23:59:00+05.5"
LINE 1: ...es_planned = NULL, description = NULL, end_date = '2021-03-0...
^
")
ERROR: invalid input syntax for type timestamp with time zone: "2021-03-02
23:59:00+05.5"
LINE 1: ...es_planned = NULL, description = NULL, end_date = '2021-03-0...
^
SQL: update im_projects set company_id = '8720', cost_bills_planned = NULL,
cost_cache_dirty = NULL, cost_expenses_planned = NULL, description = NULL,
end_date = '2021-03-02 23:59:00+05.5', milestone_p = NULL, note = NULL, on
_track_status_id = '66', parent_id = NULL, percent_completed = '0', project
_lead_id = '8869', project_name = 'sonar dome11', project_nr = '2021_0002',
project_status_id = '76', project_type_id = '2501', project_wbs = NULL, so
rt_order = '0', start_date = '2021-03-02 00:00:00+05.5' where project_id =
'53529''
Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/project-open/support-requests/67/
To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/
Related
Support Requests: #67