Title: [Plugin: Multisite Global Search] Error to activate plugin
Last modified: August 20, 2016

---

# [Plugin: Multisite Global Search] Error to activate plugin

 *  [Santos R. Guerra Faro](https://wordpress.org/support/users/dragondeluz/)
 * (@dragondeluz)
 * [14 years, 5 months ago](https://wordpress.org/support/topic/plugin-multisite-global-search-error-to-activate-plugin/)
 * Error creating search views in the database. Deactivate Multisite Global Search
   and check you have create views privilege in your WordPress database.
    Illegal
   mix of collations for operation ‘UNION’
 * [http://wordpress.org/extend/plugins/multisite-global-search/](http://wordpress.org/extend/plugins/multisite-global-search/)

Viewing 15 replies - 1 through 15 (of 15 total)

 *  Plugin Author [aliciagh](https://wordpress.org/support/users/aliciagh/)
 * (@aliciagh)
 * [14 years, 4 months ago](https://wordpress.org/support/topic/plugin-multisite-global-search-error-to-activate-plugin/#post-2471932)
 * Hi Santos,
 * The problem is your database uses two different collations. If I find any solution,
   I’ll write you.
 * [http://forums.mysql.com/read.php?103,27204,27204](http://forums.mysql.com/read.php?103,27204,27204)
 *  Thread Starter [Santos R. Guerra Faro](https://wordpress.org/support/users/dragondeluz/)
 * (@dragondeluz)
 * [14 years, 4 months ago](https://wordpress.org/support/topic/plugin-multisite-global-search-error-to-activate-plugin/#post-2471933)
 * Thank you!
    I will be pending. the same way Try to repair the database
 *  Thread Starter [Santos R. Guerra Faro](https://wordpress.org/support/users/dragondeluz/)
 * (@dragondeluz)
 * [14 years, 4 months ago](https://wordpress.org/support/topic/plugin-multisite-global-search-error-to-activate-plugin/#post-2471934)
 * I have checked the database and “utf8_unicode_ci” and “utf8_general_ci”
    Are 
   there any tools to fix this problem?
 *  Plugin Author [aliciagh](https://wordpress.org/support/users/aliciagh/)
 * (@aliciagh)
 * [14 years, 4 months ago](https://wordpress.org/support/topic/plugin-multisite-global-search-error-to-activate-plugin/#post-2471935)
 * I think your problem will be resolved if you put this line in the file inc/view.
   php, between line 81 and 82.
    @mysql_query(“SET collation_connection = utf8_general_ci”);
 * 81: if( $blogs != null ) {
    82: $v_query1 = “CREATE OR REPLACE VIEW `{$wpdb->
   base_prefix}v_posts` AS “.$posts_select_query;
 * If it resolves the problem, write it here.
    Thanks!
 *  Plugin Author [aliciagh](https://wordpress.org/support/users/aliciagh/)
 * (@aliciagh)
 * [14 years, 4 months ago](https://wordpress.org/support/topic/plugin-multisite-global-search-error-to-activate-plugin/#post-2471936)
 * I found the solution on [http://www.adrformacion.com/articulos/bases_de_datos/mysql___problemas_con_juegos_de_caracteres___illegal_mix_of_collations/articulo1057.html](http://www.adrformacion.com/articulos/bases_de_datos/mysql___problemas_con_juegos_de_caracteres___illegal_mix_of_collations/articulo1057.html)
 *  Plugin Author [aliciagh](https://wordpress.org/support/users/aliciagh/)
 * (@aliciagh)
 * [14 years, 4 months ago](https://wordpress.org/support/topic/plugin-multisite-global-search-error-to-activate-plugin/#post-2471937)
 * Sorry, the line must be
    $wpdb->query(“SET collation_connection = utf8_general_ci”);
 *  Thread Starter [Santos R. Guerra Faro](https://wordpress.org/support/users/dragondeluz/)
 * (@dragondeluz)
 * [14 years, 4 months ago](https://wordpress.org/support/topic/plugin-multisite-global-search-error-to-activate-plugin/#post-2471938)
 * I did the following
    ALTER TABLE <table> DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
 * Yet the problem persists when you activate the plugin
 *  Thread Starter [Santos R. Guerra Faro](https://wordpress.org/support/users/dragondeluz/)
 * (@dragondeluz)
 * [14 years, 4 months ago](https://wordpress.org/support/topic/plugin-multisite-global-search-error-to-activate-plugin/#post-2471939)
 * no me digas que hablas español? y yo pasando trabajo con la traduccion, jajajajaja
   tando nadar para morir en la orilla, bueno….
 * Tenía eso ahi listo para publicar pero me quede dormido, lo publique ahorita 
   y vi tu respuesta, voy a revisar a que puedo hacer.
 * Te comento que antes de aplicar ese método, consulte varias instalaciones de 
   wordpress que tengo, y todas hay tablas en los 2 tipos de cotejamiento, osea 
   nunca antes lo había notado, pero casi todas mis instalaciones de wordpress tienen**
   utf8_general_ci** y **utf8_unicode_ci** en sus bases de datos.
    Por eso probé
   primero en **utf8_general_ci**.
 *  Thread Starter [Santos R. Guerra Faro](https://wordpress.org/support/users/dragondeluz/)
 * (@dragondeluz)
 * [14 years, 4 months ago](https://wordpress.org/support/topic/plugin-multisite-global-search-error-to-activate-plugin/#post-2471940)
 * No me funciona, ahora todas las tablas están en **utf8_general_ci**. por lo que
   no debería haber problemas, voy a eliminar el plugin y subirlo de nuevo, intentaré
   una vez mas con la base de datos.
 *  Thread Starter [Santos R. Guerra Faro](https://wordpress.org/support/users/dragondeluz/)
 * (@dragondeluz)
 * [14 years, 4 months ago](https://wordpress.org/support/topic/plugin-multisite-global-search-error-to-activate-plugin/#post-2471941)
 * Desactive todos los otros plugins por si había un conflicto pero tampoco.
 *  Plugin Author [aliciagh](https://wordpress.org/support/users/aliciagh/)
 * (@aliciagh)
 * [14 years, 4 months ago](https://wordpress.org/support/topic/plugin-multisite-global-search-error-to-activate-plugin/#post-2471942)
 * ¿Y has probado poniendo la linea que te he comentado? Yo tengo toda la base de
   datos con utf8_general_ci y no me da ningún problema en ninguna de las versiones
   de WordPress que tengo instaladas…
 *  Thread Starter [Santos R. Guerra Faro](https://wordpress.org/support/users/dragondeluz/)
 * (@dragondeluz)
 * [14 years, 4 months ago](https://wordpress.org/support/topic/plugin-multisite-global-search-error-to-activate-plugin/#post-2471943)
 * lo he colocado así:
 *  // Create or replace views.
    if( $blogs != null ) { $v_query1 = “CREATE OR REPLACE
   VIEW `$wpdb->query("SET collation_connection = utf8_general_ci");` AS “.$posts_select_query;
   if ( $wpdb->query( $wpdb->prepare( $v_query1 ) ) === false ) { wp_die( __( ‘Error
   creating search views in the database. [Deactivate Multisite Global Search](https://wordpress.org/support/topic/plugin-multisite-global-search-error-to-activate-plugin/plugins.php?output_format=md)
   and check you have create views privilege in your WordPress database.’, ‘ms-global-
   search’ ).’‘. $wpdb->last_error ); }
 * ¿o es que no entendí como era?
 *  Plugin Author [aliciagh](https://wordpress.org/support/users/aliciagh/)
 * (@aliciagh)
 * [14 years, 4 months ago](https://wordpress.org/support/topic/plugin-multisite-global-search-error-to-activate-plugin/#post-2471944)
 * La sentencia donde indicamos el tipo de collation que vamos a utilizar para realizar
   la conexión debe ir antes de ejecutar la sentencia de creación de la vista, es
   decir, así:
 * if( $blogs != null ) {
    $wpdb->query(“SET collation_connection = utf8_general_ci”);
   $v_query1 = “CREATE OR REPLACE VIEW {$wpdb->base_prefix}v_posts AS “.$posts_select_query;
   if ( $wpdb->query( $wpdb->prepare( $v_query1 ) ) === false ) {
 * Una vez hecho esto, desactiva y reactiva el plugin, si da error, comprueba en
   la base de datos si al menos se ha creado la vista wp_v_posts.
 *  Thread Starter [Santos R. Guerra Faro](https://wordpress.org/support/users/dragondeluz/)
 * (@dragondeluz)
 * [14 years, 4 months ago](https://wordpress.org/support/topic/plugin-multisite-global-search-error-to-activate-plugin/#post-2471945)
 * Hola, lo he intentado de nuevo y sigo teniendo el mismo resultado. No se mucho
   de manejo de base de datos.
 * Pero voy a hacer una prueba en otro servidor para ir despejando otras cosas. 
   A ver si es que hay algo en el tema.
 * Gracias por tu tiempo.
 *  Plugin Author [aliciagh](https://wordpress.org/support/users/aliciagh/)
 * (@aliciagh)
 * [14 years, 4 months ago](https://wordpress.org/support/topic/plugin-multisite-global-search-error-to-activate-plugin/#post-2471946)
 * Si consigues solucionarlo por favor házmelo saber para que lo comparta con el
   resto de la comunidad en el caso de que le pase a alguien más.
 * Gracias a ti por apostar por este plugin.

Viewing 15 replies - 1 through 15 (of 15 total)

The topic ‘[Plugin: Multisite Global Search] Error to activate plugin’ is closed
to new replies.

 * ![](https://ps.w.org/multisite-global-search/assets/icon-256x256.png?rev=1594489)
 * [Multisite Global Search](https://wordpress.org/plugins/multisite-global-search/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/multisite-global-search/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/multisite-global-search/)
 * [Active Topics](https://wordpress.org/support/plugin/multisite-global-search/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/multisite-global-search/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/multisite-global-search/reviews/)

 * 15 replies
 * 2 participants
 * Last reply from: [aliciagh](https://wordpress.org/support/users/aliciagh/)
 * Last activity: [14 years, 4 months ago](https://wordpress.org/support/topic/plugin-multisite-global-search-error-to-activate-plugin/#post-2471946)
 * Status: not resolved