Project

General

Profile

Actions

Defect #21065

closed

Transition state: wrong visualization & update on MS SqlServer

Added by fabio meoli over 9 years ago. Updated over 9 years ago.

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

0%

Estimated time:
Resolution:
Invalid
Affected version:

Description

Hi,

when you insert the transition state of a workflow in the "default section", redmine displays this in the "author" and "assignee" (the contents of the table record workflow seems correct).
Also no longer able to clear the two options. (If I repeat the action on MySql instead MS SQL it's all ok!).

Explanation
Initial Status: only one check is on

On “save”, the check option are visualized on “author” and “assignee” section, instead on default transition state

The content of the workflow table on Ms Sql are correct but redmine visualizes the checks on wrong positions:

Another problem is on uncheck …

After the “save” the results are the same … nothing are changed; The trace of sqlserver show only “select” and “update” … but no “delete”.

Our Environment:

Redmine version 2.6.3.stable
Ruby version 2.0.0-p643 (2015-02-25) [i386-mingw32]
Rails version 3.2.21
Environment production
Database adapter SQLServer

SCM:

Subversion 1.8.10
Git 1.9.5
Filesystem

Redmine plugins:

no plugin installed

Adapter MS Sql Server

activerecord-sqlserver-adapter 3.2.13


Files

img2.jpg (134 KB) img2.jpg fabio meoli, 2015-10-26 11:48
img1.jpg (202 KB) img1.jpg fabio meoli, 2015-10-26 11:48
img3.jpg (83.9 KB) img3.jpg fabio meoli, 2015-10-26 11:48
img5.jpg (138 KB) img5.jpg fabio meoli, 2015-10-26 11:48
img4.jpg (135 KB) img4.jpg fabio meoli, 2015-10-26 11:48
Actions #1

Updated by Toshi MARUYAMA over 9 years ago

  • Category changed from Administration to Database
Actions #2

Updated by fabio meoli over 9 years ago

Sorry, I resolved.

The error was probably caused by the migration from MySQL to SQL Server 2014 Express.

I repeated migration creating new Sql Server db before, executed the "rake db:migrate RAILS_ENV=production", and then importing the data with the" SQL Server Import and Export Wizard" from old Sql Server db.

It's work fine now.

Fabio

Actions #3

Updated by fabio meoli over 9 years ago

  • Status changed from New to Resolved
Actions #4

Updated by Toshi MARUYAMA over 9 years ago

  • Status changed from Resolved to Closed
  • Resolution set to Invalid
Actions

Also available in: Atom PDF