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

    Plus d'informations
    il y a 4 ans 1 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.196 secondes

    Paramétrages de cookies

    ×

    Cookies fonctionnels

    Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

    Mesure d"'"audience

    Ce site utilise des cookies de mesure et d’analyse d’audience, tels que Google Analytics et Google Ads, afin d’évaluer et d’améliorer notre site internet.

    Réseaux sociaux/Vidéos

    Des plug-ins de réseaux sociaux et de vidéos, qui exploitent des cookies, sont présents sur ce site web. Ils permettent d’améliorer la convivialité et la promotion du site grâce à différentes interactions sociales.

    Session

    Veuillez vous connecter pour voir vos activités "!"

    Autres cookies

    Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.

    Connexion

    Qui est en ligne ?

    Il y a 2579 invités et 2 membres en ligne

    • ESSEAU
    • The-batch

    Informations

    Dernières actualités

    • Version 1.3.3.9 (06/09/2024)

      Ajout de l'export des locations vers Noethysweb Correction de la vignette des pièces de type PDF Ajout de l'option Masquer les archivés dans les options de la fiche famille Ajout du tableau des...

      Lire la suite...

    Recherche