v7 Wip sql issue when adding access codes
Whenever I enable access codes and relate them to the proper system, I start having issues with the rdio not loading after the access code is entered. Additionally, I'm unable to search older calls—the page just keeps loading. Once I remove the access keys, the page starts working properly again.
This is the error I get in the logs:
lient.processmessage: controller.processmessage.commandlistcall: calls.search: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '%!d(float64=13)) ORDER BY c."timestamp" ASC' at line 1 in SELECT c."timestamp" FROM "calls" AS c LEFT JOIN "systems" AS s ON s."systemId" = c."systemId" LEFT JOIN "talkgroups" AS t ON t."talkgroupId" = c."talkgroupId" LEFT JOIN "delayed" AS d ON d."callId" = c."callId" WHERE (s."systemRef" = %!d(float64=13)) ORDER BY c."timestamp" ASC
I know this is still a work in progress, and you might have already fixed it, but I wanted to give you a heads-up.