Hi , Please help we are not able to update to Metabase new version 0.49.5. Error Prompt is attached for reference. Please help how to resolve this issue.
Error :- Caused by : Java.sql. SQLException : You have an error in your SQL syntax : check the manual that corresponds to your MySQL Server version for the right syntax to use near 'agg_recipients' as ( select pulse_channel_id , group_concat
---81 More
Info metabase.core :: Metabase is shutting down .....
Upgrading from what version?
What version of MySQL are you using?
What version of Java?
Upgrading from metabase/metabase:v0.47.8
MySQL version 5.7
Java :- docker exec -it 22ef8a552bee /bin/bash
22ef8a552bee:/# java -version
openjdk version "11.0.21" 2023-10-17
OpenJDK Runtime Environment Temurin-11.0.21+9 (build 11.0.21+9)
OpenJDK 64-Bit Server VM Temurin-11.0.21+9 (build 11.0.21+9, mixed mode)
22ef8a552bee:/#
We are upgrading through images available on metabase using Pull image
Line 2 is the problem - time to upgrade to a later version of MySQL.
Thanks, this issue is resolved post updating Mysql to 8
But now the issue is Dashboards are showing null results where filters are set to Required Field. then these values are shown as null. Can you please help out with this.