Corrigir botão de exportação "SPLinker"

[edvaldoszy]

No painel, va no menu "Exportação" e clique em "SPLinker", a API está retornando código 500

 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*)) AS `count` FROM `tombos` AS `tombos`' at line 1
2026-02-04T22:22:38.646685704Z at Query.formatError (/home/hcf_api/app/node_modules/sequelize/lib/dialects/mysql/query.js:247:16)
2026-02-04T22:22:38.646691896Z at Query.handler [as onResult] (/home/hcf_api/app/node_modules/sequelize/lib/dialects/mysql/query.js:68:23)
2026-02-04T22:22:38.646707192Z at Query.execute (/home/hcf_api/app/node_modules/mysql2/lib/commands/command.js:36:14)
2026-02-04T22:22:38.646712439Z at Connection.handlePacket (/home/hcf_api/app/node_modules/mysql2/lib/base/connection.js:477:34)
2026-02-04T22:22:38.646717081Z at PacketParser.onPacket (/home/hcf_api/app/node_modules/mysql2/lib/base/connection.js:93:12)
2026-02-04T22:22:38.646721343Z at PacketParser.executeStart (/home/hcf_api/app/node_modules/mysql2/lib/packet_parser.js:75:16)
2026-02-04T22:22:38.646725946Z at Socket.<anonymous> (/home/hcf_api/app/node_modules/mysql2/lib/base/connection.js:100:25)
2026-02-04T22:22:38.646731082Z at Socket.emit (node:events:518:28)
2026-02-04T22:22:38.646735472Z at addChunk (node:internal/streams/readable:561:12)
2026-02-04T22:22:38.646739882Z at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
2026-02-04T22:22:38.646744746Z at Readable.push (node:internal/streams/readable:392:5)
2026-02-04T22:22:38.646749198Z at TCP.onStreamRead (node:internal/stream_base_commons:189:23)
2026-02-04T22:22:38.646753504Z From previous event:
2026-02-04T22:22:38.646757734Z at Query.run (/home/hcf_api/app/node_modules/sequelize/lib/dialects/mysql/query.js:57:12)
2026-02-04T22:22:38.646762240Z at /home/hcf_api/app/node_modules/sequelize/lib/sequelize.js:561:20
2026-02-04T22:22:38.646766616Z From previous event:
2026-02-04T22:22:38.646786345Z at /home/hcf_api/app/node_modules/sequelize/lib/sequelize.js:558:8
2026-02-04T22:22:38.646790436Z at /home/hcf_api/app/node_modules/retry-as-promised/index.js:39:21
2026-02-04T22:22:38.646794466Z at retryAsPromised (/home/hcf_api/app/node_modules/retry-as-promised/index.js:29:10)
2026-02-04T22:22:38.646798591Z at Sequelize.query (/home/hcf_api/app/node_modules/sequelize/lib/sequelize.js:457:28)
2026-02-04T22:22:38.646802884Z at QueryInterface.rawSelect (/home/hcf_api/app/node_modules/sequelize/lib/query-interface.js:1153:27)
2026-02-04T22:22:38.646807069Z at tombos.aggregate (/home/hcf_api/app/node_modules/sequelize/lib/model.js:1810:32)
2026-02-04T22:22:38.646811184Z at /home/hcf_api/app/node_modules/sequelize/lib/model.js:1855:19
2026-02-04T22:22:38.646816219Z at process.processImmediate (node:internal/timers:491:21)
2026-02-04T22:22:38.646820545Z From previous event:
2026-02-04T22:22:38.646824824Z at tombos.count (/home/hcf_api/app/node_modules/sequelize/lib/model.js:1839:8)
2026-02-04T22:22:38.646828938Z at obterModeloSPLinker (/home/hcf_api/app/dist/controllers/splinker-controller.js:142:40)
2026-02-04T22:22:38.646833140Z at Layer.handleRequest (/home/hcf_api/app/node_modules/router/lib/layer.js:152:17)
2026-02-04T22:22:38.646837266Z at next (/home/hcf_api/app/node_modules/router/lib/route.js:157:13)
2026-02-04T22:22:38.646841331Z at /home/hcf_api/app/dist/middlewares/tokens-middleware.js:29:5
2026-02-04T22:22:38.646845380Z at Layer.handleRequest (/home/hcf_api/app/node_modules/router/lib/layer.js:152:17)
2026-02-04T22:22:38.646852961Z at next (/home/hcf_api/app/node_modules/router/lib/route.js:157:13)
2026-02-04T22:22:38.646899224Z at Route.dispatch (/home/hcf_api/app/node_modules/router/lib/route.js:117:3)
2026-02-04T22:22:38.646904921Z at handle (/home/hcf_api/app/node_modules/router/index.js:435:11)
2026-02-04T22:22:38.646909086Z at Layer.handleRequest (/home/hcf_api/app/node_modules/router/lib/layer.js:152:17)
2026-02-04T22:22:38.646919797Z at /home/hcf_api/app/node_modules/router/index.js:295:15
2026-02-04T22:22:38.646923844Z at processParams (/home/hcf_api/app/node_modules/router/index.js:582:12)
2026-02-04T22:22:38.646928074Z at next (/home/hcf_api/app/node_modules/router/index.js:291:5)
2026-02-04T22:22:38.646932231Z at Function.handle (/home/hcf_api/app/node_modules/router/index.js:186:3)
2026-02-04T22:22:38.646936461Z at Function.handle (/home/hcf_api/app/node_modules/express/lib/application.js:177:15)
2026-02-04T22:22:38.646940902Z at mounted_app (/home/hcf_api/app/node_modules/express/lib/application.js:232:10)
2026-02-04T22:22:38.646945350Z at Layer.handleRequest (/home/hcf_api/app/node_modules/router/lib/layer.js:152:17)
2026-02-04T22:22:38.646949644Z at trimPrefix (/home/hcf_api/app/node_modules/router/index.js:342:13)
2026-02-04T22:22:38.646953928Z at /home/hcf_api/app/node_modules/router/index.js:297:9
2026-02-04T22:22:38.646958285Z at processParams (/home/hcf_api/app/node_modules/router/index.js:582:12)
2026-02-04T22:22:38.646962666Z at next (/home/hcf_api/app/node_modules/router/index.js:291:5)
2026-02-04T22:22:38.646966738Z at logger (/home/hcf_api/app/node_modules/morgan/index.js:144:5)
2026-02-04T22:22:38.646972056Z at Layer.handleRequest (/home/hcf_api/app/node_modules/router/lib/layer.js:152:17)
2026-02-04T22:22:38.646976372Z at trimPrefix (/home/hcf_api/app/node_modules/router/index.js:342:13)
2026-02-04T22:22:38.646980859Z at /home/hcf_api/app/node_modules/router/index.js:297:9 {
2026-02-04T22:22:38.646985610Z parent: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*)) AS `count` FROM `tombos` AS `tombos`' at line 1
2026-02-04T22:22:38.646990202Z at Packet.asError (/home/hcf_api/app/node_modules/mysql2/lib/packets/packet.js:740:17)
2026-02-04T22:22:38.646994389Z at Query.execute (/home/hcf_api/app/node_modules/mysql2/lib/commands/command.js:29:26)
2026-02-04T22:22:38.646998473Z at Connection.handlePacket (/home/hcf_api/app/node_modules/mysql2/lib/base/connection.js:477:34)
2026-02-04T22:22:38.647002605Z at PacketParser.onPacket (/home/hcf_api/app/node_modules/mysql2/lib/base/connection.js:93:12)
2026-02-04T22:22:38.647006747Z at PacketParser.executeStart (/home/hcf_api/app/node_modules/mysql2/lib/packet_parser.js:75:16)
2026-02-04T22:22:38.647010883Z at Socket.<anonymous> (/home/hcf_api/app/node_modules/mysql2/lib/base/connection.js:100:25)
2026-02-04T22:22:38.647019205Z at Socket.emit (node:events:518:28)
2026-02-04T22:22:38.647023284Z at addChunk (node:internal/streams/readable:561:12)
2026-02-04T22:22:38.647027352Z at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
2026-02-04T22:22:38.647031617Z at Readable.push (node:internal/streams/readable:392:5)
2026-02-04T22:22:38.647035697Z at TCP.onStreamRead (node:internal/stream_base_commons:189:23) {
2026-02-04T22:22:38.647039801Z code: 'ER_PARSE_ERROR',
2026-02-04T22:22:38.647043806Z errno: 1064,
2026-02-04T22:22:38.647064705Z sqlState: '42000',
2026-02-04T22:22:38.647069258Z sqlMessage: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*)) AS `count` FROM `tombos` AS `tombos`' at line 1",
2026-02-04T22:22:38.647073955Z sql: 'SELECT count(DISTINCT(*)) AS `count` FROM `tombos` AS `tombos`;'
2026-02-04T22:22:38.647078275Z },
2026-02-04T22:22:38.647082558Z original: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*)) AS `count` FROM `tombos` AS `tombos`' at line 1
2026-02-04T22:22:38.647087132Z at Packet.asError (/home/hcf_api/app/node_modules/mysql2/lib/packets/packet.js:740:17)
2026-02-04T22:22:38.647091619Z at Query.execute (/home/hcf_api/app/node_modules/mysql2/lib/commands/command.js:29:26)
2026-02-04T22:22:38.647096074Z at Connection.handlePacket (/home/hcf_api/app/node_modules/mysql2/lib/base/connection.js:477:34)
2026-02-04T22:22:38.647100990Z at PacketParser.onPacket (/home/hcf_api/app/node_modules/mysql2/lib/base/connection.js:93:12)
2026-02-04T22:22:38.647106241Z at PacketParser.executeStart (/home/hcf_api/app/node_modules/mysql2/lib/packet_parser.js:75:16)
2026-02-04T22:22:38.647110751Z at Socket.<anonymous> (/home/hcf_api/app/node_modules/mysql2/lib/base/connection.js:100:25)
2026-02-04T22:22:38.647120411Z at Socket.emit (node:events:518:28)
2026-02-04T22:22:38.647124646Z at addChunk (node:internal/streams/readable:561:12)
2026-02-04T22:22:38.647129198Z at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
2026-02-04T22:22:38.647133791Z at Readable.push (node:internal/streams/readable:392:5)
2026-02-04T22:22:38.647138065Z at TCP.onStreamRead (node:internal/stream_base_commons:189:23) {
2026-02-04T22:22:38.647142503Z code: 'ER_PARSE_ERROR',
2026-02-04T22:22:38.647146703Z errno: 1064,
2026-02-04T22:22:38.647150862Z sqlState: '42000',
2026-02-04T22:22:38.647155060Z sqlMessage: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*)) AS `count` FROM `tombos` AS `tombos`' at line 1",
2026-02-04T22:22:38.647159756Z sql: 'SELECT count(DISTINCT(*)) AS `count` FROM `tombos` AS `tombos`;'
2026-02-04T22:22:38.647167292Z },
2026-02-04T22:22:38.647171457Z sql: 'SELECT count(DISTINCT(*)) AS `count` FROM `tombos` AS `tombos`;'
2026-02-04T22:22:38.647175784Z }
2026-02-04T22:22:38.648057966Z GET /api/splinker 500 16.389 ms - 54