[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-tracker] [Bug #3475] so_sql has error for date postgresql
From: |
nobody |
Subject: |
[Phpgroupware-tracker] [Bug #3475] so_sql has error for date postgresql fields when using save function |
Date: |
Tue, 13 May 2003 23:13:03 -0400 |
=================== BUG #3475: LATEST MODIFICATIONS ==================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=3475&group_id=509
Changes by: Johnson <address@hidden>
Date: Wed 05/14/2003 at 03:13 (GMT)
------------------ Additional Follow-up Comments ----------------------------
Looks like you prepared for this since there is an $empty_on_write = "NULL";
near the top of the so_sql class but the save function uses
$this->empty_on_write that doesn't seem to be set equal to "NULL"
I added $this->empty_on_write = "NULL"; immediately above $cols .= ($cols ?
',' : '') . $db_col; and the save started to work for me.
I realize this is a hack but should help you find where the problem really is.
Would this also solve postgresql 7.3 bugs for fields not liking '' for apps
using so_sql? I think it would
=================== BUG #3475: FULL BUG SNAPSHOT ===================
Submitted by: jecinc Project: phpGroupWare
Submitted on: Mon 05/05/2003 at 16:50
Category: eTemplates Bug Group: None
Severity: 5 - Major Priority: None
Resolution: None Assigned to: ralfbecker
Status: Open Component Version: None
Platform Version: None Reproducibility: None
Summary: so_sql has error for date postgresql fields when using save function
Original Submission: Empty date fields are set to '' but postgresql returns
error
Postgresql wants null date values set to null (not '')
Follow-up Comments
*******************
-------------------------------------------------------
Date: Wed 05/14/2003 at 03:13 By: jecinc
Looks like you prepared for this since there is an $empty_on_write = "NULL";
near the top of the so_sql class but the save function uses
$this->empty_on_write that doesn't seem to be set equal to "NULL"
I added $this->empty_on_write = "NULL"; immediately above $cols .= ($cols ?
',' : '') . $db_col; and the save started to work for me.
I realize this is a hack but should help you find where the problem really is.
Would this also solve postgresql 7.3 bugs for fields not liking '' for apps
using so_sql? I think it would
-------------------------------------------------------
Date: Mon 05/05/2003 at 18:45 By: ralfbecker
Ok, I will fix it soon.
CC list is empty
No files currently attached
For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=3475&group_id=509