SiT! Bugs - SiT!
View Issue Details
0000804SiT!reportspublic2009-07-25 11:002009-08-16 14:39
Tomse 
paulh 
normalminoralways
closedfixed 
3.45 
3.503.50 
0000804: Making a report with no dates creates errors - report_incidents_billable.php
When trying to fetch a report, but you don't fill in any dates, the following errors are returned. If you fill in dates it seems to work as should.
This is using the example data. and no billable incidents are located in the DB

MySQL Query Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 in C:\Inetpub\wwwroot\report_incidents_billable.php @ line 76 trigger_error()

mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwroot\report_incidents_billable.php @ line 78 mysql_num_rows()
No tags attached.
Issue History
2009-07-25 11:00TomseNew Issue
2009-07-25 11:39ivanStatusnew => assigned
2009-07-25 11:39ivanAssigned To => ivan
2009-07-25 11:39ivanTarget Version => 3.50
2009-07-25 11:52ivanNote Added: 0001394
2009-07-25 11:52ivanAssigned Toivan => paulh
2009-07-25 11:52ivanResolutionopen => fixed
2009-07-26 14:39paulhNote Added: 0001408
2009-07-26 14:39paulhStatusassigned => resolved
2009-07-26 14:39paulhFixed in Version => Current SVN
2009-07-26 14:41ivanNote Added: 0001409
2009-08-16 13:15ivanFixed in VersionCurrent SVN => 3.50
2009-08-16 14:39ivanNote Added: 0001692
2009-08-16 14:39ivanStatusresolved => closed

Notes
(0001394)
ivan   
2009-07-25 11:52   
I've fixed the errors in trunk r5597 but this now produces an empty report. I'm not sure how to make it print a message saying there are no results..


Paul? can you help?
(0001408)
paulh   
2009-07-26 14:39   
trunk r5662 resolves this - type in enddate also added no results when non found
(0001409)
ivan   
2009-07-26 14:41   
Thanks Paul, and sorry about the cruft - I added 'ss' by accident. :-/
(0001692)
ivan   
2009-08-16 14:39   
Released in 3.50rc1