Dear developers,

I'm running SOGo 3.2.8 (and old releases) on CentOS 6.x with MySQL 5.1.73 (the one shipped by CentOS), it creates other SQL tables, but cannot create SQL table for OCSCacheFolder.

Here's the tables created by SOGo automatically:

############

mysql sogo -e "show tables"

+------------------------+
| Tables_in_sogo |
+------------------------+
| sogo_acl |
| sogo_alarms_folder |
| sogo_folder_info |
| sogo_quick_appointment |
| sogo_quick_contact |
| sogo_sessions_folder |
| sogo_store |
| sogo_user_profile |
| users | # <- This one is SQL VIEW, created manually.
+------------------------+
##################

This is the original SQL template from SOGo package (/usr/lib64/GNUstep/SOGo/MainUI.SOGo/Resources/OCSCacheFolder-mysql.sql):

###################################

-- (C) 2004-2005 SKYRIX Software AG
-- (C) 2006-2007 Inverse inc.

CREATE TABLE @{tableName} (
c_uid VARCHAR(255) NOT NULL,
c_path VARCHAR(255) NOT NULL,
c_parent_path VARCHAR(255),
c_type TINYINT UNSIGNED NOT NULL,
c_creationdate INT NOT NULL,
c_lastmodified INT NOT NULL,
c_version INT NOT NULL DEFAULT 0,
c_deleted TINYINT NOT NULL DEFAULT 0,
c_content LONGTEXT,
CONSTRAINT @{tableName}_pkey PRIMARY KEY (c_uid, c_path)
);
###################################

I replaced @{tableName} by the real sql table name "sogo_cache_folder", then import it manually:

mysql sogo < OCSCacheFolder-mysql.sql

ERROR 1071 (42000) at line 6: Specified key was too long; max key length is 1000 bytes

SOGo database was created with UTF8 character set:

#############################
mysql> show create database sogo;
+----------+---------------------------------------------------------------+
| Database | Create Database |
+----------+---------------------------------------------------------------+
| sogo | CREATE DATABASE sogo /!40100 DEFAULT CHARACTER SET utf8 / |
+----------+---------------------------------------------------------------+
#############################