having a issue with ps-mdt

[Chill527]

the mdt is working apart from reading the players details from the database .
iv ran it on a older version on qb where i was having a different issue with the incidents not working but now iv updated to the newest qb and it will create the reports and incidents but if i try get any player data through the mdt i get errors in the console and it wont load. any help would be much appreciated.

[ script:qb-core] SCRIPT ERROR: citizen:/scripting/lua/scheduler.lua:739: SCRIPT ERROR: @ps-mdt/server/main.lua:256: ps-mdt was unable to execute a query!
[ script:qb-core] Query: SELECT p.citizenid, p.charinfo, md.pfp, md.fingerprint FROM players p LEFT JOIN mdt_data md on p.citizenid = md.cid WHERE LOWER(CONCAT(JSON_VALUE(p.charinfo, '$.firstname'), ' ', JSON_VALUE(p.charinfo, '$.lastname'))) LIKE ? OR LOWER(charinfo) LIKE ? OR LOWER(citizenid) LIKE ? OR LOWER(md.fingerprint) LIKE ? AND jobtype = ? LIMIT 20
[ script:qb-core] ["%test%","%test%","%test%","%test%","police"]
[ script:qb-core] Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='
[ script:qb-core] > ref (@ps-mdt/server/main.lua:256)
[ script:qb-core] > logError (@oxmysql/dist/build.js:24894)
[ script:qb-core] > rawQuery (@oxmysql/dist/build.js:25061)
[ script:qb-core] > processTicksAndRejections (node:internal/process/task_queues:96)
[ script:qb-core]
[ script:qb-core] > TriggerCallback (@qb-core/server/functions.lua:365)
[ script:qb-core] > handler (@qb-core/server/events.lua:104)
[ script:qb-core] > logError (@oxmysql/dist/build.js:24894)
[ script:qb-core] > rawQuery (@oxmysql/dist/build.js:25061)
[ script:qb-core] > processTicksAndRejections (node:internal/process/task_queues:96)

[ script:ps-mdt] SCRIPT ERROR: @ps-mdt/server/main.lua:847: ps-mdt was unable to execute a query!
[ script:ps-mdt] Query: SELECT p.citizenid, p.charinfo, p.metadata, md.pfp from players p LEFT JOIN mdt_data md on p.citizenid = md.cid WHERE (LOWER(JSON_UNQUOTE(JSON_EXTRACT(charinfo, '$.firstname'))) LIKE ? AND LOWER(JSON_UNQUOTE(JSON_EXTRACT(charinfo, '$.lastname'))) LIKE ?) OR LOWER(citizenid) LIKE ? AND jobtype = ? LIMIT 30
[ script:ps-mdt] ["%test%","%%","%test%","police"]
[ script:ps-mdt] Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='
[ script:ps-mdt] > handler (@ps-mdt/server/main.lua:847)
[ script:ps-mdt] > logError (@oxmysql/dist/build.js:24894)
[ script:ps-mdt] > rawQuery (@oxmysql/dist/build.js:25061)
[ script:ps-mdt] > processTicksAndRejections (node:internal/process/task_queues:96)