View Issue Details

IDProjectCategoryView StatusLast Update
0002825SOGoBackend Generalpublic2014-06-23 16:19
Reportertfu Assigned Toludovic  
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
Target Version2.2.6Fixed in Version2.2.6 
Summary0002825: SOGoCacheGCSObject: column definition of c_type (tinyint) cannot store ActiveSyncGlobalCacheObject
Description

c_type of table storing data of SOGoCacheGCSObject is defined as tinyint when on mysql.

tinyint can only store a range of -128 to 127.

+----------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+--------------+------+-----+---------+-------+
| c_path | varchar(255) | NO | PRI | NULL | |
| c_parent_path | varchar(255) | YES | | NULL | |
| c_type | tinyint(4) | NO | | NULL | |
| c_creationdate | int(11) | NO | | NULL | |
| c_lastmodified | int(11) | NO | | NULL | |
| c_version | int(11) | NO | | 0 | |
| c_deleted | tinyint(4) | NO | | 0 | |
| c_content | longtext | YES | | NULL | |
+----------------+--------------+------+-----+---------+-------+

typedef enum {
MAPIFolderCacheObject = 1,
MAPIMessageCacheObject = 2,
MAPIFAICacheObject = 3,
MAPIInternalCacheObject = 99, / object = property list /
ActiveSyncGlobalCacheObject = 200,
ActiveSyncFolderCacheObject = 201
} SOGoCacheObjectType;

Either column definition needs to be changed or the value of ActiveSyncGlobalCacheObject and ActiveSyncFolderCacheObject.

TagsNo tags attached.

Issue History

Date Modified Username Field Change
2014-06-20 22:15 tfu New Issue
2014-06-23 16:19 ludovic Target Version => 2.2.6
2014-06-23 16:19 ludovic Note Added: 0007229
2014-06-23 16:19 ludovic Status new => resolved
2014-06-23 16:19 ludovic Fixed in Version => 2.2.6
2014-06-23 16:19 ludovic Resolution open => fixed
2014-06-23 16:19 ludovic Assigned To => ludovic