Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Activity update doesn't register changes
#2
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

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
Reply


Messages In This Thread
RE: Activity update doesn't register changes - joebordes - 12-07-2021, 03:11 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)