Mentions · Activity · aliciagh

laloma posted an update in the group Multisite Global Search: 13 years, 3 months ago

WP 3.0.4, BP 1.2.7 and MGS 1.2.4

After installing and network activating, error arrived:

Error creating search views in the database. Deactivate Multisite Global Search and check you have create views privilege in your WordPress database.
CREATE VIEW command denied to user ‘user’@’localhost’ for table ‘wp_v_posts’

How to fix this ?

Regards,

aliciagh replied 13 years, 3 months ago

The database user defined in wp_config.php have to have the “create view” privilege and the “drop” privilege. I’m talking about MySQL privileges.

Create view and drop view were added int MySQL 5.0.1 so the plugin requires MySQL 5.0.1 or greater.
- laloma replied 13 years, 3 months ago
  
  @aliciagh
  
  Im not an expert, can you guide me on how to do this ? MSQL 5.0.1 ready.
  
  Regards,
- laloma replied 13 years, 3 months ago
  
  @aliciagh
  
  Already check user privileges on DB and find “create” and “drop” are allowed, however I did not find how to assign “create views” privileges.
  
  Where / how to do this ?
  
  Regards,
aliciagh replied 13 years, 3 months ago

Execute this sql sentence:

grant create view on your_wordpress_database.* to ‘your_user’@’localhost’;

Thanks for use my plugin 🙂
- laloma replied 13 years, 3 months ago
  
  Already run sql sentence on MySQL 5.0.91, receiving error messages: #1044 – Access denied for user ‘user’@’localhost’ to database ‘databasename’
  
  Thanks for your help.
  
  Regards,
aliciagh replied 13 years, 3 months ago

First, you need upgrade MySQL to version 5.0.1. Request to the admin of your server for grant “create view” privilege on your WordPress database.
- laloma replied 13 years, 3 months ago
  
  Thanks, talking to them already.
  
  Regards,

BuddyPress.org