bug with fresh clean install 7.10.6

I have a bug with fresh installation on empty database. It is related to reminders. It is expecting to see min and max dates but I believe the problems lies in a fact that I don’t have any reminders yet. How ever this should be solved in future releases.
Will also open an issue in git hub.

Thu Jun 7 12:56:47 2018 [696][1][FATAL] Query Failed: SELECT reminders.* , jt0.user_name modified_by_name , jt0.created_by modified_by_name_owner , N’Users’ modified_by_name_mod , jt1.user_name created_by_name , jt1.created_by created_by_name_owner , N’Users’ created_by_name_mod , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , N’Users’ assigned_user_name_mod FROM reminders LEFT JOIN users jt0 ON reminders.modified_user_id=jt0.id AND jt0.deleted=0

AND jt0.deleted=0 LEFT JOIN users jt1 ON reminders.created_by=jt1.id AND jt1.deleted=0

AND jt1.deleted=0 LEFT JOIN users jt2 ON reminders.assigned_user_id=jt2.id AND jt2.deleted=0

AND jt2.deleted=0 where (reminders.popup = 1 AND (reminders.date_willexecute = -1 OR reminders.date_willexecute[color=#ff0000] BETWEEN AND [/color])) AND reminders.deleted=0::: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near the keyword ‘AND’.

For reference, this same issue is posted on GitHub

https://github.com/salesagility/SuiteCRM/issues/6000

Yes, that’s the one I opened few hours ago. Will post updates here as well.

I’ve posted a possibile fix for this bug

1 Like

Same in 7.11.5