[Obm] Problème Evènement ressource OBM 2.1.4

[Mehdi Rande]

Le mercredi 06 février 2008 à 16:43 +0100, Jimmy Goudin a écrit :
> Bonjour, 
> 
> J'ai un problème avec la nouvelle version 2.1.4. 
> Sur des évènements qui sont sur l'Agenda des ressources et dont je ne
> suis pas l'Organisateur, j'ai le message suivant:
> Par contre ce n'est pas systématique sur chaque évènement. Je ne
> comprend pas à quoi cela est du.
> 

Est ce que votre événement contient des utilisateurs comme participants
ou que des ressources? En effet la 2.1.4 semble avoir un problème avec
les événements sans participants de type utilisateur. Ce problème est
corrigé dans le trunk et sera présent dans la 2.1.5.

HTH,
Mehdi Rande


> Warning: in_array() [function.in-array]: Wrong datatype for second
> argument in /var/www/obm-2.1.4/php/calendar/calendar_query.inc on line
> 1899
> 
> Voici les infos de Debug :  
> 
> get_calendar_event_info() : SELECT *,
> UNIX_TIMESTAMP(calendarevent_date) as calendarevent_date FROM
> CalendarEvent LEFT JOIN EventEntity ON evententity_event_id =
> calendarevent_id WHERE calendarevent_id='289' AND
> (calendarevent_domain_id='1' )
> ______________________________________________________________________
> get_user_info() : SELECT *, UNIX_TIMESTAMP(userobm_datebegin) as
> datebegin FROM UserObm WHERE userobm_id='4'
> ______________________________________________________________________
> of_right_entity_for_user() : SELECT e.userobm_id as id,
> concat(userobm_lastname , ' ' , userobm_firstname) as label,
> 'calendar' as entityright_entity FROM EntityRight LEFT JOIN UserObm as
> e ON entityright_entity_id = e.userobm_id WHERE entityright_entity =
> 'calendar' AND ( (entityright_consumer = 'user' AND
> (entityright_consumer_id = '4' OR entityright_consumer_id = 0)) OR
> (entityright_consumer = 'group' AND (entityright_consumer_id IN
> (SELECT of_usergroup_group_id FROM of_usergroup WHERE
> of_usergroup_user_id = '4') OR entityright_consumer_id = 0))) AND
> entityright_write = 1 GROUP BY id, label, entityright_entity UNION
> SELECT '4' as id, 'Goudin Jimmy' as label, 'calendar' as
> entityright_entity ORDER BY entityright_entity, label
> ______________________________________________________________________
> get_calendar_event_info() : SELECT *,
> UNIX_TIMESTAMP(calendarevent_date) as calendarevent_date FROM
> CalendarEvent LEFT JOIN EventEntity ON evententity_event_id =
> calendarevent_id WHERE calendarevent_id='289' AND
> (calendarevent_domain_id='1' )
> ______________________________________________________________________
> get_user_info() : SELECT *, UNIX_TIMESTAMP(userobm_datebegin) as
> datebegin FROM UserObm WHERE userobm_id='4'
> ______________________________________________________________________
> of_right_entity_for_user() : SELECT e.userobm_id as id,
> concat(userobm_lastname , ' ' , userobm_firstname) as label,
> 'calendar' as entityright_entity FROM EntityRight LEFT JOIN UserObm as
> e ON entityright_entity_id = e.userobm_id WHERE entityright_entity =
> 'calendar' AND ( (entityright_consumer = 'user' AND
> (entityright_consumer_id = '4' OR entityright_consumer_id = 0)) OR
> (entityright_consumer = 'group' AND (entityright_consumer_id IN
> (SELECT of_usergroup_group_id FROM of_usergroup WHERE
> of_usergroup_user_id = '4') OR entityright_consumer_id = 0))) GROUP BY
> id, label, entityright_entity UNION SELECT '4' as id, 'Goudin Jimmy'
> as label, 'calendar' as entityright_entity ORDER BY
> entityright_entity, label
> ______________________________________________________________________
> run_query_calendar_detail() : SELECT DISTINCT calendarevent_id,
> c.userobm_login AS usercreate, u.userobm_login AS userupdate,
> UNIX_TIMESTAMP(calendarevent_timeupdate) as timeupdate,
> UNIX_TIMESTAMP(calendarevent_timecreate) as timecreate,
> calendarevent_owner, o.userobm_lastname AS owner_lastname,
> o.userobm_firstname AS owner_firstname, calendarevent_title,
> calendarevent_description, calendarevent_properties,
> calendarevent_repeatfrequence, calendarevent_location,
> calendarevent_category1_id, calendarcategory1_label,
> calendarevent_privacy, calendarevent_priority,
> calendarevent_repeatkind, calendarevent_duration,
> calendarevent_repeatdays, calendarevent_allday, calendarevent_color,
> UNIX_TIMESTAMP(calendarevent_endrepeat) as calendarevent_endrepeat,
> UNIX_TIMESTAMP(calendarevent_date) as calendarevent_date FROM
> CalendarEvent LEFT JOIN CalendarCategory1 ON
> calendarevent_category1_id = calendarcategory1_id LEFT JOIN UserObm AS
> c ON calendarevent_usercreate = c.userobm_id LEFT JOIN UserObm AS u ON
> calendarevent_userupdate = u.userobm_id LEFT JOIN UserObm AS o ON
> calendarevent_owner = o.userobm_id WHERE calendarevent_id = '289' AND
> (calendarevent_domain_id='1' )
> ______________________________________________________________________
> get_calendar_event_entity(1) : SELECT DISTINCT userobm_id,
> userobm_lastname, userobm_firstname, evententity_entity,
> evententity_entity_id, evententity_state as state FROM EventEntity
> LEFT JOIN UserObm ON evententity_entity_id = userobm_id WHERE
> evententity_event_id = '289' AND evententity_entity = 'user' AND
> (userobm_domain_id='1' )
> ______________________________________________________________________
> get_calendar_event_entity(2) : SELECT DISTINCT resource_id,
> resource_name, evententity_entity, evententity_entity_id,
> evententity_state as state FROM EventEntity LEFT JOIN Resource ON
> evententity_entity_id = resource_id WHERE evententity_event_id = '289'
> AND evententity_entity = 'resource' AND (resource_domain_id='1' )
> ______________________________________________________________________
> get_calendar_event_entity(2) : SELECT DISTINCT projecttask_id,
> project_name, projecttask_label, evententity_entity,
> evententity_entity_id, evententity_state as state FROM EventEntity
> LEFT JOIN ProjectTask ON evententity_entity_id = projecttask_id LEFT
> JOIN Project ON projecttask_project_id = project_id WHERE
> evententity_event_id = '289' AND evententity_entity = 'task' AND
> (project_domain_id='1' )
> ______________________________________________________________________
> run_query_get_one_event_exception() : SELECT
> calendarexception_event_id, UNIX_TIMESTAMP(calendarexception_date) as
> calendarexception_date FROM CalendarException WHERE
> calendarexception_event_id='289'
> ______________________________________________________________________
> get_one_event_user_alert() : SELECT calendaralert_duration,
> calendaralert_user_id FROM CalendarAlert WHERE
> calendaralert_event_id='289' 
> ______________________________________________________________________
> get_user_info() : SELECT *, UNIX_TIMESTAMP(userobm_datebegin) as
> datebegin FROM UserObm WHERE userobm_id='4'
> ______________________________________________________________________
> of_right_entity_for_user() : SELECT e.userobm_id as id,
> concat(userobm_lastname , ' ' , userobm_firstname) as label,
> 'calendar' as entityright_entity FROM EntityRight LEFT JOIN UserObm as
> e ON entityright_entity_id = e.userobm_id WHERE entityright_entity =
> 'calendar' AND ( (entityright_consumer = 'user' AND
> (entityright_consumer_id = '4' OR entityright_consumer_id = 0)) OR
> (entityright_consumer = 'group' AND (entityright_consumer_id IN
> (SELECT of_usergroup_group_id FROM of_usergroup WHERE
> of_usergroup_user_id = '4') OR entityright_consumer_id = 0))) AND
> entityright_write = 1 GROUP BY id, label, entityright_entity UNION
> SELECT '4' as id, 'Goudin Jimmy' as label, 'calendar' as
> entityright_entity ORDER BY entityright_entity, label
> ______________________________________________________________________
> of_right_entity_for_user() : SELECT e.resource_id as id,
> e.resource_name as label, 'resource' as entityright_entity FROM
> EntityRight LEFT JOIN Resource as e ON entityright_entity_id =
> e.resource_id WHERE entityright_entity = 'resource' AND
> ( (entityright_consumer = 'user' AND (entityright_consumer_id = '4' OR
> entityright_consumer_id = 0)) OR (entityright_consumer = 'group' AND
> (entityright_consumer_id IN (SELECT of_usergroup_group_id FROM
> of_usergroup WHERE of_usergroup_user_id = '4') OR
> entityright_consumer_id = 0))) AND entityright_write = 1 GROUP BY id,
> label, entityright_entity ORDER BY entityright_entity, label
> ______________________________________________________________________
> of_category_get_entitycategories() : SELECT calendarcategory1_id,
> calendarcategory1_label, calendarcategory1_code FROM CalendarEvent,
> CalendarCategory1 WHERE calendarevent_category1_id =
> calendarcategory1_id AND calendarevent_id = '289' AND
> (calendarcategory1_domain_id='1' )
> ______________________________________________________________________
> Paramètres
> action=detailconsult
> params[action]=detailconsult
> params[calendar_id]=289
> 
> 
> Cordialement, 
> Goudin Jimmy
> _______________________________________________
> Obm mailing list
> Obm at list.aliasource.fr
> http://www.list.aliasource.fr/mailman/listinfo/obm
-- 
Mehdi Rande
Aliasource - Groupe LINAGORA
20, rue Hermès, Parc Technologique du Canal 31520 RAMONVILLE SAINT AGNE
Téléphone : +33 (0)5 62 19 24 91