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 over 14 years ago. Updated about 14 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
 #1

Updated by Michael Jahn over 14 years ago

I forgot to say: Great piece of software!
That's my first ticket, I have to say thanks. :)

Actions
Copy link
 #2

Updated by Jean-Philippe Lang over 14 years ago

  • Status changed from New to Resolved
  • Target version set to 0.9.4
  • Resolution set to Fixed

The error is fixed in r3566 (reproduced with slite3 only).
You should now get a message that says that the issue could not be saved. Now we just need to display the reason why...

Actions
Copy link
 #3

Updated by xt zhang over 14 years ago

Michael Jahn wrote:

I forgot to say: Great piece of software!

That's my first ticket, I have to say thanks. :)

me 2.
no ticket yet.

Actions
Copy link
 #4

Updated by Michael Jahn over 14 years ago

Many thanks for the quick fix!

Actions
Copy link
 #5

Updated by Jean-Philippe Lang over 14 years ago

  • Subject changed from Error 500 while moving an issue to another project to Possible error 500 while moving an issue to another project with SQLite
  • Status changed from Resolved to Closed
Actions
Copy link

Also available in: Atom PDF