[MySQL] Error loading trips from DB: Error: Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='
    at fetchTripsFromDb (/home/asystemc/public_html/trip/dist/server.cjs:216:31)
    at /home/asystemc/public_html/trip/dist/server.cjs:428:27
    at Layer.handle [as handle_request] (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/layer.js:95:5)
    at next (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/route.js:149:13)
    at Route.dispatch (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/route.js:119:3)
    at Layer.handle [as handle_request] (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/layer.js:95:5)
    at /home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/index.js:284:15
    at Function.process_params (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/index.js:346:12)
    at next (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/index.js:280:10)
    at jsonParser (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/body-parser/lib/types/json.js:113:7) {
  code: 'ER_CANT_AGGREGATE_2COLLATIONS',
  errno: 1267,
  sqlState: 'HY000',
  sqlMessage: "Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='",
  sql: '\n' +
    '      SELECT t.*, k.nama_karyawan, k.nomor_ktp, k.jabatan_db, k.prinsiple, k.area, k.region, k.pimpinan\n' +
    '      FROM tb_perjalanan t\n' +
    '      LEFT JOIN tb_karyawan k ON t.request_by_email = k.email\n' +
    '      ORDER BY t.created_at DESC\n' +
    '    '
}
[MySQL] Error loading trips from DB: Error: Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='
    at fetchTripsFromDb (/home/asystemc/public_html/trip/dist/server.cjs:216:31)
    at /home/asystemc/public_html/trip/dist/server.cjs:428:27
    at Layer.handle [as handle_request] (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/layer.js:95:5)
    at next (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/route.js:149:13)
    at Route.dispatch (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/route.js:119:3)
    at Layer.handle [as handle_request] (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/layer.js:95:5)
    at /home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/index.js:284:15
    at Function.process_params (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/index.js:346:12)
    at next (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/index.js:280:10)
    at jsonParser (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/body-parser/lib/types/json.js:113:7) {
  code: 'ER_CANT_AGGREGATE_2COLLATIONS',
  errno: 1267,
  sqlState: 'HY000',
  sqlMessage: "Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='",
  sql: '\n' +
    '      SELECT t.*, k.nama_karyawan, k.nomor_ktp, k.jabatan_db, k.prinsiple, k.area, k.region, k.pimpinan\n' +
    '      FROM tb_perjalanan t\n' +
    '      LEFT JOIN tb_karyawan k ON t.request_by_email = k.email\n' +
    '      ORDER BY t.created_at DESC\n' +
    '    '
}
[MySQL] Error loading trips from DB: Error: Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='
    at fetchTripsFromDb (/home/asystemc/public_html/trip/dist/server.cjs:216:31)
    at /home/asystemc/public_html/trip/dist/server.cjs:428:27
    at Layer.handle [as handle_request] (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/layer.js:95:5)
    at next (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/route.js:149:13)
    at Route.dispatch (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/route.js:119:3)
    at Layer.handle [as handle_request] (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/layer.js:95:5)
    at /home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/index.js:284:15
    at Function.process_params (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/index.js:346:12)
    at next (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/index.js:280:10)
    at jsonParser (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/body-parser/lib/types/json.js:113:7) {
  code: 'ER_CANT_AGGREGATE_2COLLATIONS',
  errno: 1267,
  sqlState: 'HY000',
  sqlMessage: "Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='",
  sql: '\n' +
    '      SELECT t.*, k.nama_karyawan, k.nomor_ktp, k.jabatan_db, k.prinsiple, k.area, k.region, k.pimpinan\n' +
    '      FROM tb_perjalanan t\n' +
    '      LEFT JOIN tb_karyawan k ON t.request_by_email = k.email\n' +
    '      ORDER BY t.created_at DESC\n' +
    '    '
}
[MySQL] Error loading trips from DB: Error: Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='
    at fetchTripsFromDb (/home/asystemc/public_html/trip/dist/server.cjs:216:31)
    at /home/asystemc/public_html/trip/dist/server.cjs:428:27
    at Layer.handle [as handle_request] (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/layer.js:95:5)
    at next (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/route.js:149:13)
    at Route.dispatch (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/route.js:119:3)
    at Layer.handle [as handle_request] (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/layer.js:95:5)
    at /home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/index.js:284:15
    at Function.process_params (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/index.js:346:12)
    at next (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/index.js:280:10)
    at jsonParser (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/body-parser/lib/types/json.js:113:7) {
  code: 'ER_CANT_AGGREGATE_2COLLATIONS',
  errno: 1267,
  sqlState: 'HY000',
  sqlMessage: "Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='",
  sql: '\n' +
    '      SELECT t.*, k.nama_karyawan, k.nomor_ktp, k.jabatan_db, k.prinsiple, k.area, k.region, k.pimpinan\n' +
    '      FROM tb_perjalanan t\n' +
    '      LEFT JOIN tb_karyawan k ON t.request_by_email = k.email\n' +
    '      ORDER BY t.created_at DESC\n' +
    '    '
}
[MySQL] Error loading trips from DB: Error: Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='
    at fetchTripsFromDb (/home/asystemc/public_html/trip/dist/server.cjs:216:31)
    at /home/asystemc/public_html/trip/dist/server.cjs:428:27
    at Layer.handle [as handle_request] (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/layer.js:95:5)
    at next (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/route.js:149:13)
    at Route.dispatch (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/route.js:119:3)
    at Layer.handle [as handle_request] (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/layer.js:95:5)
    at /home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/index.js:284:15
    at Function.process_params (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/index.js:346:12)
    at next (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/index.js:280:10)
    at jsonParser (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/body-parser/lib/types/json.js:113:7) {
  code: 'ER_CANT_AGGREGATE_2COLLATIONS',
  errno: 1267,
  sqlState: 'HY000',
  sqlMessage: "Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='",
  sql: '\n' +
    '      SELECT t.*, k.nama_karyawan, k.nomor_ktp, k.jabatan_db, k.prinsiple, k.area, k.region, k.pimpinan\n' +
    '      FROM tb_perjalanan t\n' +
    '      LEFT JOIN tb_karyawan k ON t.request_by_email = k.email\n' +
    '      ORDER BY t.created_at DESC\n' +
    '    '
}
[MySQL] Error loading trips from DB: Error: Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='
    at fetchTripsFromDb (/home/asystemc/public_html/trip/dist/server.cjs:216:31)
    at /home/asystemc/public_html/trip/dist/server.cjs:428:27
    at Layer.handle [as handle_request] (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/layer.js:95:5)
    at next (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/route.js:149:13)
    at Route.dispatch (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/route.js:119:3)
    at Layer.handle [as handle_request] (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/layer.js:95:5)
    at /home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/index.js:284:15
    at Function.process_params (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/index.js:346:12)
    at next (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/express/lib/router/index.js:280:10)
    at jsonParser (/home/asystemc/nodevenv/public_html/trip/20/lib/node_modules/body-parser/lib/types/json.js:113:7) {
  code: 'ER_CANT_AGGREGATE_2COLLATIONS',
  errno: 1267,
  sqlState: 'HY000',
  sqlMessage: "Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='",
  sql: '\n' +
    '      SELECT t.*, k.nama_karyawan, k.nomor_ktp, k.jabatan_db, k.prinsiple, k.area, k.region, k.pimpinan\n' +
    '      FROM tb_perjalanan t\n' +
    '      LEFT JOIN tb_karyawan k ON t.request_by_email = k.email\n' +
    '      ORDER BY t.created_at DESC\n' +
    '    '
}