Recordad que para pedir soporte alguno, debéis facilitar los datos de soporte oportunos por favor, mirad aquí y leer las Normas generales del foro, esto nos servirá de ayuda para dar el mejor soporte..

Gracias.

La Administración de phpBB España.

Solución Caracteres Extraños al convertir, migrar, trasladarTema Solucionado

Foros donde podréis dejar vuestras dudas sobre phpBB 3.0.x
Avatar de Usuario
Alorse
Ex Staff
Mensajes: 5144
Registrado: 22 Mar 2008, 02:14
Género:
Edad: 36

Solución Caracteres Extraños al convertir, migrar, trasladar  Tema Solucionado

#1

Mensaje por Alorse »

Esta es una duda más que común y que tal vez a todos nos ha llegado a suceder alguna vez si es que hemos llegado a migrar una base de datos de un gestor a otro o haber migrado de phpBB2 a phpBB3 o simplemente luego de trasladar nuestro foro a otro servidor.

Esto sucede porque realizamos algún paso equivocadamente en el momento aquel, sobre todo porque no nos fijamos en la codificación los archivos y la base de datos.

Aclaro que este tutorial solo es para arreglar caracteres de los temas, foros, post, nombres de usuarios, firmas, etc... en si solo los datos almacenados en la base de datos.

Si este problema te sucede luego de instalar un MOD, o modificar un archivo de idioma, puedes fijarte en este documento sobre Dudas frecuentes en phpBB3, en el que se explica como solucionarlo.

Y sin más preámbulos vamos a la solución.

Esta consiste en generar unas consultas SQL mediante phpMyAdmin para reemplazar estos caracteres extraños por las letras con los acentos, las ñ y algunos caracteres especiales.

Así que abrimos nuestra base de datos mediante phpMyAdmin (esto en el caso de MySQL), o si usamos otro tipo de base de datos, entonces con su gestor favorito.

Primero que todo y como siempre, creamos una backup de la base de datos por si surge algun inconveniente.

Aca estoy poniendo los ejemplo con el prefijo "phpbb_" que es el mas usado y el que trae por defecto phpBB en su instalación, pero si usan otro deberan cambiarlo o sino, las consultas mostraran error.

Ejecutamos por partes, las siguiente consultas (también se puede ejecutar todas juntas pero lo hare de esta manera, para explicar mejor).

Nombres de los foros y subforos (Para estos tendremos que actualizar los registros de la tabla phpbb_forums):

Código: Seleccionar todo

UPDATE phpbb_forums SET forum_name = replace(forum_name,'á','á');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'é','é');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'í','í');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'ó','ó');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'ú','ú');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'ñ','ñ');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'¿','¿');
Descripción de los foros y subforos:

Código: Seleccionar todo

UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'á','á');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'é','é');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'í','í');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'ó','ó');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'ú','ú');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'ñ','ñ');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'¿','¿');
Titulos de los Temas (Para estos tendremos que actualizar los registros de la tabla phpbb_topics):

Código: Seleccionar todo

UPDATE phpbb_topics SET topic_title = replace(topic_title,'á','á');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'é','é');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'í','í');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'ó','ó');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'ú','ú');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'ñ','ñ');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'¿','¿');
Asutos de los post (Para estos tendremos que actualizar los registros de la tabla phpbb_posts):

Código: Seleccionar todo

UPDATE phpbb_posts SET post_subject = replace(post_subject,'á','á');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'é','é');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'í','í');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'ó','ó');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'ú','ú');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'ñ','ñ');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'¿','¿');
Texto de los post (Si tu foro es muy grande y tiene demaciados mensajes, esta consulta puede tardar mas en realizarse, así que tengamos paciencia):

Código: Seleccionar todo

UPDATE phpbb_posts SET post_text = replace(post_text,'á','á');
UPDATE phpbb_posts SET post_text = replace(post_text,'é','é');
UPDATE phpbb_posts SET post_text = replace(post_text,'í','í');
UPDATE phpbb_posts SET post_text = replace(post_text,'ó','ó');
UPDATE phpbb_posts SET post_text = replace(post_text,'ú','ú');
UPDATE phpbb_posts SET post_text = replace(post_text,'ñ','ñ');
UPDATE phpbb_posts SET post_text = replace(post_text,'¿','¿');
Firmas de los usuarios (Para estos tendremos que actualizar los registros de la tabla phpbb_users):

Código: Seleccionar todo

UPDATE phpbb_users SET user_sig = replace(user_sig,'á','á');
UPDATE phpbb_users SET user_sig = replace(user_sig,'é','é');
UPDATE phpbb_users SET user_sig = replace(user_sig,'í','í');
UPDATE phpbb_users SET user_sig = replace(user_sig,'ó','ó');
UPDATE phpbb_users SET user_sig = replace(user_sig,'ú','ú');
UPDATE phpbb_users SET user_sig = replace(user_sig,'ñ','ñ');
UPDATE phpbb_users SET user_sig = replace(user_sig,'¿','¿');
Nicks de los usuarios (Algunos usuarios usan caracteres especiales o acentos en sus Nicks, así que tambien es necesario actulizar estos campos).

Código: Seleccionar todo

UPDATE phpbb_users SET username = replace(username,'á','á');
UPDATE phpbb_users SET username = replace(username,'é','é');
UPDATE phpbb_users SET username = replace(username,'í','í');
UPDATE phpbb_users SET username = replace(username,'ó','ó');
UPDATE phpbb_users SET username = replace(username,'ú','ú');
UPDATE phpbb_users SET username = replace(username,'ñ','ñ');
UPDATE phpbb_users SET username = replace(username,'¿','¿');
UPDATE phpbb_users SET username_clean = replace(username_clean,'á','á');
UPDATE phpbb_users SET username_clean = replace(username_clean,'é','é');
UPDATE phpbb_users SET username_clean = replace(username_clean,'í','í');
UPDATE phpbb_users SET username_clean = replace(username_clean,'ó','ó');
UPDATE phpbb_users SET username_clean = replace(username_clean,'ú','ú');
UPDATE phpbb_users SET username_clean = replace(username_clean,'ñ','ñ');
UPDATE phpbb_users SET username_clean = replace(username_clean,'¿','¿');

Estas consultas convertiran los caracteres á , é , í , ó , ú , ñ , ¿ lo que significa que no convierten otros caractedes especiales como el º o vocales con acentos en MAYUSCULAS (É , Ú , Ó), así que deberan crear sus propias consultas para esto, explico:

Para convertIr otros caracteres que no estan acá, de la siguiente manera:

UPDATE TABLA_DE_PHPBB SET CAMPO_TABLA = replace( CAMPO_TABLA, 'CARACTER_EXTRAÑO' , 'CARACTER_CORRECTO' );

TABLA_DE_PHPBB, Tabla en la cual realizaremos la consulta, eje = phpbb_posts,
CAMPO_TABLA, campo en el cual se encuentra almanecenado el caracter extraño, eje = post_text,
CARACTER_EXTRAÑO, caracter que queremos convertir, eje = ´ => caracter extraño que representa la Á,
CARACTER_CORRECTO, caracter correcto por que queremos reemplazar el extraño, eje = Á,

Entonces si queremos crear una consulta con el ejemplo anterior que puse quedaria de la siguiete manera:

UPDATE phpbb_posts SET post_text = replace( post_text , '´' , 'Á' );

Y lo que haria, seria reemplazar todos los caracteres estraños que representan la á mayuscula por "Á".
Espero haberme hecho entender y que esta guía les sea de utilidad, cualquier duda, pueden preguntar.

Agrego unas cuantas lineas mas que HuanManwe nos ha compartido para hacer mas amplia la solucion.

Código: Seleccionar todo

UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'ƒÂ','');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'á','á');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'é','é');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'Ã-','í');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'ó','ó');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'ú','ú');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'ñ','ñ');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'¿','¿');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'´','Á');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'É','É');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'Ó','Ó');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'Ú','Ú');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'¡','¡');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'Ñ','Ñ');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'À','À');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'È','È');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'è','è');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'Ã’','Ò');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'ò','ò');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'Ã','í');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'Â','Í');

UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'ƒÂ','');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'á','á');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'é','é');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'Ã-','í');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'ó','ó');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'ú','ú');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'ñ','ñ');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'¿','¿');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'´','Á');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'É','É');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'Ó','Ó');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'Ú','Ú');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'¡','¡');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'Ñ','Ñ');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'À','À');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'È','È');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'è','è');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'Ã’','Ò');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'ò','ò');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'Â','Í');

UPDATE phpbb_drafts SET draft_message = replace(draft_message,'ƒÂ','');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'á','á');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'é','é');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'Ã-','í');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'ó','ó');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'ú','ú');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'ñ','ñ');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'¿','¿');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'´','Á');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'É','É');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'Ó','Ó');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'Ú','Ú');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'¡','¡');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'Ñ','Ñ');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'À','À');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'È','È');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'è','è');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'Ã’','Ò');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'ò','ò');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'Ã','í');

UPDATE phpbb_extension_groups SET group_name = replace(group_name,'ƒÂ','');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'á','á');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'é','é');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'Ã-','í');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'ó','ó');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'ú','ú');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'ñ','ñ');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'¿','¿');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'´','Á');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'É','É');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'Ó','Ó');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'Ú','Ú');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'¡','¡');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'Ñ','Ñ');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'À','À');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'È','È');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'è','è');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'Ã’','Ò');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'ò','ò');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'Ã','í');

UPDATE phpbb_forums SET forum_name = replace(forum_name,'ƒÂ','');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'á','á');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'é','é');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'Ã-','í');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'ó','ó');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'ú','ú');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'ñ','ñ');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'¿','¿');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'´','Á');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'É','É');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'Ó','Ó');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'Ú','Ú');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'¡','¡');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'Ñ','Ñ');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'À','À');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'È','È');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'è','è');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'Ã’','Ò');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'ò','ò');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'Ã','í');
   
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'ƒÂ','');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'á','á');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'é','é');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'Ã-','í');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'ó','ó');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'ú','ú');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'ñ','ñ');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'¿','¿');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'´','Á');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'É','É');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'Ó','Ó');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'Ú','Ú');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'¡','¡');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'Ñ','Ñ');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'À','À');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'È','È');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'è','è');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'Ã’','Ò');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'ò','ò');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'Ã','í');

UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'ƒÂ','');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'á','á');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'é','é');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'Ã-','í');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'ó','ó');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'ú','ú');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'ñ','ñ');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'¿','¿');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'´','Á');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'É','É');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'Ó','Ó');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'Ú','Ú');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'¡','¡');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'Ñ','Ñ');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'À','À');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'È','È');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'è','è');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'Ã’','Ò');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'ò','ò');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'Ã','í');

UPDATE phpbb_groups SET group_name = replace(group_name,'ƒÂ','');
UPDATE phpbb_groups SET group_name = replace(group_name,'á','á');
UPDATE phpbb_groups SET group_name = replace(group_name,'é','é');
UPDATE phpbb_groups SET group_name = replace(group_name,'Ã-','í');
UPDATE phpbb_groups SET group_name = replace(group_name,'ó','ó');
UPDATE phpbb_groups SET group_name = replace(group_name,'ó','ó');
UPDATE phpbb_groups SET group_name = replace(group_name,'ú','ú');
UPDATE phpbb_groups SET group_name = replace(group_name,'ñ','ñ');
UPDATE phpbb_groups SET group_name = replace(group_name,'¿','¿');
UPDATE phpbb_groups SET group_name = replace(group_name,'´','Á');
UPDATE phpbb_groups SET group_name = replace(group_name,'É','É');
UPDATE phpbb_groups SET group_name = replace(group_name,'Ó','Ó');
UPDATE phpbb_groups SET group_name = replace(group_name,'Ú','Ú');
UPDATE phpbb_groups SET group_name = replace(group_name,'¡','¡');
UPDATE phpbb_groups SET group_name = replace(group_name,'Ñ','Ñ');
UPDATE phpbb_groups SET group_name = replace(group_name,'À','À');
UPDATE phpbb_groups SET group_name = replace(group_name,'È','È');
UPDATE phpbb_groups SET group_name = replace(group_name,'è','è');
UPDATE phpbb_groups SET group_name = replace(group_name,'Ã’','Ò');
UPDATE phpbb_groups SET group_name = replace(group_name,'ò','ò');
UPDATE phpbb_groups SET group_name = replace(group_name,'Ã','í');

UPDATE phpbb_groups SET group_desc = replace(group_desc,'ƒÂ','');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'á','á');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'é','é');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'Ã-','í');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'ó','ó');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'ó','ó');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'ú','ú');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'ñ','ñ');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'¿','¿');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'´','Á');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'É','É');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'Ó','Ó');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'Ú','Ú');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'¡','¡');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'Ñ','Ñ');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'À','À');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'È','È');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'è','è');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'Ã’','Ò');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'ò','ò');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'Ã','í');

UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'ƒÂ','');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'á','á');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'é','é');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'Ã-','í');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'ó','ó');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'ú','ú');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'ñ','ñ');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'¿','¿');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'´','Á');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'É','É');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'Ó','Ó');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'Ú','Ú');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'¡','¡');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'Ñ','Ñ');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'À','À');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'È','È');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'è','è');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'Ã’','Ò');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'ò','ò');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'Ã','í');
   
UPDATE phpbb_log SET log_data = replace(log_data,'ƒÂ','');
UPDATE phpbb_log SET log_data = replace(log_data,'á','á');
UPDATE phpbb_log SET log_data = replace(log_data,'é','é');
UPDATE phpbb_log SET log_data = replace(log_data,'Ã-','í');
UPDATE phpbb_log SET log_data = replace(log_data,'ó','ó');
UPDATE phpbb_log SET log_data = replace(log_data,'ú','ú');
UPDATE phpbb_log SET log_data = replace(log_data,'ñ','ñ');
UPDATE phpbb_log SET log_data = replace(log_data,'¿','¿');
UPDATE phpbb_log SET log_data = replace(log_data,'´','Á');
UPDATE phpbb_log SET log_data = replace(log_data,'É','É');
UPDATE phpbb_log SET log_data = replace(log_data,'Ó','Ó');
UPDATE phpbb_log SET log_data = replace(log_data,'Ú','Ú');
UPDATE phpbb_log SET log_data = replace(log_data,'¡','¡');
UPDATE phpbb_log SET log_data = replace(log_data,'Ñ','Ñ');
UPDATE phpbb_log SET log_data = replace(log_data,'À','À');
UPDATE phpbb_log SET log_data = replace(log_data,'È','È');
UPDATE phpbb_log SET log_data = replace(log_data,'è','è');
UPDATE phpbb_log SET log_data = replace(log_data,'Ã’','Ò');
UPDATE phpbb_log SET log_data = replace(log_data,'ò','ò');
UPDATE phpbb_log SET log_data = replace(log_data,'Ã','í');

UPDATE phpbb_moderator_cache SET username = replace(username,'ƒÂ','');
UPDATE phpbb_moderator_cache SET username = replace(username,'á','á');
UPDATE phpbb_moderator_cache SET username = replace(username,'é','é');
UPDATE phpbb_moderator_cache SET username = replace(username,'Ã-','í');
UPDATE phpbb_moderator_cache SET username = replace(username,'ó','ó');
UPDATE phpbb_moderator_cache SET username = replace(username,'ú','ú');
UPDATE phpbb_moderator_cache SET username = replace(username,'ñ','ñ');
UPDATE phpbb_moderator_cache SET username = replace(username,'¿','¿');
UPDATE phpbb_moderator_cache SET username = replace(username,'´','Á');
UPDATE phpbb_moderator_cache SET username = replace(username,'É','É');
UPDATE phpbb_moderator_cache SET username = replace(username,'Ó','Ó');
UPDATE phpbb_moderator_cache SET username = replace(username,'Ú','Ú');
UPDATE phpbb_moderator_cache SET username = replace(username,'¡','¡');
UPDATE phpbb_moderator_cache SET username = replace(username,'Ñ','Ñ');
UPDATE phpbb_moderator_cache SET username = replace(username,'À','À');
UPDATE phpbb_moderator_cache SET username = replace(username,'È','È');
UPDATE phpbb_moderator_cache SET username = replace(username,'è','è');
UPDATE phpbb_moderator_cache SET username = replace(username,'Ã’','Ò');
UPDATE phpbb_moderator_cache SET username = replace(username,'ò','ò');
UPDATE phpbb_moderator_cache SET username = replace(username,'Ã','í');

UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'ƒÂ','');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'á','á');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'á','á');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'é','é');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'Ã-','í');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'ó','ó');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'ú','ú');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'ñ','ñ');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'¿','¿');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'´','Á');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'Ó','Ó');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'Ú','Ú');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'¡','¡');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'Ñ','Ñ');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'À','À');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'È','È');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'è','è');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'Ã’','Ò');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'ò','ò');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'Ã','í');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'€','€');

UPDATE phpbb_posts SET post_subject = replace(post_subject,'ƒÂ','');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'á','á');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'é','é');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'Ã-','í');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'ó','ó');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'ú','ú');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'ñ','ñ');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'¿','¿');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'´','Á');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'É','É');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'Ó','Ó');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'Ú','Ú');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'©','©');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'¡','¡');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'Ñ','Ñ');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'À','À');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'È','È');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'è','è');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'Ã’','Ò');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'ò','ò');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'Ã','í');


UPDATE phpbb_posts SET post_text = replace(post_text,'ƒÂ','');
UPDATE phpbb_posts SET post_text = replace(post_text,'á','á');
UPDATE phpbb_posts SET post_text = replace(post_text,'é','é');
UPDATE phpbb_posts SET post_text = replace(post_text,'Ã-','í');
UPDATE phpbb_posts SET post_text = replace(post_text,'ó','ó');
UPDATE phpbb_posts SET post_text = replace(post_text,'ú','ú');
UPDATE phpbb_posts SET post_text = replace(post_text,'ñ','ñ');
UPDATE phpbb_posts SET post_text = replace(post_text,'í±','ñ');
UPDATE phpbb_posts SET post_text = replace(post_text,'¿','¿');
UPDATE phpbb_posts SET post_text = replace(post_text,'´','Á');
UPDATE phpbb_posts SET post_text = replace(post_text,'É','É');
UPDATE phpbb_posts SET post_text = replace(post_text,'Ó','Ó');
UPDATE phpbb_posts SET post_text = replace(post_text,'Ú','Ú');
UPDATE phpbb_posts SET post_text = replace(post_text,'©','©');
UPDATE phpbb_posts SET post_text = replace(post_text,'¡','¡');
UPDATE phpbb_posts SET post_text = replace(post_text,'Ñ','Ñ');
UPDATE phpbb_posts SET post_text = replace(post_text,'À','À');
UPDATE phpbb_posts SET post_text = replace(post_text,'È','È');
UPDATE phpbb_posts SET post_text = replace(post_text,'è','è');
UPDATE phpbb_posts SET post_text = replace(post_text,'Ã’','Ò');
UPDATE phpbb_posts SET post_text = replace(post_text,'ò','ò');
UPDATE phpbb_posts SET post_text = replace(post_text,'Ã','í');



UPDATE phpbb_privmsgs SET message_text = replace(message_text,'ƒÂ','');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'á','á');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'é','é');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'Ã-','í');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'ó','ó');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'ú','ú');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'ñ','ñ');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'¿','¿');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'´','Á');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'É','É');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'Ó','Ó');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'Ú','Ú');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'¡','¡');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'Ñ','Ñ');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'À','À');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'È','È');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'è','è');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'Ã’','Ò');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'ò','ò');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'Ã','í');
   
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'ƒÂ','');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'á','á');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'é','é');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'Ã-','í');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'ó','ó');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'ú','ú');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'ñ','ñ');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'¿','¿');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'´','Á');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'É','É');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'Ó','Ó');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'Ú','Ú');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'¡','¡');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'Ñ','Ñ');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'À','À');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'È','È');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'è','è');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'Ã’','Ò');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'ò','ò');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'Ã','í');

UPDATE phpbb_reports SET report_text = replace(report_text,'ƒÂ','');
UPDATE phpbb_reports SET report_text = replace(report_text,'á','á');
UPDATE phpbb_reports SET report_text = replace(report_text,'é','é');
UPDATE phpbb_reports SET report_text = replace(report_text,'Ã-','í');
UPDATE phpbb_reports SET report_text = replace(report_text,'ó','ó');
UPDATE phpbb_reports SET report_text = replace(report_text,'ú','ú');
UPDATE phpbb_reports SET report_text = replace(report_text,'ñ','ñ');
UPDATE phpbb_reports SET report_text = replace(report_text,'¿','¿');
UPDATE phpbb_reports SET report_text = replace(report_text,'´','Á');
UPDATE phpbb_reports SET report_text = replace(report_text,'É','É');
UPDATE phpbb_reports SET report_text = replace(report_text,'Ó','Ó');
UPDATE phpbb_reports SET report_text = replace(report_text,'Ú','Ú');
UPDATE phpbb_reports SET report_text = replace(report_text,'¡','¡');
UPDATE phpbb_reports SET report_text = replace(report_text,'Ñ','Ñ');
UPDATE phpbb_reports SET report_text = replace(report_text,'À','À');
UPDATE phpbb_reports SET report_text = replace(report_text,'È','È');
UPDATE phpbb_reports SET report_text = replace(report_text,'è','è');
UPDATE phpbb_reports SET report_text = replace(report_text,'Ã’','Ò');
UPDATE phpbb_reports SET report_text = replace(report_text,'ò','ò');
UPDATE phpbb_reports SET report_text = replace(report_text,'Ã','í');

UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'ƒÂ','');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'á','á');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'é','é');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'Ã-','í');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'ó','ó');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'ú','ú');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'ñ','ñ');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'¿','¿');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'´','Á');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'É','É');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'Ó','Ó');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'Ú','Ú');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'¡','¡');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'Ñ','Ñ');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'À','À');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'È','È');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'è','è');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'Ã’','Ò');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'ò','ò');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'Ã','í');

UPDATE phpbb_topics SET topic_title = replace(topic_title,'ƒÂ','');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'á','á');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'é','é');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'Ã-','í');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'ó','ó');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'ú','ú');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'ñ','ñ');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'¿','¿');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'´','Á');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'É','É');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'Ó','Ó');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'Ú','Ú');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'©','©');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'¡','¡');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'Ñ','Ñ');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'À','À');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'È','È');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'è','è');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'Ã’','Ò');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'ò','ò');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'Ã','í');
   
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'ƒÂ','');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'á','á');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'é','é');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'Ã-','í');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'ó','ó');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'ú','ú');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'ñ','ñ');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'¿','¿');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'´','Á');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'É','É');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'Ó','Ó');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'Ú','Ú');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'©','©');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'¡','¡');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'Ñ','Ñ');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'À','À');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'È','È');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'è','è');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'Ã’','Ò');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'ò','ò');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'Ã','í');

UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'ƒÂ','');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'á','á');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'é','é');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'Ã-','í');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'ó','ó');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'ú','ú');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'ñ','ñ');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'¿','¿');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'´','Á');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'É','É');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'Ó','Ó');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'Ú','Ú');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'¡','¡');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'Ñ','Ñ');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'À','À');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'È','È');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'è','è');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'Ã’','Ò');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'ò','ò');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'Ã','í');
   
UPDATE phpbb_users SET user_sig = replace(user_sig,'ƒÂ','');
UPDATE phpbb_users SET user_sig = replace(user_sig,'á','á');
UPDATE phpbb_users SET user_sig = replace(user_sig,'é','é');
UPDATE phpbb_users SET user_sig = replace(user_sig,'Ã-','í');
UPDATE phpbb_users SET user_sig = replace(user_sig,'ó','ó');
UPDATE phpbb_users SET user_sig = replace(user_sig,'ú','ú');
UPDATE phpbb_users SET user_sig = replace(user_sig,'ñ','ñ');
UPDATE phpbb_users SET user_sig = replace(user_sig,'¿','¿');
UPDATE phpbb_users SET user_sig = replace(user_sig,'´','Á');
UPDATE phpbb_users SET user_sig = replace(user_sig,'É','É');
UPDATE phpbb_users SET user_sig = replace(user_sig,'Ó','Ó');
UPDATE phpbb_users SET user_sig = replace(user_sig,'Ú','Ú');
UPDATE phpbb_users SET user_sig = replace(user_sig,'¡','¡');
UPDATE phpbb_users SET user_sig = replace(user_sig,'Ñ','Ñ');
UPDATE phpbb_users SET user_sig = replace(user_sig,'À','À');
UPDATE phpbb_users SET user_sig = replace(user_sig,'È','È');
UPDATE phpbb_users SET user_sig = replace(user_sig,'è','è');
UPDATE phpbb_users SET user_sig = replace(user_sig,'Ã’','Ò');
UPDATE phpbb_users SET user_sig = replace(user_sig,'ò','ò');
UPDATE phpbb_users SET user_sig = replace(user_sig,'Ã','í');

UPDATE phpbb_users SET username = replace(username,'ƒÂ','');
UPDATE phpbb_users SET username = replace(username,'á','á');
UPDATE phpbb_users SET username = replace(username,'é','é');
UPDATE phpbb_users SET username = replace(username,'Ã-','í');
UPDATE phpbb_users SET username = replace(username,'ó','ó');
UPDATE phpbb_users SET username = replace(username,'ú','ú');
UPDATE phpbb_users SET username = replace(username,'ñ','ñ');
UPDATE phpbb_users SET username = replace(username,'¿','¿');
UPDATE phpbb_users SET username = replace(username,'ª','ª');
UPDATE phpbb_users SET username = replace(username,'´','Á');
UPDATE phpbb_users SET username = replace(username,'É','É');
UPDATE phpbb_users SET username = replace(username,'Ó','Ó');
UPDATE phpbb_users SET username = replace(username,'Ú','Ú');
UPDATE phpbb_users SET username = replace(username,'¡','¡');
UPDATE phpbb_users SET username = replace(username,'Ñ','Ñ');
UPDATE phpbb_users SET username = replace(username,'À','À');
UPDATE phpbb_users SET username = replace(username,'È','È');
UPDATE phpbb_users SET username = replace(username,'è','è');
UPDATE phpbb_users SET username = replace(username,'Ã’','Ò');
UPDATE phpbb_users SET username = replace(username,'ò','ò');
UPDATE phpbb_users SET username = replace(username,'Ã','í');
UPDATE phpbb_users SET username_clean = replace(username_clean,'ƒÂ','');
UPDATE phpbb_users SET username_clean = replace(username_clean,'á','á');
UPDATE phpbb_users SET username_clean = replace(username_clean,'é','é');
UPDATE phpbb_users SET username_clean = replace(username_clean,'Ã-','í');
UPDATE phpbb_users SET username_clean = replace(username_clean,'ó','ó');
UPDATE phpbb_users SET username_clean = replace(username_clean,'ú','ú');
UPDATE phpbb_users SET username_clean = replace(username_clean,'ñ','ñ');
UPDATE phpbb_users SET username_clean = replace(username_clean,'¿','¿');
UPDATE phpbb_users SET username_clean = replace(username_clean,'´','Á');
UPDATE phpbb_users SET username_clean = replace(username_clean,'À','Á');
UPDATE phpbb_users SET username_clean = replace(username_clean,'‰','É');
UPDATE phpbb_users SET username_clean = replace(username_clean,'Ó','Ó');
UPDATE phpbb_users SET username_clean = replace(username_clean,'Ú','Ú');
UPDATE phpbb_users SET username_clean = replace(username_clean,'¡','¡');
UPDATE phpbb_users SET username_clean = replace(username_clean,'Ñ','Ñ');
UPDATE phpbb_users SET username_clean = replace(username_clean,'À','À');
UPDATE phpbb_users SET username_clean = replace(username_clean,'È','È');
UPDATE phpbb_users SET username_clean = replace(username_clean,'è','è');
UPDATE phpbb_users SET username_clean = replace(username_clean,'Ã’','Ò');
UPDATE phpbb_users SET username_clean = replace(username_clean,'ò','ò');
UPDATE phpbb_users SET username_clean = replace(username_clean,'Ã','í');

UPDATE phpbb_styles SET style_copyright = replace(style_copyright,'©','©');
Otra mas para la tabla phpbb_users - campos: user_from (ubicación), user_occ (ocupación), user_interests (intereses)

Código: Seleccionar todo

UPDATE phpbb_users SET user_from = replace(user_from,'ƒÂ','');
UPDATE phpbb_users SET user_from = replace(user_from,'á','á');
UPDATE phpbb_users SET user_from = replace(user_from,'é','é');
UPDATE phpbb_users SET user_from = replace(user_from,'Ã-','í');
UPDATE phpbb_users SET user_from = replace(user_from,'ó','ó');
UPDATE phpbb_users SET user_from = replace(user_from,'ú','ú');
UPDATE phpbb_users SET user_from = replace(user_from,'ñ','ñ');
UPDATE phpbb_users SET user_from = replace(user_from,'¿','¿');
UPDATE phpbb_users SET user_from = replace(user_from,'´','Á');
UPDATE phpbb_users SET user_from = replace(user_from,'À','Á');
UPDATE phpbb_users SET user_from = replace(user_from,'‰','É');
UPDATE phpbb_users SET user_from = replace(user_from,'Ó','Ó');
UPDATE phpbb_users SET user_from = replace(user_from,'Ú','Ú');
UPDATE phpbb_users SET user_from = replace(user_from,'¡','¡');
UPDATE phpbb_users SET user_from = replace(user_from,'Ñ','Ñ');
UPDATE phpbb_users SET user_from = replace(user_from,'À','À');
UPDATE phpbb_users SET user_from = replace(user_from,'È','È');
UPDATE phpbb_users SET user_from = replace(user_from,'è','è');
UPDATE phpbb_users SET user_from = replace(user_from,'Ã’','Ò');
UPDATE phpbb_users SET user_from = replace(user_from,'ò','ò');
UPDATE phpbb_users SET user_from = replace(user_from,'Ã','í');


UPDATE phpbb_users SET user_occ = replace(user_occ,'ƒÂ','');
UPDATE phpbb_users SET user_occ = replace(user_occ,'á','á');
UPDATE phpbb_users SET user_occ = replace(user_occ,'é','é');
UPDATE phpbb_users SET user_occ = replace(user_occ,'Ã-','í');
UPDATE phpbb_users SET user_occ = replace(user_occ,'ó','ó');
UPDATE phpbb_users SET user_occ = replace(user_occ,'ú','ú');
UPDATE phpbb_users SET user_occ = replace(user_occ,'ñ','ñ');
UPDATE phpbb_users SET user_occ = replace(user_occ,'¿','¿');
UPDATE phpbb_users SET user_occ = replace(user_occ,'´','Á');
UPDATE phpbb_users SET user_occ = replace(user_occ,'À','Á');
UPDATE phpbb_users SET user_occ = replace(user_occ,'‰','É');
UPDATE phpbb_users SET user_occ = replace(user_occ,'Ó','Ó');
UPDATE phpbb_users SET user_occ = replace(user_occ,'Ú','Ú');
UPDATE phpbb_users SET user_occ = replace(user_occ,'¡','¡');
UPDATE phpbb_users SET user_occ = replace(user_occ,'Ñ','Ñ');
UPDATE phpbb_users SET user_occ = replace(user_occ,'À','À');
UPDATE phpbb_users SET user_occ = replace(user_occ,'È','È');
UPDATE phpbb_users SET user_occ = replace(user_occ,'è','è');
UPDATE phpbb_users SET user_occ = replace(user_occ,'Ã’','Ò');
UPDATE phpbb_users SET user_occ = replace(user_occ,'ò','ò');
UPDATE phpbb_users SET user_occ = replace(user_occ,'Ã','í');


UPDATE phpbb_users SET user_interests = replace(user_interests,'ƒÂ','');
UPDATE phpbb_users SET user_interests = replace(user_interests,'á','á');
UPDATE phpbb_users SET user_interests = replace(user_interests,'é','é');
UPDATE phpbb_users SET user_interests = replace(user_interests,'Ã-','í');
UPDATE phpbb_users SET user_interests = replace(user_interests,'ó','ó');
UPDATE phpbb_users SET user_interests = replace(user_interests,'ú','ú');
UPDATE phpbb_users SET user_interests = replace(user_interests,'ñ','ñ');
UPDATE phpbb_users SET user_interests = replace(user_interests,'¿','¿');
UPDATE phpbb_users SET user_interests = replace(user_interests,'´','Á');
UPDATE phpbb_users SET user_interests = replace(user_interests,'À','Á');
UPDATE phpbb_users SET user_interests = replace(user_interests,'‰','É');
UPDATE phpbb_users SET user_interests = replace(user_interests,'Ó','Ó');
UPDATE phpbb_users SET user_interests = replace(user_interests,'Ú','Ú');
UPDATE phpbb_users SET user_interests = replace(user_interests,'¡','¡');
UPDATE phpbb_users SET user_interests = replace(user_interests,'Ñ','Ñ');
UPDATE phpbb_users SET user_interests = replace(user_interests,'À','À');
UPDATE phpbb_users SET user_interests = replace(user_interests,'È','È');
UPDATE phpbb_users SET user_interests = replace(user_interests,'è','è');
UPDATE phpbb_users SET user_interests = replace(user_interests,'Ã’','Ò');
UPDATE phpbb_users SET user_interests = replace(user_interests,'ò','ò');
UPDATE phpbb_users SET user_interests = replace(user_interests,'Ã','í');
Saludos.

EDITADO por leviatan21: añado adjunto un charset.zip con un script que se encargara de "arreglar" los caracteres extraños que hallan en nuestro foro..
solucion_caracteres_extraños_2010_12_27.zip
listado completo actualizado al día 27 de diciembre del 2010
(3.04 KiB) Descargado 558 veces
EDITADO por HuanManwe: actualizado el archivo txt adjunto con todo el listado al día 27 de diciembre del 2010 con el aporte de karbiko: http://www.phpbb-es.com/foro/mensaje168580.html#p168570.
charset.zip
(2.73 KiB) Descargado 645 veces
Instrucciones :
Descargar el adjunto, descomprimir y subir al servidor, para ejecutarlo se debe estar identificado en el foro como administrador, preferentemente fundador.
Una vez en tu servidor, abrir una ventana y apuntar el navegador a esta dirección :

Código: Seleccionar todo

http://URL_AL_RAIZ_DEL_FORO/charset.php
Puede resultar lento, y se debe ejecutar tantas veces como sea necesario, hasta que en la pantalla sólo aparezca la palabra FIN
Última edición por Alorse el 05 Nov 2011, 04:44, editado 2 veces en total.
Razón: Agregada instrucciones para el script "charser.php"

Avatar de Usuario
HuanManwe
Ex Staff
Mensajes: 5078
Registrado: 20 Jun 2006, 18:21
Género:
Edad: 50

Re: Solución Caracteres Extraños al convertir, migrar, trasladar

#2

Mensaje por HuanManwe »

Gran trabajo de recopilación :bravo: muy útil

Der Mensch schuf Gott nach seinem eigenen Bild

Berlín siempre estará en mi corazón. Auf wiedersehen, Berlin!!


Avatar de Usuario
HuanManwe
Ex Staff
Mensajes: 5078
Registrado: 20 Jun 2006, 18:21
Género:
Edad: 50

Re: Solución Caracteres Extraños al convertir, migrar, trasl

#3

Mensaje por HuanManwe »

He ampliado un poco el listado de sentencias SQL para conseguir arreglar esos problemas. Aquí va:

Código: Seleccionar todo

UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'','');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'á','á');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'é','é');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'í','í');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'ó','ó');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'ú','ú');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'ñ','ñ');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'¿','¿');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'Á','Á');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'É','É');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'Ó','Ó');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'íš','Ú');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'¡','¡');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'Ñ','Ñ');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'À','À');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'íˆ','È');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'È','è');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'í’','Ò');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'í²','ò');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'í','í');
UPDATE phpbb_banlist SET ban_reason = replace(ban_reason,'Â','Í');

UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'','');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'á','á');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'é','é');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'í','í');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'ó','ó');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'ú','ú');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'ñ','ñ');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'¿','¿');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'Á','Á');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'É','É');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'Ó','Ó');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'íš','Ú');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'¡','¡');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'Ñ','Ñ');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'À','À');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'íˆ','È');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'È','è');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'í’','Ò');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'í²','ò');
UPDATE phpbb_banlist SET ban_give_reason = replace(ban_give_reason,'Â','Í');

UPDATE phpbb_drafts SET draft_message = replace(draft_message,'','');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'á','á');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'é','é');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'í','í');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'ó','ó');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'ú','ú');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'ñ','ñ');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'¿','¿');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'Á','Á');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'É','É');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'Ó','Ó');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'íš','Ú');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'¡','¡');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'Ñ','Ñ');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'À','À');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'íˆ','È');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'È','è');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'í’','Ò');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'í²','ò');
UPDATE phpbb_drafts SET draft_message = replace(draft_message,'í','í');

UPDATE phpbb_extension_groups SET group_name = replace(group_name,'','');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'á','á');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'é','é');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'í','í');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'ó','ó');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'ú','ú');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'ñ','ñ');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'¿','¿');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'Á','Á');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'É','É');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'Ó','Ó');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'íš','Ú');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'¡','¡');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'Ñ','Ñ');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'À','À');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'íˆ','È');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'È','è');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'í’','Ò');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'í²','ò');
UPDATE phpbb_extension_groups SET group_name = replace(group_name,'í','í');

UPDATE phpbb_forums SET forum_name = replace(forum_name,'','');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'á','á');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'é','é');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'í','í');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'ó','ó');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'ú','ú');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'ñ','ñ');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'¿','¿');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'Á','Á');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'É','É');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'Ó','Ó');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'íš','Ú');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'¡','¡');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'Ñ','Ñ');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'À','À');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'íˆ','È');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'È','è');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'í’','Ò');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'í²','ò');
UPDATE phpbb_forums SET forum_name = replace(forum_name,'í','í');
	
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'','');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'á','á');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'é','é');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'í','í');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'ó','ó');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'ú','ú');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'ñ','ñ');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'¿','¿');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'Á','Á');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'É','É');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'Ó','Ó');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'íš','Ú');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'¡','¡');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'Ñ','Ñ');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'À','À');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'íˆ','È');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'È','è');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'í’','Ò');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'í²','ò');
UPDATE phpbb_forums SET forum_desc = replace(forum_desc,'í','í');

UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'','');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'á','á');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'é','é');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'í','í');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'ó','ó');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'ú','ú');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'ñ','ñ');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'¿','¿');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'Á','Á');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'É','É');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'Ó','Ó');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'íš','Ú');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'¡','¡');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'Ñ','Ñ');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'À','À');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'íˆ','È');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'È','è');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'í’','Ò');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'í²','ò');
UPDATE phpbb_forums SET forum_parents = replace(forum_parents,'í','í');

UPDATE phpbb_groups SET group_name = replace(group_name,'','');
UPDATE phpbb_groups SET group_name = replace(group_name,'á','á');
UPDATE phpbb_groups SET group_name = replace(group_name,'é','é');
UPDATE phpbb_groups SET group_name = replace(group_name,'í','í');
UPDATE phpbb_groups SET group_name = replace(group_name,'ó','ó');
UPDATE phpbb_groups SET group_name = replace(group_name,'ó','ó');
UPDATE phpbb_groups SET group_name = replace(group_name,'ú','ú');
UPDATE phpbb_groups SET group_name = replace(group_name,'ñ','ñ');
UPDATE phpbb_groups SET group_name = replace(group_name,'¿','¿');
UPDATE phpbb_groups SET group_name = replace(group_name,'Á','Á');
UPDATE phpbb_groups SET group_name = replace(group_name,'É','É');
UPDATE phpbb_groups SET group_name = replace(group_name,'Ó','Ó');
UPDATE phpbb_groups SET group_name = replace(group_name,'íš','Ú');
UPDATE phpbb_groups SET group_name = replace(group_name,'¡','¡');
UPDATE phpbb_groups SET group_name = replace(group_name,'Ñ','Ñ');
UPDATE phpbb_groups SET group_name = replace(group_name,'À','À');
UPDATE phpbb_groups SET group_name = replace(group_name,'íˆ','È');
UPDATE phpbb_groups SET group_name = replace(group_name,'È','è');
UPDATE phpbb_groups SET group_name = replace(group_name,'í’','Ò');
UPDATE phpbb_groups SET group_name = replace(group_name,'í²','ò');
UPDATE phpbb_groups SET group_name = replace(group_name,'í','í');

UPDATE phpbb_groups SET group_desc = replace(group_desc,'','');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'á','á');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'é','é');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'í','í');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'ó','ó');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'ó','ó');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'ú','ú');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'ñ','ñ');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'¿','¿');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'Á','Á');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'É','É');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'Ó','Ó');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'íš','Ú');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'¡','¡');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'Ñ','Ñ');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'À','À');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'íˆ','È');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'È','è');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'í’','Ò');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'í²','ò');
UPDATE phpbb_groups SET group_desc = replace(group_desc,'í','í');

UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'','');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'á','á');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'é','é');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'í','í');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'ó','ó');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'ú','ú');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'ñ','ñ');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'¿','¿');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'Á','Á');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'É','É');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'Ó','Ó');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'íš','Ú');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'¡','¡');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'Ñ','Ñ');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'À','À');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'íˆ','È');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'È','è');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'í’','Ò');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'í²','ò');
UPDATE phpbb_lang SET lang_local_name = replace(lang_local_name,'í','í');
	
UPDATE phpbb_log SET log_data = replace(log_data,'','');
UPDATE phpbb_log SET log_data = replace(log_data,'á','á');
UPDATE phpbb_log SET log_data = replace(log_data,'é','é');
UPDATE phpbb_log SET log_data = replace(log_data,'í','í');
UPDATE phpbb_log SET log_data = replace(log_data,'ó','ó');
UPDATE phpbb_log SET log_data = replace(log_data,'ú','ú');
UPDATE phpbb_log SET log_data = replace(log_data,'ñ','ñ');
UPDATE phpbb_log SET log_data = replace(log_data,'¿','¿');
UPDATE phpbb_log SET log_data = replace(log_data,'Á','Á');
UPDATE phpbb_log SET log_data = replace(log_data,'É','É');
UPDATE phpbb_log SET log_data = replace(log_data,'Ó','Ó');
UPDATE phpbb_log SET log_data = replace(log_data,'íš','Ú');
UPDATE phpbb_log SET log_data = replace(log_data,'¡','¡');
UPDATE phpbb_log SET log_data = replace(log_data,'Ñ','Ñ');
UPDATE phpbb_log SET log_data = replace(log_data,'À','À');
UPDATE phpbb_log SET log_data = replace(log_data,'íˆ','È');
UPDATE phpbb_log SET log_data = replace(log_data,'È','è');
UPDATE phpbb_log SET log_data = replace(log_data,'í’','Ò');
UPDATE phpbb_log SET log_data = replace(log_data,'í²','ò');
UPDATE phpbb_log SET log_data = replace(log_data,'í','í');

UPDATE phpbb_moderator_cache SET username = replace(username,'','');
UPDATE phpbb_moderator_cache SET username = replace(username,'á','á');
UPDATE phpbb_moderator_cache SET username = replace(username,'é','é');
UPDATE phpbb_moderator_cache SET username = replace(username,'í','í');
UPDATE phpbb_moderator_cache SET username = replace(username,'ó','ó');
UPDATE phpbb_moderator_cache SET username = replace(username,'ú','ú');
UPDATE phpbb_moderator_cache SET username = replace(username,'ñ','ñ');
UPDATE phpbb_moderator_cache SET username = replace(username,'¿','¿');
UPDATE phpbb_moderator_cache SET username = replace(username,'Á','Á');
UPDATE phpbb_moderator_cache SET username = replace(username,'É','É');
UPDATE phpbb_moderator_cache SET username = replace(username,'Ó','Ó');
UPDATE phpbb_moderator_cache SET username = replace(username,'íš','Ú');
UPDATE phpbb_moderator_cache SET username = replace(username,'¡','¡');
UPDATE phpbb_moderator_cache SET username = replace(username,'Ñ','Ñ');
UPDATE phpbb_moderator_cache SET username = replace(username,'À','À');
UPDATE phpbb_moderator_cache SET username = replace(username,'íˆ','È');
UPDATE phpbb_moderator_cache SET username = replace(username,'È','è');
UPDATE phpbb_moderator_cache SET username = replace(username,'í’','Ò');
UPDATE phpbb_moderator_cache SET username = replace(username,'í²','ò');
UPDATE phpbb_moderator_cache SET username = replace(username,'í','í');

UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'','');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'á','á');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'탡','á');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'é','é');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'í','í');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'ó','ó');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'ú','ú');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'ñ','ñ');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'¿','¿');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'Á','Á');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'Ó','Ó');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'íš','Ú');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'¡','¡');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'Ñ','Ñ');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'À','À');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'íˆ','È');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'È','è');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'í’','Ò');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'í²','ò');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'í','í');
UPDATE phpbb_poll_options SET poll_option_text = replace(poll_option_text,'€','€');

UPDATE phpbb_posts SET post_subject = replace(post_subject,'','');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'á','á');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'é','é');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'í','í');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'ó','ó');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'ú','ú');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'ñ','ñ');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'¿','¿');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'Á','Á');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'É','É');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'Ó','Ó');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'íš','Ú');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'©','©');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'¡','¡');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'Ñ','Ñ');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'À','À');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'íˆ','È');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'È','è');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'í’','Ò');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'í²','ò');
UPDATE phpbb_posts SET post_subject = replace(post_subject,'í','í');



UPDATE phpbb_posts SET post_text = replace(post_text,'','');
UPDATE phpbb_posts SET post_text = replace(post_text,'á','á');
UPDATE phpbb_posts SET post_text = replace(post_text,'é','é');
UPDATE phpbb_posts SET post_text = replace(post_text,'í','í');
UPDATE phpbb_posts SET post_text = replace(post_text,'ó','ó');
UPDATE phpbb_posts SET post_text = replace(post_text,'ú','ú');
UPDATE phpbb_posts SET post_text = replace(post_text,'ñ','ñ');
UPDATE phpbb_posts SET post_text = replace(post_text,'í±','ñ');
UPDATE phpbb_posts SET post_text = replace(post_text,'¿','¿');
UPDATE phpbb_posts SET post_text = replace(post_text,'Á','Á');
UPDATE phpbb_posts SET post_text = replace(post_text,'É','É');
UPDATE phpbb_posts SET post_text = replace(post_text,'Ó','Ó');
UPDATE phpbb_posts SET post_text = replace(post_text,'íš','Ú');
UPDATE phpbb_posts SET post_text = replace(post_text,'©','©');
UPDATE phpbb_posts SET post_text = replace(post_text,'¡','¡');
UPDATE phpbb_posts SET post_text = replace(post_text,'Ñ','Ñ');
UPDATE phpbb_posts SET post_text = replace(post_text,'À','À');
UPDATE phpbb_posts SET post_text = replace(post_text,'íˆ','È');
UPDATE phpbb_posts SET post_text = replace(post_text,'È','è');
UPDATE phpbb_posts SET post_text = replace(post_text,'í’','Ò');
UPDATE phpbb_posts SET post_text = replace(post_text,'í²','ò');
UPDATE phpbb_posts SET post_text = replace(post_text,'í','í');



UPDATE phpbb_privmsgs SET message_text = replace(message_text,'','');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'á','á');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'é','é');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'í','í');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'ó','ó');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'ú','ú');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'ñ','ñ');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'¿','¿');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'Á','Á');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'É','É');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'Ó','Ó');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'íš','Ú');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'¡','¡');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'Ñ','Ñ');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'À','À');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'íˆ','È');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'È','è');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'í’','Ò');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'í²','ò');
UPDATE phpbb_privmsgs SET message_text = replace(message_text,'í','í');
	
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'','');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'á','á');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'é','é');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'í','í');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'ó','ó');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'ú','ú');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'ñ','ñ');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'¿','¿');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'Á','Á');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'É','É');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'Ó','Ó');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'íš','Ú');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'¡','¡');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'Ñ','Ñ');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'À','À');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'íˆ','È');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'È','è');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'í’','Ò');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'í²','ò');
UPDATE phpbb_ranks SET rank_title = replace(rank_title,'í','í');

UPDATE phpbb_reports SET report_text = replace(report_text,'','');
UPDATE phpbb_reports SET report_text = replace(report_text,'á','á');
UPDATE phpbb_reports SET report_text = replace(report_text,'é','é');
UPDATE phpbb_reports SET report_text = replace(report_text,'í','í');
UPDATE phpbb_reports SET report_text = replace(report_text,'ó','ó');
UPDATE phpbb_reports SET report_text = replace(report_text,'ú','ú');
UPDATE phpbb_reports SET report_text = replace(report_text,'ñ','ñ');
UPDATE phpbb_reports SET report_text = replace(report_text,'¿','¿');
UPDATE phpbb_reports SET report_text = replace(report_text,'Á','Á');
UPDATE phpbb_reports SET report_text = replace(report_text,'É','É');
UPDATE phpbb_reports SET report_text = replace(report_text,'Ó','Ó');
UPDATE phpbb_reports SET report_text = replace(report_text,'íš','Ú');
UPDATE phpbb_reports SET report_text = replace(report_text,'¡','¡');
UPDATE phpbb_reports SET report_text = replace(report_text,'Ñ','Ñ');
UPDATE phpbb_reports SET report_text = replace(report_text,'À','À');
UPDATE phpbb_reports SET report_text = replace(report_text,'íˆ','È');
UPDATE phpbb_reports SET report_text = replace(report_text,'È','è');
UPDATE phpbb_reports SET report_text = replace(report_text,'í’','Ò');
UPDATE phpbb_reports SET report_text = replace(report_text,'í²','ò');
UPDATE phpbb_reports SET report_text = replace(report_text,'í','í');

UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'','');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'á','á');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'é','é');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'í','í');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'ó','ó');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'ú','ú');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'ñ','ñ');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'¿','¿');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'Á','Á');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'É','É');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'Ó','Ó');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'íš','Ú');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'¡','¡');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'Ñ','Ñ');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'À','À');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'íˆ','È');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'È','è');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'í’','Ò');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'í²','ò');
UPDATE phpbb_reports_reasons SET reason_description = replace(reason_description,'í','í');

UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'','');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'á','á');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'é','é');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'í','í');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'ó','ó');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'ú','ú');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'ñ','ñ');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'¿','¿');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'Á','Á');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'É','É');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'Ó','Ó');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'íš','Ú');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'©','©');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'¡','¡');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'Ñ','Ñ');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'À','À');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'íˆ','È');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'È','è');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'í’','Ò');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'í²','ò');
UPDATE phpbb_topics SET topic_last_post_subject = replace(topic_last_post_subject,'í','í');

UPDATE phpbb_topics SET topic_title = replace(topic_title,'','');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'á','á');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'é','é');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'í','í');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'ó','ó');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'ú','ú');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'ñ','ñ');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'¿','¿');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'Á','Á');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'É','É');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'Ó','Ó');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'íš','Ú');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'©','©');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'¡','¡');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'Ñ','Ñ');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'À','À');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'íˆ','È');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'È','è');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'í’','Ò');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'í²','ò');
UPDATE phpbb_topics SET topic_title = replace(topic_title,'í','í');
	
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'','');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'á','á');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'é','é');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'í','í');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'ó','ó');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'ú','ú');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'ñ','ñ');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'¿','¿');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'Á','Á');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'É','É');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'Ó','Ó');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'íš','Ú');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'¡','¡');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'Ñ','Ñ');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'À','À');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'íˆ','È');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'È','è');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'í’','Ò');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'í²','ò');
UPDATE phpbb_topics SET topic_last_poster_name = replace(topic_last_poster_name,'í','í');
	
UPDATE phpbb_users SET user_sig = replace(user_sig,'','');
UPDATE phpbb_users SET user_sig = replace(user_sig,'á','á');
UPDATE phpbb_users SET user_sig = replace(user_sig,'é','é');
UPDATE phpbb_users SET user_sig = replace(user_sig,'í','í');
UPDATE phpbb_users SET user_sig = replace(user_sig,'ó','ó');
UPDATE phpbb_users SET user_sig = replace(user_sig,'ú','ú');
UPDATE phpbb_users SET user_sig = replace(user_sig,'ñ','ñ');
UPDATE phpbb_users SET user_sig = replace(user_sig,'¿','¿');
UPDATE phpbb_users SET user_sig = replace(user_sig,'Á','Á');
UPDATE phpbb_users SET user_sig = replace(user_sig,'É','É');
UPDATE phpbb_users SET user_sig = replace(user_sig,'Ó','Ó');
UPDATE phpbb_users SET user_sig = replace(user_sig,'íš','Ú');
UPDATE phpbb_users SET user_sig = replace(user_sig,'¡','¡');
UPDATE phpbb_users SET user_sig = replace(user_sig,'Ñ','Ñ');
UPDATE phpbb_users SET user_sig = replace(user_sig,'À','À');
UPDATE phpbb_users SET user_sig = replace(user_sig,'íˆ','È');
UPDATE phpbb_users SET user_sig = replace(user_sig,'È','è');
UPDATE phpbb_users SET user_sig = replace(user_sig,'í’','Ò');
UPDATE phpbb_users SET user_sig = replace(user_sig,'í²','ò');
UPDATE phpbb_users SET user_sig = replace(user_sig,'í','í');

UPDATE phpbb_users SET username = replace(username,'','');
UPDATE phpbb_users SET username = replace(username,'á','á');
UPDATE phpbb_users SET username = replace(username,'é','é');
UPDATE phpbb_users SET username = replace(username,'í','í');
UPDATE phpbb_users SET username = replace(username,'ó','ó');
UPDATE phpbb_users SET username = replace(username,'ú','ú');
UPDATE phpbb_users SET username = replace(username,'ñ','ñ');
UPDATE phpbb_users SET username = replace(username,'¿','¿');
UPDATE phpbb_users SET username = replace(username,'º','ª');
UPDATE phpbb_users SET username = replace(username,'Á','Á');
UPDATE phpbb_users SET username = replace(username,'É','É');
UPDATE phpbb_users SET username = replace(username,'Ó','Ó');
UPDATE phpbb_users SET username = replace(username,'íš','Ú');
UPDATE phpbb_users SET username = replace(username,'¡','¡');
UPDATE phpbb_users SET username = replace(username,'Ñ','Ñ');
UPDATE phpbb_users SET username = replace(username,'À','À');
UPDATE phpbb_users SET username = replace(username,'íˆ','È');
UPDATE phpbb_users SET username = replace(username,'È','è');
UPDATE phpbb_users SET username = replace(username,'í’','Ò');
UPDATE phpbb_users SET username = replace(username,'í²','ò');
UPDATE phpbb_users SET username = replace(username,'í','í');
UPDATE phpbb_users SET username_clean = replace(username_clean,'','');
UPDATE phpbb_users SET username_clean = replace(username_clean,'á','á');
UPDATE phpbb_users SET username_clean = replace(username_clean,'é','é');
UPDATE phpbb_users SET username_clean = replace(username_clean,'í','í');
UPDATE phpbb_users SET username_clean = replace(username_clean,'ó','ó');
UPDATE phpbb_users SET username_clean = replace(username_clean,'ú','ú');
UPDATE phpbb_users SET username_clean = replace(username_clean,'ñ','ñ');
UPDATE phpbb_users SET username_clean = replace(username_clean,'¿','¿');
UPDATE phpbb_users SET username_clean = replace(username_clean,'Á','Á');
UPDATE phpbb_users SET username_clean = replace(username_clean,'íƒâ‚¬','Á');
UPDATE phpbb_users SET username_clean = replace(username_clean,'‰','É');
UPDATE phpbb_users SET username_clean = replace(username_clean,'Ó','Ó');
UPDATE phpbb_users SET username_clean = replace(username_clean,'íš','Ú');
UPDATE phpbb_users SET username_clean = replace(username_clean,'¡','¡');
UPDATE phpbb_users SET username_clean = replace(username_clean,'Ñ','Ñ');
UPDATE phpbb_users SET username_clean = replace(username_clean,'À','À');
UPDATE phpbb_users SET username_clean = replace(username_clean,'íˆ','È');
UPDATE phpbb_users SET username_clean = replace(username_clean,'È','è');
UPDATE phpbb_users SET username_clean = replace(username_clean,'í’','Ò');
UPDATE phpbb_users SET username_clean = replace(username_clean,'í²','ò');
UPDATE phpbb_users SET username_clean = replace(username_clean,'í','í');

UPDATE phpbb_styles SET style_copyright = replace(style_copyright,'©','©');
Si consigo completar todas las posibilidades de caracteres en español que se han "estropeado" lo publicaré aquí.

EDITADO por HuanManwe: para añadir para la tabla phpbb_topics el campo topic_last_post_subject

Der Mensch schuf Gott nach seinem eigenen Bild

Berlín siempre estará en mi corazón. Auf wiedersehen, Berlin!!


Avatar de Usuario
Alorse
Ex Staff
Mensajes: 5144
Registrado: 22 Mar 2008, 02:14
Género:
Edad: 36

Re: Solución Caracteres Extraños al convertir, migrar, trasl

#4

Mensaje por Alorse »

Gracias definitivamente mucho mas completo Huan, sientete libre de abrear los faltantes al primer mensaje, así los usuarios tiene todo en uno mismo.

Avatar de Usuario
ThE KuKa
Administrador
Mensajes: 10374
Registrado: 04 Ene 2004, 19:27
Género:
Edad: 49

Re: Solución Caracteres Extraños al convertir, migrar, trasl

#5

Mensaje por ThE KuKa »

Perfecto, si me dais el "OK" mas adelante, edito el articulo de la Biblioteca así quedara perfecto para el usuario. :ok:

📌 Raul [ThE KuKa] en phpBB 📌
✅ Jr. Extension Validator - Jr. Styles Validator - Style Customisations - Translator - International Support Team
✅

Si te gustan mis estilos, traducciones, etc. y quieres mostrar algo de aprecio, no dudes en hacer una donación Imagen
:flag_es: phpBB España - En línea desde 2003 :heart:



Avatar de Usuario
HuanManwe
Ex Staff
Mensajes: 5078
Registrado: 20 Jun 2006, 18:21
Género:
Edad: 50

Re: Solución Caracteres Extraños al convertir, migrar, trasl

#6

Mensaje por HuanManwe »

estoy teniendo un problemilla con este listado porque ocurre algo muy raro: cuando copio en el Notepad++ el código y lo pego aquí se me "pierde" un guión, en concreto el de la línea con la í (i con tilde), por ejemplo:

Código: Seleccionar todo

UPDATE phpbb_log SET log_data = replace(log_data,'í­','í');
OJO CON ESE PROBLEMA porque también pasa con el primer mensaje de Alorse, y eso puede volver loco a cualquier usuario que intente usar esas sentencias SQL.
No entiendo por qué ocurre eso, pero ha producido que al aplicar las sentencias me cambiaban todos los signos anteriores (solo la í) que es igual en el inicio de todos los caracteres extraños (ó','ú, etc). Con lo cual al buscar el de la ñ, por ejemplo (ñ), ya no encontraba la í anterior (que había pasado a ser una í), con lo que no cambiaba los caracteres, porque el primero ya había sido modificado.

Eso no afecta a este listado, pero sí al foro que estaba intentando arreglar, porque ahora tengo que aplicar un parche corrigiendo cada uno de esos fallos que he producido.

En cuanto al listado me falta el caracter que correspondería a la i mayúscula con tilde (la Í), que solo me aparece como í, y como he explicado eso estropea todo el script.

EDITO: también me falta saber el caracter de la "a catalana con la tilde al revés". El de la À corresponde a À pero el de la à me aparece como í y eso no puede ser :-)

Der Mensch schuf Gott nach seinem eigenen Bild

Berlín siempre estará en mi corazón. Auf wiedersehen, Berlin!!


Avatar de Usuario
HuanManwe
Ex Staff
Mensajes: 5078
Registrado: 20 Jun 2006, 18:21
Género:
Edad: 50

Re: Solución Caracteres Extraños al convertir, migrar, trasl

#7

Mensaje por HuanManwe »

De momento he editado el mensaje anterior, donde puse todo el listado de sentencias que había hecho pero he añadido

Código: Seleccionar todo

UPDATE tabla SET campo = replace(campo,'í','í');
Lo que ocurre es que tanto la Á (a mayúscula) como la í (i minúscula) se presentan como í y dado que no consigo crear un código que las diferencie y dado que es más habitual que sea í pues lo he dejado así de momento.

También he añadido al principio la línea para cambiar unos caracteres que he visto que a veces aparecen, y evitan que se haga la conversión bien porque se interponen entre los caracteres que sí hay que modificar. La idea es quitarlos y que no quede nada en ese sitio, así

Código: Seleccionar todo

UPDATE tabla SET campo = replace(campo,'','');

Ya queda menos para tener el listado completo y adecuado.

Der Mensch schuf Gott nach seinem eigenen Bild

Berlín siempre estará en mi corazón. Auf wiedersehen, Berlin!!


Avatar de Usuario
Alorse
Ex Staff
Mensajes: 5144
Registrado: 22 Mar 2008, 02:14
Género:
Edad: 36

Re: Solución Caracteres Extraños al convertir, migrar, trasl

#8

Mensaje por Alorse »

Hay alguno caracteres que molestan mucho, los que dices y otros que ya no recuerdo, sobre lo de copiar y pegar acá y que hace falta, podriamos subir un txt adjunto para descargar y que tenga todas estas consultas.

Avatar de Usuario
HuanManwe
Ex Staff
Mensajes: 5078
Registrado: 20 Jun 2006, 18:21
Género:
Edad: 50

Re: Solución Caracteres Extraños al convertir, migrar, trasl

#9

Mensaje por HuanManwe »

Alorse escribió:Hay alguno caracteres que molestan mucho, los que dices y otros que ya no recuerdo,...
Pues sí.
Alorse escribió:... podriamos subir un txt adjunto para descargar y que tenga todas estas consultas.
Yo ya tengo el txt preparado pero hasta que no lo tenga todo terminado y compruebe que va bien no quiero ir subiendo y actualizando ningún archivo.

Der Mensch schuf Gott nach seinem eigenen Bild

Berlín siempre estará en mi corazón. Auf wiedersehen, Berlin!!


Avatar de Usuario
leviatan21
Ex Staff
Mensajes: 8279
Registrado: 26 Mar 2008, 20:06
Género:
Edad: 54

Re: Solución Caracteres Extraños al convertir, migrar, trasl

#10

Mensaje por leviatan21 »

HuanManwe escribió:
Alorse escribió:Hay alguno caracteres que molestan mucho, los que dices y otros que ya no recuerdo,...
Pues sí.
Alorse escribió:... podriamos subir un txt adjunto para descargar y que tenga todas estas consultas.
Yo ya tengo el txt preparado pero hasta que no lo tenga todo terminado y compruebe que va bien no quiero ir subiendo y actualizando ningún archivo.
Me intrometo...

Si ya tienen preparado todo en .txt, ¿ no se animan a armar un pequeño script y que los usuarios puedan descargar y ejecutar directamente ?
Y todos sabemos lo que cuesta hacer estas cosas cuando se en novato. :oops:
Normas de phpBB España | Normas de Soporte
No doy soporte por privado : tenga en cuenta que su problema, también puede ser el problema de otro usuario.
Cualquier mensaje privado no solicitado será ignorado :twisted:

"Education is what remains after one has forgotten everything he learned in school" - Albert Einstein

Avatar de Usuario
Alorse
Ex Staff
Mensajes: 5144
Registrado: 22 Mar 2008, 02:14
Género:
Edad: 36

Re: Solución Caracteres Extraños al convertir, migrar, trasladar

#11

Mensaje por Alorse »

Esta buena la opción ahorraria estar cambiando el prefijo de phpBB y todo, pero no seria un pequeño script, ya que esto es mejor hacerlo por tablas, supongamos la tabla phpbb_post puede ser demasiado grande, y ejecutarlo junto con las otras podria saturar el servidor, lo digo porque ya me paso en un servidor dedicado bastante bueno... y eso que solo ejecute las consultas para esa tabla.

Tambien lo otro seria ir actualizando por registros, del 1 al 1000, del 1001 al 2000, etc...
Seria cuestión de diseñar un buen script con todas estas opciones, una especie de database_update.

Un dia hice uno muy sencillo sin validaciones ni nada, solo al correrle se ejecutaba sobre la base de datos, pero no se porque demonios no me reconocio los caracteres especiales desde el archivo php :x , seguro una novatada o algo así.

Nazcar
Ex Staff
Mensajes: 1728
Registrado: 14 Oct 2005, 20:39

Solución Caracteres Extraños al convertir, migrar, trasladar

#12

Mensaje por Nazcar »

Como quedo el tema estoy expectante en saber si habra o no habra txt para solucioar lo que a todos nos ha pasado una vez y es un coñazo hacerlo a mano :cerveza:

Avatar de Usuario
HuanManwe
Ex Staff
Mensajes: 5078
Registrado: 20 Jun 2006, 18:21
Género:
Edad: 50

Re: Solución Caracteres Extraños al convertir, migrar, trasladar

#13

Mensaje por HuanManwe »

La verdad es que sospecho que muchos de esos problemas con los caracteres al migrar se podrían solucionar cambiando la codificación de las tablas, aunque no sé bien si funcionaría. Si lo hiciera sería aún más sencillo que usar estos scripts tan pesados para las base de datos.

Der Mensch schuf Gott nach seinem eigenen Bild

Berlín siempre estará en mi corazón. Auf wiedersehen, Berlin!!


Avatar de Usuario
HuanManwe
Ex Staff
Mensajes: 5078
Registrado: 20 Jun 2006, 18:21
Género:
Edad: 50

Re: Solución Caracteres Extraños al convertir, migrar, trasladar

#14

Mensaje por HuanManwe »

Por si acaso amplío el listado de campos a tener en cuenta.

Alertado de campos que faltaban por considerar por el usuario airam en este tema: http://www.phpbb-es.com/foro/soporte-ph ... ml#p164837

Tabla phpbb_users - campos: user_from (ubicación), user_occ (ocupación), user_interests (intereses)

Código: Seleccionar todo

UPDATE phpbb_users SET user_from = replace(user_from,'','');
UPDATE phpbb_users SET user_from = replace(user_from,'á','á');
UPDATE phpbb_users SET user_from = replace(user_from,'é','é');
UPDATE phpbb_users SET user_from = replace(user_from,'í','í');
UPDATE phpbb_users SET user_from = replace(user_from,'ó','ó');
UPDATE phpbb_users SET user_from = replace(user_from,'ú','ú');
UPDATE phpbb_users SET user_from = replace(user_from,'ñ','ñ');
UPDATE phpbb_users SET user_from = replace(user_from,'¿','¿');
UPDATE phpbb_users SET user_from = replace(user_from,'Á','Á');
UPDATE phpbb_users SET user_from = replace(user_from,'íƒâ‚¬','Á');
UPDATE phpbb_users SET user_from = replace(user_from,'‰','É');
UPDATE phpbb_users SET user_from = replace(user_from,'Ó','Ó');
UPDATE phpbb_users SET user_from = replace(user_from,'íš','Ú');
UPDATE phpbb_users SET user_from = replace(user_from,'¡','¡');
UPDATE phpbb_users SET user_from = replace(user_from,'Ñ','Ñ');
UPDATE phpbb_users SET user_from = replace(user_from,'À','À');
UPDATE phpbb_users SET user_from = replace(user_from,'íˆ','È');
UPDATE phpbb_users SET user_from = replace(user_from,'È','è');
UPDATE phpbb_users SET user_from = replace(user_from,'í’','Ò');
UPDATE phpbb_users SET user_from = replace(user_from,'í²','ò');
UPDATE phpbb_users SET user_from = replace(user_from,'í','í');


UPDATE phpbb_users SET user_occ = replace(user_occ,'','');
UPDATE phpbb_users SET user_occ = replace(user_occ,'á','á');
UPDATE phpbb_users SET user_occ = replace(user_occ,'é','é');
UPDATE phpbb_users SET user_occ = replace(user_occ,'í','í');
UPDATE phpbb_users SET user_occ = replace(user_occ,'ó','ó');
UPDATE phpbb_users SET user_occ = replace(user_occ,'ú','ú');
UPDATE phpbb_users SET user_occ = replace(user_occ,'ñ','ñ');
UPDATE phpbb_users SET user_occ = replace(user_occ,'¿','¿');
UPDATE phpbb_users SET user_occ = replace(user_occ,'Á','Á');
UPDATE phpbb_users SET user_occ = replace(user_occ,'íƒâ‚¬','Á');
UPDATE phpbb_users SET user_occ = replace(user_occ,'‰','É');
UPDATE phpbb_users SET user_occ = replace(user_occ,'Ó','Ó');
UPDATE phpbb_users SET user_occ = replace(user_occ,'íš','Ú');
UPDATE phpbb_users SET user_occ = replace(user_occ,'¡','¡');
UPDATE phpbb_users SET user_occ = replace(user_occ,'Ñ','Ñ');
UPDATE phpbb_users SET user_occ = replace(user_occ,'À','À');
UPDATE phpbb_users SET user_occ = replace(user_occ,'íˆ','È');
UPDATE phpbb_users SET user_occ = replace(user_occ,'È','è');
UPDATE phpbb_users SET user_occ = replace(user_occ,'í’','Ò');
UPDATE phpbb_users SET user_occ = replace(user_occ,'í²','ò');
UPDATE phpbb_users SET user_occ = replace(user_occ,'í','í');


UPDATE phpbb_users SET user_interests = replace(user_interests,'','');
UPDATE phpbb_users SET user_interests = replace(user_interests,'á','á');
UPDATE phpbb_users SET user_interests = replace(user_interests,'é','é');
UPDATE phpbb_users SET user_interests = replace(user_interests,'í','í');
UPDATE phpbb_users SET user_interests = replace(user_interests,'ó','ó');
UPDATE phpbb_users SET user_interests = replace(user_interests,'ú','ú');
UPDATE phpbb_users SET user_interests = replace(user_interests,'ñ','ñ');
UPDATE phpbb_users SET user_interests = replace(user_interests,'¿','¿');
UPDATE phpbb_users SET user_interests = replace(user_interests,'Á','Á');
UPDATE phpbb_users SET user_interests = replace(user_interests,'íƒâ‚¬','Á');
UPDATE phpbb_users SET user_interests = replace(user_interests,'‰','É');
UPDATE phpbb_users SET user_interests = replace(user_interests,'Ó','Ó');
UPDATE phpbb_users SET user_interests = replace(user_interests,'íš','Ú');
UPDATE phpbb_users SET user_interests = replace(user_interests,'¡','¡');
UPDATE phpbb_users SET user_interests = replace(user_interests,'Ñ','Ñ');
UPDATE phpbb_users SET user_interests = replace(user_interests,'À','À');
UPDATE phpbb_users SET user_interests = replace(user_interests,'íˆ','È');
UPDATE phpbb_users SET user_interests = replace(user_interests,'È','è');
UPDATE phpbb_users SET user_interests = replace(user_interests,'í’','Ò');
UPDATE phpbb_users SET user_interests = replace(user_interests,'í²','ò');
UPDATE phpbb_users SET user_interests = replace(user_interests,'í','í');

Der Mensch schuf Gott nach seinem eigenen Bild

Berlín siempre estará en mi corazón. Auf wiedersehen, Berlin!!


Avatar de Usuario
Alorse
Ex Staff
Mensajes: 5144
Registrado: 22 Mar 2008, 02:14
Género:
Edad: 36

Re: Solución Caracteres Extraños al convertir, migrar, trasladar

#15

Mensaje por Alorse »

Una vez mas, mil gracias Huan :ok:
En un rato lo agrego al post principal.

Cerrado

Volver a “Foros de Soporte 3.0.x”