Introduction

Noethys, ce n'est pas qu'un simple outil informatique, c'est également une communauté très active qui donne bénévolement de son temps et de son énergie pour vous accompagner au quotidien dans l'appréhension du logiciel.

Si vous recevez en général une réponse à votre question dans la journée, c'est grâce au formidable travail des autres utilisateurs de Noethys ! Pour remercier ces contributeurs et témoigner de votre reconnaissance, vous pouvez simplement cliquer sur le bouton 'Remerciements' de la discussion.

Et peut-être souhaiterez-vous également partager à votre tour vos connaissances auprès des nouveaux utilisateurs ? Car ceux qui donnent vie à Noethys, c'est vous...

Bug connecthys

FILLON
Auteur du sujet
Hors Ligne
Nouveau membre

Plus d'informations

il y a 4 ans 2 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,

[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.164 secondes

Propulsé par Kunena