[ERROR] <0x0xb9eb7180[GCSFolder]> -[GCSFolder _generateInsertStatementForRow:adaptor:tableName:]: no type found for column name c_description 2015-06-09 12:14:44.966 sogod[6038] <MySQL4Channel[0x0xb9e59f50] connection=0x0xb9b77540> SQL: INSERT INTO sogoianiljon002067e9026_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, 1434456000, 0, 'Divers', '', 'Test events', '76f868e0-e01e-419a-955f-d88e9bc31832', 0, 1434452400, '', '76f868e0-e01e-419a-955f-d88e9bc31832.ics');
since the table sogoianiljon002067e9026_quick does have the column c_description and its type is mediumtext. I suppose the insert error follows from the first problem.
Regards,
Ian
sogo.conf:
{
SOGoProfileURL =
"mysql://sogo:squashed@localhost:3306/sogo/sogo_user_profile";
OCSFolderInfoURL =
"mysql://sogo:squashed@localhost:3306/sogo/sogo_folder_info";
OCSSessionsFolderURL =
"mysql://sogo:squashed@localhost:3306/sogo/sogo_sessions_folder";
OCSEMailAlarmsFolderURL =
"mysql://sogo:squashed@localhost:3306/sogo/sogo_alarms_folder";
SOGoLanguage = English;
SOGoAppointmentSendEMailNotifications = YES;
SOGoMailingMechanism = smtp;
SOGoSMTPServer = mx;
SOGoTimeZone = UTC;
SOGoSentFolderName = Sent;
SOGoTrashFolderName = Trash;
SOGoDraftsFolderName = Drafts;
SOGoIMAPServer = "imap://mx";
SOGoSieveServer = "sieve://mx";
SOGoIMAPAclConformsToIMAPExt = YES;
SOGoVacationEnabled = NO;
SOGoForwardEnabled = NO;
SOGoSieveScriptsEnabled = NO;
SOGoFirstDayOfWeek = 0;
SOGoMailMessageCheck = manually;
SOGoMailAuxiliaryUserAccountsEnabled = NO;
SOGoTrashFolderName = "INBOX/Trash";
SOGoSentFolderName = "INBOX/Sent";
SOGoPageTitle ="Le Jardin Webmail";
SOGoFaviconRelativeURL = "../images/favicon.ico";
SOGoMailMessageCheck = every_5_minutes;
SOGoUserSources = (
{
type = ldap;
CNFieldName = cn;
IDFieldName = cn;
UIDFieldName = mail;
baseDN = "ou=email-users,dc=fs,dc=crumjones,dc=net";
bindDN = "cn=Administrator,cn=Users,dc=fs,dc=iljones,dc=net";
bindFields = (mail);
bindPassword=Bananas;
canAuthenticate = YES;
displayName = "Active Directory";
hostname = "localhost";
id = directory;
isAddressBook = YES;
}
);
LDAPDebugEnabled = YES;
MySQL4DebugEnabled = YES;
SOGoDebugRequests = YES;
SOGoUIxDebugEnabled = YES;
SoSecurityManagerDebugEnabled = YES;
}
Le 09/06/2015 12:03, Filias Heidt a écrit :
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, FiliasAm 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
-- [email protected] https://inverse.ca/sogo/lists
