After upgrading from version 7.14.1 to 7.14.3,
In the advanced search, I set the start date Equals to 05/19/2024 (or any other date) and hit the search button, but the displayed result is always related to today’s date. (2024/05/21)
SuiteCRM Version is:
Version 7.14.3
Sugar Version 6.5.25 (Build 344)
Thank you for your response, in suitecrm.log I found this:
Query Failed: SELECT `meetings`.name AS 'Subject0', `meetings`.description AS 'Description1', `meetings`.created_by AS 'Created_By2', `meetings`.date_entered AS 'Date_Created3', `meetings`.date_start AS 'Start_Date4', `meetings:accounts`.name AS 'Name5', `meetings:case`.account_id AS 'Account_Name6', `meetings:accounts`.industry AS 'Proficiency7', `meetings:accounts`.billing_address_state AS 'Office_State8', `meetings:accounts`.billing_address_city AS 'Office_City9', `meetings`.id AS 'meetings_id', `meetings:accounts`.id AS 'meetings:accounts_id', `meetings:case`.id AS 'meetings:case_id' FROM `meetings` LEFT JOIN accounts `meetings:accounts` ON `meetings`.parent_id=`meetings:accounts`.id AND `meetings:accounts`.deleted=0
AND `meetings`.parent_type = 'Accounts'
LEFT JOIN cases `meetings:case` ON `meetings`.parent_id=`meetings:case`.id AND `meetings:case`.deleted=0
AND `meetings`.parent_type = 'Cases'
WHERE ( (`meetings`.date_start = '' OR `meetings`.date_start IS NULL) AND (`meetings`.created_by = '' OR `meetings`.created_by IS NULL) ) AND meetings.deleted = 0 LIMIT 0,20: MySQL error 1525: Incorrect DATETIME value: ''
before upgrading, its working but now I have NULL in query:
meetings.date_start = '' OR meetings`.date_start IS NULL
also it says: convert: Conversion of 2024-05-25 00:00 from m/d/Y H:i to Y-m-d failed
In live demo, in meeting’s advanced filter, there is no date section by default. And I cannot access admin section to add date to filter to test it. So I cannot verify that.