Calendar Install error Calendar 2.1.0 B4

Code:
XF\Db\InvalidQueryException: Batch install error: xf_nf_calendar_event: MySQL statement prepare error [1101]: BLOB/TEXT column 'event_timezone' can't have a default value src/XF/Db/AbstractStatement.php:217

Stack Trace
ALTER TABLE `xf_nf_calendar_event`
MODIFY COLUMN `event_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
MODIFY COLUMN `event_title` VARCHAR(255) NOT NULL,
MODIFY COLUMN `user_id` INT UNSIGNED NOT NULL,
MODIFY COLUMN `username` VARCHAR(50) NOT NULL,
MODIFY COLUMN `category_id` INT UNSIGNED NOT NULL DEFAULT '0',
MODIFY COLUMN `created_date` INT UNSIGNED NOT NULL DEFAULT '0',
MODIFY COLUMN `last_update` INT UNSIGNED NOT NULL DEFAULT '0',
MODIFY COLUMN `description` TEXT NOT NULL,
MODIFY COLUMN `event_state` ENUM('visible', 'moderated', 'deleted') NOT NULL DEFAULT 'visible',
MODIFY COLUMN `start_date` INT UNSIGNED NOT NULL,
MODIFY COLUMN `next_date` INT UNSIGNED NOT NULL DEFAULT '0',
MODIFY COLUMN `end_date` INT UNSIGNED NOT NULL,
MODIFY COLUMN `all_day` INT UNSIGNED NOT NULL DEFAULT '0',
MODIFY COLUMN `event_timezone` TEXT NOT NULL DEFAULT 'Europe/London',
MODIFY COLUMN `is_recurring` TINYINT UNSIGNED NOT NULL DEFAULT '0',
MODIFY COLUMN `recurring_options` BLOB NOT NULL,
MODIFY COLUMN `recurring_end_date` INT UNSIGNED NOT NULL DEFAULT '0',
MODIFY COLUMN `event_location` VARCHAR(255) NOT NULL DEFAULT '',
MODIFY COLUMN `event_location_data` BLOB NOT NULL,
MODIFY COLUMN `ip_id` INT UNSIGNED NOT NULL DEFAULT '0',
MODIFY COLUMN `warning_id` INT UNSIGNED NOT NULL DEFAULT '0',
MODIFY COLUMN `warning_message` VARCHAR(255) NOT NULL DEFAULT '',
 
I can't reproduce this and the query in your post isn't the actual query that is run. Can you re-download the package and try again?
 
Back
Top