Defect #10076

Query browser bookmarks fail if not logged in.

Added by Alan Budden over 9 years ago.

Status:NewStart date:
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:-
Target version:-
Resolution: Affected version:1.3.0

Description

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.

Back

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

Versions:

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 195.171.105.102 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.

Also available in: Atom PDF