The primary key of the tproperties table is incorrect
what can i do?
server-log: The primary key of the tproperties table is incorrect
https://forum.kopano.io/topic/2090/can-not-upload-attachments could be related to this.
Question is: what did you do before this first started? Performed an update? Could it be a hardware failure?
Easiest is probably to restore from a working backup.
in november 2018 it was ok. i can not restore a backup. because i will lose all data from november to today
What about the questions I asked you?
i don’t know. i think i updated the system in november.
you do not really provide much information to work with.
So what we got so far:
- you last changed anything on the server in November last year (update kopano core packages)
- yesterday you noticed the “The primary key of the tproperties table is incorrect” in your server.log
So unless your system crashed the day before and this corupted your database I would go with “your hdd is about to break down”.
PS: you should really rethink your backup strategy.
can i use kopano-backup to restore the user backups in a new database?
- backup users
- create new database
- konfigure kopano with new database
- restore backups
If you still get your data out, sure why not.