Defect #10076


Query browser bookmarks fail if not logged in.

Added by Alan Budden over 12 years ago. Updated 6 months ago.

Target version:
Start date:
Due date:
% Done:


Estimated time:
Cant reproduce
Affected version:


I have a bookmark in Firefox pointing to https://SERVER/redmine/issues?query_id=4&per_page=100

If I am logged into redmine, this works absolutely fine. If I am not logged in to redmine, I would expect it to jump me to the redmine log-in page and once I've logged in it should take me back to the query page. What it does instead of this is report:

Internal error

An error occurred on the page you were trying to access.
If you continue to experience problems please contact your Redmine administrator for assistance.

If you are the Redmine administrator, check your log files for details about the error.


The log entry is at the end of this bug report.


Redmine 1.3.0 (mysql) running on Ubuntu 11.10.

About your application's environment
Ruby version              1.8.7 (i686-linux)
RubyGems version          1.4.2
Rack version              1.1.2
Rails version             2.3.11
Active Record version     2.3.11
Active Resource version   2.3.11
Action Mailer version     2.3.11
Active Support version    2.3.11
Edge Rails revision       unknown
Application root          /usr/share/redmine
Environment               production
Database adapter          mysql
Database schema version   20110511000000

About your Redmine plugins
Issue Importer                                   0.9
Redmine Code Review plugin                       0.3.1
Sidebar content                                  0.0.2
Redmine Drafts plugin                            0.1.1
Redmine Ultraviolet Syntax highlighting plugin   0.0.3
Redmine Hudson plugin                            1.0.7
Default Assign plugin                            0.2.0

Log entry:

Processing IssuesController#index (for at 2012-01-27 13:00:12) [GET]
  Parameters: {"action"=>"index", "query_id"=>"4", "controller"=>"issues", "per_page"=>"100"}

ActiveRecord::StatementInvalid (Mysql::Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=': SELECT * FROM `tokens` WHERE (`tokens`.`value` = 'ºÇ«
                                          app/models/user.rb:337:in `find_by_api_key'
  app/controllers/application_controller.rb:88:in `find_current_user'
  app/controllers/application_controller.rb:87:in `find_current_user'
  app/controllers/application_controller.rb:64:in `user_setup'
  passenger (3.0.9) lib/phusion_passenger/rack/request_handler.rb:96:in `process_request'
  passenger (3.0.9) lib/phusion_passenger/abstract_request_handler.rb:513:in `accept_and_process_next_request'
  passenger (3.0.9) lib/phusion_passenger/abstract_request_handler.rb:274:in `main_loop'
  passenger (3.0.9) lib/phusion_passenger/classic_rails/application_spawner.rb:321:in `start_request_handler'
  passenger (3.0.9) lib/phusion_passenger/classic_rails/application_spawner.rb:275:in `send'
  passenger (3.0.9) lib/phusion_passenger/classic_rails/application_spawner.rb:275:in `handle_spawn_application'
  passenger (3.0.9) lib/phusion_passenger/utils.rb:479:in `safe_fork'
  passenger (3.0.9) lib/phusion_passenger/classic_rails/application_spawner.rb:270:in `handle_spawn_application'
  passenger (3.0.9) lib/phusion_passenger/abstract_server.rb:357:in `__send__'
  passenger (3.0.9) lib/phusion_passenger/abstract_server.rb:357:in `server_main_loop'
  passenger (3.0.9) lib/phusion_passenger/abstract_server.rb:206:in `start_synchronously'
  passenger (3.0.9) lib/phusion_passenger/abstract_server.rb:180:in `start'
  passenger (3.0.9) lib/phusion_passenger/classic_rails/application_spawner.rb:149:in `start'
  passenger (3.0.9) lib/phusion_passenger/spawn_manager.rb:219:in `spawn_rails_application'
  passenger (3.0.9) lib/phusion_passenger/abstract_server_collection.rb:132:in `lookup_or_add'
  passenger (3.0.9) lib/phusion_passenger/spawn_manager.rb:214:in `spawn_rails_application'
  passenger (3.0.9) lib/phusion_passenger/abstract_server_collection.rb:82:in `synchronize'
  passenger (3.0.9) lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize'
  passenger (3.0.9) lib/phusion_passenger/spawn_manager.rb:213:in `spawn_rails_application'
  passenger (3.0.9) lib/phusion_passenger/spawn_manager.rb:132:in `spawn_application'
  passenger (3.0.9) lib/phusion_passenger/spawn_manager.rb:275:in `handle_spawn_application'
  passenger (3.0.9) lib/phusion_passenger/abstract_server.rb:357:in `__send__'
  passenger (3.0.9) lib/phusion_passenger/abstract_server.rb:357:in `server_main_loop'
  passenger (3.0.9) lib/phusion_passenger/abstract_server.rb:206:in `start_synchronously'
  passenger (3.0.9) helper-scripts/passenger-spawn-server:99

Rendering /usr/share/redmine/public/500.html (500 Internal Server Error)

If there's any more information required, I will obviously be happy to provide it.

Actions #1

Updated by Go MAEDA 6 months ago

  • Status changed from New to Closed
  • Resolution set to Cant reproduce

I cannot reproduce the issue.

Since the code of Redmine has changed a lot from the time this problem was reported, I am closing this issue. Please reopen this issue if you still experience the problem.


Also available in: Atom PDF