Install of module resulted in errors

  • 3
  • Problem
  • Updated 8 years ago
  • Solved
Query failed with message 'CREATE VIEW command denied to user 'webxspos_webcamp'@'localhost' for table 'acx_view_ticket_categories''
Photo of Derek Brown

Derek Brown

  • 5 Posts
  • 0 Reply Likes
  • sad

Posted 8 years ago

  • 3
Photo of Nirav Mehta

Nirav Mehta, Official Rep

  • 1989 Posts
  • 62 Reply Likes
Official Response
If you have granted all privileges to the db user, but you are still getting a command denied error, please explicitly grant CREATE VIEW to your db user.

Grant All Privileges sometimes does not include view creation permissions.

You can grant create privileges like this, as root MySQL user:

GRANT CREATE VIEW ON yourdbname.* TO 'dbusername'@'localhost'

Replace your database and user / host names as appropriate.

Run another query - FLUSH PRIVILEGES - after the above command to ensure new privileges are activated.

HTH.
Photo of Nirav Mehta

Nirav Mehta, Official Rep

  • 1989 Posts
  • 62 Reply Likes
Official Response
The latest version of Reports module (1.4) does not require view creation privileges any more. It also fixes a couple of other issues and adds small features. We suggest you use that.

You can download it using the link in your original purchase email.