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:[email protected] _______________________________________________ Obm mailing list [email protected] http://list.obm.org/mailman/listinfo/obm
