-
Hi, for some time, I've been getting an error using DAVDroid (android app) and SoGo. The error comes up when trying to sync a new contact from android to the server.
The error that Sogo returns is:
ExecutionFailed REASON:Unknown column 'c_hascertificate' in 'field list'The error was already discussed here: https://lists.inverse.ca/sogo/arc/users/2018-01/msg00013.html and came up because of an update in some of the last commits.
The solution from one of the users in the above link was:
"It seems that a new column 'c_hascertificate' was added to the
SoGo-mysql-database around Dec 25th. I was able to resolve this issue by manually adding a column c_hascertificate' (as INT) to the relevant database."Can you update this as well in cloudron?
Thanks, T.
-
@tadeas For more context, see https://cloudron.io/blog/2018-06-04-cloudron-2.3.html. We released a new sogo (scroll down in that blog).
-
@tadeas For more context, see https://cloudron.io/blog/2018-06-04-cloudron-2.3.html. We released a new sogo (scroll down in that blog).
-
So as @girish inidicated, due to the way we initially packaged SOGo, we had to publish an entirely new package for Cloudron lately with a new app ID. That one is not possible to update from the old SOGo package to the new one. The reason is the way we used to map users. So @tadeas if you do not have much data in your SOGo installation now, the easiest way would be to simply install SOGo fresh on your Cloudron, this will pick the new package, however note that the login credentials will be different! The new package works based on the mailboxes on the Cloudron, like other PIM apps with email support.
I will see if we can provide an update to the old package though to fix this issue for users of the old package. -
Alright I managed to publish an update to the old SOGo package, which includes the fix.
@tadeas let me know if this works for you once you update your app instance.
