Project-Sloth/ps-mdt

Database issue

Steviithetv opened this issue · 0 comments

[ script:ps-mdt] SCRIPT ERROR: @ps-mdt/server/main.lua:1658: ps-mdt was unable to execute a query!
[ script:ps-mdt] Query: SELECT p.plate, p.citizenid, m.id FROM player_vehicles p INNER JOIN mdt_convictions m ON p.citizenid = m.cid WHERE m.warrant =1 AND p.plate =?
[ script:ps-mdt] ["AZF 906 "]
[ script:ps-mdt] Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='
[ script:ps-mdt] > GetWarrantStatus (@ps-mdt/server/main.lua:1658)
[ script:ps-mdt] > handler (@ps-mdt/server/main.lua:47)
[ script:ps-mdt] > logError (@oxmysql/dist/build.js:24894)
[ script:ps-mdt] > rawQuery (@oxmysql/dist/build.js:25061)
[ script:ps-mdt] > runMicrotasks (:0)
[ script:ps-mdt] > processTicksAndRejections (node:internal/process/task_queues:96)