+- CoreBOSBB (https://discussions.corebos.org)
+-- Forum: Support (https://discussions.corebos.org/forumdisplay.php?fid=17)
+--- Forum: Administrator Support (https://discussions.corebos.org/forumdisplay.php?fid=8)
+--- Thread: Can't modify report (/showthread.php?tid=2406)
Pages:
1
2
RE: Can't modify report - addady2 - 08-26-2022
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
RE: Can't modify report - joebordes - 08-26-2022
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?