thewca / statistics

12 stars 16 forks source link

Error message using custom function for displaying results #79

Closed dunkOnIT closed 2 years ago

dunkOnIT commented 2 years ago

This came in via the WST email - though it would be best to put it here so you can work on it when you get a chance :)

Been loving the new WCA Statistics page, but it seems permissions have been denied for the custom function for displaying results. Here is the Error message:

< StatementCallback; bad SQL grammar [select count(*) from ( SELECT wca_statistics_time_format(347, '333', 'single') ) alias]; nested exception is java.sql.SQLSyntaxErrorException: execute command denied to user 'read_only'@'%' for routine 'wca_development.wca_statistics_time_format' >

It's a great function that I'd love to utilise, so this would be great to have access to! Amazing work on the rest of this site.