Hi there, we had the same problems and needed to write the value of OCSFolderInfoURL into our /etc/sogo/sogo.conf. According to http://www.sogo.nu/nc/support/faq/article/how-do-i-configure-sogo-to-use-mysql.html it was configured only in the defaults.
We got the value with "defaults read sogod“. The script seems to expect the value in the configuration file, not in the defaults. Cheerio, Filias > Am 08.06.2015 um 17:34 schrieb Ian <[email protected]>: > > Hello again: > > ERROR 1060 (42S21) at line 1: Duplicate column name 'c_description' > > The column is there: > > mysql> show columns from sogojinnycru0042207df01_quick; > +------------------+---------------+------+-----+---------+-------+ > | Field | Type | Null | Key | Default | Extra | > +------------------+---------------+------+-----+---------+-------+ > | c_name | varchar(255) | NO | PRI | NULL | | > | c_uid | varchar(255) | NO | | NULL | | > | c_startdate | int(11) | YES | | NULL | | > | c_enddate | int(11) | YES | | NULL | | > | c_cycleenddate | int(11) | YES | | NULL | | > | c_title | varchar(1000) | NO | | NULL | | > | c_participants | mediumtext | YES | | NULL | | > | c_isallday | int(11) | YES | | NULL | | > | c_iscycle | int(11) | YES | | NULL | | > | c_cycleinfo | mediumtext | YES | | NULL | | > | c_classification | int(11) | NO | | NULL | | > | c_isopaque | int(11) | NO | | NULL | | > | c_status | int(11) | NO | | NULL | | > | c_priority | int(11) | YES | | NULL | | > | c_location | varchar(255) | YES | | NULL | | > | c_orgmail | varchar(255) | YES | | NULL | | > | c_partmails | mediumtext | YES | | NULL | | > | c_partstates | mediumtext | YES | | NULL | | > | c_category | varchar(255) | YES | | NULL | | > | c_sequence | int(11) | YES | | NULL | | > | c_component | varchar(10) | NO | | NULL | | > | c_nextalarm | int(11) | YES | | NULL | | > | c_description | mediumtext | YES | | NULL | | > +------------------+---------------+------+-----+---------+-------+ > 23 rows in set (0.00 sec) > > > Regards, > Ian > > > Le 08/06/2015 14:02, Kamaldeep Singh a écrit : >> Hi Ian, >> >> Please run this script as a sogo user. >> >> Thanks, >> Kamaldeep Singh >> >> On Monday 08 June 2015 04:47 PM, Ian wrote: >>> Hello Kamaldeep, and thanks for the reply. >>> >>> My /usr/share/doc/sogo contains the following: >>> >>> apache.conf sql-update-1.2.2_to_1.3.0-mysql.sh >>> sql-update-20070724.sh >>> changelog.Debian.gz sql-update-1.2.2_to_1.3.0.sh >>> sql-update-20070822.sh >>> changelog.gz sql-update-1.3.11_to_1.3.12-mysql.sh >>> sql-update-20080303.sh >>> copyright sql-update-1.3.11_to_1.3.12.sh >>> sql-update-2.0.4b_to_2.0.5-mysql.sh >>> NEWS.gz sql-update-1.3.16_to_1.3.17-mysql.sh >>> sql-update-2.1.17_to_2.3.0-mysql.sh >>> SOGo-apple-ab.conf sql-update-1.3.16_to_1.3.17.sh >>> sql-update-2.1.17_to_2.3.0.sh >>> sogo-backup.sh sql-update-1.3.3_to_1.3.4-mysql.sh updates.php >>> sql-update-101_to_102.sh sql-update-1.3.3_to_1.3.4.sh >>> >>> I ran sql-update-2.1.17_to_2.3.0-mysql.sh, but I'm still getting errors: >>> >>> Jun 08 11:14:33 sogod [12323]: [ERROR] <0x0xb8012e90[GCSFolder]> >>> -[GCSFolder _generateInsertStatementForRow:adaptor:tableName:]: no type >>> found for column name c_description >>> 2015-06-08 11:14:33.128 sogod[12323] <MySQL4Channel[0x0xb7a28078] >>> connection=0x0xb7ad7be0> SQL: INSERT INTO sogojinnycru0042207df01_quick >>> (c_isopaque, c_partstates, c_isallday, c_nextalarm, c_participants, >>> c_status, c_sequence, c_component, c_priority, c_enddate, c_description, >>> c_category, c_iscycle, c_location, c_title, c_uid, c_partmails, >>> c_classification, c_startdate, c_orgmail, c_name) VALUES (1, '0', 0, 0, >>> 'Jinny Crum-Jones', 1, 2, 'vevent', 0, 1433746200, 'Divers', 0, '', 'Test >>> event', '08877588-fd70-4a0e-94bf-976524d02966', '[email protected]', 0, >>> 1433742600, '[email protected]', '08877588-fd70-4a0e-94bf-976524d02966.ics'); >>> 2015-06-08 11:14:33.128 sogod[12323] <MySQL4Channel[0x0xb7a28078] >>> connection=0x0xb7ad7be0> ERROR: Column count doesn't match value count at >>> row 1 >>> >>> >>> Regards >>> Ian >>> >>> Le 08/06/2015 12:44, Kamaldeep Singh a écrit : >>>> Hi Ian, >>>> >>>> If you had upgraded the SOGO to 2.3 then you need to run database upgrade >>>> script which may be located in /usr/share/doc/sogo-2.3.0. >>>> >>>> >>>> Thanks, >>>> Kamaldeep Singh >>>> On Monday 08 June 2015 08:53 AM, Ian wrote: >>>>> Hello! >>>>> >>>>> I am getting errors like the following: >>>>> >>>>> SQL: INSERT INTO sogojinnycru0060246e923_quick (c_isopaque, c_partstates, >>>>> c_isallday, c_nextalarm, c_status, c_sequence, c_component, c_priority, >>>>> c_enddate, c_iscycle, c_category, c_description, c_location, c_title, >>>>> c_uid, c_classification, c_startdate, c_orgmail, c_name) VALUES (1, '', >>>>> 0, 0, 1, 0, 'vevent', 0, 1438187220, 0, null, 'ORD to MCO', 'flight:', >>>>> '743058BD-AA78-477E-B1A2-9732E73ED4B3', 0, 1438177200, '', >>>>> '743058BD-AA78-477E-B1A2-9732E73ED4B3.ics'); >>>>> 2015-06-08 03:15:10.261 sogod[9757] <MySQL4Channel[0x0xb98d33e8] >>>>> connection=0x0xb999d580> ERROR: Column count doesn't match value count >>>>> at row 1 >>>>> >>>>> And indeed, if you count the fields and values there are 19 and 18 >>>>> respectively. Any suggestions? >>>>> >>>>> Thanks, >>>>> Ian >>>>> >>>>> dpkg -s sogo >>>>> Package: sogo >>>>> Status: install ok installed >>>>> Priority: optional >>>>> Section: web >>>>> Installed-Size: 12577 >>>>> Maintainer: Inverse Support <[email protected]> >>>>> Architecture: i386 >>>>> Multi-Arch: same >>>>> Version: 2.3.0-1 >>>>> >>>>> >>>>> >>>> >>>> -- >>>> Kamaldeep Singh >>>> System Administrator >>>> >>>> Direct: +91 124 4548380 >>>> Tel: +91 124 4548383 Ext- 1007 >>>> UK: +44 845 0047 142 Ext- 5010 >>>> >>>> >>>> >>>> >>>> Techblue Software Pvt. Ltd >>>> The Palms, Plot No 73, Sector 5, IMT Manesar, >>>> Gurgaon- 122050 (Hr.) >>>> www.techbluesoftware.co.in >>>> >>>> >>>> >>>> >>>> >>>> >>> >> >> -- >> Kamaldeep Singh >> System Administrator >> >> Direct: +91 124 4548380 >> Tel: +91 124 4548383 Ext- 1007 >> UK: +44 845 0047 142 Ext- 5010 >> >> >> >> >> Techblue Software Pvt. Ltd >> The Palms, Plot No 73, Sector 5, IMT Manesar, >> Gurgaon- 122050 (Hr.) >> www.techbluesoftware.co.in >> >> >> >> >> >> > >
signature.asc
Description: Message signed with OpenPGP using GPGMail
