Database Error migrating from 7.0.2 to 7.0.3 blocking my Nextcloud

[LutzPx23]

Hi,
when do this migration, I receive the following database error:

Database error when running migration 070002Date20241020160425 for app gpxpod
An exception occurred while executing a query: SQLSTATE[42803]: Grouping error: 7
ERROR: column "oc_gpxpod_directories.id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: SELECT "id", "user", "path", COUNT(*) FROM "oc_gpxpod_direct...\n

Ciao, Lutz

[julien-nc]

Thanks for reporting this. Can you replace the content of lib/Migration/Version070002Date20241020160425.php by https://github.com/julien-nc/gpxpod/blob/fix/64/groupby/lib/Migration/Version070002Date20241020160425.php and try again?

If that works I'll include this change in a release very soon.

[floviolleau]

Hi,

Works fine for me.

Thanks!

[julien-nc]

Thanks for the feedback. I'll probably make a release later today.
Also, which kind of database are you using? Postgres?

[floviolleau]

On my side mysql.