search

KollerSystems / Koller-Server

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

mandatory lekérés ID filtere NON_UNIQ #65

Open lolfail opened 2 months ago

lolfail commented 2 months ago

GET /api/timetable/mandatory?ID=1 

node:internal/process/promises:288
            triggerUncaughtException(err, true /* fromPromise */);
            ^

Error: ER_NON_UNIQ_ERROR: Column 'ID' in where clause is ambiguous
    at Sequence._packetToError (/home/lolfail/Koller/Koller-Server/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
    at Query.ErrorPacket (/home/lolfail/Koller/Koller-Server/node_modules/mysql/lib/protocol/sequences/Query.js:79:18)
    at Protocol._parsePacket (/home/lolfail/Koller/Koller-Server/node_modules/mysql/lib/protocol/Protocol.js:291:23)
    at Parser._parsePacket (/home/lolfail/Koller/Koller-Server/node_modules/mysql/lib/protocol/Parser.js:433:10)
    at Parser.write (/home/lolfail/Koller/Koller-Server/node_modules/mysql/lib/protocol/Parser.js:43:10)
    at Protocol.write (/home/lolfail/Koller/Koller-Server/node_modules/mysql/lib/protocol/Protocol.js:38:16)
    at Socket.<anonymous> (/home/lolfail/Koller/Koller-Server/node_modules/mysql/lib/Connection.js:88:28)
    at Socket.<anonymous> (/home/lolfail/Koller/Koller-Server/node_modules/mysql/lib/Connection.js:526:10)
    at Socket.emit (node:events:517:28)
    at addChunk (node:internal/streams/readable:368:12)
    --------------------
    at Protocol._enqueue (/home/lolfail/Koller/Koller-Server/node_modules/mysql/lib/protocol/Protocol.js:144:48)
    at Connection.query (/home/lolfail/Koller/Koller-Server/node_modules/mysql/lib/Connection.js:198:25)
    at /home/lolfail/Koller/Koller-Server/node_modules/knex/lib/dialects/mysql/index.js:132:18
    at new Promise (<anonymous>)
    at Client_MySQL._query (/home/lolfail/Koller/Koller-Server/node_modules/knex/lib/dialects/mysql/index.js:126:12)
    at executeQuery (/home/lolfail/Koller/Koller-Server/node_modules/knex/lib/execution/internal/query-executioner.js:37:17)
    at Client_MySQL.query (/home/lolfail/Koller/Koller-Server/node_modules/knex/lib/client.js:154:12)
    at Runner.query (/home/lolfail/Koller/Koller-Server/node_modules/knex/lib/execution/runner.js:141:36)
    at ensureConnectionCallback (/home/lolfail/Koller/Koller-Server/node_modules/knex/lib/execution/internal/ensure-connection-callback.js:13:17)
    at Runner.ensureConnection (/home/lolfail/Koller/Koller-Server/node_modules/knex/lib/execution/runner.js:318:20) {
  code: 'ER_NON_UNIQ_ERROR',
  errno: 1052,
  sqlMessage: "Column 'ID' in where clause is ambiguous",
  sqlState: '23000',
  index: 0,
  sql: 'select `mandatory_program`.`ID`, `mandatory_program`.`ClassID`, `program_types`.`Type`, `program_types`.`Topic`, `program_types`.`RID`, `program_types`.`TUID`, `program`.`ProgramID`, `program`.`Date`, `program`.`Lesson`, `program`.`Length`, `date`.`DayTypeID` from `mandatory_program` left join `program` on `program`.`ID` = `mandatory_program`.`ID` left join `program_types` on `program_types`.`ID` = `program`.`ProgramID` left join `date` on `date`.`DateID` = `program`.`Date` left join `class` on `ClassID` = `class`.`ID` left join `teacher` on `TUID` = `teacher`.`UID` left join `user` on `TUID` = `user`.`UID` where `ClassID` = 1 and ID = 1 limit 25'
}

Node.js v18.19.0