Project

General

Profile

Actions

Defect #13549

closed

migrate database from Redmine 1.4.3.stable (MySQL) to Redmine 2.3.0.stable (MySQL).

Added by Victor Shkrob over 12 years ago. Updated over 6 years ago.

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

0%

Estimated time:
Resolution:
Invalid
Affected version:

Description

After migration when accessing the Overview page of project, the following error gets logged
In the browser:

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.

In log:

Started GET "/redmine/projects" for 192.168.10.4 at Thu Mar 21 13:02:02 +0200 2013
Processing by ProjectsController#index as HTML
Current user: victor (id=3)
Rendered projects/index.html.erb within layouts/base (76.2ms)
Completed 200 OK in 89ms (Views: 84.7ms | ActiveRecord: 1.2ms)
Started GET "/redmine/projects/ss" for 192.168.10.4 at Thu Mar 21 13:02:43 +0200 2013
Processing by ProjectsController#show as HTML
Parameters: {"id"=>"ss"}
Current user: victor (id=3)
Completed 500 Internal Server Error in 32ms

ActiveRecord::StatementInvalid (Mysql::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AS count, tracker_id AS tracker_id FROM `issues` LEFT OUTER JOIN `projects` ON' at line 1: SELECT COUNT AS count, tracker_id AS tracker_id FROM `issues` LEFT OUTER JOIN `projects` ON `projects`.`id` = `issues`.`project_id` LEFT OUTER JOIN `issue_statuses` ON `issue_statuses`.`id` = `issues`.`status_id` WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND (issue_statuses.is_closed = 0) AND ((projects.id = 2 OR (projects.lft > 1 AND projects.rgt < 2))) GROUP BY tracker_id):
app/controllers/projects_controller.rb:154:in `show'

Environment:
Redmine version 2.3.0.stable
Ruby version 1.8.7 (i686-linux)
Rails version 3.2.13
Environment production
Database adapter MySQL
Redmine plugins:
no plugin installed

Actions

Also available in: Atom PDF