Project-Sloth/ps-mdt

Problem researching player

Closed this issue · 0 comments

Nobbls commented

I get this error when the mdt is trying to research players.

[ script:ps-mdt] SCRIPT ERROR: @ps-mdt/server/main.lua:852: 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] ["%jaja%","%%","%jaja%","police"]
[ script:ps-mdt] Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='