plainblack.com
Username Password
search
Bookmark and Share
View All Tickets
SQLForm and date isNULL  (#3104)
Issue

When you have a date field in a record with a NULL value and you want to edit the record you ending in the search function. The webgui log give the next error.

at /data/wre/prereqs/perl/lib/site_perl/5.8.8/DateTime/Format/Strptime.pm
line 444 2007/04/09 00:03:14 - WARN - wgtest.conf - main::[[undef]] -
Couldn't call method editRecord on asset for url:  dir/dir/nameassetsqlform
Root cause: The 'month' parameter ("00") to DateTime::new did not pass the 'is between 1 and 12' callback  at /data/wre/prereqs/perl/lib/site_perl/5.8.8/DateTime/Format/Strptime.pm line 444

Solution Summary
Comments
nogura
0
5/2/2007 9:10 am

Its fixed.  MySQL null dates are now converted to undef.  This prevents the program from dying. 

However, undef dates are automatically converted to today's date, so be warned. 

To fix it so that it handles null MySQL dates gracefully without changing them would be a RFE.  Please submit it as such if that is your desire.

Details
Ticket Status Closed  
Rating0.0 
Submitted Byremsnel 
Date Submitted2007-04-09 
Assigned To unassigned  
Date Assigned2012-02-10 
Assigned By 
Severity Critical (mostly not working)  
What's the bug in?  
WebGUI / WRE Version 7.3.14  
URLbugs/tracker/sqlform-and-date-isnull
Keywords
Ticket History
© 2012 Plain Black Corporation | All Rights Reserved