0000262: Can not create any contact or calendar entry - SOGo

The problem is probably this code here in sope/sope-gdl1/MySQL/MySQL4Channel.m:

static NSString *sqlFolderFormat = (@"CREATE TABLE %@ (\n" \
@" c_name VARCHAR (256) NOT NULL PRIMARY KEY,\n"
@" c_content VARCHAR (100000) NOT NULL,\n"
@" c_creationdate INT NOT NULL,\n"
@" c_lastmodified INT NOT NULL,\n"
@" c_version INT NOT NULL,\n"
@" c_deleted INT NULL\n"
@")");

I run MySQL in UTF-8 mode and creating a primary key that long in UTF-8 is not possible in MySQL. If you try that then you should get an error like this here (where xxxx is normally a number up to 1000):

Specified key was too long; max key length is xxxx bytes

I don't know for what the field c_name is used for but if it can be in latin1 then the requested 256 characters could easy fit in the key limit of 1000 bytes that MySQL has:

If both tables can be in latin1 then one could go on and create both table with character set latin1 and collation latin1_general_ci:

static NSString *sqlFolderACLFormat = (@"CREATE TABLE %@ (\n" \
@" c_uid VARCHAR (256) NOT NULL,\n"
@" c_object VARCHAR (256) NOT NULL,\n"
@" c_role VARCHAR (80) NOT NULL\n"
@")\n"
@" DEFAULT CHARACTER SET latin1\n"
@" DEFAULT COLLATE latin1_general_ci;");

(NSException ) createGCSFolderTableWithName: (NSString ) tableName
{

The second issue is this here:

2009-11-27 23:00:28.213 sogod[28852] ERROR: MySQL4 field is marked unsigned (unsupported): {columnName = c_folder_id; name = c_folder_id; }

So that needs as well to be changed:

ALTER TABLE `sogo_folder_info` CHANGE `c_folder_id` `c_folder_id` BIGINT( 20 ) NOT NULL AUTO_INCREMENT

And all of this still did not fixed my issue. I can't create new contacts. The last error that I have and that I am (for now) not able to fix is:

How can I get that field extractor class included? I don't understand why that is not there? I just have compiled SOGo exactly as it is mentioned on the SOGo web page. But I still am getting errors when starting SOGo. Regardless my strict following of the documentation when compiling:

Searching that folder for the classes that SOGo is claiming not be able to load give me the following result:

And the content of that pruduct.plist file is:

};
}
nyx ~ #

Other files that I have in that directory:

I don't know if this is helping in any way but I try. I started SOGo with the following parameters:

And this is what SOGo is adding to the log:

The problem is probably this code here in sope/sope-gdl1/MySQL/MySQL4Channel.m:

static NSString *sqlFolderFormat = (@"CREATE TABLE %@ (\n" \ @" c_name VARCHAR (256) NOT NULL PRIMARY KEY,\n" @" c_content VARCHAR (100000) NOT NULL,\n" @" c_creationdate INT NOT NULL,\n" @" c_lastmodified INT NOT NULL,\n" @" c_version INT NOT NULL,\n" @" c_deleted INT NULL\n" @")");

I run MySQL in UTF-8 mode and creating a primary key that long in UTF-8 is not possible in MySQL. If you try that then you should get an error like this here (where xxxx is normally a number up to 1000):

Specified key was too long; max key length is xxxx bytes

I don't know for what the field c_name is used for but if it can be in latin1 then the requested 256 characters could easy fit in the key limit of 1000 bytes that MySQL has:

If both tables can be in latin1 then one could go on and create both table with character set latin1 and collation latin1_general_ci:

static NSString *sqlFolderACLFormat = (@"CREATE TABLE %@ (\n" \ @" c_uid VARCHAR (256) NOT NULL,\n" @" c_object VARCHAR (256) NOT NULL,\n" @" c_role VARCHAR (80) NOT NULL\n" @")\n" @" DEFAULT CHARACTER SET latin1\n" @" DEFAULT COLLATE latin1_general_ci;");

(NSException ) createGCSFolderTableWithName: (NSString ) tableName {

The second issue is this here:

2009-11-27 23:00:28.213 sogod[28852] ERROR: MySQL4 field is marked unsigned (unsupported): {columnName = c_folder_id; name = c_folder_id; }

So that needs as well to be changed:

ALTER TABLE sogo_folder_info CHANGE c_folder_id c_folder_id BIGINT( 20 ) NOT NULL AUTO_INCREMENT

And all of this still did not fixed my issue. I can't create new contacts. The last error that I have and that I am (for now) not able to fix is:

How can I get that field extractor class included? I don't understand why that is not there? I just have compiled SOGo exactly as it is mentioned on the SOGo web page. But I still am getting errors when starting SOGo. Regardless my strict following of the documentation when compiling:

Searching that folder for the classes that SOGo is claiming not be able to load give me the following result:

And the content of that pruduct.plist file is:

}; } nyx ~ #

Other files that I have in that directory:

I don't know if this is helping in any way but I try. I started SOGo with the following parameters:

And this is what SOGo is adding to the log:

static NSString *sqlFolderFormat = (@"CREATE TABLE %@ (\n" \
@" c_name VARCHAR (256) NOT NULL PRIMARY KEY,\n"
@" c_content VARCHAR (100000) NOT NULL,\n"
@" c_creationdate INT NOT NULL,\n"
@" c_lastmodified INT NOT NULL,\n"
@" c_version INT NOT NULL,\n"
@" c_deleted INT NULL\n"
@")");

static NSString *sqlFolderACLFormat = (@"CREATE TABLE %@ (\n" \
@" c_uid VARCHAR (256) NOT NULL,\n"
@" c_object VARCHAR (256) NOT NULL,\n"
@" c_role VARCHAR (80) NOT NULL\n"
@")\n"
@" DEFAULT CHARACTER SET latin1\n"
@" DEFAULT COLLATE latin1_general_ci;");

(NSException ) createGCSFolderTableWithName: (NSString ) tableName
{

ALTER TABLE `sogo_folder_info` CHANGE `c_folder_id` `c_folder_id` BIGINT( 20 ) NOT NULL AUTO_INCREMENT

};
}
nyx ~ #