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

Jimmy Goudin jimmy.goudin at gmail.com
Wed Feb 6 16:43:30 CET 2008


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.

*Warning*: in_array()
[function.in-array<https://obm.docubase.com/calendar/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_nameas 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.list.aliasource.fr/pipermail/obm/attachments/20080206/5f12445c/attachment.htm


More information about the Obm mailing list