Hello Christian and others,
Thanks for your responce!
Op 31-08-2022 om 18:30 schreef Christian Mack
(christian.m...@uni-konstanz.de):
Hello
Am 31.08.22 um 13:39 schrieb Paul van der Vlis (p...@vandervlis.nl):
Hello Christian, hello group,
Op 31-08-2022 om 11:28 schreef Christian Mack
(christian.m...@uni-konstanz.de):
Hello
From which version did you upgrade?
Perhaps you have to run:
/usr/share/doc/sogo/sql-update-3.2.10_to_4.0.0-mysql.sh
I did run that script so far I know, and I see it in my bash_history,
but it is possible something went wrong with it.
Would it be a problem to run it twice?
Does the script rename the name of excisting tables?
It will change some tables, but not rename them.
You can safely run it as often as you like, it will change nothing after
the first run.
This is a very small server, I think there is only one active user left
at the moment. He had problems on his phone, but after reinstalling
DAVx⁵ that problem seems to be gone. But I still saw errors in the log.
I did run the script again. I saw some errors:
-------------
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1060 (42S21) at line 1: Duplicate column name 'c_hascertificate'
ERROR 1146 (42S02) at line 1: Table 'sogo.sogojk0013c1348af_quick'
doesn't exist
ERROR 1146 (42S02) at line 1: Table 'sogo.sogojk0013c1348af_quick'
doesn't exist
-------------
After this, I see some errors about that table in the logs, it seems to
be the only table what gives errors:
-----------
Sep 01 10:39:53 sogod [2336490]: <0x0x55f7d4deeb60[GCSFolder]>
ERROR(-[GCSFolder
writeContent:fromComponent:container:toName:baseVersion:]): cannot
insert content : <MySQL4Exception: 0x55f7d5159bb0> NAME:ExecutionFailed
REASON:Table 'sogo.sogojk0013c1348af_quick' doesn't exist
-----------
What could point at that table-name?
There is also no "sogojk0013c1348af" or "sogojk0013c1348af_acl" table.
Sorry, I misread your error message.
You don't have that table altogether, instead of "just" missing a column.
I never had that myself.
With regards,
Paul van der Vlis
--
Paul van der Vlis Linux systeembeheer Groningen
https://vandervlis.nl/
