Re: [SOGo] MySQL errors

[Ian]

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', 'ji...@crumjones.com', 0, 1433742600, 'i...@iljones.org', '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 <supp...@inverse.ca> 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