node:internal/modules/esm/resolve:1204
    throw error;
    ^

Error [ERR_MODULE_NOT_FOUND]: Cannot find package 'cors' imported from /home/kernostudio/apierincometaxerp.kernostudio.com/server.js
    at packageResolve (node:internal/modules/esm/resolve:873:9)
    at moduleResolve (node:internal/modules/esm/resolve:946:18)
    at defaultResolve (node:internal/modules/esm/resolve:1188:11)
    at ModuleLoader.defaultResolve (node:internal/modules/esm/loader:708:12)
    at #cachedDefaultResolve (node:internal/modules/esm/loader:657:25)
    at ModuleLoader.getModuleJobForRequire (node:internal/modules/esm/loader:413:53)
    at new ModuleJobSync (node:internal/modules/esm/module_job:375:34)
    at ModuleLoader.importSyncForRequire (node:internal/modules/esm/loader:386:11)
    at loadESMFromCJS (node:internal/modules/cjs/loader:1363:24)
    at Module._compile (node:internal/modules/cjs/loader:1503:5) {
  code: 'ERR_MODULE_NOT_FOUND'
}

Node.js v20.20.0
node:internal/modules/esm/resolve:1204
    throw error;
    ^

Error [ERR_MODULE_NOT_FOUND]: Cannot find package 'cors' imported from /home/kernostudio/apierincometaxerp.kernostudio.com/server.js
    at packageResolve (node:internal/modules/esm/resolve:873:9)
    at moduleResolve (node:internal/modules/esm/resolve:946:18)
    at defaultResolve (node:internal/modules/esm/resolve:1188:11)
    at ModuleLoader.defaultResolve (node:internal/modules/esm/loader:708:12)
    at #cachedDefaultResolve (node:internal/modules/esm/loader:657:25)
    at ModuleLoader.getModuleJobForRequire (node:internal/modules/esm/loader:413:53)
    at new ModuleJobSync (node:internal/modules/esm/module_job:375:34)
    at ModuleLoader.importSyncForRequire (node:internal/modules/esm/loader:386:11)
    at loadESMFromCJS (node:internal/modules/cjs/loader:1363:24)
    at Module._compile (node:internal/modules/cjs/loader:1503:5) {
  code: 'ERR_MODULE_NOT_FOUND'
}

Node.js v20.20.0
Error: secretOrPrivateKey must have a value
    at module.exports [as sign] (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/jsonwebtoken/sign.js:111:20)
    at generateToken (file:///home/kernostudio/apierincometaxerp.kernostudio.com/utils/helpers.js:8:14)
    at file:///home/kernostudio/apierincometaxerp.kernostudio.com/routes/users.js:85:19
Error: secretOrPrivateKey must have a value
    at module.exports [as sign] (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/jsonwebtoken/sign.js:111:20)
    at generateToken (file:///home/kernostudio/apierincometaxerp.kernostudio.com/utils/helpers.js:8:14)
    at file:///home/kernostudio/apierincometaxerp.kernostudio.com/routes/users.js:85:19
Error: secretOrPrivateKey must have a value
    at module.exports [as sign] (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/jsonwebtoken/sign.js:111:20)
    at generateToken (file:///home/kernostudio/apierincometaxerp.kernostudio.com/utils/helpers.js:8:14)
    at file:///home/kernostudio/apierincometaxerp.kernostudio.com/routes/users.js:85:19
Error: secretOrPrivateKey must have a value
    at module.exports [as sign] (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/jsonwebtoken/sign.js:111:20)
    at generateToken (file:///home/kernostudio/apierincometaxerp.kernostudio.com/utils/helpers.js:8:14)
    at file:///home/kernostudio/apierincometaxerp.kernostudio.com/routes/users.js:85:19
Error: secretOrPrivateKey must have a value
    at module.exports [as sign] (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/jsonwebtoken/sign.js:111:20)
    at generateToken (file:///home/kernostudio/apierincometaxerp.kernostudio.com/utils/helpers.js:8:14)
    at file:///home/kernostudio/apierincometaxerp.kernostudio.com/routes/users.js:85:19
Error: secretOrPrivateKey must have a value
    at module.exports [as sign] (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/jsonwebtoken/sign.js:111:20)
    at generateToken (file:///home/kernostudio/apierincometaxerp.kernostudio.com/utils/helpers.js:8:14)
    at file:///home/kernostudio/apierincometaxerp.kernostudio.com/routes/users.js:85:19
Error: secretOrPrivateKey must have a value
    at module.exports [as sign] (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/jsonwebtoken/sign.js:111:20)
    at generateToken (file:///home/kernostudio/apierincometaxerp.kernostudio.com/utils/helpers.js:8:14)
    at file:///home/kernostudio/apierincometaxerp.kernostudio.com/routes/users.js:85:19
Error: secretOrPrivateKey must have a value
    at module.exports [as sign] (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/jsonwebtoken/sign.js:111:20)
    at generateToken (file:///home/kernostudio/apierincometaxerp.kernostudio.com/utils/helpers.js:8:14)
    at file:///home/kernostudio/apierincometaxerp.kernostudio.com/routes/users.js:85:19
Error: secretOrPrivateKey must have a value
    at module.exports [as sign] (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/jsonwebtoken/sign.js:111:20)
    at generateToken (file:///home/kernostudio/apierincometaxerp.kernostudio.com/utils/helpers.js:8:14)
    at file:///home/kernostudio/apierincometaxerp.kernostudio.com/routes/users.js:85:19
Error: secretOrPrivateKey must have a value
    at module.exports [as sign] (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/jsonwebtoken/sign.js:111:20)
    at generateToken (file:///home/kernostudio/apierincometaxerp.kernostudio.com/utils/helpers.js:8:14)
    at file:///home/kernostudio/apierincometaxerp.kernostudio.com/routes/users.js:85:19
Error: secretOrPrivateKey must have a value
    at module.exports [as sign] (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/jsonwebtoken/sign.js:111:20)
    at generateToken (file:///home/kernostudio/apierincometaxerp.kernostudio.com/utils/helpers.js:8:14)
    at file:///home/kernostudio/apierincometaxerp.kernostudio.com/routes/users.js:85:19
Error: secretOrPrivateKey must have a value
    at module.exports [as sign] (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/jsonwebtoken/sign.js:111:20)
    at generateToken (file:///home/kernostudio/apierincometaxerp.kernostudio.com/utils/helpers.js:8:14)
    at file:///home/kernostudio/apierincometaxerp.kernostudio.com/routes/users.js:85:19
Error: secretOrPrivateKey must have a value
    at module.exports [as sign] (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/jsonwebtoken/sign.js:111:20)
    at generateToken (file:///home/kernostudio/apierincometaxerp.kernostudio.com/utils/helpers.js:8:14)
    at file:///home/kernostudio/apierincometaxerp.kernostudio.com/routes/users.js:85:19
Error: secretOrPrivateKey must have a value
    at module.exports [as sign] (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/jsonwebtoken/sign.js:111:20)
    at generateToken (file:///home/kernostudio/apierincometaxerp.kernostudio.com/utils/helpers.js:8:14)
    at file:///home/kernostudio/apierincometaxerp.kernostudio.com/routes/users.js:85:19
Error: secretOrPrivateKey must have a value
    at module.exports [as sign] (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/jsonwebtoken/sign.js:111:20)
    at generateToken (file:///home/kernostudio/apierincometaxerp.kernostudio.com/utils/helpers.js:8:14)
    at file:///home/kernostudio/apierincometaxerp.kernostudio.com/routes/users.js:85:19
Error: secretOrPrivateKey must have a value
    at module.exports [as sign] (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/jsonwebtoken/sign.js:111:20)
    at generateToken (file:///home/kernostudio/apierincometaxerp.kernostudio.com/utils/helpers.js:8:14)
    at file:///home/kernostudio/apierincometaxerp.kernostudio.com/routes/users.js:85:19
Error: Unknown column 't.receipt_no' in 'SELECT'
    at /home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/promise/make_done_cb.js:6:24
    at Prepare.onResult (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:807:11)
    at Prepare.execute (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/commands/command.js:36:14)
    at PoolConnection.handlePacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:552:34)
    at PacketParser.onPacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:102:12)
    at PacketParser.executeStart (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.<anonymous> (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:109:25)
    at Socket.emit (node:events:524:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) {
  code: 'ER_BAD_FIELD_ERROR',
  errno: 1054,
  sql: '\n' +
    '      SELECT a.id, a.transaction_id, a.status, a.notes, a.timestamp,\n' +
    '             t.receipt_no, t.amount, t.category_id, t.user_id,\n' +
    '             u.name as user_name, c.name as category_name\n' +
    '      FROM approvals a\n' +
    '      JOIN transactions t ON a.transaction_id = t.id\n' +
    '      JOIN users u ON t.user_id = u.id\n' +
    '      JOIN categories c ON t.category_id = c.id\n' +
    '      WHERE 1=1\n' +
    '     AND t.fiscal_year_id = ? AND a.status = ? ORDER BY a.timestamp DESC LIMIT ? OFFSET ?',
  sqlState: '42S22',
  sqlMessage: "Unknown column 't.receipt_no' in 'SELECT'"
}
Error: Unknown column 't.receipt_no' in 'SELECT'
    at /home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/promise/make_done_cb.js:6:24
    at Prepare.onResult (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:807:11)
    at Prepare.execute (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/commands/command.js:36:14)
    at PoolConnection.handlePacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:552:34)
    at PacketParser.onPacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:102:12)
    at PacketParser.executeStart (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.<anonymous> (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:109:25)
    at Socket.emit (node:events:524:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) {
  code: 'ER_BAD_FIELD_ERROR',
  errno: 1054,
  sql: '\n' +
    '      SELECT a.id, a.transaction_id, a.status, a.notes, a.timestamp,\n' +
    '             t.receipt_no, t.amount, t.category_id, t.user_id,\n' +
    '             u.name as user_name, c.name as category_name\n' +
    '      FROM approvals a\n' +
    '      JOIN transactions t ON a.transaction_id = t.id\n' +
    '      JOIN users u ON t.user_id = u.id\n' +
    '      JOIN categories c ON t.category_id = c.id\n' +
    '      WHERE 1=1\n' +
    '     AND t.fiscal_year_id = ? AND a.status = ? ORDER BY a.timestamp DESC LIMIT ? OFFSET ?',
  sqlState: '42S22',
  sqlMessage: "Unknown column 't.receipt_no' in 'SELECT'"
}
Error: Unknown column 't.receipt_no' in 'SELECT'
    at /home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/promise/make_done_cb.js:6:24
    at Prepare.onResult (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:807:11)
    at Prepare.execute (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/commands/command.js:36:14)
    at PoolConnection.handlePacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:552:34)
    at PacketParser.onPacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:102:12)
    at PacketParser.executeStart (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.<anonymous> (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:109:25)
    at Socket.emit (node:events:524:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) {
  code: 'ER_BAD_FIELD_ERROR',
  errno: 1054,
  sql: '\n' +
    '      SELECT a.id, a.transaction_id, a.status, a.notes, a.timestamp,\n' +
    '             t.receipt_no, t.amount, t.category_id, t.user_id,\n' +
    '             u.name as user_name, c.name as category_name\n' +
    '      FROM approvals a\n' +
    '      JOIN transactions t ON a.transaction_id = t.id\n' +
    '      JOIN users u ON t.user_id = u.id\n' +
    '      JOIN categories c ON t.category_id = c.id\n' +
    '      WHERE 1=1\n' +
    '     AND t.fiscal_year_id = ? AND a.status = ? ORDER BY a.timestamp DESC LIMIT ? OFFSET ?',
  sqlState: '42S22',
  sqlMessage: "Unknown column 't.receipt_no' in 'SELECT'"
}
Error: Unknown column 't.receipt_no' in 'SELECT'
    at /home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/promise/make_done_cb.js:6:24
    at Prepare.onResult (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:807:11)
    at Prepare.execute (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/commands/command.js:36:14)
    at PoolConnection.handlePacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:552:34)
    at PacketParser.onPacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:102:12)
    at PacketParser.executeStart (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.<anonymous> (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:109:25)
    at Socket.emit (node:events:524:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) {
  code: 'ER_BAD_FIELD_ERROR',
  errno: 1054,
  sql: '\n' +
    '      SELECT a.id, a.transaction_id, a.status, a.notes, a.timestamp,\n' +
    '             t.receipt_no, t.amount, t.category_id, t.user_id,\n' +
    '             u.name as user_name, c.name as category_name\n' +
    '      FROM approvals a\n' +
    '      JOIN transactions t ON a.transaction_id = t.id\n' +
    '      JOIN users u ON t.user_id = u.id\n' +
    '      JOIN categories c ON t.category_id = c.id\n' +
    '      WHERE 1=1\n' +
    '     AND t.fiscal_year_id = ? AND a.status = ? ORDER BY a.timestamp DESC LIMIT ? OFFSET ?',
  sqlState: '42S22',
  sqlMessage: "Unknown column 't.receipt_no' in 'SELECT'"
}
Error: Unknown column 't.receipt_no' in 'SELECT'
    at /home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/promise/make_done_cb.js:6:24
    at Prepare.onResult (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:807:11)
    at Prepare.execute (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/commands/command.js:36:14)
    at PoolConnection.handlePacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:552:34)
    at PacketParser.onPacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:102:12)
    at PacketParser.executeStart (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.<anonymous> (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:109:25)
    at Socket.emit (node:events:524:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) {
  code: 'ER_BAD_FIELD_ERROR',
  errno: 1054,
  sql: '\n' +
    '      SELECT a.id, a.transaction_id, a.status, a.notes, a.timestamp,\n' +
    '             t.receipt_no, t.amount, t.category_id, t.user_id,\n' +
    '             u.name as user_name, c.name as category_name\n' +
    '      FROM approvals a\n' +
    '      JOIN transactions t ON a.transaction_id = t.id\n' +
    '      JOIN users u ON t.user_id = u.id\n' +
    '      JOIN categories c ON t.category_id = c.id\n' +
    '      WHERE 1=1\n' +
    '     AND t.fiscal_year_id = ? AND a.status = ? ORDER BY a.timestamp DESC LIMIT ? OFFSET ?',
  sqlState: '42S22',
  sqlMessage: "Unknown column 't.receipt_no' in 'SELECT'"
}
Error: Unknown column 't.receipt_no' in 'SELECT'
    at /home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/promise/make_done_cb.js:6:24
    at Prepare.onResult (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:807:11)
    at Prepare.execute (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/commands/command.js:36:14)
    at PoolConnection.handlePacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:552:34)
    at PacketParser.onPacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:102:12)
    at PacketParser.executeStart (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.<anonymous> (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:109:25)
    at Socket.emit (node:events:524:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) {
  code: 'ER_BAD_FIELD_ERROR',
  errno: 1054,
  sql: '\n' +
    '      SELECT a.id, a.transaction_id, a.status, a.notes, a.timestamp,\n' +
    '             t.receipt_no, t.amount, t.category_id, t.user_id,\n' +
    '             u.name as user_name, c.name as category_name\n' +
    '      FROM approvals a\n' +
    '      JOIN transactions t ON a.transaction_id = t.id\n' +
    '      JOIN users u ON t.user_id = u.id\n' +
    '      JOIN categories c ON t.category_id = c.id\n' +
    '      WHERE 1=1\n' +
    '     AND t.fiscal_year_id = ? AND a.status = ? ORDER BY a.timestamp DESC LIMIT ? OFFSET ?',
  sqlState: '42S22',
  sqlMessage: "Unknown column 't.receipt_no' in 'SELECT'"
}
Error: Unknown column 't.receipt_no' in 'SELECT'
    at /home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/promise/make_done_cb.js:6:24
    at Prepare.onResult (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:807:11)
    at Prepare.execute (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/commands/command.js:36:14)
    at PoolConnection.handlePacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:552:34)
    at PacketParser.onPacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:102:12)
    at PacketParser.executeStart (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.<anonymous> (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:109:25)
    at Socket.emit (node:events:524:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) {
  code: 'ER_BAD_FIELD_ERROR',
  errno: 1054,
  sql: '\n' +
    '      SELECT a.id, a.transaction_id, a.status, a.notes, a.timestamp,\n' +
    '             t.receipt_no, t.amount, t.category_id, t.user_id,\n' +
    '             u.name as user_name, c.name as category_name\n' +
    '      FROM approvals a\n' +
    '      JOIN transactions t ON a.transaction_id = t.id\n' +
    '      JOIN users u ON t.user_id = u.id\n' +
    '      JOIN categories c ON t.category_id = c.id\n' +
    '      WHERE 1=1\n' +
    '     AND t.fiscal_year_id = ? AND a.status = ? ORDER BY a.timestamp DESC LIMIT ? OFFSET ?',
  sqlState: '42S22',
  sqlMessage: "Unknown column 't.receipt_no' in 'SELECT'"
}
Error: Unknown column 't.receipt_no' in 'SELECT'
    at /home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/promise/make_done_cb.js:6:24
    at Prepare.onResult (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:807:11)
    at Prepare.execute (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/commands/command.js:36:14)
    at PoolConnection.handlePacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:552:34)
    at PacketParser.onPacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:102:12)
    at PacketParser.executeStart (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.<anonymous> (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:109:25)
    at Socket.emit (node:events:524:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) {
  code: 'ER_BAD_FIELD_ERROR',
  errno: 1054,
  sql: '\n' +
    '      SELECT a.id, a.transaction_id, a.status, a.notes, a.timestamp,\n' +
    '             t.receipt_no, t.amount, t.category_id, t.user_id,\n' +
    '             u.name as user_name, c.name as category_name\n' +
    '      FROM approvals a\n' +
    '      JOIN transactions t ON a.transaction_id = t.id\n' +
    '      JOIN users u ON t.user_id = u.id\n' +
    '      JOIN categories c ON t.category_id = c.id\n' +
    '      WHERE 1=1\n' +
    '     AND t.fiscal_year_id = ? AND a.status = ? ORDER BY a.timestamp DESC LIMIT ? OFFSET ?',
  sqlState: '42S22',
  sqlMessage: "Unknown column 't.receipt_no' in 'SELECT'"
}
Error: Unknown column 't.receipt_no' in 'SELECT'
    at /home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/promise/make_done_cb.js:6:24
    at Prepare.onResult (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:807:11)
    at Prepare.execute (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/commands/command.js:36:14)
    at PoolConnection.handlePacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:552:34)
    at PacketParser.onPacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:102:12)
    at PacketParser.executeStart (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.<anonymous> (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:109:25)
    at Socket.emit (node:events:524:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) {
  code: 'ER_BAD_FIELD_ERROR',
  errno: 1054,
  sql: '\n' +
    '      SELECT a.id, a.transaction_id, a.status, a.notes, a.timestamp,\n' +
    '             t.receipt_no, t.amount, t.category_id, t.user_id,\n' +
    '             u.name as user_name, c.name as category_name\n' +
    '      FROM approvals a\n' +
    '      JOIN transactions t ON a.transaction_id = t.id\n' +
    '      JOIN users u ON t.user_id = u.id\n' +
    '      JOIN categories c ON t.category_id = c.id\n' +
    '      WHERE 1=1\n' +
    '     AND t.fiscal_year_id = ? AND a.status = ? ORDER BY a.timestamp DESC LIMIT ? OFFSET ?',
  sqlState: '42S22',
  sqlMessage: "Unknown column 't.receipt_no' in 'SELECT'"
}
Error: Unknown column 't.receipt_no' in 'SELECT'
    at /home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/promise/make_done_cb.js:6:24
    at Prepare.onResult (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:807:11)
    at Prepare.execute (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/commands/command.js:36:14)
    at PoolConnection.handlePacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:552:34)
    at PacketParser.onPacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:102:12)
    at PacketParser.executeStart (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.<anonymous> (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:109:25)
    at Socket.emit (node:events:524:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) {
  code: 'ER_BAD_FIELD_ERROR',
  errno: 1054,
  sql: '\n' +
    '      SELECT a.id, a.transaction_id, a.status, a.notes, a.timestamp,\n' +
    '             t.receipt_no, t.amount, t.category_id, t.user_id,\n' +
    '             u.name as user_name, c.name as category_name\n' +
    '      FROM approvals a\n' +
    '      JOIN transactions t ON a.transaction_id = t.id\n' +
    '      JOIN users u ON t.user_id = u.id\n' +
    '      JOIN categories c ON t.category_id = c.id\n' +
    '      WHERE 1=1\n' +
    '     AND t.fiscal_year_id = ? AND a.status = ? ORDER BY a.timestamp DESC LIMIT ? OFFSET ?',
  sqlState: '42S22',
  sqlMessage: "Unknown column 't.receipt_no' in 'SELECT'"
}
Error: Unknown column 't.receipt_no' in 'SELECT'
    at /home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/promise/make_done_cb.js:6:24
    at Prepare.onResult (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:807:11)
    at Prepare.execute (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/commands/command.js:36:14)
    at PoolConnection.handlePacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:552:34)
    at PacketParser.onPacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:102:12)
    at PacketParser.executeStart (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.<anonymous> (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:109:25)
    at Socket.emit (node:events:524:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) {
  code: 'ER_BAD_FIELD_ERROR',
  errno: 1054,
  sql: '\n' +
    '      SELECT a.id, a.transaction_id, a.status, a.notes, a.timestamp,\n' +
    '             t.receipt_no, t.amount, t.category_id, t.user_id,\n' +
    '             u.name as user_name, c.name as category_name\n' +
    '      FROM approvals a\n' +
    '      JOIN transactions t ON a.transaction_id = t.id\n' +
    '      JOIN users u ON t.user_id = u.id\n' +
    '      JOIN categories c ON t.category_id = c.id\n' +
    '      WHERE 1=1\n' +
    '     AND t.fiscal_year_id = ? AND a.status = ? ORDER BY a.timestamp DESC LIMIT ? OFFSET ?',
  sqlState: '42S22',
  sqlMessage: "Unknown column 't.receipt_no' in 'SELECT'"
}
Error: Unknown column 't.receipt_no' in 'SELECT'
    at /home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/promise/make_done_cb.js:6:24
    at Prepare.onResult (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:807:11)
    at Prepare.execute (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/commands/command.js:36:14)
    at PoolConnection.handlePacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:552:34)
    at PacketParser.onPacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:102:12)
    at PacketParser.executeStart (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.<anonymous> (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:109:25)
    at Socket.emit (node:events:524:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) {
  code: 'ER_BAD_FIELD_ERROR',
  errno: 1054,
  sql: '\n' +
    '      SELECT a.id, a.transaction_id, a.status, a.notes, a.timestamp,\n' +
    '             t.receipt_no, t.amount, t.category_id, t.user_id,\n' +
    '             u.name as user_name, c.name as category_name\n' +
    '      FROM approvals a\n' +
    '      JOIN transactions t ON a.transaction_id = t.id\n' +
    '      JOIN users u ON t.user_id = u.id\n' +
    '      JOIN categories c ON t.category_id = c.id\n' +
    '      WHERE 1=1\n' +
    '     AND t.fiscal_year_id = ? AND a.status = ? ORDER BY a.timestamp DESC LIMIT ? OFFSET ?',
  sqlState: '42S22',
  sqlMessage: "Unknown column 't.receipt_no' in 'SELECT'"
}
Error: Unknown column 't.receipt_no' in 'SELECT'
    at /home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/promise/make_done_cb.js:6:24
    at Prepare.onResult (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:807:11)
    at Prepare.execute (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/commands/command.js:36:14)
    at PoolConnection.handlePacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:552:34)
    at PacketParser.onPacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:102:12)
    at PacketParser.executeStart (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.<anonymous> (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:109:25)
    at Socket.emit (node:events:524:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) {
  code: 'ER_BAD_FIELD_ERROR',
  errno: 1054,
  sql: '\n' +
    '      SELECT a.id, a.transaction_id, a.status, a.notes, a.timestamp,\n' +
    '             t.receipt_no, t.amount, t.category_id, t.user_id,\n' +
    '             u.name as user_name, c.name as category_name\n' +
    '      FROM approvals a\n' +
    '      JOIN transactions t ON a.transaction_id = t.id\n' +
    '      JOIN users u ON t.user_id = u.id\n' +
    '      JOIN categories c ON t.category_id = c.id\n' +
    '      WHERE 1=1\n' +
    '     AND t.fiscal_year_id = ? AND a.status = ? ORDER BY a.timestamp DESC LIMIT ? OFFSET ?',
  sqlState: '42S22',
  sqlMessage: "Unknown column 't.receipt_no' in 'SELECT'"
}
Error: Unknown column 't.receipt_no' in 'SELECT'
    at /home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/promise/make_done_cb.js:6:24
    at Prepare.onResult (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:807:11)
    at Prepare.execute (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/commands/command.js:36:14)
    at PoolConnection.handlePacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:552:34)
    at PacketParser.onPacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:102:12)
    at PacketParser.executeStart (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.<anonymous> (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:109:25)
    at Socket.emit (node:events:524:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) {
  code: 'ER_BAD_FIELD_ERROR',
  errno: 1054,
  sql: '\n' +
    '      SELECT a.id, a.transaction_id, a.status, a.notes, a.timestamp,\n' +
    '             t.receipt_no, t.amount, t.category_id, t.user_id,\n' +
    '             u.name as user_name, c.name as category_name\n' +
    '      FROM approvals a\n' +
    '      JOIN transactions t ON a.transaction_id = t.id\n' +
    '      JOIN users u ON t.user_id = u.id\n' +
    '      JOIN categories c ON t.category_id = c.id\n' +
    '      WHERE 1=1\n' +
    '     AND t.fiscal_year_id = ? AND a.status = ? ORDER BY a.timestamp DESC LIMIT ? OFFSET ?',
  sqlState: '42S22',
  sqlMessage: "Unknown column 't.receipt_no' in 'SELECT'"
}
Error: Unknown column 't.receipt_no' in 'SELECT'
    at /home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/promise/make_done_cb.js:6:24
    at Prepare.onResult (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:807:11)
    at Prepare.execute (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/commands/command.js:36:14)
    at PoolConnection.handlePacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:552:34)
    at PacketParser.onPacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:102:12)
    at PacketParser.executeStart (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.<anonymous> (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:109:25)
    at Socket.emit (node:events:524:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) {
  code: 'ER_BAD_FIELD_ERROR',
  errno: 1054,
  sql: '\n' +
    '      SELECT a.id, a.transaction_id, a.status, a.notes, a.timestamp,\n' +
    '             t.receipt_no, t.amount, t.category_id, t.user_id,\n' +
    '             u.name as user_name, c.name as category_name\n' +
    '      FROM approvals a\n' +
    '      JOIN transactions t ON a.transaction_id = t.id\n' +
    '      JOIN users u ON t.user_id = u.id\n' +
    '      JOIN categories c ON t.category_id = c.id\n' +
    '      WHERE 1=1\n' +
    '     AND t.fiscal_year_id = ? AND a.status = ? ORDER BY a.timestamp DESC LIMIT ? OFFSET ?',
  sqlState: '42S22',
  sqlMessage: "Unknown column 't.receipt_no' in 'SELECT'"
}
Error: Unknown column 't.receipt_no' in 'SELECT'
    at /home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/promise/make_done_cb.js:6:24
    at Prepare.onResult (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:807:11)
    at Prepare.execute (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/commands/command.js:36:14)
    at PoolConnection.handlePacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:552:34)
    at PacketParser.onPacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:102:12)
    at PacketParser.executeStart (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.<anonymous> (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:109:25)
    at Socket.emit (node:events:524:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) {
  code: 'ER_BAD_FIELD_ERROR',
  errno: 1054,
  sql: '\n' +
    '      SELECT a.id, a.transaction_id, a.status, a.notes, a.timestamp,\n' +
    '             t.receipt_no, t.amount, t.category_id, t.user_id,\n' +
    '             u.name as user_name, c.name as category_name\n' +
    '      FROM approvals a\n' +
    '      JOIN transactions t ON a.transaction_id = t.id\n' +
    '      JOIN users u ON t.user_id = u.id\n' +
    '      JOIN categories c ON t.category_id = c.id\n' +
    '      WHERE 1=1\n' +
    '     AND t.fiscal_year_id = ? AND a.status = ? ORDER BY a.timestamp DESC LIMIT ? OFFSET ?',
  sqlState: '42S22',
  sqlMessage: "Unknown column 't.receipt_no' in 'SELECT'"
}
Error: Unknown column 't.receipt_no' in 'SELECT'
    at /home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/promise/make_done_cb.js:6:24
    at Prepare.onResult (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:807:11)
    at Prepare.execute (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/commands/command.js:36:14)
    at PoolConnection.handlePacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:552:34)
    at PacketParser.onPacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:102:12)
    at PacketParser.executeStart (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.<anonymous> (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:109:25)
    at Socket.emit (node:events:524:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) {
  code: 'ER_BAD_FIELD_ERROR',
  errno: 1054,
  sql: '\n' +
    '      SELECT a.id, a.transaction_id, a.status, a.notes, a.timestamp,\n' +
    '             t.receipt_no, t.amount, t.category_id, t.user_id,\n' +
    '             u.name as user_name, c.name as category_name\n' +
    '      FROM approvals a\n' +
    '      JOIN transactions t ON a.transaction_id = t.id\n' +
    '      JOIN users u ON t.user_id = u.id\n' +
    '      JOIN categories c ON t.category_id = c.id\n' +
    '      WHERE 1=1\n' +
    '     AND t.fiscal_year_id = ? AND a.status = ? ORDER BY a.timestamp DESC LIMIT ? OFFSET ?',
  sqlState: '42S22',
  sqlMessage: "Unknown column 't.receipt_no' in 'SELECT'"
}
Error: Unknown column 't.receipt_no' in 'SELECT'
    at /home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/promise/make_done_cb.js:6:24
    at Prepare.onResult (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:807:11)
    at Prepare.execute (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/commands/command.js:36:14)
    at PoolConnection.handlePacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:552:34)
    at PacketParser.onPacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:102:12)
    at PacketParser.executeStart (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.<anonymous> (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:109:25)
    at Socket.emit (node:events:524:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) {
  code: 'ER_BAD_FIELD_ERROR',
  errno: 1054,
  sql: '\n' +
    '      SELECT a.id, a.transaction_id, a.status, a.notes, a.timestamp,\n' +
    '             t.receipt_no, t.amount, t.category_id, t.user_id,\n' +
    '             u.name as user_name, c.name as category_name\n' +
    '      FROM approvals a\n' +
    '      JOIN transactions t ON a.transaction_id = t.id\n' +
    '      JOIN users u ON t.user_id = u.id\n' +
    '      JOIN categories c ON t.category_id = c.id\n' +
    '      WHERE 1=1\n' +
    '     AND t.fiscal_year_id = ? AND a.status = ? ORDER BY a.timestamp DESC LIMIT ? OFFSET ?',
  sqlState: '42S22',
  sqlMessage: "Unknown column 't.receipt_no' in 'SELECT'"
}
Error: Unknown column 't.receipt_no' in 'SELECT'
    at /home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/promise/make_done_cb.js:6:24
    at Prepare.onResult (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:807:11)
    at Prepare.execute (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/commands/command.js:36:14)
    at PoolConnection.handlePacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:552:34)
    at PacketParser.onPacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:102:12)
    at PacketParser.executeStart (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.<anonymous> (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:109:25)
    at Socket.emit (node:events:524:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) {
  code: 'ER_BAD_FIELD_ERROR',
  errno: 1054,
  sql: '\n' +
    '      SELECT a.id, a.transaction_id, a.status, a.notes, a.timestamp,\n' +
    '             t.receipt_no, t.amount, t.category_id, t.user_id,\n' +
    '             u.name as user_name, c.name as category_name\n' +
    '      FROM approvals a\n' +
    '      JOIN transactions t ON a.transaction_id = t.id\n' +
    '      JOIN users u ON t.user_id = u.id\n' +
    '      JOIN categories c ON t.category_id = c.id\n' +
    '      WHERE 1=1\n' +
    '     AND t.fiscal_year_id = ? AND a.status = ? ORDER BY a.timestamp DESC LIMIT ? OFFSET ?',
  sqlState: '42S22',
  sqlMessage: "Unknown column 't.receipt_no' in 'SELECT'"
}
Error: Unknown column 't.receipt_no' in 'SELECT'
    at /home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/promise/make_done_cb.js:6:24
    at Prepare.onResult (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:807:11)
    at Prepare.execute (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/commands/command.js:36:14)
    at PoolConnection.handlePacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:552:34)
    at PacketParser.onPacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:102:12)
    at PacketParser.executeStart (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.<anonymous> (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:109:25)
    at Socket.emit (node:events:524:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) {
  code: 'ER_BAD_FIELD_ERROR',
  errno: 1054,
  sql: '\n' +
    '      SELECT a.id, a.transaction_id, a.status, a.notes, a.timestamp,\n' +
    '             t.receipt_no, t.amount, t.category_id, t.user_id,\n' +
    '             u.name as user_name, c.name as category_name\n' +
    '      FROM approvals a\n' +
    '      JOIN transactions t ON a.transaction_id = t.id\n' +
    '      JOIN users u ON t.user_id = u.id\n' +
    '      JOIN categories c ON t.category_id = c.id\n' +
    '      WHERE 1=1\n' +
    '     AND t.fiscal_year_id = ? AND a.status = ? ORDER BY a.timestamp DESC LIMIT ? OFFSET ?',
  sqlState: '42S22',
  sqlMessage: "Unknown column 't.receipt_no' in 'SELECT'"
}
Error: Unknown column 't.receipt_no' in 'SELECT'
    at /home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/promise/make_done_cb.js:6:24
    at Prepare.onResult (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:807:11)
    at Prepare.execute (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/commands/command.js:36:14)
    at PoolConnection.handlePacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:552:34)
    at PacketParser.onPacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:102:12)
    at PacketParser.executeStart (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.<anonymous> (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:109:25)
    at Socket.emit (node:events:524:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) {
  code: 'ER_BAD_FIELD_ERROR',
  errno: 1054,
  sql: '\n' +
    '      SELECT a.id, a.transaction_id, a.status, a.notes, a.timestamp,\n' +
    '             t.receipt_no, t.amount, t.category_id, t.user_id,\n' +
    '             u.name as user_name, c.name as category_name\n' +
    '      FROM approvals a\n' +
    '      JOIN transactions t ON a.transaction_id = t.id\n' +
    '      JOIN users u ON t.user_id = u.id\n' +
    '      JOIN categories c ON t.category_id = c.id\n' +
    '      WHERE 1=1\n' +
    '     AND t.fiscal_year_id = ? AND a.status = ? ORDER BY a.timestamp DESC LIMIT ? OFFSET ?',
  sqlState: '42S22',
  sqlMessage: "Unknown column 't.receipt_no' in 'SELECT'"
}
Error: Duplicate entry '1-2026-SL-001' for key 'unique_serial_per_year'
    at Execute.onResult (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/promise/make_done_cb.js:6:24)
    at Execute.execute (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/commands/command.js:36:14)
    at PoolConnection.handlePacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:552:34)
    at PacketParser.onPacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:102:12)
    at PacketParser.executeStart (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.<anonymous> (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:109:25)
    at Socket.emit (node:events:524: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_DUP_ENTRY',
  errno: 1062,
  sql: 'INSERT INTO clients (fiscal_year_id, serial_no, name, designation_id, department_id, account_no, status)\n' +
    "       VALUES (?, ?, ?, ?, ?, ?, 'active')",
  sqlState: '23000',
  sqlMessage: "Duplicate entry '1-2026-SL-001' for key 'unique_serial_per_year'"
}
Error: Duplicate entry '1-2026-SL-001' for key 'unique_serial_per_year'
    at Execute.onResult (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/promise/make_done_cb.js:6:24)
    at Execute.execute (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/commands/command.js:36:14)
    at PoolConnection.handlePacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:552:34)
    at PacketParser.onPacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:102:12)
    at PacketParser.executeStart (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.<anonymous> (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:109:25)
    at Socket.emit (node:events:524: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_DUP_ENTRY',
  errno: 1062,
  sql: 'INSERT INTO clients (fiscal_year_id, serial_no, name, designation_id, department_id, account_no, status)\n' +
    "       VALUES (?, ?, ?, ?, ?, ?, 'active')",
  sqlState: '23000',
  sqlMessage: "Duplicate entry '1-2026-SL-001' for key 'unique_serial_per_year'"
}
Error: Duplicate entry '1-2026-SL-001' for key 'unique_serial_per_year'
    at Execute.onResult (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/promise/make_done_cb.js:6:24)
    at Execute.execute (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/commands/command.js:36:14)
    at PoolConnection.handlePacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:552:34)
    at PacketParser.onPacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:102:12)
    at PacketParser.executeStart (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.<anonymous> (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:109:25)
    at Socket.emit (node:events:524: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_DUP_ENTRY',
  errno: 1062,
  sql: 'INSERT INTO clients (fiscal_year_id, serial_no, name, designation_id, department_id, account_no, status)\n' +
    "       VALUES (?, ?, ?, ?, ?, ?, 'active')",
  sqlState: '23000',
  sqlMessage: "Duplicate entry '1-2026-SL-001' for key 'unique_serial_per_year'"
}
Error: Duplicate entry '1-2026-SL-001' for key 'unique_serial_per_year'
    at Execute.onResult (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/promise/make_done_cb.js:6:24)
    at Execute.execute (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/commands/command.js:36:14)
    at PoolConnection.handlePacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:552:34)
    at PacketParser.onPacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:102:12)
    at PacketParser.executeStart (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.<anonymous> (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:109:25)
    at Socket.emit (node:events:524: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_DUP_ENTRY',
  errno: 1062,
  sql: 'INSERT INTO clients (fiscal_year_id, serial_no, name, designation_id, department_id, account_no, status)\n' +
    "       VALUES (?, ?, ?, ?, ?, ?, 'active')",
  sqlState: '23000',
  sqlMessage: "Duplicate entry '1-2026-SL-001' for key 'unique_serial_per_year'"
}
Error: Duplicate entry '1-2026-SL-001' for key 'unique_serial_per_year'
    at Execute.onResult (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/promise/make_done_cb.js:6:24)
    at Execute.execute (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/commands/command.js:36:14)
    at PoolConnection.handlePacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:552:34)
    at PacketParser.onPacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:102:12)
    at PacketParser.executeStart (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.<anonymous> (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:109:25)
    at Socket.emit (node:events:524: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_DUP_ENTRY',
  errno: 1062,
  sql: 'INSERT INTO clients (fiscal_year_id, serial_no, name, designation_id, department_id, account_no, status)\n' +
    "       VALUES (?, ?, ?, ?, ?, ?, 'active')",
  sqlState: '23000',
  sqlMessage: "Duplicate entry '1-2026-SL-001' for key 'unique_serial_per_year'"
}
Error: Duplicate entry '1-2026-SL-001' for key 'unique_serial_per_year'
    at Execute.onResult (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/promise/make_done_cb.js:6:24)
    at Execute.execute (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/commands/command.js:36:14)
    at PoolConnection.handlePacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:552:34)
    at PacketParser.onPacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:102:12)
    at PacketParser.executeStart (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.<anonymous> (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:109:25)
    at Socket.emit (node:events:524: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_DUP_ENTRY',
  errno: 1062,
  sql: 'INSERT INTO clients (fiscal_year_id, serial_no, name, designation_id, department_id, account_no, status)\n' +
    "       VALUES (?, ?, ?, ?, ?, ?, 'active')",
  sqlState: '23000',
  sqlMessage: "Duplicate entry '1-2026-SL-001' for key 'unique_serial_per_year'"
}
Error: Duplicate entry '1-2026-SL-001' for key 'unique_serial_per_year'
    at Execute.onResult (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/promise/make_done_cb.js:6:24)
    at Execute.execute (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/commands/command.js:36:14)
    at PoolConnection.handlePacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:552:34)
    at PacketParser.onPacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:102:12)
    at PacketParser.executeStart (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.<anonymous> (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:109:25)
    at Socket.emit (node:events:524: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_DUP_ENTRY',
  errno: 1062,
  sql: 'INSERT INTO clients (fiscal_year_id, serial_no, name, designation_id, department_id, account_no, status)\n' +
    "       VALUES (?, ?, ?, ?, ?, ?, 'active')",
  sqlState: '23000',
  sqlMessage: "Duplicate entry '1-2026-SL-001' for key 'unique_serial_per_year'"
}
Error: Duplicate entry '1-2026-SL-001' for key 'unique_serial_per_year'
    at Execute.onResult (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/promise/make_done_cb.js:6:24)
    at Execute.execute (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/commands/command.js:36:14)
    at PoolConnection.handlePacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:552:34)
    at PacketParser.onPacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:102:12)
    at PacketParser.executeStart (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.<anonymous> (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:109:25)
    at Socket.emit (node:events:524: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_DUP_ENTRY',
  errno: 1062,
  sql: 'INSERT INTO clients (fiscal_year_id, serial_no, name, designation_id, department_id, account_no, status)\n' +
    "       VALUES (?, ?, ?, ?, ?, ?, 'active')",
  sqlState: '23000',
  sqlMessage: "Duplicate entry '1-2026-SL-001' for key 'unique_serial_per_year'"
}
Error: Unknown column 't.receipt_no' in 'SELECT'
    at /home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/promise/make_done_cb.js:6:24
    at Prepare.onResult (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:807:11)
    at Prepare.execute (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/commands/command.js:36:14)
    at PoolConnection.handlePacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:552:34)
    at PacketParser.onPacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:102:12)
    at PacketParser.executeStart (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.<anonymous> (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:109:25)
    at Socket.emit (node:events:524:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) {
  code: 'ER_BAD_FIELD_ERROR',
  errno: 1054,
  sql: '\n' +
    '      SELECT a.id, a.transaction_id, a.status, a.notes, a.timestamp,\n' +
    '             t.receipt_no, t.amount, t.category_id, t.user_id,\n' +
    '             u.name as user_name, c.name as category_name\n' +
    '      FROM approvals a\n' +
    '      JOIN transactions t ON a.transaction_id = t.id\n' +
    '      JOIN users u ON t.user_id = u.id\n' +
    '      JOIN categories c ON t.category_id = c.id\n' +
    '      WHERE 1=1\n' +
    '     AND t.fiscal_year_id = ? AND a.status = ? ORDER BY a.timestamp DESC LIMIT ? OFFSET ?',
  sqlState: '42S22',
  sqlMessage: "Unknown column 't.receipt_no' in 'SELECT'"
}
Error: Unknown column 't.receipt_no' in 'SELECT'
    at /home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/promise/make_done_cb.js:6:24
    at Prepare.onResult (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:807:11)
    at Prepare.execute (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/commands/command.js:36:14)
    at PoolConnection.handlePacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:552:34)
    at PacketParser.onPacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:102:12)
    at PacketParser.executeStart (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.<anonymous> (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:109:25)
    at Socket.emit (node:events:524:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) {
  code: 'ER_BAD_FIELD_ERROR',
  errno: 1054,
  sql: '\n' +
    '      SELECT a.id, a.transaction_id, a.status, a.notes, a.timestamp,\n' +
    '             t.receipt_no, t.amount, t.category_id, t.user_id,\n' +
    '             u.name as user_name, c.name as category_name\n' +
    '      FROM approvals a\n' +
    '      JOIN transactions t ON a.transaction_id = t.id\n' +
    '      JOIN users u ON t.user_id = u.id\n' +
    '      JOIN categories c ON t.category_id = c.id\n' +
    '      WHERE 1=1\n' +
    '     AND t.fiscal_year_id = ? AND a.status = ? ORDER BY a.timestamp DESC LIMIT ? OFFSET ?',
  sqlState: '42S22',
  sqlMessage: "Unknown column 't.receipt_no' in 'SELECT'"
}
Error: Unknown column 't.receipt_no' in 'SELECT'
    at /home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/promise/make_done_cb.js:6:24
    at Prepare.onResult (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:807:11)
    at Prepare.execute (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/commands/command.js:36:14)
    at PoolConnection.handlePacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:552:34)
    at PacketParser.onPacket (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:102:12)
    at PacketParser.executeStart (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.<anonymous> (/home/kernostudio/nodevenv/apierincometaxerp.kernostudio.com/20/lib/node_modules/mysql2/lib/base/connection.js:109:25)
    at Socket.emit (node:events:524:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) {
  code: 'ER_BAD_FIELD_ERROR',
  errno: 1054,
  sql: '\n' +
    '      SELECT a.id, a.transaction_id, a.status, a.notes, a.timestamp,\n' +
    '             t.receipt_no, t.amount, t.category_id, t.user_id,\n' +
    '             u.name as user_name, c.name as category_name\n' +
    '      FROM approvals a\n' +
    '      JOIN transactions t ON a.transaction_id = t.id\n' +
    '      JOIN users u ON t.user_id = u.id\n' +
    '      JOIN categories c ON t.category_id = c.id\n' +
    '      WHERE 1=1\n' +
    '     AND t.fiscal_year_id = ? AND a.status = ? ORDER BY a.timestamp DESC LIMIT ? OFFSET ?',
  sqlState: '42S22',
  sqlMessage: "Unknown column 't.receipt_no' in 'SELECT'"
}
