WordPress.org

Support

Support » Plugins and Hacks » [Plugin: Multisite Global Search] create view privileges?

[Plugin: Multisite Global Search] create view privileges?

  • Roy
    Member

    @gangleri

    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?

Viewing 12 replies - 1 through 12 (of 12 total)
  • Roy
    Member

    @gangleri

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

    Roy
    Member

    @gangleri

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

    Plugin Author aliciagh
    Member

    @aliciagh

    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.

    KustomByKris
    Member

    @kustombykris

    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.

    philkershaw
    Member

    @philkershaw

    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.

    allmyhoney
    Member

    @allmyhoney

    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?

    Plugin Author aliciagh
    Member

    @aliciagh

    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

    kaotik
    Participant

    @kaotik

    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.

    Rob Roy
    Member

    @danetidwell

    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.

    allmyhoney
    Member

    @allmyhoney

    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

Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘[Plugin: Multisite Global Search] create view privileges?’ is closed to new replies.