Re: [SOGo] Wrong table name
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 : 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/
Re: [SOGo] Wrong table name
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. 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 (p...@vandervlis.nl): >>> 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': >>> 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
Re: [SOGo] Wrong table name
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? Thanks for your reply! With regards, Paul van der Vlis Kind regards, Christian Mack Am 30.08.22 um 22:35 schrieb Paul van der Vlis (p...@vandervlis.nl): 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': 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 -- Paul van der Vlis Linux systeembeheer Groningen https://vandervlis.nl/
Re: [SOGo] Wrong table name
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 Kind regards, Christian Mack Am 30.08.22 um 22:35 schrieb Paul van der Vlis (p...@vandervlis.nl): > 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': > 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
[SOGo] Wrong table name
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': 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 -- Paul van der Vlis Linux systeembeheer Groningen https://vandervlis.nl/
