we need to see the SQL and run it directly in MySQL to see what it is returning.
activate logging at FATAL level and add this line of code before line 115
that should write the SQL into the logs/corebosxxx.log file. Run it directly in MySQL and share the SQL and the result.
activate logging at FATAL level and add this line of code before line 115
PHP Code:
global $log;
$log->fatal("SELECT $selectcolumn, modifiedby as modifier, smownerid as owner, module, createdtime!=modifiedtime as haschanged
FROM $table
INNER JOIN vtiger_dart_recordchanges ON $table.$idcolumn = vtiger_dart_recordchanges.crmid AND modifiedon=?
INNER JOIN vtiger_crmentity on vtiger_crmentity.crmid=vtiger_dart_recordchanges.crmid");
that should write the SQL into the logs/corebosxxx.log file. Run it directly in MySQL and share the SQL and the result.
Joe
TSolucio
TSolucio