hi all, i have just installed latest stable sogo on centos x64 with mysql 5.6.10
during the 1st login of a user, calendar is not created -- i finally found the error while watching the traffic between mysql and soogod CREATE TABLE sogocgubgdla00300bc52d4_quick ( c_name VARCHAR(255) NOT NULL PRIMARY KEY, c_uid VARCHAR(255) NOT NULL, c_startdate INT NULL, c_enddate INT NULL, c_cycleenddate INT NULL, c_title VARCHAR(1000) NOT NULL, c_participants VARCHAR(1000000) NULL, c_isallday INT NULL, c_iscycle INT NULL, c_cycleinfo VARCHAR(1000000) NULL, c_classification INT NOT NULL, c_isopaque INT NOT NULL, c_status INT NOT NULL, c_priority INT NULL, c_location VARCHAR(255) NULL, c_orgmail VARCHAR(255) NULL, c_partmails VARCHAR(100000) NULL, c_partstates VARCHAR(255) NULL, c_category VARCHAR(255) NULL, c_sequence INT NULL, c_component VARCHAR(10) NOT NULL, c_nextalarm INT NULL ); and mysql responds with ERROR 1074 (42000): Column length too big for column 'c_participants' (max = 65535); use BLOB or TEXT instead and that seems to be true: c_participants VARCHAR(1000000) where mysql doc show that varchar max length is 65535 any suggestions? thanks m -- [email protected] https://inverse.ca/sogo/lists
