Calendar not open into VtigerCRM Version 7.4.0

Hello Team,

I just install the new vtigercrm version 7.4.0 and I checked the calendar but it's not open there is some issue in the calendar.

Please resolved it.

Enable error_reporting or observe the network response to know the reason why JSON is getting corrupted.

Status changed to closed

I'm guessing (PHP Deprecation error_reporting) is likely coming in the way.

@prasad I think this is a real problem. I have installed a clean 7.4.0 on a test virtual machine with php7.4. The installation went fine. I have imported leads, organisation and contact records all OK. Navigation around the system seems fine too.

But when you load the Calendar, if you enable error_reporting, in the javascript console you will see the following error:

Fatal error: Uncaught Error: Call to a member function GetRowAssoc() on bool in /var/www/html/vtiger/include/database/PearDatabase.php:757 
Stack trace: 
#0 /var/www/html/vtiger/modules/Calendar/actions/Feed.php(409): PearDatabase->fetchByAssoc() 
#1 /var/www/html/vtiger/modules/Calendar/actions/Feed.php(76): Calendar_Feed_Action->pullTasks() 
#2 /var/www/html/vtiger/modules/Calendar/actions/Feed.php(33): Calendar_Feed_Action->_process() 
#3 /var/www/html/vtiger/includes/main/WebUI.php(215): Calendar_Feed_Action->process() 
#4 /var/www/html/vtiger/index.php(20): Vtiger_WebUI->process() 
#5 {main} thrown in /var/www/html/vtiger/include/database/PearDatabase.php on line 757

If you enable debug logging, there is a database error thrown:

2021-08-08T12:38:34+00:00 INFO  VT PearDatabase ->ADODB error  Query Failed:SELECT vtiger_activity.subject, vtiger_activity.status, CASE WHEN (vtiger_activity.status not like '') THEN vtiger_activity.status ELSE vtiger_activity.eventstatus END AS status, vtiger_activity.activitytype, vtiger_activity.date_start, vtiger_activity.time_start, vtiger_activity.time_start, vtiger_activity.due_date, vtiger_activity.time_end, vtiger_activity.time_end, vtiger_activity.activityid FROM vtiger_activity  INNER JOIN vtiger_crmentity ON vtiger_activity.activityid = vtiger_crmentity.crmid  WHERE vtiger_crmentity.deleted=0 AND vtiger_activity.activityid > 0 AND vtiger_activity.activitytype = 'Task' AND  ((date_start >= ? AND due_date < ? ) OR ( due_date >= ? )) AND vtiger_crmentity.smownerid IN (?,?)::->[1525]Incorrect DATE value: '08-08-2021'

2021-08-08T12:38:34+00:00 DEBUG VT Prepared sql query parameters : [08-08-2021,08-15-2021,08-08-2021,1,3]

If I change my user's calendar date format to "yyyy-mm-dd" the calendar loads and the errors above are not present. However, if I choose either "dd-mm-yyyy" or "mm-dd-yyyy" then the above error happens again.

This should have been fixed in #1602 (closed) but it would appear not.

As an aside, in vtiger 7.3.0 the user has a choice of 5 calendar formats. In 7.4.0 this is down to just 3. What will happen to migrations where users have one of the other values set?

@prasad this issue seems to stem from the client...

In vtiger 7.3.0 the POST params have the date already formatted to ISO 8601 irrespective of the user's Calendar format setting.

In vtiger 7.4.0 the POST params are formatted the same as the user's own setting.