bugphpGroupWare - Bugs: bug #3475, so_sql has error for date...

 
 

You are not allowed to post comments on this tracker with your current authentication level.

bug #3475: so_sql has error for date postgresql fields when using save function

Submitter:  Johnson <jecinc>
Submitted:  Mon 05 May 2003 04:50:48 PM UTC
   
 
Category:  eTemplates Item Group:  None
Severity:  3 - Normal Priority:  5 - Normal
Status:  None Privacy:  Public
Assigned to:  Caeies Open/Closed:  Open
Component Version:  None Operating System:  None
Reproducibility:  None Planned Release:  None
Fixed Release: 

Wed 14 May 2003 03:13:03 AM UTC, comment #2: 

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


Johnson <jecinc>
Mon 05 May 2003 06:45:57 PM UTC, comment #1: 

Ok, I will fix it soon.

Invalid User ID <#2883>
Mon 05 May 2003 04:50:48 PM UTC, original submission:  

Empty date fields are set to '' but postgresql returns error

Postgresql wants null date values set to null (not '')


Johnson <jecinc>

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

 

Follow 3 latest changes.

Date Changed by Updated Field Previous Value => Replaced by
2004-06-06 skwashd Assigned toNone Caeies
2004-01-20 powerstat Assigned to#2883 None
2003-05-05 #2883 Assigned toNone None

Back to the top

Powered by Savane 3.13-f8d8.
Corresponding source code