Project

General

Profile

Actions

Defect #8

closed

Schema Creation fails with Redmine 0.4.2 & MySQL 5

Added by Vijay Ram over 17 years ago. Updated over 11 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Affected version:

Description

Hi

I am using MySQL 5 and I am getting some errors when I run the
rake migrate RAILS_ENV="production"
I have attached the errors here:

In 001_setup.rb
Mysql::Error: #42000BLOB/TEXT column 'possible_values' can't have a default value:
CREATE TABLE custom_fields (`id` int(11) DEFAULT NULL auto_increment PRIMARYKEY,
`type` varchar(30) DEFAULT '' NOT NULL,
`name` varchar(30) DEFAULT '' NOT NULL,
`field_format` varchar(30) DEFAULT '' NOT NULL,
`possible_values` text DEFAULT '',
`regexp` varchar(255) DEFAULT '',
`min_length` int(11) DEFAULT 0 NOT NULL,
`max_length` int(11) DEFAULT 0 NOT NULL,
`is_required` tinyint(1) DEFAULT 0 NOT NULL,
`is_for_all` tinyint(1) DEFAULT 0 NOT NULL) ENGINE=InnoDB

The following tables have the similar error:
TABLE NAME COLUMN NAME
custom_values value
documents description
issue_histories notes
issues description
news description

In 010_create_comments.rb:
TABLE NAME COLUMN NAME
comments comment

I just removed the DEFAULT' ' next to the text fields and the schema got created.
I have the 0.4.2 version of Redmine.

-Vijay

Actions

Also available in: Atom PDF