maghog
commented
1 month ago 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
Steps to reproduce
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'