Where I work we’ve had a long standing problem with the roadmap view in Trac with the Agilo plugin. We were seeing a “ticket 0 does not exist error” and after finally finding the right keywords to search with, I found my answer. Turns out that if you’re using PostgreSQL as your database backend, any Sprints that have a ‘ in the name will cause the roadmap to stop working. The fix is to simply rename any Sprints so they don’t have a ‘ in their name.
A better fix would be to patch the code to properly sqlquote sprint names. What you have described is a workaround not a fix.
I completely agree but not everyone has the expertise to fix this issue or even the needed access.