I am using Joomla 3.7.5 and as of this posting, I pulled the very latest github version of fabrik.
I am testing out the FullCalendar visualizer. I have a form with 2 groups in it. One of the groups is set to repeating. In the repeating group, I have 2 date elements, a start and end date.
I set the calendar visualizer start date and end date elements to the respective start and end elements in the table's repeating group.
When the calendar tries to display data back to me in a menu item, there is no data in the calendar. When I opened up the browsers debug console I see the following error.
I opened up the visualizer plugin into PHPStorm and found out that in the FullCalendar's model code on line 449 when you pull the $endField = $endElement->getFullName(false) to build the where clause, it returns the array name of the field and passes that to the SQL statement. If the square brackets are checked for and removed prior to assigning it to the where clause the SQL will work properly.
Thanks!
I am testing out the FullCalendar visualizer. I have a form with 2 groups in it. One of the groups is set to repeating. In the repeating group, I have 2 date elements, a start and end date.
I set the calendar visualizer start date and end date elements to the respective start and end elements in the table's repeating group.
When the calendar tries to display data back to me in a menu item, there is no data in the calendar. When I opened up the browsers debug console I see the following error.
Code:
You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the right syntax to use
near '[] >= '2017-07-30' AND gpf_gaps_credential_manager_91_repeat.date_expiring[] <= ' at line 40
I opened up the visualizer plugin into PHPStorm and found out that in the FullCalendar's model code on line 449 when you pull the $endField = $endElement->getFullName(false) to build the where clause, it returns the array name of the field and passes that to the SQL statement. If the square brackets are checked for and removed prior to assigning it to the where clause the SQL will work properly.
Thanks!
Last edited: