I have a flag with a multi date field (fieldable flag), this is assigned to a node. When I flag the node and add multiple dates I want the flagging dates to show up on the calendar (nothing shows).
The new views calendar setup allows me to add a template, in my case :
"A calendar view of the 'field_multiple_date_climbed' field in the 'flagging' base table."
When i create this template i get the error:
SQLSTATE: Syntax error or access violation: 1064 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 'AS flagging_, 'flagging' AS field_data_field_multiple_date_climbed_flagging_enti' at line 1
There is no relationship in the view so this is a obvious problem, but:
When i click to add a relationship i only have the "Flags: Flagging flag" available, but i need the "Flags: Node flag".
If I create a table or list format it works fine, but calendar won't work.
I think it's a calendar bug, but not sure. I hope it's all clear, let me know if you need more info, Thanks!!
Using calendar version 7.x-3.4+1-dev
Date version 7.x-2.6+2-dev