[Obm] obm 2.3.7. erreurs sql sur import calendrier

Patrick BOSSARD Patrick.Bossard at ifremer.fr
Wed Jun 9 16:42:41 CEST 2010


bonjour à tous,

sur un obm 2.3.7
j'ai un seul user qui fait un import (sur la base vierge) d'un ocs 
exporté par sun calendar.
Malgré l'insertion de données, j'obtiens des erreurs sql importantes 
dans l'ihm :
> Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid 
> input syntax for type timestamp: "1257112800" in 
> /usr/share/obm/www/obminclude/phplib/db_pgsql.inc on line 96
> Database error: Invalid SQL: INSERT INTO Event ( event_ext_id, 
> event_timeupdate, event_timecreate, event_usercreate, event_type, 
> event_origin, event_owner, event_timezone, event_opacity, event_title, 
> event_date, event_description, event_properties, event_location, 
> event_category1_id, event_priority, event_privacy, event_duration, 
> event_repeatkind, event_repeatfrequence, event_repeatdays, 
> event_allday, event_tag_id, event_allow_documents, event_endrepeat, 
> event_domain_id) VALUES ( 
> '000000000000000000000000000000004abb70690000025e000004ce00003f9f', 
> NOW(), NOW(), '2', 'VEVENT', 'obm-ui-web-2.3.7', '2', 'Europe/Paris', 
> 'TRANSPARENT', 'Congés', '2009-10-25 23:00:00', '', '', '', NULL, 3, 
> 0, '86400', 'weekly', '1', '0111110', TRUE, NULL, '0', '1257112800', 2)
> PostgreSQL Error: 1 (ERROR: invalid input syntax for type timestamp: 
> "1257112800")
>
> Warning: pg_query() [function.pg-query]: Query failed: ERROR: insert 
> or update on table "evententity" violates foreign key constraint 
> "evententity_event_id_event_id_fkey" DETAIL: Key 
> (evententity_event_id)=(12) is not present in table "event". in 
> /usr/share/obm/www/obminclude/phplib/db_pgsql.inc on line 96
> Database error: Invalid SQL: INSERT INTO EventEntity 
> (evententity_entity_id, evententity_event_id ) VALUES (13, 12)
> PostgreSQL Error: 1 (ERROR: insert or update on table "evententity" 
> violates foreign key constraint "evententity_event_id_event_id_fkey" 
> DETAIL: Key (evententity_event_id)=(12) is not present in table "event".)
>
> Warning: pg_query() [function.pg-query]: Query failed: ERROR: insert 
> or update on table "eventlink" violates foreign key constraint 
> "eventlink_event_id_event_id_fkey" DETAIL: Key 
> (eventlink_event_id)=(12) is not present in table "event". in 
> /usr/share/obm/www/obminclude/phplib/db_pgsql.inc on line 96
> Database error: Invalid SQL: INSERT INTO EventLink ( 
> eventlink_timecreate, eventlink_usercreate, eventlink_event_id, 
> eventlink_entity_id, eventlink_required, eventlink_state) VALUES ( 
> NOW(), 2, 12, (SELECT userentity_entity_id FROM UserEntity WHERE 
> userentity_user_id = 2), 'REQ', 'ACCEPTED')
> PostgreSQL Error: 1 (ERROR: insert or update on table "eventlink" 
> violates foreign key constraint "eventlink_event_id_event_id_fkey" 
> DETAIL: Key (eventlink_event_id)=(12) is not present in table "event".)
>
> Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid 
> input syntax for type timestamp: "1261951200" in 
> /usr/share/obm/www/obminclude/phplib/db_pgsql.inc on line 96
> Database error: Invalid SQL: INSERT INTO Event ( event_ext_id, 
> event_timeupdate, event_timecreate, event_usercreate, event_type, 
> event_origin, event_owner, event_timezone, event_opacity, event_title, 
> event_date, event_description, event_properties, event_location, 
> event_category1_id, event_priority, event_privacy, event_duration, 
> event_repeatkind, event_repeatfrequence, event_repeatdays, 
> event_allday, event_tag_id, event_allow_documents, event_endrepeat, 
> event_domain_id) VALUES ( 
> '000000000000000000000000000000004abb741700007da90000039800003fa6', 
> NOW(), NOW(), '2', 'VEVENT', 'obm-ui-web-2.3.7', '2', 'Europe/Paris', 
> 'TRANSPARENT', 'Congés', '2009-12-20 23:00:00', '', '', '', NULL, 2, 
> 0, '86400', 'weekly', '1', '0111100', TRUE, NULL, '0', '1261951200', 2)
> PostgreSQL Error: 1 (ERROR: invalid input syntax for type timestamp: 
> "1261951200")
>
> Warning: pg_query() [function.pg-query]: Query failed: ERROR: insert 
> or update on table "evententity" violates foreign key constraint 
> "evententity_event_id_event_id_fkey" DETAIL: Key 
> (evententity_event_id)=(13) is not present in table "event". in 
> /usr/share/obm/www/obminclude/phplib/db_pgsql.inc on line 96
> Database error: Invalid SQL: INSERT INTO EventEntity 
> (evententity_entity_id, evententity_event_id ) VALUES (14, 13)
> PostgreSQL Error: 1 (ERROR: insert or update on table "evententity" 
> violates foreign key constraint "evententity_event_id_event_id_fkey" 
> DETAIL: Key (evententity_event_id)=(13) is not present in table "event".)
>
> Warning: pg_query() [function.pg-query]: Query failed: ERROR: insert 
> or update on table "eventlink" violates foreign key constraint 
> "eventlink_event_id_event_id_fkey" DETAIL: Key 
> (eventlink_event_id)=(13) is not present in table "event". in 
> /usr/share/obm/www/obminclude/phplib/db_pgsql.inc on line 96
> Database error: Invalid SQL: INSERT INTO EventLink ( 
> eventlink_timecreate, eventlink_usercreate, eventlink_event_id, 
> eventlink_entity_id, eventlink_required, eventlink_state) VALUES ( 
> NOW(), 2, 13, (SELECT userentity_entity_id FROM UserEntity WHERE 
> userentity_user_id = 2), 'REQ', 'ACCEPTED')
> PostgreSQL Error: 1 (ERROR: insert or update on table "eventlink" 
> violates foreign key constraint "eventlink_event_id_event_id_fkey" 
> DETAIL: Key (eventlink_event_id)=(13) is not present in table "event".)

Pour info, le même ics est correctement importé en 2.2.14 (mis à part un 
décalage de 2h des evts).
J'ai pensé à un pb lié à une base instable. mais après une recréation de 
la base, re-création des domaines etc c'est pareil.
Quelqun aurait une idée du pb ?

-- 
Patrick BOSSARD - DOP/DCB/IDM/RIC
IFREMER centre de Brest
BP 70 29280 Plouzane FRANCE
Tel  : 02 98 22 44 09 - Fax: 02 98 22 45 46
Email:Patrick.Bossard at ifremer.fr  



More information about the Obm mailing list