Details
-
Type:
Bug
-
Status: Open
-
Priority:
Important
-
Resolution: Unresolved
-
Affects Version/s: 4.7.20
-
Fix Version/s: None
-
Component/s: CiviCase
-
Labels:None
-
Versioning Impact:Patch (backwards-compatible bug fixes)
-
Documentation Required?:None
-
Funding Source:Needs Funding
-
Verified?:No
Description
On a fresh install of Drupal 7 and CiviCRM 4.7.20 I try to enable CiviCase and I see:
Sorry but we are not able to provide this at the moment. A fatal error was triggered: Could not create the MySQL views for CiviCase. Your mysql user needs to have the 'CREATE VIEW' permission
but the user has that permission:
mysql> create view TEST as select uid from users;
Query OK, 0 rows affected (0.01 sec)
mysql -V
mysql Ver 14.14 Distrib 5.7.18-percona-sure1, for Linux (x86_64) using 6.3