Update to 0.8.0 Tables problems, again

[Jednadvacet]

Steps to reproduce

1. Update to Tables 0.8.0 on self-hosted NC 29.0.7

Expected behavior

Tables app being able to work.

Actual behavior

Tables app not working.

Tables app version

0.8.0

Browser

No response

Client operating system

No response

Operating system

Ubuntu 20.04

Web server

Nginx

PHP engine version

PHP 8.3

Database

PostgreSQL

Additional info

Hi all.

After update to Tables 0.8.0 (updated automatically during NC version 29.0.6 to 29.0.7) it is not possible to add new rows to existing tables. It is not even possible to add columns neither to existing tables, nor the new ones. I can only update existing rows. Existing table/views shares are not functional as well. I can create a new table but importing data gives an error as well.

Few log errors appeared:

1. adding new rows

DbalException
An exception occurred while executing a query: SQLSTATE[23505]: Unique violation: 7 ERROR: duplicate key value violates unique constraint "oc_tables_row_sleeves_pkey" DETAIL: Key (id)=(353) already exists.

2. sharing tables

Exception
Cannot assign array to property OCA\Tables\Db\View::$onSharePermissions of type ?OCA\Tables\Model\Permissions in file '/var/www/html/nextcloud/cloud.live/lib/public/AppFramework/Db/Entity.php' line 136

3. deleting empty testing tables

Exception
Call to undefined method OCA\Tables\Service\ContextService::deleteNodeRel() in file '/var/www/html/nextcloud/cloud.live/custom_apps/tables/lib/Service/TableService.php' line 457

I am quite desperate now.

[enjeck]

An exception occurred while executing a query: SQLSTATE[23505]: Unique violation: 7 ERROR: duplicate key value violates unique constraint "oc_tables_row_sleeves_pkey" DETAIL: Key (id)=(353) already exists.

I see you faced a similar issue at #1029 (comment). Does running occ maintenance:repair get fix this first problem?