KollerSystems / Koller-Server

Szerver a Koller-hez.
Other
3 stars 0 forks source link

Server crashes if role does not exists #10

Closed TheBlueLines closed 1 year ago

TheBlueLines commented 1 year ago

URL: http://127.0.0.1/api/users?role=slave (GET)

> koller-api@1.2.0 start
> node index.js

Server started listening on port 80!
C:\Users\David\GitHub\Koller-backend\api\node_modules\knex\lib\query\querycompiler.js:110
      throw new Error(
            ^

Error: Undefined binding(s) detected when compiling SELECT. Undefined column(s): [role] query: select * from `slave` natural join user where `role` = ? limit ?
    at QueryCompiler_MySQL.toSQL (C:\Users\David\GitHub\Koller-backend\api\node_modules\knex\lib\query\querycompiler.js:110:13)
    at Builder.toSQL (C:\Users\David\GitHub\Koller-backend\api\node_modules\knex\lib\query\querybuilder.js:83:44)
    at ensureConnectionCallback (C:\Users\David\GitHub\Koller-backend\api\node_modules\knex\lib\execution\internal\ensure-connection-callback.js:4:30)
    at Runner.ensureConnection (C:\Users\David\GitHub\Koller-backend\api\node_modules\knex\lib\execution\runner.js:300:20)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async Runner.run (C:\Users\David\GitHub\Koller-backend\api\node_modules\knex\lib\execution\runner.js:30:19)
    at async file:///C:/Users/David/GitHub/Koller-backend/api/routes/users.js:62:13

Node.js v20.4.0
lolfail commented 1 year ago

Fixálva lett a 098121173c38d4c5a9dd54d39b3fcf3b709e9832 commitban!