#67 timestamp with time zone

[Sandeep Jadhav]

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''

[Frank Bergmann]

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

[Sandeep Jadhav]

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/