SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'oc_user_status.PRIMARY'

Hey,

I’m getting a lot of errors in my nextcloud:

DbalException An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'oc_user_status.PRIMARY'
Exception thrown: OC\DB\Exceptions\DbalException

Nextcloud version: 28.0.3

My table oc_user_status’s structure looks like this:

It contains the following data:

I’m only confused why their is He… and _He… (the same but with _) and why there is my the account th… also with _ (but not without it).

The account th… has no problems, is logged in at the moment and can access all of his files. He… also without problems at least what I know. But the account hi… has problems. Most folders look empty althought there is lot of files inside:

When I try to open the main folder it throws the exception:

[webdav] Error: Cannot decrypt this file, probably this is a shared file. Please ask the file owner to reshare the file with you.
	PROPFIND /remote.php/dav/files/hi.../
	from 194.95.... by hi... at 03.03.2024, 10:42:10

May those errors be connected? Ideas how to fix them?

Thanks for your help.
Carsten

I’m still having this problems with the account hi…
Also update to 28.0.4.1 is not improving anything.

Today when this account logs in I’m getting the error:

 DbalException An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'oc_talk_rooms.PRIMARY'
Exception thrown: OC\DB\Exceptions\DbalException

Files still not accessible.

Any ideas?