Project

General

Profile

Actions

Defect #24866

closed

SQLServer: Visibility not included in list

Added by Ronny . about 7 years ago. Updated about 7 years ago.

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

0%

Estimated time:
Resolution:
Invalid
Affected version:

Description

I have an empty, just installed Redmine.
While try to have a look at issue list i get a message "visibility ist not included in list".

Having some google i found some issues with table queries und some sql to fix NULL problem.
As my queries table has no content (Count(*) = 0) such fix would not have an effect.

Any idea whats going on here?

thanks und by from germany
Ronny

Windows Server 2012R2
Sql Server 2016
Installed yesterday and no content (tickets or so on).

Environment:
  Redmine version                3.3.2.stable
  Ruby version                   2.1.7-p400 (2015-08-18) [x64-mingw32]
  Rails version                  4.2.7.1
  Environment                    production
  Database adapter               SQLServer
SCM:
  Filesystem                     
Redmine plugins:
  no plugin installed

Files

vis_not_inc.png (23.8 KB) vis_not_inc.png Ronny ., 2017-01-18 16:06
Actions #1

Updated by Ronny . about 7 years ago

select * from queries

id project_id name filters user_id column_names sort_criteria group_by type visibility options
----------- ----------- ----- -------- -------- ------------- -------------- --------- ------ ----------- --------
(0 Zeile(n) betroffen)

Saving a filter will remove that message. Deleteing that saved filter will put the message there again.

Ronny

Actions #3

Updated by Toshi MARUYAMA about 7 years ago

  • Related to Defect #17147: Public/private saved queries are not separated anymore added
Actions #4

Updated by Ronny . about 7 years ago

Ok, i did some more research.
I found this All Issues shows "visibility is not included in the list".

Written in the single comment there was a hint to set database role of the user to db_owner .
This seems to solve my problem, i no longer get the error message.

What should be done:
I used this SQL to create the database schmea (found in installation wiki on this page). This should be updated.

USE [master]
GO

-- Very basic DB creation
CREATE DATABASE [REDMINE]
GO

-- Creation of a login with SQL Server login/password authentication and no password expiration policy
CREATE LOGIN [REDMINE] WITH PASSWORD=N'redminepassword', DEFAULT_DATABASE=[REDMINE], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO

-- User creation using previously created login authentication
USE [REDMINE]
GO
CREATE USER [REDMINE] FOR LOGIN [REDMINE]
GO
-- User permissions set via roles
EXEC sp_addrolemember N'db_datareader', N'REDMINE'
GO
EXEC sp_addrolemember N'db_datawriter', N'REDMINE'
GO

Maybe a tool the chekcs database right would be helpfull.
Whats about a subpage at Admin-section of Redmine called "Check database". Here you could put a button which starts some SQL-calls to determine if the database is set to a privilege level to fullfill the request of redmine?

cheers
Ronny

Actions #5

Updated by Toshi MARUYAMA about 7 years ago

  • Related to deleted (Defect #17147: Public/private saved queries are not separated anymore)
Actions #6

Updated by Toshi MARUYAMA about 7 years ago

  • Subject changed from Visibility not included in list to SQLServer: Visibility not included in list
  • Status changed from New to Closed
  • Resolution set to Invalid
Actions

Also available in: Atom PDF