FUNCTION kuttdb.string_agg does not exist - mysql2 Driver - Using MariaDB #788
Description
Using MariaDB Server version: 10.11.10-MariaDB-ubu2204 mariadb.org binary distribution
OS version: Ubuntu 22.04.5 LTS
Steps to replicate - Follow documentation on Github. Copy example env to .env, edit configuration to use mysql2 driver and populate with details. Run npm run migrate, completes with 10 migrations. Start application and create admin user. Navigating to DOMAIN/admin (if done reverse proxy) then Users tab, the following appears on the output. It seems it's missing it's FUNCTION inside the database tables or what not.
Error: select `users`.`id`, `users`.`email`, `users`.`verified`, `users`.`role`, `users`.`banned`, `users`.`banned_by_id`, `users`.`created_at`, `users`.`updated_at`, `l`.`links_count`, `d`.`domains` from users left join (select `user_id`, string_agg(address, ', ') AS domains from `domains` group by `user_id`) as `d` on `users`.`id` = `d`.`user_id` left join (select `user_id`, count(`id`) as `links_count` from `links` group by `user_id`) as `l` on `users`.`id` = `l`.`user_id` group by 1, `l`.`links_count`, `d`.`domains` order by `users`.`id` desc limit 10 - FUNCTION kuttdb.string_agg does not exist
at Packet.asError (/applications/kutt-3.0.3/node_modules/mysql2/lib/packets/packet.js:740:17)
at Query.execute (/applications/kutt-3.0.3/node_modules/mysql2/lib/commands/command.js:29:26)
at Connection.handlePacket (/applications/kutt-3.0.3/node_modules/mysql2/lib/base/connection.js:475:34)
at PacketParser.onPacket (/applications/kutt-3.0.3/node_modules/mysql2/lib/base/connection.js:93:12)
at PacketParser.executeStart (/applications/kutt-3.0.3/node_modules/mysql2/lib/packet_parser.js:75:16)
at Socket.<anonymous> (/applications/kutt-3.0.3/node_modules/mysql2/lib/base/connection.js:100:25)
at Socket.emit (node:events:518:28)
at addChunk (node:internal/streams/readable:561:12)
at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
at Readable.push (node:internal/streams/readable:392:5) {
code: 'ER_SP_DOES_NOT_EXIST',
errno: 1305,
sqlState: '42000',
sqlMessage: 'FUNCTION kuttdb.string_agg does not exist',
sql: "select `users`.`id`, `users`.`email`, `users`.`verified`, `users`.`role`, `users`.`banned`, `users`.`banned_by_id`, `users`.`created_at`, `users`.`updated_at`, `l`.`links_count`, `d`.`domains` from users left join (select `user_id`, string_agg(address, ', ') AS domains from `domains` group by `user_id`) as `d` on `users`.`id` = `d`.`user_id` left join (select `user_id`, count(`id`) as `links_count` from `links` group by `user_id`) as `l` on `users`.`id` = `l`.`user_id` group by 1, `l`.`links_count`, `d`.`domains` order by `users`.`id` desc limit 10"
}