Erreur de Syntaxe SQL (bloquant au démarrage d'enDI) : CompanyService.label_datas_query
Environnement logiciel
MariaDB 10.5.16 enDI : commit 2e0408f1
File "/home/gas/.virtualenvs/endi/bin/endi-migrate", line 33, in <module>
sys.exit(load_entry_point('endi', 'console_scripts', 'endi-migrate')())
File "/home/gas/endi/endi/endi/scripts/endi_migrate.py", line 408, in migrate_entry_point
return command(callback, migrate_entry_point.__doc__)
File "/home/gas/endi/endi/endi/scripts/utils.py", line 19, in command
pyramid_env = bootstrap(args["<config_uri>"])
File "/home/gas/.virtualenvs/endi/lib/python3.9/site-packages/pyramid-2.0-py3.9.egg/pyramid/paster.py", line 117, in bootstrap
app = get_app(config_uri, options=options)
File "/home/gas/.virtualenvs/endi/lib/python3.9/site-packages/pyramid-2.0-py3.9.egg/pyramid/paster.py", line 30, in get_app
return loader.get_wsgi_app(name, options)
File "/home/gas/.virtualenvs/endi/lib/python3.9/site-packages/plaster_pastedeploy-0.7-py3.9.egg/plaster_pastedeploy/__init__.py", line 125, in get_wsgi_app
return loadapp(
File "/home/gas/.virtualenvs/endi/lib/python3.9/site-packages/PasteDeploy-2.1.1-py3.9.egg/paste/deploy/loadwsgi.py", line 253, in loadapp
return loadobj(APP, uri, name=name, **kw)
File "/home/gas/.virtualenvs/endi/lib/python3.9/site-packages/PasteDeploy-2.1.1-py3.9.egg/paste/deploy/loadwsgi.py", line 278, in loadobj
return context.create()
File "/home/gas/.virtualenvs/endi/lib/python3.9/site-packages/PasteDeploy-2.1.1-py3.9.egg/paste/deploy/loadwsgi.py", line 715, in create
return self.object_type.invoke(self)
File "/home/gas/.virtualenvs/endi/lib/python3.9/site-packages/PasteDeploy-2.1.1-py3.9.egg/paste/deploy/loadwsgi.py", line 209, in invoke
app = context.app_context.create()
File "/home/gas/.virtualenvs/endi/lib/python3.9/site-packages/PasteDeploy-2.1.1-py3.9.egg/paste/deploy/loadwsgi.py", line 715, in create
return self.object_type.invoke(self)
File "/home/gas/.virtualenvs/endi/lib/python3.9/site-packages/PasteDeploy-2.1.1-py3.9.egg/paste/deploy/loadwsgi.py", line 152, in invoke
return fix_call(context.object, context.global_conf, **context.local_conf)
File "/home/gas/.virtualenvs/endi/lib/python3.9/site-packages/PasteDeploy-2.1.1-py3.9.egg/paste/deploy/util.py", line 55, in fix_call
val = callable(*args, **kw)
File "/home/gas/endi/endi/endi/__init__.py", line 590, in main
config = base_configure(config, dbsession, **settings)
File "/home/gas/endi/endi/endi/__init__.py", line 550, in base_configure
prepare_view_config(config, dbsession, from_tests, **settings)
File "/home/gas/endi/endi/endi/__init__.py", line 542, in prepare_view_config
config.include(config_panels)
File "/home/gas/.virtualenvs/endi/lib/python3.9/site-packages/pyramid-2.0-py3.9.egg/pyramid/config/__init__.py", line 666, in include
c(configurator)
File "/home/gas/endi/endi/endi/__init__.py", line 401, in config_panels
config.include(module)
File "/home/gas/.virtualenvs/endi/lib/python3.9/site-packages/pyramid-2.0-py3.9.egg/pyramid/config/__init__.py", line 632, in include
c = self.maybe_dotted(callable)
File "/home/gas/.virtualenvs/endi/lib/python3.9/site-packages/pyramid-2.0-py3.9.egg/pyramid/config/__init__.py", line 740, in maybe_dotted
return self.name_resolver.maybe_resolve(dotted)
File "/home/gas/.virtualenvs/endi/lib/python3.9/site-packages/pyramid-2.0-py3.9.egg/pyramid/path.py", line 327, in maybe_resolve
return self._resolve(dotted, package)
File "/home/gas/.virtualenvs/endi/lib/python3.9/site-packages/pyramid-2.0-py3.9.egg/pyramid/path.py", line 334, in _resolve
return self._zope_dottedname_style(dotted, package)
File "/home/gas/.virtualenvs/endi/lib/python3.9/site-packages/pyramid-2.0-py3.9.egg/pyramid/path.py", line 389, in _zope_dottedname_style
__import__(used)
File "/home/gas/endi/endi/endi/panels/menu.py", line 17, in <module>
from endi.views.export.routes import BPF_EXPORT_ODS_URL
File "/home/gas/endi/endi/endi/views/export/__init__.py", line 8, in <module>
from endi.views.export.utils import HELPMSG_CONFIG
File "/home/gas/endi/endi/endi/views/export/utils.py", line 5, in <module>
from endi.forms.export import (
File "/home/gas/endi/endi/endi/forms/export.py", line 232, in <module>
class SupplierInvoiceSchema(colander.MappingSchema):
File "/home/gas/endi/endi/endi/forms/export.py", line 238, in SupplierInvoiceSchema
company_id = company_filter_node_factory()
File "/home/gas/endi/endi/endi/forms/__init__.py", line 1025, in filter_node
return base_node_factory(
File "/home/gas/endi/endi/endi/forms/company.py", line 384, in company_node
widget=get_deferred_company_choices(widget_options),
File "/home/gas/endi/endi/endi/forms/company.py", line 349, in get_deferred_company_choices
query = widget_options.get("query", Company.get_companies_select_datas(active_only))
File "/home/gas/endi/endi/endi/models/company.py", line 1105, in get_companies_select_datas
return cls._endi_service.get_companies_select_datas(cls, active_only)
File "/home/gas/endi/endi/endi/models/services/company.py", line 405, in get_companies_select_datas
for company_datas in query.all():
File "/home/gas/.virtualenvs/endi/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 2759, in all
return self._iter().all()
File "/home/gas/.virtualenvs/endi/lib64/python3.9/site-packages/sqlalchemy/orm/query.py", line 2894, in _iter
result = self.session.execute(
File "/home/gas/.virtualenvs/endi/lib64/python3.9/site-packages/sqlalchemy/orm/session.py", line 1692, in execute
result = conn._execute_20(statement, params or {}, execution_options)
File "/home/gas/.virtualenvs/endi/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1620, in _execute_20
return meth(self, args_10style, kwargs_10style, execution_options)
File "/home/gas/.virtualenvs/endi/lib64/python3.9/site-packages/sqlalchemy/sql/elements.py", line 325, in _execute_on_connection
return connection._execute_clauseelement(
File "/home/gas/.virtualenvs/endi/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1487, in _execute_clauseelement
ret = self._execute_context(
File "/home/gas/.virtualenvs/endi/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1851, in _execute_context
self._handle_dbapi_exception(
File "/home/gas/.virtualenvs/endi/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 2032, in _handle_dbapi_exception
util.raise_(
File "/home/gas/.virtualenvs/endi/lib64/python3.9/site-packages/sqlalchemy/util/compat.py", line 207, in raise_
raise exception
File "/home/gas/.virtualenvs/endi/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1808, in _execute_context
self.dialect.do_execute(
File "/home/gas/.virtualenvs/endi/lib64/python3.9/site-packages/sqlalchemy/engine/default.py", line 732, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (mariadb.ProgrammingError) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '?) AS employees_list
FROM node INNER JOIN company ON node.id = company.id LE...' at line 1
[SQL: SELECT company.id AS company_id, node.name AS node_name, company.code_compta AS company_code_compta, company.active AS company_active, count(accounts.id) AS nb_employees, group_concat(concat(accounts.lastname, ?, accounts.firstname) separator ?) AS employees_list
FROM node INNER JOIN company ON node.id = company.id LEFT OUTER JOIN company_employee ON company.id = company_employee.company_id LEFT OUTER JOIN accounts ON accounts.id = company_employee.account_id LEFT OUTER JOIN login ON accounts.id = login.user_id AND login.active = ? GROUP BY company.id ORDER BY node.name]
[parameters: (' ', ', ', 1)]```