Bug connecthys

Plus d'informations
il y a 1 an 8 mois #26168 par FILLON
Bug connecthys a été créé par FILLON
Bonjour,

Depuis 2 jours, connecthys ne fonctionne plus, il est indiqué 500 internal server error. Voici le log du portail  : 

[2022-07-02 11:26:01,609][ERROR][app.py:1892] Exception on /accueil_famille [GET]
Traceback (most recent call last):
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 2447, in wsgi_app
    response = self.full_dispatch_request()
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1952, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1821, in handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1950, in full_dispatch_request
    rv = self.dispatch_request()
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1936, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/usr/local/lib/python2.7/dist-packages/flask_login/utils.py", line 272, in decorated_view
    return func(*args, **kwargs)
  File "/home/afr/connecthys/application/views.py", line 477, in accueil_famille
    liste_pieces_manquantes = models.Piece_manquante.query.filter_by(IDfamille=current_user.IDfamille).order_by(models.Piece_manquante.IDtype_piece).all()
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 3341, in all
    return list(self)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 3503, in __iter__
    return self._execute_and_instances(context)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 3528, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1014, in execute
    return meth(self, multiparams, params)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1133, in _execute_clauseelement
    distilled_params,
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1318, in _execute_context
    e, statement, parameters, cursor, context
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1512, in _handle_dbapi_exception
    sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1278, in _execute_context
    cursor, statement, parameters, context
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 593, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 250, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
    raise errorvalue
ProgrammingError: (_mysql_exceptions.ProgrammingError) (1146, "Table 'afr_connecthys.portail_pieces_manquantes' doesn't exist")
[SQL: SELECT portail_pieces_manquantes.`IDpiece_manquante` AS `portail_pieces_manquantes_IDpiece_manquante`, portail_pieces_manquantes.`IDfamille` AS `portail_pieces_manquantes_IDfamille`, portail_pieces_manquantes.`IDtype_piece` AS `portail_pieces_manquantes_IDtype_piece`, portail_pieces_manquantes.`IDindividu` AS `portail_pieces_manquantes_IDindividu`, portail_pieces_manquantes.nom AS portail_pieces_manquantes_nom 
FROM portail_pieces_manquantes 
WHERE portail_pieces_manquantes.`IDfamille` = %s ORDER BY portail_pieces_manquantes.`IDtype_piece`]
[parameters: (9L,)]
(Background on this error at: http://sqlalche.me/e/13/f405)
[2022-07-02 11:26:53,060][INFO][__init__.py:134] flask_sessionstore non fonctionnel
[2022-07-02 11:28:33,535][INFO][__init__.py:134] flask_sessionstore non fonctionnel
[2022-07-02 11:30:14,044][INFO][__init__.py:134] flask_sessionstore non fonctionnel
[2022-07-02 11:31:54,576][INFO][__init__.py:134] flask_sessionstore non fonctionnel
[2022-07-02 11:33:14,924][DEBUG][views.py:136] Demande update: Version Noethys=(1, 3, 0, 8)
[2022-07-02 11:33:14,925][DEBUG][updater.py:91] Recherche d'une update...
[2022-07-02 11:33:14,925][DEBUG][updater.py:92] Version de Noethys : 1.3.0.8 (Mode : wsgi)
[2022-07-02 11:33:14,926][DEBUG][updater.py:96] Version actuelle de connecthys: 0.9.6
[2022-07-02 11:33:15,104][DEBUG][updater.py:119] Pas de nouvelle version disponible.
[2022-07-02 11:33:35,057][INFO][__init__.py:134] flask_sessionstore non fonctionnel
[2022-07-02 11:35:15,541][INFO][__init__.py:134] flask_sessionstore non fonctionnel
[2022-07-02 11:36:56,040][INFO][__init__.py:134] flask_sessionstore non fonctionnel
[2022-07-02 11:37:38,734][DEBUG][views.py:297] Recuperation des demandes: last(20220630132730878460000037)
[2022-07-02 11:38:08,390][DEBUG][importation.py:124] Traitement de la table users...
[2022-07-02 11:38:08,398][DEBUG][importation.py:163] Enregistrement de la table users...
[2022-07-02 11:38:08,417][DEBUG][importation.py:167] Fin de traitement de la table users.
[2022-07-02 11:38:08,418][DEBUG][importation.py:170] Traitement des autres tables...
[2022-07-02 11:38:08,569][DEBUG][importation.py:207] Suppression des tables ok.
[2022-07-02 11:38:08,626][ERROR][app.py:1892] Exception on /syncup/153399028941144559 [GET]
Traceback (most recent call last):
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 2447, in wsgi_app
    response = self.full_dispatch_request()
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1952, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1821, in handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1950, in full_dispatch_request
    rv = self.dispatch_request()
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1936, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/home/afr/connecthys/application/views.py", line 289, in syncup
    resultat = importation.Importation(secret=secret)
  File "/home/afr/connecthys/application/importation.py", line 210, in Importation
    db.create_all()
  File "/usr/local/lib/python2.7/dist-packages/flask_sqlalchemy/__init__.py", line 1039, in create_all
    self._execute_for_all_tables(app, bind, 'create_all')
  File "/usr/local/lib/python2.7/dist-packages/flask_sqlalchemy/__init__.py", line 1031, in _execute_for_all_tables
    op(bind=self.get_engine(app, bind), **extra)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py", line 4547, in create_all
    ddl.SchemaGenerator, self, checkfirst=checkfirst, tables=tables
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2098, in _run_visitor
    conn._run_visitor(visitorcallable, element, **kwargs)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1657, in _run_visitor
    visitorcallable(self.dialect, self, **kwargs).traverse_single(element)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 144, in traverse_single
    return meth(obj, **kw)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 787, in visit_metadata
    _is_metadata_operation=True,
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 144, in traverse_single
    return meth(obj, **kw)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 832, in visit_table
    include_foreign_key_constraints,  # noqa
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1014, in execute
    return meth(self, multiparams, params)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 72, in _execute_on_connection
    return connection._execute_ddl(self, multiparams, params)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1076, in _execute_ddl
    compiled,
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1318, in _execute_context
    e, statement, parameters, cursor, context
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1512, in _handle_dbapi_exception
    sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1278, in _execute_context
    cursor, statement, parameters, context
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 593, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 250, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
    raise errorvalue
OperationalError: (_mysql_exceptions.OperationalError) (1074, "Column length too big for column 'parametres' (max = 21844); use BLOB or TEXT instead")
[SQL: 
CREATE TABLE portail_blocs (
    `IDbloc` INTEGER NOT NULL AUTO_INCREMENT, 
    `IDpage` INTEGER, 
    titre VARCHAR(300), 
    couleur VARCHAR(100), 
    categorie VARCHAR(200), 
    ordre INTEGER, 
    parametres VARCHAR(100000), 
    PRIMARY KEY (`IDbloc`)
)

]
(Background on this error at: http://sqlalche.me/e/13/e3q8)
[2022-07-02 11:38:36,537][INFO][__init__.py:134] flask_sessionstore non fonctionnel
[2022-07-02 11:40:17,042][INFO][__init__.py:134] flask_sessionstore non fonctionnel
[2022-07-02 11:41:57,536][INFO][__init__.py:134] flask_sessionstore non fonctionnel
[2022-07-02 11:43:38,049][INFO][__init__.py:134] flask_sessionstore non fonctionnel
[2022-07-02 11:45:18,551][INFO][__init__.py:134] flask_sessionstore non fonctionnel
[2022-07-02 11:46:59,047][INFO][__init__.py:134] flask_sessionstore non fonctionnel
[2022-07-02 11:48:39,534][INFO][__init__.py:134] flask_sessionstore non fonctionnel
[2022-07-02 11:50:20,048][INFO][__init__.py:134] flask_sessionstore non fonctionnel
[2022-07-02 11:52:00,540][INFO][__init__.py:134] flask_sessionstore non fonctionnel
[2022-07-02 11:53:41,038][INFO][__init__.py:134] flask_sessionstore non fonctionnel
[2022-07-02 11:55:21,543][INFO][__init__.py:134] flask_sessionstore non fonctionnel
[2022-07-02 11:57:02,050][INFO][__init__.py:134] flask_sessionstore non fonctionnel
[2022-07-02 11:57:19,032][DEBUG][views.py:297] Recuperation des demandes: last(20220630132730878460000037)
[2022-07-02 11:57:46,994][DEBUG][importation.py:124] Traitement de la table users...
[2022-07-02 11:57:47,003][DEBUG][importation.py:163] Enregistrement de la table users...
[2022-07-02 11:57:47,020][DEBUG][importation.py:167] Fin de traitement de la table users.
[2022-07-02 11:57:47,020][DEBUG][importation.py:170] Traitement des autres tables...
[2022-07-02 11:57:47,148][DEBUG][importation.py:207] Suppression des tables ok.
[2022-07-02 11:57:47,203][ERROR][app.py:1892] Exception on /syncup/7450318075987617943 [GET]
Traceback (most recent call last):
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 2447, in wsgi_app
    response = self.full_dispatch_request()
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1952, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1821, in handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1950, in full_dispatch_request
    rv = self.dispatch_request()
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1936, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/home/afr/connecthys/application/views.py", line 289, in syncup
    resultat = importation.Importation(secret=secret)
  File "/home/afr/connecthys/application/importation.py", line 210, in Importation
    db.create_all()
  File "/usr/local/lib/python2.7/dist-packages/flask_sqlalchemy/__init__.py", line 1039, in create_all
    self._execute_for_all_tables(app, bind, 'create_all')
  File "/usr/local/lib/python2.7/dist-packages/flask_sqlalchemy/__init__.py", line 1031, in _execute_for_all_tables
    op(bind=self.get_engine(app, bind), **extra)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py", line 4547, in create_all
    ddl.SchemaGenerator, self, checkfirst=checkfirst, tables=tables
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2098, in _run_visitor
    conn._run_visitor(visitorcallable, element, **kwargs)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1657, in _run_visitor
    visitorcallable(self.dialect, self, **kwargs).traverse_single(element)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 144, in traverse_single
    return meth(obj, **kw)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 787, in visit_metadata
    _is_metadata_operation=True,
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 144, in traverse_single
    return meth(obj, **kw)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 832, in visit_table
    include_foreign_key_constraints,  # noqa
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1014, in execute
    return meth(self, multiparams, params)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 72, in _execute_on_connection
    return connection._execute_ddl(self, multiparams, params)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1076, in _execute_ddl
    compiled,
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1318, in _execute_context
    e, statement, parameters, cursor, context
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1512, in _handle_dbapi_exception
    sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1278, in _execute_context
    cursor, statement, parameters, context
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 593, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 250, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
    raise errorvalue
OperationalError: (_mysql_exceptions.OperationalError) (1074, "Column length too big for column 'parametres' (max = 21844); use BLOB or TEXT instead")
[SQL: 
CREATE TABLE portail_blocs (
    `IDbloc` INTEGER NOT NULL AUTO_INCREMENT, 
    `IDpage` INTEGER, 
    titre VARCHAR(300), 
    couleur VARCHAR(100), 
    categorie VARCHAR(200), 
    ordre INTEGER, 
    parametres VARCHAR(100000), 
    PRIMARY KEY (`IDbloc`)
)

]
(Background on this error at: http://sqlalche.me/e/13/e3q8)
[2022-07-02 11:58:42,539][INFO][__init__.py:134] flask_sessionstore non fonctionnel
[2022-07-02 11:59:33,078][DEBUG][views.py:297] Recuperation des demandes: last(20220630132730878460000037)
[2022-07-02 12:00:00,037][DEBUG][importation.py:124] Traitement de la table users...
[2022-07-02 12:00:00,045][DEBUG][importation.py:163] Enregistrement de la table users...
[2022-07-02 12:00:00,061][DEBUG][importation.py:167] Fin de traitement de la table users.
[2022-07-02 12:00:00,061][DEBUG][importation.py:170] Traitement des autres tables...
[2022-07-02 12:00:00,209][DEBUG][importation.py:207] Suppression des tables ok.
[2022-07-02 12:00:00,254][ERROR][app.py:1892] Exception on /syncup/45743762839671644358 [GET]
Traceback (most recent call last):
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 2447, in wsgi_app
    response = self.full_dispatch_request()
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1952, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1821, in handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1950, in full_dispatch_request
    rv = self.dispatch_request()
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1936, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/home/afr/connecthys/application/views.py", line 289, in syncup
    resultat = importation.Importation(secret=secret)
  File "/home/afr/connecthys/application/importation.py", line 210, in Importation
    db.create_all()
  File "/usr/local/lib/python2.7/dist-packages/flask_sqlalchemy/__init__.py", line 1039, in create_all
    self._execute_for_all_tables(app, bind, 'create_all')
  File "/usr/local/lib/python2.7/dist-packages/flask_sqlalchemy/__init__.py", line 1031, in _execute_for_all_tables
    op(bind=self.get_engine(app, bind), **extra)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py", line 4547, in create_all
    ddl.SchemaGenerator, self, checkfirst=checkfirst, tables=tables
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2098, in _run_visitor
    conn._run_visitor(visitorcallable, element, **kwargs)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1657, in _run_visitor
    visitorcallable(self.dialect, self, **kwargs).traverse_single(element)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 144, in traverse_single
    return meth(obj, **kw)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 787, in visit_metadata
    _is_metadata_operation=True,
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 144, in traverse_single
    return meth(obj, **kw)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 832, in visit_table
    include_foreign_key_constraints,  # noqa
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1014, in execute
    return meth(self, multiparams, params)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 72, in _execute_on_connection
    return connection._execute_ddl(self, multiparams, params)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1076, in _execute_ddl
    compiled,
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1318, in _execute_context
    e, statement, parameters, cursor, context
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1512, in _handle_dbapi_exception
    sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1278, in _execute_context
    cursor, statement, parameters, context
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 593, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 250, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
    raise errorvalue
OperationalError: (_mysql_exceptions.OperationalError) (1074, "Column length too big for column 'parametres' (max = 21844); use BLOB or TEXT instead")
[SQL: 
CREATE TABLE portail_blocs (
    `IDbloc` INTEGER NOT NULL AUTO_INCREMENT, 
    `IDpage` INTEGER, 
    titre VARCHAR(300), 
    couleur VARCHAR(100), 
    categorie VARCHAR(200), 
    ordre INTEGER, 
    parametres VARCHAR(100000), 
    PRIMARY KEY (`IDbloc`)
)

]
(Background on this error at: http://sqlalche.me/e/13/e3q8)
[2022-07-02 12:00:23,241][INFO][__init__.py:134] flask_sessionstore non fonctionnel
[2022-07-02 12:02:03,533][INFO][__init__.py:134] flask_sessionstore non fonctionnel
[2022-07-02 12:03:05,080][DEBUG][views.py:297] Recuperation des demandes: last(0)
[2022-07-02 12:03:05,096][ERROR][app.py:1892] Exception on /accueil_famille [GET]
Traceback (most recent call last):
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 2447, in wsgi_app
    response = self.full_dispatch_request()
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1952, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1821, in handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1950, in full_dispatch_request
    rv = self.dispatch_request()
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1936, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/usr/local/lib/python2.7/dist-packages/flask_login/utils.py", line 272, in decorated_view
    return func(*args, **kwargs)
  File "/home/afr/connecthys/application/views.py", line 477, in accueil_famille
    liste_pieces_manquantes = models.Piece_manquante.query.filter_by(IDfamille=current_user.IDfamille).order_by(models.Piece_manquante.IDtype_piece).all()
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 3341, in all
    return list(self)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 3503, in __iter__
    return self._execute_and_instances(context)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 3528, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1014, in execute
    return meth(self, multiparams, params)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1133, in _execute_clauseelement
    distilled_params,
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1318, in _execute_context
    e, statement, parameters, cursor, context
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1512, in _handle_dbapi_exception
    sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1278, in _execute_context
    cursor, statement, parameters, context
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 593, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 250, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
    raise errorvalue
ProgrammingError: (_mysql_exceptions.ProgrammingError) (1146, "Table 'afr_connecthys.portail_pieces_manquantes' doesn't exist")
[SQL: SELECT portail_pieces_manquantes.`IDpiece_manquante` AS `portail_pieces_manquantes_IDpiece_manquante`, portail_pieces_manquantes.`IDfamille` AS `portail_pieces_manquantes_IDfamille`, portail_pieces_manquantes.`IDtype_piece` AS `portail_pieces_manquantes_IDtype_piece`, portail_pieces_manquantes.`IDindividu` AS `portail_pieces_manquantes_IDindividu`, portail_pieces_manquantes.nom AS portail_pieces_manquantes_nom 
FROM portail_pieces_manquantes 
WHERE portail_pieces_manquantes.`IDfamille` = %s ORDER BY portail_pieces_manquantes.`IDtype_piece`]
[parameters: (9L,)]
(Background on this error at: http://sqlalche.me/e/13/f405)
[2022-07-02 12:03:44,069][INFO][__init__.py:134] flask_sessionstore non fonctionnel
[2022-07-02 12:05:24,620][INFO][__init__.py:134] flask_sessionstore non fonctionnel
[2022-07-02 12:06:18,207][DEBUG][importation.py:124] Traitement de la table users...
[2022-07-02 12:06:18,215][DEBUG][importation.py:163] Enregistrement de la table users...
[2022-07-02 12:06:18,230][DEBUG][importation.py:167] Fin de traitement de la table users.
[2022-07-02 12:06:18,231][DEBUG][importation.py:170] Traitement des autres tables...
[2022-07-02 12:06:18,377][DEBUG][importation.py:207] Suppression des tables ok.
[2022-07-02 12:06:18,423][ERROR][app.py:1892] Exception on /syncup/38346588862112815729 [GET]
Traceback (most recent call last):
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 2447, in wsgi_app
    response = self.full_dispatch_request()
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1952, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1821, in handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1950, in full_dispatch_request
    rv = self.dispatch_request()
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1936, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/home/afr/connecthys/application/views.py", line 289, in syncup
    resultat = importation.Importation(secret=secret)
  File "/home/afr/connecthys/application/importation.py", line 210, in Importation
    db.create_all()
  File "/usr/local/lib/python2.7/dist-packages/flask_sqlalchemy/__init__.py", line 1039, in create_all
    self._execute_for_all_tables(app, bind, 'create_all')
  File "/usr/local/lib/python2.7/dist-packages/flask_sqlalchemy/__init__.py", line 1031, in _execute_for_all_tables
    op(bind=self.get_engine(app, bind), **extra)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py", line 4547, in create_all
    ddl.SchemaGenerator, self, checkfirst=checkfirst, tables=tables
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2098, in _run_visitor
    conn._run_visitor(visitorcallable, element, **kwargs)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1657, in _run_visitor
    visitorcallable(self.dialect, self, **kwargs).traverse_single(element)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 144, in traverse_single
    return meth(obj, **kw)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 787, in visit_metadata
    _is_metadata_operation=True,
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 144, in traverse_single
    return meth(obj, **kw)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 832, in visit_table
    include_foreign_key_constraints,  # noqa
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1014, in execute
    return meth(self, multiparams, params)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 72, in _execute_on_connection
    return connection._execute_ddl(self, multiparams, params)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1076, in _execute_ddl
    compiled,
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1318, in _execute_context
    e, statement, parameters, cursor, context
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1512, in _handle_dbapi_exception
    sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1278, in _execute_context
    cursor, statement, parameters, context
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 593, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 250, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
    raise errorvalue
OperationalError: (_mysql_exceptions.OperationalError) (1074, "Column length too big for column 'parametres' (max = 21844); use BLOB or TEXT instead")
[SQL: 
CREATE TABLE portail_blocs (
    `IDbloc` INTEGER NOT NULL AUTO_INCREMENT, 
    `IDpage` INTEGER, 
    titre VARCHAR(300), 
    couleur VARCHAR(100), 
    categorie VARCHAR(200), 
    ordre INTEGER, 
    parametres VARCHAR(100000), 
    PRIMARY KEY (`IDbloc`)
)

]
(Background on this error at: http://sqlalche.me/e/13/e3q8)
[2022-07-02 12:07:05,066][INFO][__init__.py:134] flask_sessionstore non fonctionnel
[2022-07-02 12:08:45,538][INFO][__init__.py:134] flask_sessionstore non fonctionnel
[2022-07-02 12:10:26,082][INFO][__init__.py:134] flask_sessionstore non fonctionnel
[2022-07-02 12:12:06,564][INFO][__init__.py:134] flask_sessionstore non fonctionnel
[2022-07-02 12:13:47,042][INFO][__init__.py:134] flask_sessionstore non fonctionnel
[2022-07-02 12:15:27,539][INFO][__init__.py:134] flask_sessionstore non fonctionnel
[2022-07-02 12:17:08,034][INFO][__init__.py:134] flask_sessionstore non fonctionnel
[2022-07-02 12:17:39,588][ERROR][app.py:1892] Exception on /accueil_famille [GET]
Traceback (most recent call last):
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 2447, in wsgi_app
    response = self.full_dispatch_request()
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1952, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1821, in handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1950, in full_dispatch_request
    rv = self.dispatch_request()
  File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1936, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/usr/local/lib/python2.7/dist-packages/flask_login/utils.py", line 272, in decorated_view
    return func(*args, **kwargs)
  File "/home/afr/connecthys/application/views.py", line 477, in accueil_famille
    liste_pieces_manquantes = models.Piece_manquante.query.filter_by(IDfamille=current_user.IDfamille).order_by(models.Piece_manquante.IDtype_piece).all()
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 3341, in all
    return list(self)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 3503, in __iter__
    return self._execute_and_instances(context)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 3528, in _execute_and_instances
    result = conn.execute(querycontext.statement, self._params)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1014, in execute
    return meth(self, multiparams, params)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1133, in _execute_clauseelement
    distilled_params,
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1318, in _execute_context
    e, statement, parameters, cursor, context
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1512, in _handle_dbapi_exception
    sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1278, in _execute_context
    cursor, statement, parameters, context
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 593, in do_execute
    cursor.execute(statement, parameters)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 250, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
    raise errorvalue
ProgrammingError: (_mysql_exceptions.ProgrammingError) (1146, "Table 'afr_connecthys.portail_pieces_manquantes' doesn't exist")
[SQL: SELECT portail_pieces_manquantes.`IDpiece_manquante` AS `portail_pieces_manquantes_IDpiece_manquante`, portail_pieces_manquantes.`IDfamille` AS `portail_pieces_manquantes_IDfamille`, portail_pieces_manquantes.`IDtype_piece` AS `portail_pieces_manquantes_IDtype_piece`, portail_pieces_manquantes.`IDindividu` AS `portail_pieces_manquantes_IDindividu`, portail_pieces_manquantes.nom AS portail_pieces_manquantes_nom 
FROM portail_pieces_manquantes 
WHERE portail_pieces_manquantes.`IDfamille` = %s ORDER BY portail_pieces_manquantes.`IDtype_piece`]
[parameters: (9L,)]
(Background on this error at: http://sqlalche.me/e/13/f405)
[2022-07-02 12:18:48,544][INFO][__init__.py:134] flask_sessionstore non fonctionnel


Merci pour votre aide,

Connexion ou Créer un compte pour participer à la conversation.

Temps de génération de la page : 0.199 secondes
Propulsé par Kunena