Explore Mods

for 𝔲𝔫𝔨𝔫𝔬𝔴𝔫 Development

If you are getting a console error like this when creating shared accounts then you need to fix your SQL. There error I saw when creating a shared account was (below): [ script:qbx_core] SCRIPT ERROR: citizen:/scripting/lua/scheduler.lua:580: SCRIPT ERROR: unknown_banking was unable to execute a query! [ script:qbx_core] Query: SELECT m.id, m.identifier, m.role, m.added_at, JSON_UNQUOTE(JSON_EXTRACT(p.charinfo, '$.firstname')) as firstname, JSON_UNQUOTE(JSON_EXTRACT(p.charinfo, '$.lastname')) as lastname FROM unknown_bank_shared_members m LEFT JOIN players p ON p.citizenid = m.identifier WHERE m.shared_account_id = ? [ script:qbx_core] [1] [ script:qbx_core] Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_uca1400_ai_ci,IMPLICIT) for operation '=' The players table uses collation utf8mb4_uca1400_ai_ci while unknown_bank_shared_members uses utf8mb4_unicode_ci. MySQL can't compare p.citizenid to m.identifier across the JOIN because they're collated differently. To fix your issue, run this in your database: