[Plugin: Multisite Global Search] create view privileges?

I guess that the plugin tries to do something itself? I’ve been messing around in the database and got an error similar to the one the plugin gives when I try to activate it:

Error creating search views in the database. Deactivate Multisite Global Search and check you have create views privilege in your WordPress database.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR REPLACE VIEW <code>xxxx_v_posts</code> AS ( SELECT '5' AS blog_id, 'www.xxxx.xx' AS' at line 1

Does that mean that I can’t use the plugin because or do I have to do something: I’m still on Mysql 4.1.21 (PHP 5.2.4).

I’d love to get this plugin working, since I found no alternatives…

The database user in wp_config.php (define(‘DB_USER’, ‘usernamehere’);) 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.

I am using MySQP 5.1.5, but am getting the same error. I have searched WordPress and the general Internet, but the information I find just seems cryptic and untelling. Is there an additional step aside from what I have already done…

Downloaded plugin.

Unzipped plugin.

Uploaded plugin to wp-content/plugins/.

Activated plugin via Super Admin cp.

This is where I get the error.

Also, I still don’t understand what you mean by “default global search uri: globalsearch”. Is this a setting? If so, where do I set it? Is there another name for this? It just doesn’t make sense to me.

Same issue here. Received this error to begin with:

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'

Once I had granted the ‘CREATE VIEW’ privilege the error changed to:

Error creating search views in the database. Deactivate Multisite Global Search and check you have create views privilege in your WordPress database.
The used SELECT statements have a different number of columns

Note just the last line changes:
CREATE VIEW command denied to user 'user'@'localhost' for table 'wp_v_posts'
to
The used SELECT statements have a different number of columns

So I’m thinking it’s a bug with a UNION SQL statement somewhere in the code. I’m going to do some fishing…

Please post back if you discover a solution. TIA

I have the same issue as philkershaw above. Any help is appreciated.

I am running MySQL 5.0.91 – community edition……. and I am getting the same errors as above – how do I go about allowing these create view privileges in my cpanel or WHM?

Same issue here my, mysql version is fine, whats going on can you help us all?

Fixed error message “The used SELECT statements have a different number of columns”. If you get this message, download version 1.2.5 or later.

Problem is explained in the topic [Plugin: Multisite Global Search] Getting the error: The used SELECT statements have a different num

This is bad. We shouldn’t have to install a plugin and be greeted with an instant error message. I’m running on the latest WP platform and started the multisite build right out of the box, but yet I’m still getting this error.

This plugin does not work.

Probably for most of the instances that reference this error it isn’t a problem with WordPress but rather using Shared Hosting with PHP5. PHP trigger, Stored Procedures, Views and Stored Functions setup requires SUPER privileges for the DB user and the majority of shared hosting providers do not give this type of access.

You may be able to contact your provider and ask them to create the Views – although if Multisite Global Search requires this as a repetitive task (i.e. it needs to be run each time you add a new network site) you should probably just switch to a VPS or Dedicated server.

I have access to a VPS and also dedicated server which I am testing this on and still the same error. I have created the views but no luck – any other suggestions on how to get it running – global search would be a great addition if I can get it to tick for me