Activating the module fails to build the video table. Without this table, of course, nothing works. Activation fails with this message:

user warning: BLOB/TEXT column 'vidfile' can't have a default value query: 

CREATE TABLE video ( 
`vid` INT unsigned NOT NULL DEFAULT 0, 
`nid` INT unsigned NOT NULL DEFAULT 0, 
`vtype` VARCHAR(32) NOT NULL DEFAULT '', 
`vidfile` TEXT DEFAULT '', 
`videox` SMALLINT unsigned NOT NULL DEFAULT 0, 
`videoy` SMALLINT unsigned NOT NULL DEFAULT 0, 
`size` BIGINT unsigned DEFAULT NULL, 
`download_counter` INT unsigned NOT NULL DEFAULT 0, 
`play_counter` INT unsigned NOT NULL DEFAULT 0, 
`video_bitrate` INT unsigned DEFAULT NULL, 
`audio_bitrate` INT unsigned DEFAULT NULL, 
`audio_sampling_rate` INT unsigned DEFAULT NULL, 
`audio_channels` TEXT DEFAULT NULL, 
`playtime_seconds` INT unsigned DEFAULT NULL, 
`download_folder` VARCHAR(255) DEFAULT NULL, 
`disable_multidownload` TINYINT unsigned NOT NULL DEFAULT 0, 
`use_play_folder` TINYINT unsigned NOT NULL DEFAULT 0, 
`serialized_data` TEXT DEFAULT NULL, 
PRIMARY KEY (vid), INDEX nid (nid) ) 

From the MySql documentation:

BLOB and TEXT columns cannot be assigned a default value

I think the correct code would include this, instead:

...
`vidfile` TEXT DEFAULT NULL,
...

Comments

hypertext200’s picture

Status: Active » Closed (fixed)