No aparecen los eventos en el calendario

We encourage users to post events happening in the community to the community events group on https://www.drupal.org.
martinfdan's picture

Buenas... estoy creando una instalación de Drupal Commons (6x) y me encontrado con que los eventos creados no se visualizan en el calendario.

En cambio, en la consulta que devuelve la vista calendario si que se ven y en la vista previa aparecen, pero no se pintan ni en el bloque ni una vez que entro al calendario.

Que puede ser? Alguna idea o pista?

Gracias!

Comments

La vista en concreto es

martinfdan's picture

La vista en concreto es "content_event_calendar" y la consulta la siguiente:

SELECT DISTINCT(node.nid) AS nid_1,
node.title AS node_title,
node.nid AS nid,
node.language AS node_language,
node_data_field_date.field_date_value AS node_data_field_date_field_date_value,
node_data_field_date.field_date_value2 AS node_data_field_date_field_date_value2,
node.type AS node_type,
node.vid AS node_vid
FROM node node
LEFT JOIN og_ancestry og_ancestry ON node.nid = og_ancestry.nid
LEFT JOIN node node_og_ancestry ON og_ancestry.group_nid = node_og_ancestry.nid
LEFT JOIN content_type_event node_data_field_date ON node.vid = node_data_field_date.vid
WHERE ((node.status = 1) AND (node.type in ('event')))
AND ((DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_date.field_date_value, '%Y-%m-%dT%T'), SEC_TO_TIME(7200)), '%Y-%m') <= '2012-07' AND DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_date.field_date_value2, '%Y-%m-%dT%T'), SEC_TO_TIME(7200)), '%Y-%m') >= '2012-07'))
ORDER BY node_data_field_date_field_date_value ASC;

Devolviendo los eventos creados, pero no se ven en el calendario.

Thanks!

Madrid

Group organizers

Group events

Add to calendar

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds:

Hot content this week