On my development system, Ubuntu 20.04.1 LTS, PHP 7.4.3 and Mysql 8.0.21 when I open the ChooseAddEvent window in full calendar I am getting an SQL error 1525 Incorrect DATETIME value: ''
In plugins/fabrik_visualization/fullcalendar/models/fullcalendar.php around line 529 we have the following:
The values for $calStart and $calEnd are obtained at the start of the function with these 2 statements:
but neither of those input values are in the ajax request so the values are assigned a null string ''.
In Mysql version 8 apparently you can no longer compare a DATETIME to '' and Mysql throws the subject error.
So, I do not know whether these 2 values should be defined or where they would be defined. I tried hard coding dates in the vis setup limits area but this did not help.
If the values are indeed empty then substituting IS NOT NULL instead of the comparatives would probably solve the problem but I imagine there is a reason for these values.
In plugins/fabrik_visualization/fullcalendar/models/fullcalendar.php around line 529 we have the following:
Code:
$query->where(FabrikString::safeColName($endField) . ' >= ' . $db->quote($calStart));
$query->where(FabrikString::safeColName($startField) . ' <= ' . $db->quote($calEnd));
The values for $calStart and $calEnd are obtained at the start of the function with these 2 statements:
Code:
$calStart = $input->get('startDate', '');
$calEnd = $input->get('endDate', '');
In Mysql version 8 apparently you can no longer compare a DATETIME to '' and Mysql throws the subject error.
So, I do not know whether these 2 values should be defined or where they would be defined. I tried hard coding dates in the vis setup limits area but this did not help.
If the values are indeed empty then substituting IS NOT NULL instead of the comparatives would probably solve the problem but I imagine there is a reason for these values.