0.7.1 - erreur lors d'une installation nouvelle #284

gildeluermoz · 2023-12-11T15:11:39Z

J'installe un serveur debian12 un GN 2.13.3, j'installe tous les modules : import, export, dashboard mais le module monitoring ne veut pas s'installer, il y aune erreur lors de la mise à jour de la base de données :

Rebuild du frontend terminé.
Installation / mise à jour de la base de données…
/home/bradmin/geonature/backend/venv/lib/python3.11/site-packages/sqlalchemy/orm/mapper.py:1841: SAWarning: Property TBaseVisits.dataset on mapped class TBaseVisits->t_base_visits being replaced with new property TBaseVisits.dataset; the old property will be discarded
  util.warn(
/home/bradmin/geonature/backend/venv/lib/python3.11/site-packages/sqlalchemy/orm/mapper.py:1687: SAWarning: Flushing object <TModules at 0x7f33f2c0ecd0> with incompatible polymorphic identity None; the object may not refresh and/or load correctly (this warning may be suppressed after 10 occurrences)
  util.warn_limited(
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade  -> 362cf9d504ec, create_monitoring_schema
INFO  [alembic.runtime.migration] Running upgrade 362cf9d504ec -> 2003e18f248a, Add type to gn_modules
INFO  [alembic.runtime.migration] Running upgrade 2003e18f248a -> e78003460441, Correction t_observation_detail
INFO  [alembic.runtime.migration] Running upgrade e78003460441 -> fc90d31c677f, declare available permissions
INFO  [alembic.runtime.migration] Running upgrade fc90d31c677f -> 3ffeea74a9dd, Rename GNM_ to MONITORINGS_
INFO  [alembic.runtime.migration] Running upgrade 3ffeea74a9dd -> c1528c94d350, Upgrade existing permissions
Traceback (most recent call last):
  File "/home/bradmin/geonature/backend/venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
    self.dialect.do_execute(
  File "/home/bradmin/geonature/backend/venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
    cursor.execute(statement, parameters)
psycopg2.errors.UndefinedTable: ERREUR:  la relation « gn_monitoring.t_module_complements » n'existe pas
LINE 2: FROM gn_commons.t_modules JOIN gn_monitoring.t_module_comple...
                                       ^


The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/home/bradmin/gn_module_monitoring/backend/gn_module_monitoring/modules/repositories.py", line 82, in get_modules
    res = DB.session.query(TMonitoringModules).order_by(TMonitoringModules.module_label).all()
          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/bradmin/geonature/backend/venv/lib/python3.11/site-packages/sqlalchemy/orm/query.py", line 3373, in all
    return list(self)
           ^^^^^^^^^^
  File "/home/bradmin/geonature/backend/venv/lib/python3.11/site-packages/sqlalchemy/orm/query.py", line 3535, in __iter__
    return self._execute_and_instances(context)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/bradmin/geonature/backend/venv/lib/python3.11/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/bradmin/geonature/backend/venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1011, in execute
    return meth(self, multiparams, params)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/bradmin/geonature/backend/venv/lib/python3.11/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/bradmin/geonature/backend/venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement
    ret = self._execute_context(
          ^^^^^^^^^^^^^^^^^^^^^^
  File "/home/bradmin/geonature/backend/venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context
    self._handle_dbapi_exception(
  File "/home/bradmin/geonature/backend/venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception
    util.raise_(
  File "/home/bradmin/geonature/backend/venv/lib/python3.11/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
    raise exception
  File "/home/bradmin/geonature/backend/venv/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
    self.dialect.do_execute(
  File "/home/bradmin/geonature/backend/venv/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedTable) ERREUR:  la relation « gn_monitoring.t_module_complements » n'existe pas
LINE 2: FROM gn_commons.t_modules JOIN gn_monitoring.t_module_comple...
                                       ^

[SQL: SELECT gn_commons.t_modules.type AS gn_commons_t_modules_type, gn_monitoring.t_module_complements.id_module AS gn_monitoring_t_module_complements_id_module, gn_commons.t_modules.id_module AS gn_commons_t_modules_id_module, gn_commons.t_modules.module_code AS gn_commons_t_modules_module_code, gn_commons.t_modules.module_label AS gn_commons_t_modules_module_label, gn_commons.t_modules.module_picto AS gn_commons_t_modules_module_picto, gn_commons.t_modules.module_desc AS gn_commons_t_modules_module_desc, gn_commons.t_modules.module_group AS gn_commons_t_modules_module_group, gn_commons.t_modules.module_path AS gn_commons_t_modules_module_path, gn_commons.t_modules.module_external_url AS gn_commons_t_modules_module_external_url, gn_commons.t_modules.module_target AS gn_commons_t_modules_module_target, gn_commons.t_modules.module_comment AS gn_commons_t_modules_module_comment, gn_commons.t_modules.active_frontend AS gn_commons_t_modules_active_frontend, gn_commons.t_modules.active_backend AS gn_commons_t_modules_active_backend, gn_commons.t_modules.module_doc_url AS gn_commons_t_modules_module_doc_url, gn_commons.t_modules.module_order AS gn_commons_t_modules_module_order, gn_commons.t_modules.ng_module AS gn_commons_t_modules_ng_module, gn_commons.t_modules.meta_create_date AS gn_commons_t_modules_meta_create_date, gn_commons.t_modules.meta_update_date AS gn_commons_t_modules_meta_update_date, gn_monitoring.t_module_complements.uuid_module_complement AS gn_monitoring_t_module_complements_uuid_module_complement, gn_monitoring.t_module_complements.id_list_observer AS gn_monitoring_t_module_complements_id_list_observer, gn_monitoring.t_module_complements.id_list_taxonomy AS gn_monitoring_t_module_complements_id_list_taxonomy, gn_monitoring.t_module_complements.taxonomy_display_field_name AS gn_monitoring_t_module_complements_taxonomy_display_field_1, gn_monitoring.t_module_complements.b_synthese AS gn_monitoring_t_module_complements_b_synthese, gn_monitoring.t_module_complements.b_draw_sites_group AS gn_monitoring_t_module_complements_b_draw_sites_group, gn_monitoring.t_module_complements.data AS gn_monitoring_t_module_complements_data, t_medias_1.id_media AS t_medias_1_id_media, t_medias_1.id_nomenclature_media_type AS t_medias_1_id_nomenclature_media_type, t_medias_1.id_table_location AS t_medias_1_id_table_location, t_medias_1.unique_id_media AS t_medias_1_unique_id_media, t_medias_1.uuid_attached_row AS t_medias_1_uuid_attached_row, t_medias_1.title_fr AS t_medias_1_title_fr, t_medias_1.title_en AS t_medias_1_title_en, t_medias_1.title_it AS t_medias_1_title_it, t_medias_1.title_es AS t_medias_1_title_es, t_medias_1.title_de AS t_medias_1_title_de, t_medias_1.media_url AS t_medias_1_media_url, t_medias_1.media_path AS t_medias_1_media_path, t_medias_1.author AS t_medias_1_author, t_medias_1.description_fr AS t_medias_1_description_fr, t_medias_1.description_en AS t_medias_1_description_en, t_medias_1.description_it AS t_medias_1_description_it, t_medias_1.description_es AS t_medias_1_description_es, t_medias_1.description_de AS t_medias_1_description_de, t_medias_1.is_public AS t_medias_1_is_public, t_medias_1.meta_create_date AS t_medias_1_meta_create_date, t_medias_1.meta_update_date AS t_medias_1_meta_update_date, t_roles_1.pass AS t_roles_1_pass, t_roles_1.pass_plus AS t_roles_1_pass_plus, t_roles_1.groupe AS t_roles_1_groupe, t_roles_1.id_role AS t_roles_1_id_role, t_roles_1.identifiant AS t_roles_1_identifiant, t_roles_1.nom_role AS t_roles_1_nom_role, t_roles_1.prenom_role AS t_roles_1_prenom_role, t_roles_1.desc_role AS t_roles_1_desc_role, t_roles_1.email AS t_roles_1_email, t_roles_1.id_organisme AS t_roles_1_id_organisme, t_roles_1.remarques AS t_roles_1_remarques, t_roles_1.champs_addi AS t_roles_1_champs_addi, t_roles_1.date_insert AS t_roles_1_date_insert, t_roles_1.date_update AS t_roles_1_date_update, t_roles_1.active AS t_roles_1_active, t_nomenclatures_1.id_nomenclature AS t_nomenclatures_1_id_nomenclature, t_nomenclatures_1.id_type AS t_nomenclatures_1_id_type, t_nomenclatures_1.cd_nomenclature AS t_nomenclatures_1_cd_nomenclature, t_nomenclatures_1.mnemonique AS t_nomenclatures_1_mnemonique, t_nomenclatures_1.label_default AS t_nomenclatures_1_label_default, t_nomenclatures_1.definition_default AS t_nomenclatures_1_definition_default, t_nomenclatures_1.label_fr AS t_nomenclatures_1_label_fr, t_nomenclatures_1.definition_fr AS t_nomenclatures_1_definition_fr, t_nomenclatures_1.label_en AS t_nomenclatures_1_label_en, t_nomenclatures_1.definition_en AS t_nomenclatures_1_definition_en, t_nomenclatures_1.label_es AS t_nomenclatures_1_label_es, t_nomenclatures_1.definition_es AS t_nomenclatures_1_definition_es, t_nomenclatures_1.label_de AS t_nomenclatures_1_label_de, t_nomenclatures_1.definition_de AS t_nomenclatures_1_definition_de, t_nomenclatures_1.label_it AS t_nomenclatures_1_label_it, t_nomenclatures_1.definition_it AS t_nomenclatures_1_definition_it, t_nomenclatures_1.source AS t_nomenclatures_1_source, t_nomenclatures_1.statut AS t_nomenclatures_1_statut, t_nomenclatures_1.id_broader AS t_nomenclatures_1_id_broader, t_nomenclatures_1.hierarchy AS t_nomenclatures_1_hierarchy, t_nomenclatures_1.active AS t_nomenclatures_1_active, t_nomenclatures_1.meta_create_date AS t_nomenclatures_1_meta_create_date, t_nomenclatures_1.meta_update_date AS t_nomenclatures_1_meta_update_date, t_roles_2.pass AS t_roles_2_pass, t_roles_2.pass_plus AS t_roles_2_pass_plus, t_roles_2.groupe AS t_roles_2_groupe, t_roles_2.id_role AS t_roles_2_id_role, t_roles_2.identifiant AS t_roles_2_identifiant, t_roles_2.nom_role AS t_roles_2_nom_role, t_roles_2.prenom_role AS t_roles_2_prenom_role, t_roles_2.desc_role AS t_roles_2_desc_role, t_roles_2.email AS t_roles_2_email, t_roles_2.id_organisme AS t_roles_2_id_organisme, t_roles_2.remarques AS t_roles_2_remarques, t_roles_2.champs_addi AS t_roles_2_champs_addi, t_roles_2.date_insert AS t_roles_2_date_insert, t_roles_2.date_update AS t_roles_2_date_update, t_roles_2.active AS t_roles_2_active, bib_organismes_1.id_organisme AS bib_organismes_1_id_organisme, bib_organismes_1.uuid_organisme AS bib_organismes_1_uuid_organisme, bib_organismes_1.nom_organisme AS bib_organismes_1_nom_organisme, bib_organismes_1.adresse_organisme AS bib_organismes_1_adresse_organisme, bib_organismes_1.cp_organisme AS bib_organismes_1_cp_organisme, bib_organismes_1.ville_organisme AS bib_organismes_1_ville_organisme, bib_organismes_1.tel_organisme AS bib_organismes_1_tel_organisme, bib_organismes_1.fax_organisme AS bib_organismes_1_fax_organisme, bib_organismes_1.email_organisme AS bib_organismes_1_email_organisme, bib_organismes_1.url_organisme AS bib_organismes_1_url_organisme, bib_organismes_1.url_logo AS bib_organismes_1_url_logo, bib_organismes_1.id_parent AS bib_organismes_1_id_parent, bib_organismes_1.additional_data AS bib_organismes_1_additional_data, cor_acquisition_framework_actor_1.id_cafa AS cor_acquisition_framework_actor_1_id_cafa, cor_acquisition_framework_actor_1.id_acquisition_framework AS cor_acquisition_framework_actor_1_id_acquisition_framewor_2, cor_acquisition_framework_actor_1.id_role AS cor_acquisition_framework_actor_1_id_role, cor_acquisition_framework_actor_1.id_organism AS cor_acquisition_framework_actor_1_id_organism, cor_acquisition_framework_actor_1.id_nomenclature_actor_role AS cor_acquisition_framework_actor_1_id_nomenclature_actor_r_3, t_acquisition_frameworks_1.id_acquisition_framework AS t_acquisition_frameworks_1_id_acquisition_framework, t_acquisition_frameworks_1.unique_acquisition_framework_id AS t_acquisition_frameworks_1_unique_acquisition_framework_i_4, t_acquisition_frameworks_1.acquisition_framework_name AS t_acquisition_frameworks_1_acquisition_framework_name, t_acquisition_frameworks_1.acquisition_framework_desc AS t_acquisition_frameworks_1_acquisition_framework_desc, t_acquisition_frameworks_1.id_nomenclature_territorial_level AS t_acquisition_frameworks_1_id_nomenclature_territorial_le_5, t_acquisition_frameworks_1.territory_desc AS t_acquisition_frameworks_1_territory_desc, t_acquisition_frameworks_1.keywords AS t_acquisition_frameworks_1_keywords, t_acquisition_frameworks_1.id_nomenclature_financing_type AS t_acquisition_frameworks_1_id_nomenclature_financing_type, t_acquisition_frameworks_1.target_description AS t_acquisition_frameworks_1_target_description, t_acquisition_frameworks_1.ecologic_or_geologic_target AS t_acquisition_frameworks_1_ecologic_or_geologic_target, t_acquisition_frameworks_1.acquisition_framework_parent_id AS t_acquisition_frameworks_1_acquisition_framework_parent_i_6, t_acquisition_frameworks_1.is_parent AS t_acquisition_frameworks_1_is_parent, t_acquisition_frameworks_1.opened AS t_acquisition_frameworks_1_opened, t_acquisition_frameworks_1.id_digitizer AS t_acquisition_frameworks_1_id_digitizer, t_acquisition_frameworks_1.acquisition_framework_start_date AS t_acquisition_frameworks_1_acquisition_framework_start_da_7, t_acquisition_frameworks_1.acquisition_framework_end_date AS t_acquisition_frameworks_1_acquisition_framework_end_date, t_acquisition_frameworks_1.meta_create_date AS t_acquisition_frameworks_1_meta_create_date, t_acquisition_frameworks_1.meta_update_date AS t_acquisition_frameworks_1_meta_update_date, t_acquisition_frameworks_1.initial_closing_date AS t_acquisition_frameworks_1_initial_closing_date, t_roles_3.pass AS t_roles_3_pass, t_roles_3.pass_plus AS t_roles_3_pass_plus, t_roles_3.groupe AS t_roles_3_groupe, t_roles_3.id_role AS t_roles_3_id_role, t_roles_3.identifiant AS t_roles_3_identifiant, t_roles_3.nom_role AS t_roles_3_nom_role, t_roles_3.prenom_role AS t_roles_3_prenom_role, t_roles_3.desc_role AS t_roles_3_desc_role, t_roles_3.email AS t_roles_3_email, t_roles_3.id_organisme AS t_roles_3_id_organisme, t_roles_3.remarques AS t_roles_3_remarques, t_roles_3.champs_addi AS t_roles_3_champs_addi, t_roles_3.date_insert AS t_roles_3_date_insert, t_roles_3.date_update AS t_roles_3_date_update, t_roles_3.active AS t_roles_3_active, t_roles_4.pass AS t_roles_4_pass, t_roles_4.pass_plus AS t_roles_4_pass_plus, t_roles_4.groupe AS t_roles_4_groupe, t_roles_4.id_role AS t_roles_4_id_role, t_roles_4.identifiant AS t_roles_4_identifiant, t_roles_4.nom_role AS t_roles_4_nom_role, t_roles_4.prenom_role AS t_roles_4_prenom_role, t_roles_4.desc_role AS t_roles_4_desc_role, t_roles_4.email AS t_roles_4_email, t_roles_4.id_organisme AS t_roles_4_id_organisme, t_roles_4.remarques AS t_roles_4_remarques, t_roles_4.champs_addi AS t_roles_4_champs_addi, t_roles_4.date_insert AS t_roles_4_date_insert, t_roles_4.date_update AS t_roles_4_date_update, t_roles_4.active AS t_roles_4_active, t_nomenclatures_2.id_nomenclature AS t_nomenclatures_2_id_nomenclature, t_nomenclatures_2.id_type AS t_nomenclatures_2_id_type, t_nomenclatures_2.cd_nomenclature AS t_nomenclatures_2_cd_nomenclature, t_nomenclatures_2.mnemonique AS t_nomenclatures_2_mnemonique, t_nomenclatures_2.label_default AS t_nomenclatures_2_label_default, t_nomenclatures_2.definition_default AS t_nomenclatures_2_definition_default, t_nomenclatures_2.label_fr AS t_nomenclatures_2_label_fr, t_nomenclatures_2.definition_fr AS t_nomenclatures_2_definition_fr, t_nomenclatures_2.label_en AS t_nomenclatures_2_label_en, t_nomenclatures_2.definition_en AS t_nomenclatures_2_definition_en, t_nomenclatures_2.label_es AS t_nomenclatures_2_label_es, t_nomenclatures_2.definition_es AS t_nomenclatures_2_definition_es, t_nomenclatures_2.label_de AS t_nomenclatures_2_label_de, t_nomenclatures_2.definition_de AS t_nomenclatures_2_definition_de, t_nomenclatures_2.label_it AS t_nomenclatures_2_label_it, t_nomenclatures_2.definition_it AS t_nomenclatures_2_definition_it, t_nomenclatures_2.source AS t_nomenclatures_2_source, t_nomenclatures_2.statut AS t_nomenclatures_2_statut, t_nomenclatures_2.id_broader AS t_nomenclatures_2_id_broader, t_nomenclatures_2.hierarchy AS t_nomenclatures_2_hierarchy, t_nomenclatures_2.active AS t_nomenclatures_2_active, t_nomenclatures_2.meta_create_date AS t_nomenclatures_2_meta_create_date, t_nomenclatures_2.meta_update_date AS t_nomenclatures_2_meta_update_date, t_roles_5.pass AS t_roles_5_pass, t_roles_5.pass_plus AS t_roles_5_pass_plus, t_roles_5.groupe AS t_roles_5_groupe, t_roles_5.id_role AS t_roles_5_id_role, t_roles_5.identifiant AS t_roles_5_identifiant, t_roles_5.nom_role AS t_roles_5_nom_role, t_roles_5.prenom_role AS t_roles_5_prenom_role, t_roles_5.desc_role AS t_roles_5_desc_role, t_roles_5.email AS t_roles_5_email, t_roles_5.id_organisme AS t_roles_5_id_organisme, t_roles_5.remarques AS t_roles_5_remarques, t_roles_5.champs_addi AS t_roles_5_champs_addi, t_roles_5.date_insert AS t_roles_5_date_insert, t_roles_5.date_update AS t_roles_5_date_update, t_roles_5.active AS t_roles_5_active, bib_organismes_2.id_organisme AS bib_organismes_2_id_organisme, bib_organismes_2.uuid_organisme AS bib_organismes_2_uuid_organisme, bib_organismes_2.nom_organisme AS bib_organismes_2_nom_organisme, bib_organismes_2.adresse_organisme AS bib_organismes_2_adresse_organisme, bib_organismes_2.cp_organisme AS bib_organismes_2_cp_organisme, bib_organismes_2.ville_organisme AS bib_organismes_2_ville_organisme, bib_organismes_2.tel_organisme AS bib_organismes_2_tel_organisme, bib_organismes_2.fax_organisme AS bib_organismes_2_fax_organisme, bib_organismes_2.email_organisme AS bib_organismes_2_email_organisme, bib_organismes_2.url_organisme AS bib_organismes_2_url_organisme, bib_organismes_2.url_logo AS bib_organismes_2_url_logo, bib_organismes_2.id_parent AS bib_organismes_2_id_parent, bib_organismes_2.additional_data AS bib_organismes_2_additional_data, cor_dataset_actor_1.id_cda AS cor_dataset_actor_1_id_cda, cor_dataset_actor_1.id_dataset AS cor_dataset_actor_1_id_dataset, cor_dataset_actor_1.id_role AS cor_dataset_actor_1_id_role, cor_dataset_actor_1.id_organism AS cor_dataset_actor_1_id_organism, cor_dataset_actor_1.id_nomenclature_actor_role AS cor_dataset_actor_1_id_nomenclature_actor_role, t_datasets_1.id_dataset AS t_datasets_1_id_dataset, t_datasets_1.unique_dataset_id AS t_datasets_1_unique_dataset_id, t_datasets_1.id_acquisition_framework AS t_datasets_1_id_acquisition_framework, t_datasets_1.dataset_name AS t_datasets_1_dataset_name, t_datasets_1.dataset_shortname AS t_datasets_1_dataset_shortname, t_datasets_1.dataset_desc AS t_datasets_1_dataset_desc, t_datasets_1.id_nomenclature_data_type AS t_datasets_1_id_nomenclature_data_type, t_datasets_1.keywords AS t_datasets_1_keywords, t_datasets_1.marine_domain AS t_datasets_1_marine_domain, t_datasets_1.terrestrial_domain AS t_datasets_1_terrestrial_domain, t_datasets_1.id_nomenclature_dataset_objectif AS t_datasets_1_id_nomenclature_dataset_objectif, t_datasets_1.bbox_west AS t_datasets_1_bbox_west, t_datasets_1.bbox_east AS t_datasets_1_bbox_east, t_datasets_1.bbox_south AS t_datasets_1_bbox_south, t_datasets_1.bbox_north AS t_datasets_1_bbox_north, t_datasets_1.id_nomenclature_collecting_method AS t_datasets_1_id_nomenclature_collecting_method, t_datasets_1.id_nomenclature_data_origin AS t_datasets_1_id_nomenclature_data_origin, t_datasets_1.id_nomenclature_source_status AS t_datasets_1_id_nomenclature_source_status, t_datasets_1.id_nomenclature_resource_type AS t_datasets_1_id_nomenclature_resource_type, t_datasets_1.meta_create_date AS t_datasets_1_meta_create_date, t_datasets_1.meta_update_date AS t_datasets_1_meta_update_date, t_datasets_1.active AS t_datasets_1_active, t_datasets_1.validable AS t_datasets_1_validable, t_datasets_1.id_digitizer AS t_datasets_1_id_digitizer, t_datasets_1.id_taxa_list AS t_datasets_1_id_taxa_list 
FROM gn_commons.t_modules JOIN gn_monitoring.t_module_complements ON gn_commons.t_modules.id_module = gn_monitoring.t_module_complements.id_module LEFT OUTER JOIN gn_commons.t_medias AS t_medias_1 ON t_medias_1.uuid_attached_row = gn_monitoring.t_module_complements.uuid_module_complement LEFT OUTER JOIN (gn_commons.cor_module_dataset AS cor_module_dataset_1 JOIN gn_meta.t_datasets AS t_datasets_1 ON t_datasets_1.id_dataset = cor_module_dataset_1.id_dataset) ON gn_commons.t_modules.id_module = cor_module_dataset_1.id_module LEFT OUTER JOIN gn_meta.t_acquisition_frameworks AS t_acquisition_frameworks_1 ON t_acquisition_frameworks_1.id_acquisition_framework = t_datasets_1.id_acquisition_framework LEFT OUTER JOIN utilisateurs.t_roles AS t_roles_1 ON t_roles_1.id_role = t_acquisition_frameworks_1.id_digitizer LEFT OUTER JOIN gn_meta.cor_acquisition_framework_actor AS cor_acquisition_framework_actor_1 ON t_acquisition_frameworks_1.id_acquisition_framework = cor_acquisition_framework_actor_1.id_acquisition_framework LEFT OUTER JOIN ref_nomenclatures.t_nomenclatures AS t_nomenclatures_1 ON t_nomenclatures_1.id_nomenclature = cor_acquisition_framework_actor_1.id_nomenclature_actor_role LEFT OUTER JOIN utilisateurs.t_roles AS t_roles_2 ON t_roles_2.id_role = cor_acquisition_framework_actor_1.id_role LEFT OUTER JOIN utilisateurs.bib_organismes AS bib_organismes_1 ON bib_organismes_1.id_organisme = cor_acquisition_framework_actor_1.id_organism LEFT OUTER JOIN utilisateurs.t_roles AS t_roles_3 ON t_roles_3.id_role = t_datasets_1.id_digitizer LEFT OUTER JOIN utilisateurs.t_roles AS t_roles_4 ON t_roles_4.id_role = t_datasets_1.id_digitizer LEFT OUTER JOIN gn_meta.cor_dataset_actor AS cor_dataset_actor_1 ON t_datasets_1.id_dataset = cor_dataset_actor_1.id_dataset LEFT OUTER JOIN ref_nomenclatures.t_nomenclatures AS t_nomenclatures_2 ON t_nomenclatures_2.id_nomenclature = cor_dataset_actor_1.id_nomenclature_actor_role LEFT OUTER JOIN utilisateurs.t_roles AS t_roles_5 ON t_roles_5.id_role = cor_dataset_actor_1.id_role LEFT OUTER JOIN utilisateurs.bib_organismes AS bib_organismes_2 ON bib_organismes_2.id_organisme = cor_dataset_actor_1.id_organism ORDER BY gn_commons.t_modules.module_label]
(Background on this error at: http://sqlalche.me/e/13/f405)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/home/bradmin/geonature/backend/venv/bin/geonature", line 8, in <module>
    sys.exit(main())
             ^^^^^^
  File "/home/bradmin/geonature/backend/venv/lib/python3.11/site-packages/click/core.py", line 1157, in __call__
    return self.main(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/bradmin/geonature/backend/venv/lib/python3.11/site-packages/click/core.py", line 1078, in main
    rv = self.invoke(ctx)
         ^^^^^^^^^^^^^^^^
  File "/home/bradmin/geonature/backend/venv/lib/python3.11/site-packages/click/core.py", line 1688, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/bradmin/geonature/backend/venv/lib/python3.11/site-packages/click/core.py", line 1434, in invoke
    return ctx.invoke(self.callback, **ctx.params)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/bradmin/geonature/backend/venv/lib/python3.11/site-packages/click/core.py", line 783, in invoke
    return __callback(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/bradmin/geonature/backend/venv/lib/python3.11/site-packages/click/decorators.py", line 33, in new_func
    return f(get_current_context(), *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/bradmin/geonature/backend/venv/lib/python3.11/site-packages/flask/cli.py", line 357, in decorator
    return __ctx.invoke(f, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/bradmin/geonature/backend/venv/lib/python3.11/site-packages/click/core.py", line 783, in invoke
    return __callback(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/bradmin/geonature/backend/geonature/core/command/create_gn_module.py", line 86, in install_gn_module
    if not module_db_upgrade(module_dist, x_arg=x_arg):
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/bradmin/geonature/backend/geonature/utils/module.py", line 137, in module_db_upgrade
    db_upgrade(directory, revision, sql, tag, x_arg)
  File "/home/bradmin/geonature/backend/venv/lib/python3.11/site-packages/flask_migrate/__init__.py", line 111, in wrapped
    f(*args, **kwargs)
  File "/home/bradmin/geonature/backend/venv/lib/python3.11/site-packages/flask_migrate/__init__.py", line 200, in upgrade
    command.upgrade(config, revision, sql=sql, tag=tag)
  File "/home/bradmin/geonature/backend/venv/lib/python3.11/site-packages/alembic/command.py", line 399, in upgrade
    script.run_env()
  File "/home/bradmin/geonature/backend/venv/lib/python3.11/site-packages/alembic/script/base.py", line 578, in run_env
    util.load_python_file(self.dir, "env.py")
  File "/home/bradmin/geonature/backend/venv/lib/python3.11/site-packages/alembic/util/pyfiles.py", line 93, in load_python_file
    module = load_module_py(module_id, path)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/bradmin/geonature/backend/venv/lib/python3.11/site-packages/alembic/util/pyfiles.py", line 109, in load_module_py
    spec.loader.exec_module(module)  # type: ignore
    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "<frozen importlib._bootstrap_external>", line 940, in exec_module
  File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed
  File "/home/bradmin/geonature/backend/geonature/migrations/env.py", line 88, in <module>
    run_migrations_online()
  File "/home/bradmin/geonature/backend/geonature/migrations/env.py", line 82, in run_migrations_online
    context.run_migrations()
  File "<string>", line 8, in run_migrations
  File "/home/bradmin/geonature/backend/venv/lib/python3.11/site-packages/alembic/runtime/environment.py", line 937, in run_migrations
    self.get_context().run_migrations(**kw)
  File "/home/bradmin/geonature/backend/venv/lib/python3.11/site-packages/alembic/runtime/migration.py", line 624, in run_migrations
    step.migration_fn(**kw)
  File "/home/bradmin/gn_module_monitoring/backend/gn_module_monitoring/migrations/c1528c94d350_upgrade_existing_permissions.py", line 28, in upgrade
    for module in installed_modules():
                  ^^^^^^^^^^^^^^^^^^^
  File "/home/bradmin/gn_module_monitoring/backend/gn_module_monitoring/command/utils.py", line 307, in installed_modules
    for module in get_modules()
                  ^^^^^^^^^^^^^
  File "/home/bradmin/gn_module_monitoring/backend/gn_module_monitoring/modules/repositories.py", line 87, in get_modules
    raise GeoNatureError("MONITORINGS - get_modules : {}".format(str(e)))
geonature.utils.errors.GeoNatureError: MONITORINGS - get_modules : (psycopg2.errors.UndefinedTable) ERREUR:  la relation « gn_monitoring.t_module_complements » n'existe pas
LINE 2: FROM gn_commons.t_modules JOIN gn_monitoring.t_module_comple...
                                       ^

[SQL: SELECT gn_commons.t_modules.type AS gn_commons_t_modules_type, gn_monitoring.t_module_complements.id_module AS gn_monitoring_t_module_complements_id_module, gn_commons.t_modules.id_module AS gn_commons_t_modules_id_module, gn_commons.t_modules.module_code AS gn_commons_t_modules_module_code, gn_commons.t_modules.module_label AS gn_commons_t_modules_module_label, gn_commons.t_modules.module_picto AS gn_commons_t_modules_module_picto, gn_commons.t_modules.module_desc AS gn_commons_t_modules_module_desc, gn_commons.t_modules.module_group AS gn_commons_t_modules_module_group, gn_commons.t_modules.module_path AS gn_commons_t_modules_module_path, gn_commons.t_modules.module_external_url AS gn_commons_t_modules_module_external_url, gn_commons.t_modules.module_target AS gn_commons_t_modules_module_target, gn_commons.t_modules.module_comment AS gn_commons_t_modules_module_comment, gn_commons.t_modules.active_frontend AS gn_commons_t_modules_active_frontend, gn_commons.t_modules.active_backend AS gn_commons_t_modules_active_backend, gn_commons.t_modules.module_doc_url AS gn_commons_t_modules_module_doc_url, gn_commons.t_modules.module_order AS gn_commons_t_modules_module_order, gn_commons.t_modules.ng_module AS gn_commons_t_modules_ng_module, gn_commons.t_modules.meta_create_date AS gn_commons_t_modules_meta_create_date, gn_commons.t_modules.meta_update_date AS gn_commons_t_modules_meta_update_date, gn_monitoring.t_module_complements.uuid_module_complement AS gn_monitoring_t_module_complements_uuid_module_complement, gn_monitoring.t_module_complements.id_list_observer AS gn_monitoring_t_module_complements_id_list_observer, gn_monitoring.t_module_complements.id_list_taxonomy AS gn_monitoring_t_module_complements_id_list_taxonomy, gn_monitoring.t_module_complements.taxonomy_display_field_name AS gn_monitoring_t_module_complements_taxonomy_display_field_1, gn_monitoring.t_module_complements.b_synthese AS gn_monitoring_t_module_complements_b_synthese, gn_monitoring.t_module_complements.b_draw_sites_group AS gn_monitoring_t_module_complements_b_draw_sites_group, gn_monitoring.t_module_complements.data AS gn_monitoring_t_module_complements_data, t_medias_1.id_media AS t_medias_1_id_media, t_medias_1.id_nomenclature_media_type AS t_medias_1_id_nomenclature_media_type, t_medias_1.id_table_location AS t_medias_1_id_table_location, t_medias_1.unique_id_media AS t_medias_1_unique_id_media, t_medias_1.uuid_attached_row AS t_medias_1_uuid_attached_row, t_medias_1.title_fr AS t_medias_1_title_fr, t_medias_1.title_en AS t_medias_1_title_en, t_medias_1.title_it AS t_medias_1_title_it, t_medias_1.title_es AS t_medias_1_title_es, t_medias_1.title_de AS t_medias_1_title_de, t_medias_1.media_url AS t_medias_1_media_url, t_medias_1.media_path AS t_medias_1_media_path, t_medias_1.author AS t_medias_1_author, t_medias_1.description_fr AS t_medias_1_description_fr, t_medias_1.description_en AS t_medias_1_description_en, t_medias_1.description_it AS t_medias_1_description_it, t_medias_1.description_es AS t_medias_1_description_es, t_medias_1.description_de AS t_medias_1_description_de, t_medias_1.is_public AS t_medias_1_is_public, t_medias_1.meta_create_date AS t_medias_1_meta_create_date, t_medias_1.meta_update_date AS t_medias_1_meta_update_date, t_roles_1.pass AS t_roles_1_pass, t_roles_1.pass_plus AS t_roles_1_pass_plus, t_roles_1.groupe AS t_roles_1_groupe, t_roles_1.id_role AS t_roles_1_id_role, t_roles_1.identifiant AS t_roles_1_identifiant, t_roles_1.nom_role AS t_roles_1_nom_role, t_roles_1.prenom_role AS t_roles_1_prenom_role, t_roles_1.desc_role AS t_roles_1_desc_role, t_roles_1.email AS t_roles_1_email, t_roles_1.id_organisme AS t_roles_1_id_organisme, t_roles_1.remarques AS t_roles_1_remarques, t_roles_1.champs_addi AS t_roles_1_champs_addi, t_roles_1.date_insert AS t_roles_1_date_insert, t_roles_1.date_update AS t_roles_1_date_update, t_roles_1.active AS t_roles_1_active, t_nomenclatures_1.id_nomenclature AS t_nomenclatures_1_id_nomenclature, t_nomenclatures_1.id_type AS t_nomenclatures_1_id_type, t_nomenclatures_1.cd_nomenclature AS t_nomenclatures_1_cd_nomenclature, t_nomenclatures_1.mnemonique AS t_nomenclatures_1_mnemonique, t_nomenclatures_1.label_default AS t_nomenclatures_1_label_default, t_nomenclatures_1.definition_default AS t_nomenclatures_1_definition_default, t_nomenclatures_1.label_fr AS t_nomenclatures_1_label_fr, t_nomenclatures_1.definition_fr AS t_nomenclatures_1_definition_fr, t_nomenclatures_1.label_en AS t_nomenclatures_1_label_en, t_nomenclatures_1.definition_en AS t_nomenclatures_1_definition_en, t_nomenclatures_1.label_es AS t_nomenclatures_1_label_es, t_nomenclatures_1.definition_es AS t_nomenclatures_1_definition_es, t_nomenclatures_1.label_de AS t_nomenclatures_1_label_de, t_nomenclatures_1.definition_de AS t_nomenclatures_1_definition_de, t_nomenclatures_1.label_it AS t_nomenclatures_1_label_it, t_nomenclatures_1.definition_it AS t_nomenclatures_1_definition_it, t_nomenclatures_1.source AS t_nomenclatures_1_source, t_nomenclatures_1.statut AS t_nomenclatures_1_statut, t_nomenclatures_1.id_broader AS t_nomenclatures_1_id_broader, t_nomenclatures_1.hierarchy AS t_nomenclatures_1_hierarchy, t_nomenclatures_1.active AS t_nomenclatures_1_active, t_nomenclatures_1.meta_create_date AS t_nomenclatures_1_meta_create_date, t_nomenclatures_1.meta_update_date AS t_nomenclatures_1_meta_update_date, t_roles_2.pass AS t_roles_2_pass, t_roles_2.pass_plus AS t_roles_2_pass_plus, t_roles_2.groupe AS t_roles_2_groupe, t_roles_2.id_role AS t_roles_2_id_role, t_roles_2.identifiant AS t_roles_2_identifiant, t_roles_2.nom_role AS t_roles_2_nom_role, t_roles_2.prenom_role AS t_roles_2_prenom_role, t_roles_2.desc_role AS t_roles_2_desc_role, t_roles_2.email AS t_roles_2_email, t_roles_2.id_organisme AS t_roles_2_id_organisme, t_roles_2.remarques AS t_roles_2_remarques, t_roles_2.champs_addi AS t_roles_2_champs_addi, t_roles_2.date_insert AS t_roles_2_date_insert, t_roles_2.date_update AS t_roles_2_date_update, t_roles_2.active AS t_roles_2_active, bib_organismes_1.id_organisme AS bib_organismes_1_id_organisme, bib_organismes_1.uuid_organisme AS bib_organismes_1_uuid_organisme, bib_organismes_1.nom_organisme AS bib_organismes_1_nom_organisme, bib_organismes_1.adresse_organisme AS bib_organismes_1_adresse_organisme, bib_organismes_1.cp_organisme AS bib_organismes_1_cp_organisme, bib_organismes_1.ville_organisme AS bib_organismes_1_ville_organisme, bib_organismes_1.tel_organisme AS bib_organismes_1_tel_organisme, bib_organismes_1.fax_organisme AS bib_organismes_1_fax_organisme, bib_organismes_1.email_organisme AS bib_organismes_1_email_organisme, bib_organismes_1.url_organisme AS bib_organismes_1_url_organisme, bib_organismes_1.url_logo AS bib_organismes_1_url_logo, bib_organismes_1.id_parent AS bib_organismes_1_id_parent, bib_organismes_1.additional_data AS bib_organismes_1_additional_data, cor_acquisition_framework_actor_1.id_cafa AS cor_acquisition_framework_actor_1_id_cafa, cor_acquisition_framework_actor_1.id_acquisition_framework AS cor_acquisition_framework_actor_1_id_acquisition_framewor_2, cor_acquisition_framework_actor_1.id_role AS cor_acquisition_framework_actor_1_id_role, cor_acquisition_framework_actor_1.id_organism AS cor_acquisition_framework_actor_1_id_organism, cor_acquisition_framework_actor_1.id_nomenclature_actor_role AS cor_acquisition_framework_actor_1_id_nomenclature_actor_r_3, t_acquisition_frameworks_1.id_acquisition_framework AS t_acquisition_frameworks_1_id_acquisition_framework, t_acquisition_frameworks_1.unique_acquisition_framework_id AS t_acquisition_frameworks_1_unique_acquisition_framework_i_4, t_acquisition_frameworks_1.acquisition_framework_name AS t_acquisition_frameworks_1_acquisition_framework_name, t_acquisition_frameworks_1.acquisition_framework_desc AS t_acquisition_frameworks_1_acquisition_framework_desc, t_acquisition_frameworks_1.id_nomenclature_territorial_level AS t_acquisition_frameworks_1_id_nomenclature_territorial_le_5, t_acquisition_frameworks_1.territory_desc AS t_acquisition_frameworks_1_territory_desc, t_acquisition_frameworks_1.keywords AS t_acquisition_frameworks_1_keywords, t_acquisition_frameworks_1.id_nomenclature_financing_type AS t_acquisition_frameworks_1_id_nomenclature_financing_type, t_acquisition_frameworks_1.target_description AS t_acquisition_frameworks_1_target_description, t_acquisition_frameworks_1.ecologic_or_geologic_target AS t_acquisition_frameworks_1_ecologic_or_geologic_target, t_acquisition_frameworks_1.acquisition_framework_parent_id AS t_acquisition_frameworks_1_acquisition_framework_parent_i_6, t_acquisition_frameworks_1.is_parent AS t_acquisition_frameworks_1_is_parent, t_acquisition_frameworks_1.opened AS t_acquisition_frameworks_1_opened, t_acquisition_frameworks_1.id_digitizer AS t_acquisition_frameworks_1_id_digitizer, t_acquisition_frameworks_1.acquisition_framework_start_date AS t_acquisition_frameworks_1_acquisition_framework_start_da_7, t_acquisition_frameworks_1.acquisition_framework_end_date AS t_acquisition_frameworks_1_acquisition_framework_end_date, t_acquisition_frameworks_1.meta_create_date AS t_acquisition_frameworks_1_meta_create_date, t_acquisition_frameworks_1.meta_update_date AS t_acquisition_frameworks_1_meta_update_date, t_acquisition_frameworks_1.initial_closing_date AS t_acquisition_frameworks_1_initial_closing_date, t_roles_3.pass AS t_roles_3_pass, t_roles_3.pass_plus AS t_roles_3_pass_plus, t_roles_3.groupe AS t_roles_3_groupe, t_roles_3.id_role AS t_roles_3_id_role, t_roles_3.identifiant AS t_roles_3_identifiant, t_roles_3.nom_role AS t_roles_3_nom_role, t_roles_3.prenom_role AS t_roles_3_prenom_role, t_roles_3.desc_role AS t_roles_3_desc_role, t_roles_3.email AS t_roles_3_email, t_roles_3.id_organisme AS t_roles_3_id_organisme, t_roles_3.remarques AS t_roles_3_remarques, t_roles_3.champs_addi AS t_roles_3_champs_addi, t_roles_3.date_insert AS t_roles_3_date_insert, t_roles_3.date_update AS t_roles_3_date_update, t_roles_3.active AS t_roles_3_active, t_roles_4.pass AS t_roles_4_pass, t_roles_4.pass_plus AS t_roles_4_pass_plus, t_roles_4.groupe AS t_roles_4_groupe, t_roles_4.id_role AS t_roles_4_id_role, t_roles_4.identifiant AS t_roles_4_identifiant, t_roles_4.nom_role AS t_roles_4_nom_role, t_roles_4.prenom_role AS t_roles_4_prenom_role, t_roles_4.desc_role AS t_roles_4_desc_role, t_roles_4.email AS t_roles_4_email, t_roles_4.id_organisme AS t_roles_4_id_organisme, t_roles_4.remarques AS t_roles_4_remarques, t_roles_4.champs_addi AS t_roles_4_champs_addi, t_roles_4.date_insert AS t_roles_4_date_insert, t_roles_4.date_update AS t_roles_4_date_update, t_roles_4.active AS t_roles_4_active, t_nomenclatures_2.id_nomenclature AS t_nomenclatures_2_id_nomenclature, t_nomenclatures_2.id_type AS t_nomenclatures_2_id_type, t_nomenclatures_2.cd_nomenclature AS t_nomenclatures_2_cd_nomenclature, t_nomenclatures_2.mnemonique AS t_nomenclatures_2_mnemonique, t_nomenclatures_2.label_default AS t_nomenclatures_2_label_default, t_nomenclatures_2.definition_default AS t_nomenclatures_2_definition_default, t_nomenclatures_2.label_fr AS t_nomenclatures_2_label_fr, t_nomenclatures_2.definition_fr AS t_nomenclatures_2_definition_fr, t_nomenclatures_2.label_en AS t_nomenclatures_2_label_en, t_nomenclatures_2.definition_en AS t_nomenclatures_2_definition_en, t_nomenclatures_2.label_es AS t_nomenclatures_2_label_es, t_nomenclatures_2.definition_es AS t_nomenclatures_2_definition_es, t_nomenclatures_2.label_de AS t_nomenclatures_2_label_de, t_nomenclatures_2.definition_de AS t_nomenclatures_2_definition_de, t_nomenclatures_2.label_it AS t_nomenclatures_2_label_it, t_nomenclatures_2.definition_it AS t_nomenclatures_2_definition_it, t_nomenclatures_2.source AS t_nomenclatures_2_source, t_nomenclatures_2.statut AS t_nomenclatures_2_statut, t_nomenclatures_2.id_broader AS t_nomenclatures_2_id_broader, t_nomenclatures_2.hierarchy AS t_nomenclatures_2_hierarchy, t_nomenclatures_2.active AS t_nomenclatures_2_active, t_nomenclatures_2.meta_create_date AS t_nomenclatures_2_meta_create_date, t_nomenclatures_2.meta_update_date AS t_nomenclatures_2_meta_update_date, t_roles_5.pass AS t_roles_5_pass, t_roles_5.pass_plus AS t_roles_5_pass_plus, t_roles_5.groupe AS t_roles_5_groupe, t_roles_5.id_role AS t_roles_5_id_role, t_roles_5.identifiant AS t_roles_5_identifiant, t_roles_5.nom_role AS t_roles_5_nom_role, t_roles_5.prenom_role AS t_roles_5_prenom_role, t_roles_5.desc_role AS t_roles_5_desc_role, t_roles_5.email AS t_roles_5_email, t_roles_5.id_organisme AS t_roles_5_id_organisme, t_roles_5.remarques AS t_roles_5_remarques, t_roles_5.champs_addi AS t_roles_5_champs_addi, t_roles_5.date_insert AS t_roles_5_date_insert, t_roles_5.date_update AS t_roles_5_date_update, t_roles_5.active AS t_roles_5_active, bib_organismes_2.id_organisme AS bib_organismes_2_id_organisme, bib_organismes_2.uuid_organisme AS bib_organismes_2_uuid_organisme, bib_organismes_2.nom_organisme AS bib_organismes_2_nom_organisme, bib_organismes_2.adresse_organisme AS bib_organismes_2_adresse_organisme, bib_organismes_2.cp_organisme AS bib_organismes_2_cp_organisme, bib_organismes_2.ville_organisme AS bib_organismes_2_ville_organisme, bib_organismes_2.tel_organisme AS bib_organismes_2_tel_organisme, bib_organismes_2.fax_organisme AS bib_organismes_2_fax_organisme, bib_organismes_2.email_organisme AS bib_organismes_2_email_organisme, bib_organismes_2.url_organisme AS bib_organismes_2_url_organisme, bib_organismes_2.url_logo AS bib_organismes_2_url_logo, bib_organismes_2.id_parent AS bib_organismes_2_id_parent, bib_organismes_2.additional_data AS bib_organismes_2_additional_data, cor_dataset_actor_1.id_cda AS cor_dataset_actor_1_id_cda, cor_dataset_actor_1.id_dataset AS cor_dataset_actor_1_id_dataset, cor_dataset_actor_1.id_role AS cor_dataset_actor_1_id_role, cor_dataset_actor_1.id_organism AS cor_dataset_actor_1_id_organism, cor_dataset_actor_1.id_nomenclature_actor_role AS cor_dataset_actor_1_id_nomenclature_actor_role, t_datasets_1.id_dataset AS t_datasets_1_id_dataset, t_datasets_1.unique_dataset_id AS t_datasets_1_unique_dataset_id, t_datasets_1.id_acquisition_framework AS t_datasets_1_id_acquisition_framework, t_datasets_1.dataset_name AS t_datasets_1_dataset_name, t_datasets_1.dataset_shortname AS t_datasets_1_dataset_shortname, t_datasets_1.dataset_desc AS t_datasets_1_dataset_desc, t_datasets_1.id_nomenclature_data_type AS t_datasets_1_id_nomenclature_data_type, t_datasets_1.keywords AS t_datasets_1_keywords, t_datasets_1.marine_domain AS t_datasets_1_marine_domain, t_datasets_1.terrestrial_domain AS t_datasets_1_terrestrial_domain, t_datasets_1.id_nomenclature_dataset_objectif AS t_datasets_1_id_nomenclature_dataset_objectif, t_datasets_1.bbox_west AS t_datasets_1_bbox_west, t_datasets_1.bbox_east AS t_datasets_1_bbox_east, t_datasets_1.bbox_south AS t_datasets_1_bbox_south, t_datasets_1.bbox_north AS t_datasets_1_bbox_north, t_datasets_1.id_nomenclature_collecting_method AS t_datasets_1_id_nomenclature_collecting_method, t_datasets_1.id_nomenclature_data_origin AS t_datasets_1_id_nomenclature_data_origin, t_datasets_1.id_nomenclature_source_status AS t_datasets_1_id_nomenclature_source_status, t_datasets_1.id_nomenclature_resource_type AS t_datasets_1_id_nomenclature_resource_type, t_datasets_1.meta_create_date AS t_datasets_1_meta_create_date, t_datasets_1.meta_update_date AS t_datasets_1_meta_update_date, t_datasets_1.active AS t_datasets_1_active, t_datasets_1.validable AS t_datasets_1_validable, t_datasets_1.id_digitizer AS t_datasets_1_id_digitizer, t_datasets_1.id_taxa_list AS t_datasets_1_id_taxa_list 
FROM gn_commons.t_modules JOIN gn_monitoring.t_module_complements ON gn_commons.t_modules.id_module = gn_monitoring.t_module_complements.id_module LEFT OUTER JOIN gn_commons.t_medias AS t_medias_1 ON t_medias_1.uuid_attached_row = gn_monitoring.t_module_complements.uuid_module_complement LEFT OUTER JOIN (gn_commons.cor_module_dataset AS cor_module_dataset_1 JOIN gn_meta.t_datasets AS t_datasets_1 ON t_datasets_1.id_dataset = cor_module_dataset_1.id_dataset) ON gn_commons.t_modules.id_module = cor_module_dataset_1.id_module LEFT OUTER JOIN gn_meta.t_acquisition_frameworks AS t_acquisition_frameworks_1 ON t_acquisition_frameworks_1.id_acquisition_framework = t_datasets_1.id_acquisition_framework LEFT OUTER JOIN utilisateurs.t_roles AS t_roles_1 ON t_roles_1.id_role = t_acquisition_frameworks_1.id_digitizer LEFT OUTER JOIN gn_meta.cor_acquisition_framework_actor AS cor_acquisition_framework_actor_1 ON t_acquisition_frameworks_1.id_acquisition_framework = cor_acquisition_framework_actor_1.id_acquisition_framework LEFT OUTER JOIN ref_nomenclatures.t_nomenclatures AS t_nomenclatures_1 ON t_nomenclatures_1.id_nomenclature = cor_acquisition_framework_actor_1.id_nomenclature_actor_role LEFT OUTER JOIN utilisateurs.t_roles AS t_roles_2 ON t_roles_2.id_role = cor_acquisition_framework_actor_1.id_role LEFT OUTER JOIN utilisateurs.bib_organismes AS bib_organismes_1 ON bib_organismes_1.id_organisme = cor_acquisition_framework_actor_1.id_organism LEFT OUTER JOIN utilisateurs.t_roles AS t_roles_3 ON t_roles_3.id_role = t_datasets_1.id_digitizer LEFT OUTER JOIN utilisateurs.t_roles AS t_roles_4 ON t_roles_4.id_role = t_datasets_1.id_digitizer LEFT OUTER JOIN gn_meta.cor_dataset_actor AS cor_dataset_actor_1 ON t_datasets_1.id_dataset = cor_dataset_actor_1.id_dataset LEFT OUTER JOIN ref_nomenclatures.t_nomenclatures AS t_nomenclatures_2 ON t_nomenclatures_2.id_nomenclature = cor_dataset_actor_1.id_nomenclature_actor_role LEFT OUTER JOIN utilisateurs.t_roles AS t_roles_5 ON t_roles_5.id_role = cor_dataset_actor_1.id_role LEFT OUTER JOIN utilisateurs.bib_organismes AS bib_organismes_2 ON bib_organismes_2.id_organisme = cor_dataset_actor_1.id_organism ORDER BY gn_commons.t_modules.module_label]
(Background on this error at: http://sqlalche.me/e/13/f405)

sur un serveur debian 10, j'ai pu monter la version du module monitoring de 0.6.0 à 0.7.1 sans soucis.

The text was updated successfully, but these errors were encountered:

jacquesfize · 2023-12-11T15:16:17Z

tu es sur quelle branche ?

gildeluermoz · 2023-12-11T15:18:22Z

je ne suis pas sur git, j'ai pris la dernière release

jacquesfize · 2023-12-11T15:21:35Z

Hum... C'est un problème que j'ai aussi de mon côté... Pour l'instant, je règle le problèmes en faisant les commandes suivantes:

geonature db upgrade monitorings+1
geonature db upgrade monitorings@head

C'est étrange, car c'est un problème qui n'apparait pas sur toute les machines...

amandine-sahl · 2023-12-11T15:36:18Z

Ce problème apparait lors d'une installation et pas des mise à jour.
Corrigé via : 5e02593

gildeluermoz · 2023-12-11T16:40:53Z

Cool merci à tous les 2 pour ces corrections et solutions rapides. C'est top. 👍

camillemonchicourt · 2023-12-15T09:28:12Z

Il faudrait faire rapidement une 0.7.2, non ?

marie-laure-cen · 2024-02-12T07:47:23Z

Pour information, j'ai également eu ce problème (installation sur Debian v12, GeoNature 2.13.4), résolu avec la solution de jacquesfize.

gildeluermoz · 2024-02-19T22:34:09Z

Sur une nouvelle installation de GN en 2.13.4, ça fonctionne en modifiant les fichiers de la 0.7.1 selon le fix de @amandine-sahl avant de lancer geonature install-gn-module ~/gn_module_monitoring MONITORINGS
Merci

Il faudrait faire rapidement une 0.7.2, non ?

ça semblerait pas mal oui ;)

O

gildeluermoz · 2024-02-19T22:53:32Z

En fait ça corrige l'installation mais lors de l'accès au module monitoring il y a une erreur :

[f9927d9f-8970-4de4-9c66-a9acbbb049c9] Exception on /monitorings/modules [GET]
Traceback (most recent call last):
  File "/home/gnadmin/geonature/backend/venv/lib/python3.11/site-packages/flask/app.py", line 1823, in full_dispatch_request
    rv = self.dispatch_request()
         ^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/gnadmin/geonature/backend/venv/lib/python3.11/site-packages/flask/app.py", line 1799, in dispatch_request
    return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/gnadmin/geonature/backend/geonature/core/gn_permissions/decorators.py", line 62, in decorated_view
    return view_func(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/gnadmin/geonature/backend/venv/lib/python3.11/site-packages/utils_flask_sqla/response.py", line 19, in _json_resp
    res = fn(*args, **kwargs)
          ^^^^^^^^^^^^^^^^^^^
  File "/home/gnadmin/gn_module_monitoring/backend/gn_module_monitoring/routes/modules.py", line 58, in get_modules_api
    modules = get_modules()
              ^^^^^^^^^^^^^
TypeError: get_modules() missing 1 required positional argument: 'session'
[2024-02-19 23:35:55 +0100] [8996] [ERROR] Exception on /monitorings/modules [GET]
Traceback (most recent call last):
  File "/home/gnadmin/geonature/backend/venv/lib/python3.11/site-packages/flask/app.py", line 1823, in full_dispatch_request
    rv = self.dispatch_request()
         ^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/gnadmin/geonature/backend/venv/lib/python3.11/site-packages/flask/app.py", line 1799, in dispatch_request
    return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/gnadmin/geonature/backend/geonature/core/gn_permissions/decorators.py", line 62, in decorated_view
    return view_func(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/gnadmin/geonature/backend/venv/lib/python3.11/site-packages/utils_flask_sqla/response.py", line 19, in _json_resp
    res = fn(*args, **kwargs)
          ^^^^^^^^^^^^^^^^^^^
  File "/home/gnadmin/gn_module_monitoring/backend/gn_module_monitoring/routes/modules.py", line 58, in get_modules_api
    modules = get_modules()
              ^^^^^^^^^^^^^
TypeError: get_modules() missing 1 required positional argument: 'session'

amandine-sahl · 2024-02-27T10:27:21Z

Soucis d'installation corrigé dans la 0.7.2.
Je n'arrive pas à reproduire le deuxième soucis que tu signales @gildeluermoz avec la branche develop actuelle (0.7.2).
A remonter dans un autre ticket si il se produit toujours ?

gildeluermoz · 2024-02-28T09:57:49Z

Super, merci pour cette release.
Je m'étais basé sur ton fix et pas sur la branche develop. Avant installation du module, j'ai modifié les 3 fichiers comme indiqué ici 5e02593
Je testerai la 0.7.2. Pour le moment, je n'ai pas de nouvelle installation à faire.

jacquesfize added the bug Something isn't working label Dec 11, 2023

jacquesfize closed this as completed Dec 11, 2023

camillemonchicourt reopened this Dec 15, 2023

camillemonchicourt mentioned this issue Feb 20, 2024

Erreur à l'installation #312

Closed

amandine-sahl closed this as completed Feb 27, 2024

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

0.7.1 - erreur lors d'une installation nouvelle #284

0.7.1 - erreur lors d'une installation nouvelle #284

gildeluermoz commented Dec 11, 2023

jacquesfize commented Dec 11, 2023

gildeluermoz commented Dec 11, 2023

jacquesfize commented Dec 11, 2023 •

edited

Loading

amandine-sahl commented Dec 11, 2023

gildeluermoz commented Dec 11, 2023

camillemonchicourt commented Dec 15, 2023

marie-laure-cen commented Feb 12, 2024 •

edited

Loading

gildeluermoz commented Feb 19, 2024

gildeluermoz commented Feb 19, 2024

amandine-sahl commented Feb 27, 2024 •

edited by camillemonchicourt

Loading

gildeluermoz commented Feb 28, 2024

0.7.1 - erreur lors d'une installation nouvelle #284

0.7.1 - erreur lors d'une installation nouvelle #284

Comments

gildeluermoz commented Dec 11, 2023

jacquesfize commented Dec 11, 2023

gildeluermoz commented Dec 11, 2023

jacquesfize commented Dec 11, 2023 • edited Loading

amandine-sahl commented Dec 11, 2023

gildeluermoz commented Dec 11, 2023

camillemonchicourt commented Dec 15, 2023

marie-laure-cen commented Feb 12, 2024 • edited Loading

gildeluermoz commented Feb 19, 2024

gildeluermoz commented Feb 19, 2024

amandine-sahl commented Feb 27, 2024 • edited by camillemonchicourt Loading

gildeluermoz commented Feb 28, 2024

jacquesfize commented Dec 11, 2023 •

edited

Loading

marie-laure-cen commented Feb 12, 2024 •

edited

Loading

amandine-sahl commented Feb 27, 2024 •

edited by camillemonchicourt

Loading