Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

no such column: false: SELECT "issue_statuses".* FROM "issue_statuses" #48

Open
matthiasbock opened this issue Mar 12, 2023 · 0 comments

Comments

@matthiasbock
Copy link

matthiasbock commented Mar 12, 2023

When navigating to the dashboard page,
by clicking "Dashboard" in the top left corner of the Redmine menu,
instead of a dashboard, a HTTP 500 error page is displayed:

Redmine 500 error
Internal Server 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 contains the following error message:

Processing by DashboardController#index as HTML
   Current user: ...
Completed 500 Internal Server Error in 11ms (ActiveRecord: 5.5ms)

ActiveRecord::StatementInvalid (SQLite3::SQLException:
  no such column:
    false:
      SELECT "issue_statuses".*
      FROM "issue_statuses"
      WHERE (is_closed = false)
      ORDER BY "issue_statuses"."position"
      ASC
):

plugins/dashboard/app/controllers/dashboard_controller.rb:37:in `get_statuses'
plugins/dashboard/app/controllers/dashboard_controller.rb:11:in `index'
lib/redmine/sudo_mode.rb:63:in `sudo_mode'
"GET /dashboard HTTP/1.1" 500 648

The database table "issues_statuses" has the following structure:

  • id: integer NOT NULL PRIMARY KEY
  • name: varchar(30) DEFAULT ''
  • is_closed: integer DEFAULT 0
  • position: integer DEFAULT NULL
  • default_done_ratio: integer DEFAULT NULL

System:

  • OS: Debian GNU/Linux Bullseye
  • Browser: Chromium 106.0.5249.119
  • Redmine version: 4.0.3
  • with database backend: SQLite
  • dashboard plugin version: latest, 6c21082
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant