Update to V50 => 2 issues

Hello all,

I updated today from 0.47.4 to 0.50.26.1 (running on Docker /w MySQL).

I have two weird issues:

  • Cumulative sum: I can't use anymore cumulative sum (nombre cumulé in french).
    • My error is 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 '(ORDER BY source.created_at ASC ROWS UNBOUNDED PRECEDING) AS count FROM (S' at line 2
    • I don't sort my result... And it was working fine previously

  • Why don't I have any more lists when I want to filter?
    • In the past, if I wanted to filter on "status", I would have all the "status" possible listed. Now, when I select Status => IS => I only have a text area...
    • I tried to "reload" my tables to be sure it is understood by the system but it didn't change anything...

CleanShot 2024-09-24 at 12.30.55

Thanks for your help!

Hi Tanguy

I am having a similar error after upgrading from 0.47.6 to 0.50.26 . The cumulative sum function is not working anymore.
The error I receive is the following :

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 '(PARTITION BY source.Hora do Horário da impressão ORDER BY source.`data_' at line 2

Hey Gborsato,
Unfortunately, I didn't find any help for the moment...

Good luck !

@Tanguy check Cumulative Sums and Counts not working with MySQL 5.7 in v0.50 due to CTE · Issue #45142 · metabase/metabase · GitHub

Also, tell us what's the field config when you go to settings->admin->table metadata for the one that you don't see the values on