In-Portal Issue Tracker - In-Portal CMS
Viewing Issue Advanced Details
1172 [In-Portal CMS] Database bug report always 2011-11-27 13:13 2012-07-25 05:32
alex  
alex  
normal  
closed 5.1.3  
fixed  
 
none 5.2.0-B1  
https://groups.google.com/d/topic/in-portal-bugs/_CDwRSvfsDE/discussion
Fixes NULL value load attempt failure in kDBItem class
1
0001172: Incorrect SQL when item load clause contains NULL
There are multiple ways to load record information from database:

1. by specifying Primary Keys value
2. by specifying value of a given field
3. by specifying a hash of field-value pairs that all must match for a loaded item

It all works until the value, used to load an item is set to NULL instead of string or number as usual.
patch null_dbitem_load_fix.patch (721) 2011-11-27 13:13
http://tracker.in-portal.org/file_download.php?file_id=1331&type=bug
Issue History
2012-07-25 05:32 alex Note Added: 0005046
2012-07-25 05:32 alex Status resolved => closed
2011-11-27 13:15 alex Note Added: 0004176
2011-11-27 13:15 alex Status reviewed and tested => resolved
2011-11-27 13:15 alex Fixed in Version => 5.2.0-B1
2011-11-27 13:15 alex Resolution open => fixed
2011-11-27 13:15 alex Assigned To !COMMUNITY => alex
2011-11-27 13:15 alex Changeset attached 5.2.x r14799
2011-11-27 13:15 alex Note Added: 0004175
2011-11-27 13:15 alex Status needs testing => reviewed and tested
2011-11-27 13:15 alex Assigned To => !COMMUNITY
2011-11-27 13:15 alex Developer => alex
2011-11-27 13:15 alex Status active => needs testing
2011-11-27 13:14 alex Reference => https://groups.google.com/d/topic/in-portal-bugs/_CDwRSvfsDE/discussion
2011-11-27 13:13 alex New Issue
2011-11-27 13:13 alex File Added: null_dbitem_load_fix.patch
2011-11-27 13:13 alex Change Log Message => Fixes NULL value load attempt failure in kDBItem class
2011-11-27 13:13 alex Estimate Points => 1

Notes
(0004175)
alex   
2011-11-27 13:15   
Will test all together later.
(0004176)
alex   
2011-11-27 13:15   
Fix committed to 5.2.x branch. Commit Message:

Fixes 0001172: Incorrect SQL when item load clause contains NULL
(0005046)
alex   
2012-07-25 05:32   
Since 5.2.0 version was released.