Problème d'installation sur ubuntu server 20.04

sqlalchemy.exc.OperationalError: (MySQLdb._exceptions.OperationalError) (1074, "Column length too big for column 'ventilation' (max = 16383); use BLOB or TEXT instead")

Lancement de Connecthys...
serveur=None host=0.0.0.0 port=5000
/home/ubuntu/.local/lib/python3.8/site-packages/flask_sqlalchemy/__init__.py:550: SAWarning: relationship 'Action.renseignements' will copy column portail_actions.IDaction to column portail_renseignements.IDaction, which conflicts with relationship(s): 'Renseignement.action' (copies portail_actions.IDaction to portail_renseignements.IDaction). If this is not the intention, consider if these relationships should be linked with back_populates, or if viewonly=True should be applied to one or more if they are read-only. For the less common case that foreign key constraints are partially overlapping, the orm.foreign() annotation can be used to isolate the columns that should be written towards.   To silence this warning, add the parameter 'overlaps="action"' to the 'Action.renseignements' relationship. (Background on this error at: https://sqlalche.me/e/14/qzyx)
  mapper = orm.class_mapper(type)
/home/ubuntu/.local/lib/python3.8/site-packages/flask_sqlalchemy/__init__.py:550: SAWarning: relationship 'Reservation_location.action' will copy column portail_actions.IDaction to column portail_reservations_locations.IDaction, which conflicts with relationship(s): 'Action.reservations_locations' (copies portail_actions.IDaction to portail_reservations_locations.IDaction). If this is not the intention, consider if these relationships should be linked with back_populates, or if viewonly=True should be applied to one or more if they are read-only. For the less common case that foreign key constraints are partially overlapping, the orm.foreign() annotation can be used to isolate the columns that should be written towards.   To silence this warning, add the parameter 'overlaps="reservations_locations"' to the 'Reservation_location.action' relationship. (Background on this error at: https://sqlalche.me/e/14/qzyx)
  mapper = orm.class_mapper(type)
/home/ubuntu/.local/lib/python3.8/site-packages/flask_sqlalchemy/__init__.py:550: SAWarning: relationship 'Periode.activite' will copy column portail_activites.IDactivite to column portail_periodes.IDactivite, which conflicts with relationship(s): 'Activite.periodes' (copies portail_activites.IDactivite to portail_periodes.IDactivite). If this is not the intention, consider if these relationships should be linked with back_populates, or if viewonly=True should be applied to one or more if they are read-only. For the less common case that foreign key constraints are partially overlapping, the orm.foreign() annotation can be used to isolate the columns that should be written towards.   To silence this warning, add the parameter 'overlaps="periodes"' to the 'Periode.activite' relationship. (Background on this error at: https://sqlalche.me/e/14/qzyx)
  mapper = orm.class_mapper(type)
/home/ubuntu/.local/lib/python3.8/site-packages/flask_sqlalchemy/__init__.py:550: SAWarning: relationship 'Reservation.action' will copy column portail_actions.IDaction to column portail_reservations.IDaction, which conflicts with relationship(s): 'Action.reservations' (copies portail_actions.IDaction to portail_reservations.IDaction). If this is not the intention, consider if these relationships should be linked with back_populates, or if viewonly=True should be applied to one or more if they are read-only. For the less common case that foreign key constraints are partially overlapping, the orm.foreign() annotation can be used to isolate the columns that should be written towards.   To silence this warning, add the parameter 'overlaps="reservations"' to the 'Reservation.action' relationship. (Background on this error at: https://sqlalche.me/e/14/qzyx)
  mapper = orm.class_mapper(type)
[2022-04-04 09:55:31,718] INFO in models: Creation de la base de donnees MySQL si besoin...
[2022-04-04 09:55:31,726] INFO in models: Creation des tables des donnees...
Traceback (most recent call last):
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1808, in _execute_context
    self.dialect.do_execute(
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 209, in execute
    res = self._query(query)
  File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 315, in _query
    db.query(q)
  File "/usr/lib/python3/dist-packages/MySQLdb/connections.py", line 226, in query
    _mysql.connection.query(self, query)
MySQLdb._exceptions.OperationalError: (1074, "Column length too big for column 'ventilation' (max = 16383); use BLOB or TEXT instead")

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

Traceback (most recent call last):
  File "run.py", line 92, in <module>
    from application import app
  File "/home/ubuntu/connecthys/application/__init__.py", line 168, in <module>
    models.CreationDB()
  File "/home/ubuntu/connecthys/application/models.py", line 77, in CreationDB
    db.create_all()
  File "/home/ubuntu/.local/lib/python3.8/site-packages/flask_sqlalchemy/__init__.py", line 1094, in create_all
    self._execute_for_all_tables(app, bind, 'create_all')
  File "/home/ubuntu/.local/lib/python3.8/site-packages/flask_sqlalchemy/__init__.py", line 1086, in _execute_for_all_tables
    op(bind=self.get_engine(app, bind), **extra)
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/sql/schema.py", line 4864, in create_all
    bind._run_ddl_visitor(
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 3123, in _run_ddl_visitor
    conn._run_ddl_visitor(visitorcallable, element, **kwargs)
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2119, in _run_ddl_visitor
    visitorcallable(self.dialect, self, **kwargs).traverse_single(element)
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/sql/visitors.py", line 524, in traverse_single
    return meth(obj, **kw)
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/sql/ddl.py", line 849, in visit_metadata
    self.traverse_single(
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/sql/visitors.py", line 524, in traverse_single
    return meth(obj, **kw)
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/sql/ddl.py", line 893, in visit_table
    self.connection.execute(
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1295, in execute
    return meth(self, multiparams, params, _EMPTY_EXECUTION_OPTS)
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/sql/ddl.py", line 80, in _execute_on_connection
    return connection._execute_ddl(
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1387, in _execute_ddl
    ret = self._execute_context(
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1851, in _execute_context
    self._handle_dbapi_exception(
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 2032, in _handle_dbapi_exception
    util.raise_(
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
    raise exception
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1808, in _execute_context
    self.dialect.do_execute(
  File "/home/ubuntu/.local/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 209, in execute
    res = self._query(query)
  File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 315, in _query
    db.query(q)
  File "/usr/lib/python3/dist-packages/MySQLdb/connections.py", line 226, in query
    _mysql.connection.query(self, query)
sqlalchemy.exc.OperationalError: (MySQLdb._exceptions.OperationalError) (1074, "Column length too big for column 'ventilation' (max = 16383); use BLOB or TEXT instead")
[SQL:
CREATE TABLE portail_paiements (
        `IDpaiement` INTEGER NOT NULL AUTO_INCREMENT,
        `factures_ID` VARCHAR(50),
        `IDfamille` INTEGER,
        `IDtransaction` VARCHAR(50),
        refdet VARCHAR(50),
        montant FLOAT,
        objet VARCHAR(50),
        saisie VARCHAR(5),
        resultrans VARCHAR(5),
        numauto VARCHAR(10),
        dattrans VARCHAR(15),
        heurtrans VARCHAR(15),
        systeme_paiement VARCHAR(50),
        resultat VARCHAR(50),
        message VARCHAR(450),
        ventilation VARCHAR(100000),
        horodatage DATETIME,
        PRIMARY KEY (`IDpaiement`)
)

]
(Background on this error at: https://sqlalche.me/e/14/e3q8)

Lancement de Connecthys...
serveur=None host=0.0.0.0 port=5000
Traceback (most recent call last):
  File "run.py", line 92, in <module>
    from application import app
  File "/home/connecthys/connecthys/application/__init__.py", line 106, in <module>
    if db.engine.url.drivername == 'sqlite':
  File "/home/connecthys/.local/lib/python3.8/site-packages/flask_sqlalchemy/extension.py", line 658, in engine
    return self.engines[None]
  File "/home/connecthys/.local/lib/python3.8/site-packages/flask_sqlalchemy/extension.py", line 636, in engines
    app = current_app._get_current_object()  # type: ignore[attr-defined]
  File "/home/connecthys/.local/lib/python3.8/site-packages/werkzeug/local.py", line 513, in _get_current_object
    raise RuntimeError(unbound_message) from None
RuntimeError: Working outside of application context.

This typically means that you attempted to use functionality that needed
the current application. To solve this, set up an application context
with app.app_context(). See the documentation for more information.

Lancement de Connecthys...
serveur=None host=0.0.0.0 port=5000
Traceback (most recent call last):
  File "run.py", line 92, in <module>
    from application import app
  File "/home/connecthys/connecthys/application/__init__.py", line 102, in <module>
    db = SQLAlchemy(app)
  File "/home/connecthys/.local/lib/python3.8/site-packages/flask_sqlalchemy/__init__.py", line 676, in __init__
    self.session = self.create_scoped_session(session_options)
  File "/home/connecthys/.local/lib/python3.8/site-packages/flask_sqlalchemy/__init__.py", line 708, in create_scoped_session
    scopefunc = options.pop('scopefunc', _app_ctx_stack.__ident_func__)
AttributeError: '_FakeStack' object has no attribute '__ident_func__'

Lancement de Connecthys...
serveur=None host=0.0.0.0 port=5000
Traceback (most recent call last):
  File "run.py", line 92, in <module>
    from application import app
  File "/home/connecthys/connecthys/application/__init__.py", line 102, in <module>
    db = SQLAlchemy(app)
  File "/home/connecthys/.local/lib/python3.8/site-packages/flask_sqlalchemy/__init__.py", line 758, in __init__
    _include_sqlalchemy(self, query_class)
  File "/home/connecthys/.local/lib/python3.8/site-packages/flask_sqlalchemy/__init__.py", line 112, in _include_sqlalchemy
    for key in module.__all__:
AttributeError: module 'sqlalchemy' has no attribute '__all__'

Lancement de Connecthys...
serveur=None host=0.0.0.0 port=5000
Traceback (most recent call last):
  File "run.py", line 92, in <module>
    from application import app
  File "/home/connecthys/connecthys/application/__init__.py", line 106, in <module>
    if db.engine.url.drivername == 'sqlite':
  File "/home/connecthys/.local/lib/python3.8/site-packages/flask_sqlalchemy/extension.py", line 642, in engine
    return self.engines[None]
  File "/home/connecthys/.local/lib/python3.8/site-packages/flask_sqlalchemy/extension.py", line 628, in engines
    app = current_app._get_current_object()  # type: ignore[attr-defined]
  File "/home/connecthys/.local/lib/python3.8/site-packages/werkzeug/local.py", line 513, in _get_current_object
    raise RuntimeError(unbound_message) from None
RuntimeError: Working outside of application context.

This typically means that you attempted to use functionality that needed
the current application. To solve this, set up an application context
with app.app_context(). See the documentation for more information.

Lancement de Connecthys...
serveur=None host=0.0.0.0 port=5000
Traceback (most recent call last):
  File "run.py", line 92, in <module>
    from application import app
  File "/home/connecthys/connecthys/application/__init__.py", line 106, in <module>
    if db.engine.url.drivername == 'sqlite':
  File "/home/connecthys/.local/lib/python3.8/site-packages/flask_sqlalchemy/extension.py", line 642, in engine
    return self.engines[None]
  File "/home/connecthys/.local/lib/python3.8/site-packages/flask_sqlalchemy/extension.py", line 628, in engines
    app = current_app._get_current_object()  # type: ignore[attr-defined]
  File "/home/connecthys/.local/lib/python3.8/site-packages/werkzeug/local.py", line 513, in _get_current_object
    raise RuntimeError(unbound_message) from None
RuntimeError: Working outside of application context.

This typically means that you attempted to use functionality that needed
the current application. To solve this, set up an application context
with app.app_context(). See the documentation for more information.

Lancement de Connecthys...
serveur=None host=0.0.0.0 port=5000
Traceback (most recent call last):
  File "run.py", line 92, in <module>
    from application import app
  File "/home/connecthys/connecthys/application/__init__.py", line 102, in <module>
    db = SQLAlchemy(app)
  File "/home/connecthys/.local/lib/python3.8/site-packages/flask_sqlalchemy/__init__.py", line 758, in __init__
    _include_sqlalchemy(self, query_class)
  File "/home/connecthys/.local/lib/python3.8/site-packages/flask_sqlalchemy/__init__.py", line 112, in _include_sqlalchemy
    for key in module.__all__:
AttributeError: module 'sqlalchemy' has no attribute '__all__'

Lancement de Connecthys...
serveur=None host=0.0.0.0 port=5000
Traceback (most recent call last):
  File "run.py", line 92, in <module>
    from application import app
  File "/home/connecthys/connecthys/application/__init__.py", line 14, in <module>
    from flask import Flask
  File "/home/connecthys/.local/lib/python3.8/site-packages/flask/__init__.py", line 14, in <module>
    from jinja2 import escape
  File "/home/connecthys/.local/lib/python3.8/site-packages/jinja2/__init__.py", line 12, in <module>
    from .environment import Environment
  File "/home/connecthys/.local/lib/python3.8/site-packages/jinja2/environment.py", line 25, in <module>
    from .defaults import BLOCK_END_STRING
  File "/home/connecthys/.local/lib/python3.8/site-packages/jinja2/defaults.py", line 3, in <module>
    from .filters import FILTERS as DEFAULT_FILTERS  # noqa: F401
  File "/home/connecthys/.local/lib/python3.8/site-packages/jinja2/filters.py", line 13, in <module>
    from markupsafe import soft_unicode
ImportError: cannot import name 'soft_unicode' from 'markupsafe' (/home/connecthys/.local/lib/python3.8/site-packages/markupsafe/__init__.py)