Update to V50 => 2 issues

[Tanguy]

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...

Thanks for your help!

[gborsato]

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

[Tanguy]

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

Good luck !

[Luiggi]

@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