WordPress.org

Ready to get started?Download WordPress

Forums

Multisite Global Search
create view privileges? (13 posts)

  1. Roy
    Member
    Posted 3 years ago #

    Create view and drop view privileges in WordPress database.

    What does that mean? Create a user for the database?

    And does a search page have to be created for every subsite?

  2. Roy
    Member
    Posted 3 years ago #

    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).

  3. Roy
    Member
    Posted 3 years ago #

    I'd love to get this plugin working, since I found no alternatives...

  4. aliciagh
    Member
    Plugin Author

    Posted 3 years ago #

    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.

  5. KustomByKris
    Member
    Posted 3 years ago #

    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.

  6. philkershaw
    Member
    Posted 3 years ago #

    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

  7. chintu74
    Member
    Posted 3 years ago #

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

  8. allmyhoney
    Member
    Posted 3 years ago #

    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?

  9. Tom Lynch
    Member
    Posted 3 years ago #

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

  10. aliciagh
    Member
    Plugin Author

    Posted 3 years ago #

    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

  11. kaotik
    Member
    Posted 3 years ago #

    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.

  12. danetidwell
    Member
    Posted 2 years ago #

    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.

  13. allmyhoney
    Member
    Posted 2 years ago #

    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

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic