Hello mayak
Am 2013-11-25 15:36, schrieb mayak: > > 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? > Seems there is a change in mysql 5.6.10 then. Previous versions accepted this and created text columns on the fly. Please create a bug report at http://www.sogo.nu/bugs Kind regards, Christian Mack -- Christian Mack Gruppe Informationsdienste Rechenzentrum Universität Konstanz -- [email protected] https://inverse.ca/sogo/lists
