[Obm] La relation "eventtag" n'existe pas

Philippe Leménager Philippe.Lemenager at educagri.fr
Wed Apr 28 16:32:01 CEST 2010


Bonjour,
J'ai a priori réussi à mettre à jour OBM de 2.2.20 en 2.5.3 en utilisant 
la procédure RedHat prévue pour la 2.2 :
- Repositionnement du /etc/yum.repos.d/obm.repo sur 
http://packages.obm.org/rpm/23
- Lancement de yum install.
- Lancement de obm-admin.

Tout semble s'être passé normalement. En admin0, la connexion se 
fait sans problème. Par contre en connexion avec un autre 
utilisateur, j'obtiens les messages d'erreur suivants :
Database error: Invalid SQL: SELECT event_id, EXTRACT (EPOCH 
from event_timeupdate) as timeupdate, EXTRACT (EPOCH from 
event_timecreate) as timecreate, event_ext_id, event_title, 
event_privacy, event_priority, event_description, event_properties, 
event_location, event_repeatfrequence, event_owner, 
userobm_lastname, userobm_firstname, event_timezone, 
event_opacity, eventlink_state, eventcategory1_label, event_date, 
event_duration, eventtag_color AS event_color, eventtag_label as 
tag, eventtag_id, event_allday, userentity_user_id as 
eventlink_entity_id, 'user' as eventlink_entity FROM Event LEFT JOIN 
EventCategory1 ON event_category1_id = eventcategory1_id INNER 
JOIN UserObm ON event_owner = userobm_id LEFT JOIN EventTag 
ON event_tag_id = eventtag_id INNER JOIN EventLink ON event_id = 
eventlink_event_id INNER JOIN UserEntity ON userentity_entity_id = 
eventlink_entity_id WHERE event_type='VEVENT' AND 
eventlink_state IN ('ACCEPTED') AND event_repeatkind = 'none' AND 
event_date >= (TIMESTAMP '2010-03-29 06:00:00' - INTERVAL '1 
SECOND' * event_duration) AND event_date <= '2010-05-02 
22:00:00' AND userentity_user_id IN (2) AND (event_domain_id='2') 
ORDER BY event_date, eventlink_entity, eventlink_entity_id
PostgreSQL Error: 1 (ERREUR: la relation « eventtag » n'existe pas)
Database error: Invalid SQL: SELECT event_id, EXTRACT (EPOCH 
from event_timeupdate) as timeupdate, EXTRACT (EPOCH from 
event_timecreate) as timecreate, event_ext_id, event_title, 
event_privacy, event_priority, event_description, event_properties, 
event_location, eventcategory1_label, event_date, event_duration, 
event_repeatkind, event_endrepeat, event_repeatfrequence, 
event_owner, userobm_lastname, userobm_firstname, 
event_timezone, event_opacity, eventlink_state, event_repeatdays, 
eventtag_color AS event_color, eventtag_label as tag, eventtag_id, 
event_allday, 'user' as eventlink_entity, userentity_user_id as 
eventlink_entity_id FROM Event LEFT JOIN EventCategory1 ON 
event_category1_id = eventcategory1_id LEFT JOIN EventTag ON 
event_tag_id = eventtag_id INNER JOIN UserObm ON event_owner = 
userobm_id INNER JOIN EventLink ON event_id = eventlink_event_id 
INNER JOIN UserEntity ON userentity_entity_id = eventlink_entity_id 
WHERE event_type='VEVENT' AND event_repeatkind != 'none' AND 
eventlink_state IN ('ACCEPTED') AND (event_endrepeat >= 
(TIMESTAMP '2010-03-29 06:00:00' - INTERVAL '1 SECOND' * 
event_duration) OR event_endrepeat IS NULL) AND event_date <= 
'2010-05-02 22:00:00' AND userentity_user_id IN (2) AND 
(event_domain_id='2') ORDER BY event_date, eventlink_entity, 
eventlink_entity_id
PostgreSQL Error: 1 (ERREUR: la relation « eventtag » n'existe pas)

Mais sous ces messages s'affiche quand même l'interface utilisateur 
d'OBM avec Agenda et Mon Compte.

Que faire pour éviter ce désagrément ?

-- 
Philippe Leménager
Ingénieur d'études en informatique
École Nationale de Formation Agronomique


More information about the Obm mailing list