Hi,
I Upgrade from 7.4.x to 7.5 , It seems like a perfect situation, apart from the Report with Conditions Type “Date” and Value “Now” not working . this report is working fine with 7.4.x. I find some error from suitecrm.log
[25903][1][FATAL] Query Failed: SELECT project_task.id AS ‘project_task_id’, project_task.name AS ‘>名称0’, project_task_cstm.appr_stage_c AS ‘认证审核阶段1’, project_task.project_id AS ‘项目名称2’, project_task.date_start AS ‘开始日>期3’, project_task.date_finish AS ‘完成日期4’ FROM project_task LEFT JOIN project_task_cstm project_task_cstm ON project_task.id = project_task_cstm.id_c WHERE ( project_task.date_finish >= DATE_ADD(NOW, INTERVAL - 12 month) AND project_task.date_finish <= DATE_ADD(NOW, INTERVAL - 5 month) AND project_task_cstm.appr_ac_code_c = ‘02’ ) AND project_task.deleted = 0 ORDER BY project_task.date_start ASC LIMIT 0,20: MySQL error 1054: Unknown column ‘NOW’ in ‘where clause’
