Database table not created
jfinkel - September 1, 2009 - 00:47
| Project: | Video |
| Version: | 6.x-2.5-beta1 |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | active |
Description
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 valueI think the correct code would include this, instead:
...
`vidfile` TEXT DEFAULT NULL,
...