BAS21 Errorlog

Feilmelding "Innstillinger > Regnskap"

Klient feillog

2026-05-16 09:04:30,274 - ERROR - [1.99.71] Traceback (most recent call last):

2026-05-16 09:04:30,274 - ERROR - [1.99.71] 
2026-05-16 09:04:30,274 - ERROR - [1.99.71]   File "ui\mainwin.py", line 1313, in open_regnskapinnstillinger

2026-05-16 09:04:30,275 - ERROR - [1.99.71] 
2026-05-16 09:04:30,275 - ERROR - [1.99.71]   File "ui\innstillinger\regnskap\regnskap.py", line 325, in __init__

2026-05-16 09:04:30,275 - ERROR - [1.99.71] 
2026-05-16 09:04:30,275 - ERROR - [1.99.71]   File "ui\innstillinger\regnskap\regnskap.py", line 348, in _fill_params

2026-05-16 09:04:30,275 - ERROR - [1.99.71] 
2026-05-16 09:04:30,275 - ERROR - [1.99.71]   File "services\valuta.py", line 15, in hent_valutakoder

///////////////////////////////////////////////////

Backend feillogg

2026-05-16 09:04:30,272 - ERROR - [2.0.0.53] ERROR:    Exception in ASGI application
Traceback (most recent call last):
  File "sqlalchemy\engine\base.py", line 1967, in _exec_single_context
  File "sqlalchemy\engine\default.py", line 952, in do_execute
  File "pymysql\cursors.py", line 153, in execute
  File "pymysql\cursors.py", line 322, in _query
  File "pymysql\connections.py", line 575, in query
  File "pymysql\connections.py", line 826, in _read_query_result
  File "pymysql\connections.py", line 1203, in read
  File "pymysql\connections.py", line 782, in _read_packet
  File "pymysql\protocol.py", line 219, in raise_for_error
  File "pymysql\err.py", line 150, in raise_mysql_exception
pymysql.err.ProgrammingError: (1064, "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 'NULLS LAST, valuta.id' at line 2")

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

Traceback (most recent call last):
  File "uvicorn\protocols\http\httptools_impl.py", line 416, in run_asgi
  File "uvicorn\middleware\proxy_headers.py", line 60, in __call__
  File "fastapi\applications.py", line 1160, in __call__
  File "starlette\applications.py", line 107, in __call__
  File "starlette\middleware\errors.py", line 186, in __call__
  File "starlette\middleware\errors.py", line 164, in __call__
  File "starlette\middleware\exceptions.py", line 63, in __call__
  File "starlette\_exception_handler.py", line 53, in wrapped_app
  File "starlette\_exception_handler.py", line 42, in wrapped_app
  File "fastapi\middleware\asyncexitstack.py", line 18, in __call__
  File "starlette\routing.py", line 716, in __call__
  File "starlette\routing.py", line 736, in app
  File "starlette\routing.py", line 290, in handle
  File "fastapi\routing.py", line 130, in app
  File "starlette\_exception_handler.py", line 53, in wrapped_app
  File "starlette\_exception_handler.py", line 42, in wrapped_app
  File "fastapi\routing.py", line 116, in app
  File "fastapi\routing.py", line 670, in app
  File "fastapi\routing.py", line 326, in run_endpoint_function
  File "starlette\concurrency.py", line 32, in run_in_threadpool
  File "anyio\to_thread.py", line 63, in run_sync
  File "anyio\_backends\_asyncio.py", line 2502, in run_sync_in_worker_thread
  File "anyio\_backends\_asyncio.py", line 986, in run
  File "bascore\webapi\api\util.py", line 65, in get_valuta
  File "sqlalchemy\orm\session.py", line 2351, in execute
  File "sqlalchemy\orm\session.py", line 2249, in _execute_internal
  File "sqlalchemy\orm\context.py", line 306, in orm_execute_statement
  File "sqlalchemy\engine\base.py", line 1419, in execute
  File "sqlalchemy\sql\elements.py", line 527, in _execute_on_connection
  File "sqlalchemy\engine\base.py", line 1641, in _execute_clauseelement
  File "sqlalchemy\engine\base.py", line 1846, in _execute_context
  File "sqlalchemy\engine\base.py", line 1986, in _exec_single_context
  File "sqlalchemy\engine\base.py", line 2363, in _handle_dbapi_exception
  File "sqlalchemy\engine\base.py", line 1967, in _exec_single_context
  File "sqlalchemy\engine\default.py", line 952, in do_execute
  File "pymysql\cursors.py", line 153, in execute
  File "pymysql\cursors.py", line 322, in _query
  File "pymysql\connections.py", line 575, in query
  File "pymysql\connections.py", line 826, in _read_query_result
  File "pymysql\connections.py", line 1203, in read
  File "pymysql\connections.py", line 782, in _read_packet
  File "pymysql\protocol.py", line 219, in raise_for_error
  File "pymysql\err.py", line 150, in raise_mysql_exception
sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1064, "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 'NULLS LAST, valuta.id' at line 2")
[SQL: SELECT valuta.id, valuta.navn, valuta.navn_eng, valuta.prioritet 
FROM valuta ORDER BY valuta.prioritet ASC NULLS LAST, valuta.id]
(Background on this error at: https://sqlalche.me/e/20/f405)