[sympa-fr] migration 6.1.17 vers 6.2.24 sur base Oracle

[Wilfried QUET <adresse@cachée>]

Bonjour,

Je tente actuellement une migration 6.1.17 vers 6.2.24.

Ma base référentielle est en Oracle 12.1.

Je tombe sur 3 soucis :

1er problème : création d'une colonne avec un nom trop long (problème qui a priori sera réglé en 12.2) :

create table notification_table
(
 ...
     arrival_date_epoch_notification    number,
 ...)
Error report -
SQL Error: ORA-00972: identifier is too long
00972. 00000 -  "identifier is too long"
*Cause:    An identifier with more than 30 characters was specified.

2ème problème : une requête faite sur un champ EMAIL inexistant dans la table subsbriber_table

Feb 21 18:38:53 mxadm sympa_msg[32755]: err main::#243 > Sympa::Spindle::spin#95 > Sympa::Spindle::ToList::_twist#58 > Sympa::Spindle::ToList::_send_msg#248 > Sympa::List::get_recipients_per_mode#1398 > Sympa::List::get_first_list_member#2666 > Sympa::DatabaseDriver::Oracle::do_query#561 > Sympa::Database::do_query#244 Unable to prepare SQL statement SELECT bounce_subscriber AS "bounce", bounce_address_subscriber AS "bounce_address", bounce_score_subscriber AS "bounce_score", custom_attribute_subscriber AS "custom_attribute", ((to_number(to_char(date_subscriber,'J')) - to_number(to_char(to_date('01/01/1970','dd/mm/yyyy'), 'J'))) * 86400) +to_number(to_char(date_subscriber,'SSSSS')) AS "date", user_subscriber AS "email", suspend_end_date_subscriber AS "enddate", comment_subscriber AS "gecos", include_sources_subscriber AS "id", included_subscriber AS "included", number_messages_subscriber AS "number_messages", reception_subscriber AS "reception", suspend_start_date_subscriber AS "startdate", subscribed_subscriber AS "subscribed", suspend_subscriber AS "suspend", topics_subscriber AS "topics", ((to_number(to_char(update_subscriber,'J')) - to_number(to_char(to_date('01/01/1970','dd/mm/yyyy'), 'J'))) * 86400) +to_number(to_char(update_subscriber,'SSSSS')) AS "update_date", visibility_subscriber AS "visibility"#012          FROM subscriber_table#012          WHERE list_subscriber = 'ingenieur-p2018' AND robot_subscriber = 'adm.utc.fr'  ORDER BY email: (S1000)

ORA-00904: "EMAIL": invalid identifier (DBD ERROR: error possibly near <*> indicator at char 1105 in 'SELECT bounce_subscriber AS "bounce", bounce_address_subscriber AS "bounce_address", bounce_score_subscriber AS "bounce_score", custom_attribute_subscriber AS "custom_attribute", ((to_number(to_char(date_subscriber,'J')) - to_number(to_char(to_date('01/01/1970','dd/mm/yyyy'), 'J'))) * 86400) +to_number(to_char(date_subscriber,'SSSSS')) AS "date", user_subscriber AS "email", suspend_end_date_subscriber AS "enddate", comment_subscriber AS "gecos", include_sources_subscriber AS "id", included_subscriber AS "included", number_messages_subscriber AS "number_messages", reception_subscriber AS "reception",

3ème problème : une requête faite sur un champ email inexistant dans la table subsbriber_table

Feb 21 18:38:53 mxadm sympa_msg[32755]: err main::#243 > Sympa::Spindle::spin#95 > Sympa::Spindle::ToList::_twist#126 > Sympa::Log::db_log#320 > Sympa::DatabaseDriver::Oracle::do_prepared_query#570 > Sympa::Database::do_prepared_query#382 Unable to execute SQL statement "INSERT INTO logs_table (date_logs, usec_logs, robot_logs, list_logs, action_logs, parameters_logs, target_email_logs, msg_id_logs, status_logs, error_type_logs, user_email_logs, client_logs, daemon_logs) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)": (S1000)

ORA-01400: cannot insert NULL into ("SYMPA"."LOGS_TABLE"."ID_LOGS") (DBD ERROR: OCIStmtExecute)

Auriez vous des idées ou suggestions?

Cordialement

Wilfried QUET

-- 
----------------------------------------
Wilfried QUET
Université de Technologie de Compiègne 
Direction des Systèmes d'Information
tél. :  03 44 23 49 90
port.:  06 22 20 59 83
fax  :  03 44 23 46 77
mail :  adresse@cachée
----------------------------------------