Project

General

Profile

Actions
Copy link

Defect #5049

closed

Possible error 500 while moving an issue to another project with SQLite

Added by Michael Jahn about 14 years ago. Updated over 13 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Issues
Target version:
0.9.4
Start date:
2010-03-11
Due date:
% Done:

0%

Estimated time:
Resolution:
Fixed
Affected version:
0.9.3

Description

Hi,

I get an "Internal Error 500" if I try to move an issue from one project to another one. I could break down the error to the
following cause: the issue has the tracker "Error" but this tracker is not available in the destination project.
Workaround:
Select an appropriate new tracker in the move dialog.
What I expected:
A better error message, that I have to select a new tracker value.

Especially strange is the error message in the server log:

SQLite3::SQLException (cannot rollback - no transaction is active):
  C:/Programme/Ruby/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.5-x86-mswin32/lib/sqlite3/errors.rb:62:in `check'
  C:/Programme/Ruby/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.5-x86-mswin32/lib/sqlite3/resultset.rb:56:in `check'
  C:/Programme/Ruby/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.5-x86-mswin32/lib/sqlite3/resultset.rb:48:in `commence'
  C:/Programme/Ruby/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.5-x86-mswin32/lib/sqlite3/resultset.rb:38:in `initialize'
  C:/Programme/Ruby/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.5-x86-mswin32/lib/sqlite3/statement.rb:136:in `new'
  C:/Programme/Ruby/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.5-x86-mswin32/lib/sqlite3/statement.rb:136:in `execute'
  C:/Programme/Ruby/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.5-x86-mswin32/lib/sqlite3/database.rb:188:in `execute'
  C:/Programme/Ruby/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.5-x86-mswin32/lib/sqlite3/database.rb:163:in `prepare'
  C:/Programme/Ruby/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.5-x86-mswin32/lib/sqlite3/database.rb:187:in `execute'
  C:/Programme/Ruby/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.5-x86-mswin32/lib/sqlite3/database.rb:597:in `rollback'
  app/models/issue.rb:95:in `move_to'
  app/controllers/issues_controller.rb:307:in `move'
  app/controllers/issues_controller.rb:299:in `each'
  app/controllers/issues_controller.rb:299:in `move'

The message doesn't point to the real cause of the error.

My installation:
Redmine 0.9.3 (Windows)
SQLite
Ruby 1.8.6 (i386-mswin32)
Rails 2.3.5
Database schema version 20100221100219

Actions
Copy link

Also available in: Atom PDF