Can't modify report

[addady2]

I add before and after writing to log file:

PHP Code:

ob_start();  
var_dump($result);   
$data = ob_get_clean();  
$fp = fopen("logs/textfile.txt", "a");   fwrite($fp, "-----------------------\n");
fwrite($fp, $data);  
fclose($fp); 
 
$rows = $result->RecordCount();  
 
$fp = fopen("logs/textfile.txt", "a");   
fwrite($fp, "^^^^^---after ^^^^^------------\n");
fclose($fp);   


This is the log

Code:

...
 ["_maxRecordCount"]=>
 int(0)
 ["datetime"]=>
 bool(false)
 ["adodbFetchMode"]=>
 int(0)
}
^^^^^---after ^^^^^------------
-----------------------
array(10) {
 [0]=>
 string(2) "27"
 ["datefilterid"]=>
 string(2) "27"
 [1]=>
 string(79) "vtiger_invoice_recurring_info:start_period:start_period:SalesOrder_Start_Period"
 ["datecolumnname"]=>
 string(79) "vtiger_invoice_recurring_info:start_period:start_period:SalesOrder_Start_Period"
 [2]=>
 string(6) "custom"
 ["datefilter"]=>
 string(6) "custom"
 [3]=>
 string(10) "0000-00-00"
 ["startdate"]=>
 string(10) "0000-00-00"
 [4]=>
 string(10) "0000-00-00"
 ["enddate"]=>
 string(10) "0000-00-00"
}

Its look to me related to the last sql query I found in the log

select vtiger_reportdatefilter.* from vtiger_reportdatefilter inner join vtiger_report on vtiger_report.reportid = vtiger_reportdatefilter.datefilterid where vtiger_report.reportid=27

[joebordes]

I see that the condition is on the recurring start date in salesorder but the fact that the error is in the calculations makes me think that the error is not in the filter. I tried a whole bunch of things but couldn't find a combination that fails.

Since your file and the latest file of coreBOS don't match could it be that we have fixed it along the way? Can you try updating your code in a test install to see if that report still fails on the latest version?