rdio-scanner icon indicating copy to clipboard operation
rdio-scanner copied to clipboard

v7 Wip sql issue when adding access codes

Open TNScanner opened this issue 1 year ago • 0 comments

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. Screenshot from 2024-11-20 12-58-15 Screenshot from 2024-11-20 12-58-43

TNScanner avatar Nov 20 '24 18:11 TNScanner