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
Comment #1
hypertext200