phpgroupware-tracker
[Top][All Lists]
Advanced

[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




reply via email to

[Prev in Thread] Current Thread [Next in Thread]