All Issues shows "visibility is not included in the list"

I installed redmine 3.1 earlier this week (Windows IIS with SQL Server). It was working great. Today I logged into my redmine server, and the "Issues" tab now just displays a "visibility is not included in the list" error message.

Using the agile board (from the redminecrm agile plugin), I get the
I am able to see all issues by creating a custom query (with status=any).
I am able to see all issues that have been assigned a version on the road map.

A Google search of the above error message only gave me one hit (#17147), which seemed to be a discussion about custom queries...

Any help to troubleshoot this would be appreciated.
Thanks

My environment info:
Environment:
Redmine version 3.1.0.stable
Ruby version 1.9.3-p448 (2013-06-27) [i386-mingw32]
Rails version 4.2.3
Environment production
Database adapter SQLServer
SCM:
Filesystem
Redmine plugins:
redmine_agile 1.3.11
redmine_checklists 3.1.1
redmine_lightbox2 0.2.2

Replies (1)

RE: All Issues shows "visibility is not included in the list" - Added by Voon Liew about 9 years ago

In case anybody was wondering... I just cleared out my redmine setup and installed it again.

I did some further tinkering and it seems that the culprit was the lack of db_owner privileges for the redmine account on my SQL Server. I took the permission off thinking it wasn't needed. The issue doesn't show up until the app pool is recycled so it wasn't very obvious the permission change was cause of this.

(1-1/1)

Project

General

Profile

Redmine