Error reordering banners: Error: 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 'UPDATE banners 
        SET sort_order = (@row_number := @row_number + 1) 
  ...' at line 2
    at Packet.asError (/home/onomoifl/nodevenv/api.onomohoteldaressalaam-menu.com/24/lib/node_modules/mysql2/lib/packets/packet.js:921:17)
    at Query.execute (/home/onomoifl/nodevenv/api.onomohoteldaressalaam-menu.com/24/lib/node_modules/mysql2/lib/commands/command.js:29:26)
    at PoolConnection.handlePacket (/home/onomoifl/nodevenv/api.onomohoteldaressalaam-menu.com/24/lib/node_modules/mysql2/lib/base/connection.js:557:34)
    at PacketParser.onPacket (/home/onomoifl/nodevenv/api.onomohoteldaressalaam-menu.com/24/lib/node_modules/mysql2/lib/base/connection.js:104:12)
    at PacketParser.executeStart (/home/onomoifl/nodevenv/api.onomohoteldaressalaam-menu.com/24/lib/node_modules/mysql2/lib/packet_parser.js:86:16)
    at Socket.<anonymous> (/home/onomoifl/nodevenv/api.onomohoteldaressalaam-menu.com/24/lib/node_modules/mysql2/lib/base/connection.js:112:25)
    at Socket.emit (node:events:509:28)
    at addChunk (node:internal/streams/readable:563:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:514:3)
    at Readable.push (node:internal/streams/readable:394:5) {
  code: 'ER_PARSE_ERROR',
  errno: 1064,
  sqlState: '42000',
  sqlMessage: "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 'UPDATE banners \n" +
    '        SET sort_order = (@row_number := @row_number + 1) \n' +
    "  ...' at line 2",
  sql: '\n' +
    '        SET @row_number = 0;\n' +
    '        UPDATE banners \n' +
    '        SET sort_order = (@row_number := @row_number + 1) \n' +
    '        ORDER BY sort_order ASC;\n' +
    '      '
}
Error reordering banners: Error: 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 'UPDATE banners 
        SET sort_order = (@row_number := @row_number + 1) 
  ...' at line 2
    at Packet.asError (/home/onomoifl/nodevenv/api.onomohoteldaressalaam-menu.com/24/lib/node_modules/mysql2/lib/packets/packet.js:921:17)
    at Query.execute (/home/onomoifl/nodevenv/api.onomohoteldaressalaam-menu.com/24/lib/node_modules/mysql2/lib/commands/command.js:29:26)
    at PoolConnection.handlePacket (/home/onomoifl/nodevenv/api.onomohoteldaressalaam-menu.com/24/lib/node_modules/mysql2/lib/base/connection.js:557:34)
    at PacketParser.onPacket (/home/onomoifl/nodevenv/api.onomohoteldaressalaam-menu.com/24/lib/node_modules/mysql2/lib/base/connection.js:104:12)
    at PacketParser.executeStart (/home/onomoifl/nodevenv/api.onomohoteldaressalaam-menu.com/24/lib/node_modules/mysql2/lib/packet_parser.js:86:16)
    at Socket.<anonymous> (/home/onomoifl/nodevenv/api.onomohoteldaressalaam-menu.com/24/lib/node_modules/mysql2/lib/base/connection.js:112:25)
    at Socket.emit (node:events:509:28)
    at addChunk (node:internal/streams/readable:563:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:514:3)
    at Readable.push (node:internal/streams/readable:394:5) {
  code: 'ER_PARSE_ERROR',
  errno: 1064,
  sqlState: '42000',
  sqlMessage: "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 'UPDATE banners \n" +
    '        SET sort_order = (@row_number := @row_number + 1) \n' +
    "  ...' at line 2",
  sql: '\n' +
    '        SET @row_number = 0;\n' +
    '        UPDATE banners \n' +
    '        SET sort_order = (@row_number := @row_number + 1) \n' +
    '        ORDER BY sort_order ASC;\n' +
    '      '
}
Error reordering banners: Error: 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 'UPDATE banners 
        SET sort_order = (@row_number := @row_number + 1) 
  ...' at line 2
    at Packet.asError (/home/onomoifl/nodevenv/api.onomohoteldaressalaam-menu.com/24/lib/node_modules/mysql2/lib/packets/packet.js:921:17)
    at Query.execute (/home/onomoifl/nodevenv/api.onomohoteldaressalaam-menu.com/24/lib/node_modules/mysql2/lib/commands/command.js:29:26)
    at PoolConnection.handlePacket (/home/onomoifl/nodevenv/api.onomohoteldaressalaam-menu.com/24/lib/node_modules/mysql2/lib/base/connection.js:557:34)
    at PacketParser.onPacket (/home/onomoifl/nodevenv/api.onomohoteldaressalaam-menu.com/24/lib/node_modules/mysql2/lib/base/connection.js:104:12)
    at PacketParser.executeStart (/home/onomoifl/nodevenv/api.onomohoteldaressalaam-menu.com/24/lib/node_modules/mysql2/lib/packet_parser.js:86:16)
    at Socket.<anonymous> (/home/onomoifl/nodevenv/api.onomohoteldaressalaam-menu.com/24/lib/node_modules/mysql2/lib/base/connection.js:112:25)
    at Socket.emit (node:events:509:28)
    at addChunk (node:internal/streams/readable:563:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:514:3)
    at Readable.push (node:internal/streams/readable:394:5) {
  code: 'ER_PARSE_ERROR',
  errno: 1064,
  sqlState: '42000',
  sqlMessage: "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 'UPDATE banners \n" +
    '        SET sort_order = (@row_number := @row_number + 1) \n' +
    "  ...' at line 2",
  sql: '\n' +
    '        SET @row_number = 0;\n' +
    '        UPDATE banners \n' +
    '        SET sort_order = (@row_number := @row_number + 1) \n' +
    '        ORDER BY sort_order ASC;\n' +
    '      '
}
Database error updating banner: TypeError: Bind parameters must not contain undefined. To pass SQL NULL specify JS null
    at /home/onomoifl/nodevenv/api.onomohoteldaressalaam-menu.com/24/lib/node_modules/mysql2/lib/base/connection.js:799:17
    at Array.forEach (<anonymous>)
    at PoolConnection.execute (/home/onomoifl/nodevenv/api.onomohoteldaressalaam-menu.com/24/lib/node_modules/mysql2/lib/base/connection.js:791:22)
    at /home/onomoifl/nodevenv/api.onomohoteldaressalaam-menu.com/24/lib/node_modules/mysql2/lib/base/pool.js:297:12
    at /home/onomoifl/nodevenv/api.onomohoteldaressalaam-menu.com/24/lib/node_modules/mysql2/lib/base/pool.js:84:11
    at process.processTicksAndRejections (node:internal/process/task_queues:85:11)
Database error updating banner: TypeError: Bind parameters must not contain undefined. To pass SQL NULL specify JS null
    at /home/onomoifl/nodevenv/api.onomohoteldaressalaam-menu.com/24/lib/node_modules/mysql2/lib/base/connection.js:799:17
    at Array.forEach (<anonymous>)
    at PoolConnection.execute (/home/onomoifl/nodevenv/api.onomohoteldaressalaam-menu.com/24/lib/node_modules/mysql2/lib/base/connection.js:791:22)
    at /home/onomoifl/nodevenv/api.onomohoteldaressalaam-menu.com/24/lib/node_modules/mysql2/lib/base/pool.js:297:12
    at /home/onomoifl/nodevenv/api.onomohoteldaressalaam-menu.com/24/lib/node_modules/mysql2/lib/base/pool.js:84:11
    at process.processTicksAndRejections (node:internal/process/task_queues:85:11)