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

[Jimmy Goudin]

Bonjour,

Effectivement, vous avez raison, le problème ne se produit que pour les
évènements qui ont seulement des ressources et pas d'utilisateur.

J'attend donc la 2.1.5 ;o)

Jimmy Goudin

2008/2/6, Mehdi Rande <mehdi.rande at aliasource.fr>:
>
>
> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.list.aliasource.fr/pipermail/obm/attachments/20080207/58e8586f/attachment.htm