Code
/www/cms/modules/mediashare/pninit.php(53):
Table creation failed: Too big column length for column 'ms_extappData' (max = 255).
use blob instead while executingCREATE TABLE zikula_mediashare_albums ( ms_id integer not null auto_increment, ms_ownerid integer not null, ms_createddate datetime not null, ms_modifieddate timestamp not null, ms_title varchar(255) not null default '', ms_keywords varchar(255) not null default '', ms_summary text, ms_description text, ms_template varchar(255) not null default 'msslideshow', ms_parentAlbumId integer, ms_accesslevel tinyint not null default 0, ms_viewkey varchar(32) not null, ms_mainmediaid integer, ms_thumbnailsize integer not null, ms_nestedsetleft integer not null default 0, ms_nestedsetright integer not null default 0, ms_nestedsetlevel integer not null default 0, ms_extappURL varchar(255), ms_extappData varchar(512), primary key (ms_id) )engine = myisam
Table creation failed: Too big column length for column 'ms_extappData' (max = 255).
use blob instead while executingCREATE TABLE zikula_mediashare_albums ( ms_id integer not null auto_increment, ms_ownerid integer not null, ms_createddate datetime not null, ms_modifieddate timestamp not null, ms_title varchar(255) not null default '', ms_keywords varchar(255) not null default '', ms_summary text, ms_description text, ms_template varchar(255) not null default 'msslideshow', ms_parentAlbumId integer, ms_accesslevel tinyint not null default 0, ms_viewkey varchar(32) not null, ms_mainmediaid integer, ms_thumbnailsize integer not null, ms_nestedsetleft integer not null default 0, ms_nestedsetright integer not null default 0, ms_nestedsetlevel integer not null default 0, ms_extappURL varchar(255), ms_extappData varchar(512), primary key (ms_id) )engine = myisam
As far as I understand this is a mysql server configuration that VARCHAR is set to max 255 char.
Is there a workaround that will not include database reconfiguration and no messing with the sugestion to change to BLOB instead.
I have the same problem with pagemaster
Code
Error! Sorry! Table creation failed. (pagemaster_pubfields, 1, 1074 - Too big column length for column 'pm_typedata' (max = 255). use blob instead)
edited by: Fredricn, Jul 04, 2009 - 02:40 PM
