upgrade from 2.6.3 to 3.0.1 windows sqlserver 2012
Added by Antonio Peta over 9 years ago
Problem with upgrade bitnami redmine-3.0.1-0 from bitnami-redmine 2.6.3 on windows server 2008 r2 and sqlserver 2012
In environment Windows 2008 and sqlsever 2012 redmine 2.6.3 works perfectly.... but the upgrade to version 3.0.1-0 redmine I get the following error:
Started POST "/ redmine / projects / pwf / issues" for 127.0.0.1 at 3/30/2015 13:22:12 +0200
Processing by IssuesController # created as HTML
Parameters: {"utf8" => "✓" "authenticity_token"=>"xxxxxxxxxx", "Issue" => {"is_private" => "0", "tracker_id" => "15", "subject" => "ssss", "description" => "ssss", "status_id" => "1" , "priority_id" => "4", "assigned_to_id" => "84", "fixed_version_id" => "", "parent_issue_id" => "", "start_date" => "", "due_date" => "" , "estimated_hours" => "", "done_ratio" => "0", "custom_field_values" => {"1" => "ALL", "71" => "To be determined"}}, "was_default_status" => "1", "commit" => "Create", "project_id" => "pwf"}
Current user: sist01 (id = 84)
TinyTds :: Error: Error converting data type nvarchar to datetime2 .: EXEC sp_executesql N'INSERT INTO [issues] ([project_id], [author_id], [tracker_id], [status_id] [subject] [description], [priority_id ], [assigned_to_id], [updated_on], [created_on]) OUTPUT INSERTED. [id] VALUES ( 0,
1, 2,
3 4
5 6
7 8
9) ', N' 0 int, int
1, 2 int, int
3, 4 nvarchar (255),
5 nvarchar (max), 6 int, int
7, 8 datetime2 ,
9 datetime2 ', 0 = 67 = 84
1, 2 = 15, 3 =
1 4 = N'ssss',
5 = N'ssss', 6 = 4
7 = 84, 8 = N'2015-03-30 13:22:12 +0200 ',
9 = N'2015-03-30 13:22:12 +0200'
Completed 500 Internal Server Error in 118ms
ActiveRecord :: StatementInvalid (TinyTds :: Error: Error converting data type nvarchar to datetime2 .: EXEC sp_executesql N'INSERT INTO [issues] ([project_id], [author_id], [tracker_id], [status_id], [subject], [ description], [priority_id], [assigned_to_id], [updated_on], [created_on]) OUTPUT INSERTED. [id] VALUES ( 0,
1, 2,
3 4
5 6
7 , 8
9) ', N' 0 int, int
1, 2 int, int
3, 4 nvarchar (255),
5 nvarchar (max), 6 int, int
7, 8 datetime2,
9 datetime2 ', 0 = 67,
1 = 84, 2 = 15 ,
3 = 1 4 = N'ssss',
5 = N'ssss', 6 = 4
7 = 84, 8 = N'2015-03-30 13:22:12 +0200 ',
9 = N'2015-03-30 13:22:12 +0200'):
app / models / issue.rb: 174: in `create_or_update '
app / controllers / issues_controller.rb: 141: in `created '
Can anyone help?
thanks
Replies (4)
RE: upgrade from 2.6.3 to 3.0.1 windows sqlserver 2012 - Added by Chris Dalley over 9 years ago
I have the same issue, I will keep an eye out for you, also.
RE: upgrade from 2.6.3 to 3.0.1 windows sqlserver 2012 - Added by Chris Dalley over 9 years ago
Antonio, have you had any luck?
RE: upgrade from 2.6.3 to 3.0.1 windows sqlserver 2012 - Added by Antonio Peta over 9 years ago
no no luck and no answer unfortunately.
at the time I stay with version 2.6.3 that works perfectly with sqlserver 2014 express
RE: upgrade from 2.6.3 to 3.0.1 windows sqlserver 2012 - Added by Chris Dalley over 9 years ago
Antonio Peta wrote:
no no luck and no answer unfortunately.
at the time I stay with version 2.6.3 that works perfectly with sqlserver 2014 express
I'm about to try upgrading 2.4 to 3.0.1 again :) Wish me luck.