I installed the Meetings module (6.x-1.0-beta1) in OpenAtrium 6.x-1.0-alpha5 and there seems to be no integration with the Calendar. Is this intended or did I install the module incorrectly? Thanks for any info.

Comments

Anonymous’s picture

Category: support » feature

Thanks for the report.

Meeting module doesn't have any calendar support yet.

If you want calendar support right now, it shouldn't bee too hard to manually add it to the view for the calendar.

Calendar support is a pretty big one, though. Eventually, this will be built in. I'm changing this to a feature request and leaving it open until the feature is added.

intu.cz’s picture

Thanks for the reply and for pointing me to the view of the calendar. I tried to set it up for both Meetings and Case Tracker Due Date, but it throws errors and ends up in a blank page (that's the default setting for no arguments in the OA calendar). I'll try to investigate the cause. I have tried to make sure that the format of both Event date field and Meetings date field are the same and have similar settings.

The most frequent errors are:

* mysql_real_escape_string() expects parameter 1 to be string, array given in C:\www\atrium\includes\database.mysql.inc on line 321.

* htmlspecialchars() expects parameter 1 to be string, array given in C:\www\atrium\includes\bootstrap.inc on line 840.

*Illegal offset type in isset or empty in C:\www\atrium\includes\common.inc on line 916.

* date_format() expects parameter 1 to be DateTime, null given in C:\www\atrium\profiles\openatrium\modules\custom\litecal\litecal_plugin_style_litecal.inc on line 188.

intu.cz’s picture

Hello, I am still trying to make Meetings work with OA (meanwhile updated to version 1.0-beta10).

I no longer have the problems described in my previous comment, the errors are gone. Casetracker due Date works ok with the Calendar. But integration of Meetings with Views so that meetings appear on the Calendar is still not working, complaining about

Unknown column 'node_data_field_meeting_date.field_meeting_date_value' in 'where clause' query: 

SELECT DISTINCT 
node.nid AS nid, 
node.title AS node_title, 
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, 
node_data_field_duedate.field_duedate_value AS node_data_field_duedate_field_duedate_value 
FROM node node 
LEFT JOIN content_type_casetracker_basic_case node_data_field_duedate 
ON node.vid = node_data_field_duedate.vid 
LEFT JOIN content_field_date node_data_field_date 
ON node.vid = node_data_field_date.vid 
WHERE ((node.type in ('event', 'feed_ical_item', 'casetracker_basic_case', 'meeting')) AND (node.status <> 0)) 
AND ((node_data_field_duedate.field_duedate_value IS NOT NULL) 
OR ((DATE_FORMAT(STR_TO_DATE(node_data_field_date.field_date_value, '%Y-%m-%dT%T'), '%Y-%m') <= '2011-03' 
AND DATE_FORMAT(STR_TO_DATE(node_data_field_date.field_date_value2, '%Y-%m-%dT%T'), '%Y-%m') >= '2011-03')) OR ((DATE_FORMAT(STR_TO_DATE(node_data_field_date.field_date_value, '%Y-%m-%dT%T'), '%Y-%m') <= '2011-03' AND DATE_FORMAT(STR_TO_DATE(node_data_field_date.field_date_value2, '%Y-%m-%dT%T'), '%Y-%m') >= '2011-03')) OR ((DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_duedate.field_duedate_value, '%Y-%m-%dT%T'), SEC_TO_TIME(3600)), '%Y-%m') <= '2011-03' AND DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_duedate.field_duedate_value, '%Y-%m-%dT%T'), SEC_TO_TIME(3600)), '%Y-%m') >= '2011-03')) OR ((DATE_FORMAT(STR_TO_DATE(node_data_field_meeting_date.field_meeting_date_value, '%Y-%m-%dT%T'), '%Y-%m') <= '2011-03' AND DATE_FORMAT(STR_TO_DATE(node_data_field_meeting_date.field_meeting_date_value2, '%Y-%m-%dT%T'), '%Y-%m') >= '2011-03')) OR ((DATE_FORMAT(STR_TO_DATE(node_data_field_meeting_date.field_meeting_date_value, '%Y-%m-%dT%T'), '%Y-%m') <= '2011-03' AND DATE_FORMAT(STR_TO_DATE(node_data_field_meeting_date.field_meeting_date_value2, '%Y-%m-%dT%T'), '%Y-%m') >= '2011-03'))) in C:\www\atrium\profiles\openatrium\modules\contrib\views\includes\view.inc on line 775.

It seems to be mentioning tables I do not have such as node_data_field_meeting_date (the columns it needs are to be found in content_type_meeting). Has anybody ever succeeded in integrating Meetings with Views? Perhaps I am doing something wrong and it's my (basic) mistake.

peterx’s picture

I am following this issue because I will need the Meetings working with a calendar before installing either Meetings or Open Atrium.

It is a separate issue but that SQL is ugly.
((DATE_FORMAT(STR_TO_DATE(node_data_field_date.field_date_value, '%Y-%m-%dT%T'), '%Y-%m') <= '2011-03'
The SQL could be fixed for performance. By the look of the SQL code, the left hand side could be a simple substring. Plus the derivations are repeated and can be performed once then reused.

pedroprsant’s picture