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[42000]: 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
Flag 7.x-3.0-alpha4+29-dev
Drupal 7.18

add-relationship-flag-node-missing.jpg381.86 KBBuFr
Members fund testing for the Drupal project. Drupal Association Learn more


eudaemonia’s picture

Issue summary: View changes

I'm having the same issue and encountering the same error message. A little discouraging that this issue is still unassigned.