Hello
Am 31.08.22 um 13:39 schrieb Paul van der Vlis ([email protected]): > Hello Christian, hello group, > > Op 31-08-2022 om 11:28 schreef Christian Mack > ([email protected]): >> 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. Sorry, I misread your error message. You don't have that table altogether, instead of "just" missing a column. I never had that myself. Kind regards, Christian Mack >> Am 30.08.22 um 22:35 schrieb Paul van der Vlis ([email protected]): >>> Hello all, >>> >>> I have a strange problem. After upgrade to SOGo version 5.01 (from >>> Debian stable) I see this type of errors: >>> -------- >>> Aug 30 04:25:12 sogod [15839]: [ERROR] <0x0x5577ff4f8b80[GCSFolder]> >>> -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot >>> execute quick-fetch SQL 'SELECT c_lastmodified FROM sogojk00158b7a148 >>> ORDER BY c_lastmodified DESC': <MySQL4Exception: 0x5577ff4f7580> >>> NAME:ExecutionFailed REASON:Table 'sogo.sogojk00158b7a148' doesn't exist >>> -------- >>> >>> When I look into MariaDB I see the table names are different! >>> For this user I see these tables: >>> -------- >>> sogojk0012d8ec8c3 >>> sogojk0012d8ec8c3_acl >>> sogojk0012d8ec8c3_quick >>> sogojk0022fcb5a6d >>> sogojk0022fcb5a6d_acl >>> sogojk0022fcb5a6d_quick >>> sogojk0030458f141 >>> sogojk0030458f141_acl >>> sogojk0030458f141_quick >>> -------- >>> >>> What could be causing this problem? >>> >>> With regards, >>> Paul van der Vlis >>> >>> >>> >> >> > -- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung IT-Dienste Forschung, Lehre, Infrastruktur 78457 Konstanz +49 7531 88-4416
smime.p7s
Description: S/MIME Cryptographic Signature
