No Tables shown after Update to 0.7.4 / `Integrity constraint violation: 1062 Duplicate entry [...] for key 'PRIMARY'`

[moj02090]

Steps to reproduce

1. Update to 0.7.4
2. Open Tables

Expected behavior

Show all available tables and no error message

Actual behavior

No tables are shown and an error message "could not load tables unexpected error" is shown

Tables app version

0.7.4

Browser

Brave 1.68

Client operating system

Windows 11 Pro

Operating system

Ubuntu 22.04 LTS Docker

Web server

Nginx

PHP engine version

PHP 8.3

Database

MariaDB

Additional info

The tables are still present in db, I can see theam in my db dump.

I tried this occ command tables:legacy:transfer:rows --all

With following output:

-- Start transfer for table 3 (Backups) [1/4] ---- Found 2 columns ---- Found 0 rows ---- ✅ All rows transferred.

-- Start transfer for table 6 (Vertraege) [2/4] ---- Found 13 columns ---- Found 19 rows ⚠️ Could not transfer data. Continue with next table. The logs will have more information about the error: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '16' for key 'PRIMARY'

-- Start transfer for table 8 (Konten) [3/4] ---- Found 5 columns ---- Found 6 rows ⚠️ Could not transfer data. Continue with next table. The logs will have more information about the error: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '30' for key 'PRIMARY'

-- Start transfer for table 11 (Crypto Adressen) [4/4] ---- Found 4 columns ---- Found 4 rows ⚠️ Could not transfer data. Continue with next table. The logs will have more information about the error: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '47' for key 'PRIMARY'

[maghog]

I get the same issue when upgrading from 0.7.5 to 0.8.1.

-- Start transfer for table 3 (Loggbok) [1/5] ---- Found 4 columns ---- Found 70 rows ⚠️ Could not transfer data. Continue with next table. The logs will have more information about the error: An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '96' for key 'PRIMARY'

I also get: [tables] Varning: An internal error or exception occurred: usergroupDefault is not a valid attribute GET /nextcloud/index.php/apps/tables/view/9