phpGroupWare - 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: |
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 |
Johnson <jecinc> |
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 to | None | Caeies | |
2004-01-20 | powerstat | Assigned to | #2883 | None | |
2003-05-05 | #2883 | Assigned to | None | None |
Powered by Savane 3.13-d3ae.
Corresponding source code
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