Problema Post Migrazione con Impex da PHPbb3 a VB 4.2.0

**y2ksw** · 20-09-2012, 20:48

Originariamente Scritto da Media-Master

grazie per la risposta y2ksw, alla fine non ho letto la tua risposta accidenti e sper di non aver fatto danni.

Ti posto le query che ho utilizzato per pulire dai due tipi di caratteri... adesso sembra andr bene. il problema è che non ho fatto il TRUNCATE TABLE postparsed... spero non succeda niente.

Codice:

UPDATE post SET pagetext = REPLACE(pagetext,'ÃƒÂ¬','ì');
UPDATE post SET pagetext = REPLACE(pagetext,'ÃƒÂ¹','ù');
UPDATE post SET pagetext = REPLACE(pagetext,'ÃƒÂ¨','è');
UPDATE post SET pagetext = REPLACE(pagetext,'ÃƒÂ©','é');
UPDATE post SET pagetext = REPLACE(pagetext,'ÃƒÂ²','ò');
UPDATE post SET pagetext = REPLACE(pagetext,'ÃƒÂ','à')

UPDATE post SET title = REPLACE(title,'ÃƒÂ¬','ì');
UPDATE post SET title = REPLACE(title,'ÃƒÂ¹','ù');
UPDATE post SET title = REPLACE(title,'ÃƒÂ¨','è');
UPDATE post SET title = REPLACE(title,'ÃƒÂ©','é');
UPDATE post SET title = REPLACE(title,'ÃƒÂ²','ò');
UPDATE post SET title = REPLACE(title,'ÃƒÂ','à')

UPDATE pmtext SET message = REPLACE(message,'ÃƒÂ¬','ì');
UPDATE pmtext SET message = REPLACE(message,'ÃƒÂ¹','ù');
UPDATE pmtext SET message = REPLACE(message,'ÃƒÂ¨','è');
UPDATE pmtext SET message = REPLACE(message,'ÃƒÂ©','é');
UPDATE pmtext SET message = REPLACE(message,'ÃƒÂ²','ò');
UPDATE pmtext SET message = REPLACE(message,'ÃƒÂ','à')

UPDATE pmtext SET title = REPLACE(title,'ÃƒÂ¬','ì');
UPDATE pmtext SET title = REPLACE(title,'ÃƒÂ¹','ù');
UPDATE pmtext SET title = REPLACE(title,'ÃƒÂ¨','è');
UPDATE pmtext SET title = REPLACE(title,'ÃƒÂ©','é');
UPDATE pmtext SET title = REPLACE(title,'ÃƒÂ²','ò');
UPDATE pmtext SET title = REPLACE(title,'ÃƒÂ','à')

UPDATE thread SET title = REPLACE(title,'ÃƒÂ¬','ì');
UPDATE thread SET title = REPLACE(title,'ÃƒÂ¹','ù');
UPDATE thread SET title = REPLACE(title,'ÃƒÂ¨','è');
UPDATE thread SET title = REPLACE(title,'ÃƒÂ©','é');
UPDATE thread SET title = REPLACE(title,'ÃƒÂ²','ò');
UPDATE thread SET title = REPLACE(title,'ÃƒÂ','à')

UPDATE sigparsed SET signatureparsed = REPLACE(signatureparsed,'ÃƒÂ¬','ì');
UPDATE sigparsed SET signatureparsed = REPLACE(signatureparsed,'ÃƒÂ¹','ù');
UPDATE sigparsed SET signatureparsed = REPLACE(signatureparsed,'ÃƒÂ¨','è');
UPDATE sigparsed SET signatureparsed = REPLACE(signatureparsed,'ÃƒÂ©','é');
UPDATE sigparsed SET signatureparsed = REPLACE(signatureparsed,'ÃƒÂ²','ò');
UPDATE sigparsed SET signatureparsed = REPLACE(signatureparsed,'ÃƒÂ','à')

---- da eseguire dopo la prima

UPDATE post SET pagetext = REPLACE(pagetext,'Ã¡','á');
UPDATE post SET pagetext = REPLACE(pagetext,'Ã¤','ä');
UPDATE post SET pagetext = REPLACE(pagetext,'Ã¢','â');
UPDATE post SET pagetext = REPLACE(pagetext,'Ã©','é');
UPDATE post SET pagetext = REPLACE(pagetext,'Ã¨','è');
UPDATE post SET pagetext = REPLACE(pagetext,'Ãª','ê');
UPDATE post SET pagetext = REPLACE(pagetext,'Ã«','ë');
UPDATE post SET pagetext = REPLACE(pagetext,'Ã¬','ì');
UPDATE post SET pagetext = REPLACE(pagetext,'Ã*','í');
UPDATE post SET pagetext = REPLACE(pagetext,'Ã®','î');
UPDATE post SET pagetext = REPLACE(pagetext,'Ã¯o','ï');
UPDATE post SET pagetext = REPLACE(pagetext,'Ã²','o');
UPDATE post SET pagetext = REPLACE(pagetext,'Ã³','ò');
UPDATE post SET pagetext = REPLACE(pagetext,'Ã´','ó');
UPDATE post SET pagetext = REPLACE(pagetext,'Ã¶','ô');
UPDATE post SET pagetext = REPLACE(pagetext,'Ã¹','ö');
UPDATE post SET pagetext = REPLACE(pagetext,'Ãº','ù');
UPDATE post SET pagetext = REPLACE(pagetext,'Ã¼','ú');
UPDATE post SET pagetext = REPLACE(pagetext,'Ã»','ü');
UPDATE post SET pagetext = REPLACE(pagetext,'â‚¬','û');
UPDATE post SET pagetext = REPLACE(pagetext,'Ã','à');
UPDATE post SET pagetext = REPLACE(pagetext,'â‚¬','€')

UPDATE post SET title = REPLACE(title,'Ã¡','á');
UPDATE post SET title = REPLACE(title,'Ã¤','ä');
UPDATE post SET title = REPLACE(title,'Ã¢','â');
UPDATE post SET title = REPLACE(title,'Ã©','é');
UPDATE post SET title = REPLACE(title,'Ã¨','è');
UPDATE post SET title = REPLACE(title,'Ãª','ê');
UPDATE post SET title = REPLACE(title,'Ã«','ë');
UPDATE post SET title = REPLACE(title,'Ã¬','ì');
UPDATE post SET title = REPLACE(title,'Ã*','í');
UPDATE post SET title = REPLACE(title,'Ã®','î');
UPDATE post SET title = REPLACE(title,'Ã¯o','ï');
UPDATE post SET title = REPLACE(title,'Ã²','o');
UPDATE post SET title = REPLACE(title,'Ã³','ò');
UPDATE post SET title = REPLACE(title,'Ã´','ó');
UPDATE post SET title = REPLACE(title,'Ã¶','ô');
UPDATE post SET title = REPLACE(title,'Ã¹','ö');
UPDATE post SET title = REPLACE(title,'Ãº','ù');
UPDATE post SET title = REPLACE(title,'Ã¼','ú');
UPDATE post SET title = REPLACE(title,'Ã»','ü');
UPDATE post SET title = REPLACE(title,'â‚¬','û');
UPDATE post SET title = REPLACE(title,'Ã','à');
UPDATE post SET title = REPLACE(title,'â‚¬','€')

UPDATE pmtext SET message = REPLACE(message,'Ã¡','á');
UPDATE pmtext SET message = REPLACE(message,'Ã¤','ä');
UPDATE pmtext SET message = REPLACE(message,'Ã¢','â');
UPDATE pmtext SET message = REPLACE(message,'Ã©','é');
UPDATE pmtext SET message = REPLACE(message,'Ã¨','è');
UPDATE pmtext SET message = REPLACE(message,'Ãª','ê');
UPDATE pmtext SET message = REPLACE(message,'Ã«','ë');
UPDATE pmtext SET message = REPLACE(message,'Ã¬','ì');
UPDATE pmtext SET message = REPLACE(message,'Ã*','í');
UPDATE pmtext SET message = REPLACE(message,'Ã®','î');
UPDATE pmtext SET message = REPLACE(message,'Ã¯o','ï');
UPDATE pmtext SET message = REPLACE(message,'Ã²','o');
UPDATE pmtext SET message = REPLACE(message,'Ã³','ò');
UPDATE pmtext SET message = REPLACE(message,'Ã´','ó');
UPDATE pmtext SET message = REPLACE(message,'Ã¶','ô');
UPDATE pmtext SET message = REPLACE(message,'Ã¹','ö');
UPDATE pmtext SET message = REPLACE(message,'Ãº','ù');
UPDATE pmtext SET message = REPLACE(message,'Ã¼','ú');
UPDATE pmtext SET message = REPLACE(message,'Ã»','ü');
UPDATE pmtext SET message = REPLACE(message,'â‚¬','û');
UPDATE pmtext SET message = REPLACE(message,'Ã','à');
UPDATE pmtext SET message = REPLACE(message,'â‚¬','€')

UPDATE pmtext SET title = REPLACE(title,'Ã¡','á');
UPDATE pmtext SET title = REPLACE(title,'Ã¤','ä');
UPDATE pmtext SET title = REPLACE(title,'Ã¢','â');
UPDATE pmtext SET title = REPLACE(title,'Ã©','é');
UPDATE pmtext SET title = REPLACE(title,'Ã¨','è');
UPDATE pmtext SET title = REPLACE(title,'Ãª','ê');
UPDATE pmtext SET title = REPLACE(title,'Ã«','ë');
UPDATE pmtext SET title = REPLACE(title,'Ã¬','ì');
UPDATE pmtext SET title = REPLACE(title,'Ã*','í');
UPDATE pmtext SET title = REPLACE(title,'Ã®','î');
UPDATE pmtext SET title = REPLACE(title,'Ã¯o','ï');
UPDATE pmtext SET title = REPLACE(title,'Ã²','o');
UPDATE pmtext SET title = REPLACE(title,'Ã³','ò');
UPDATE pmtext SET title = REPLACE(title,'Ã´','ó');
UPDATE pmtext SET title = REPLACE(title,'Ã¶','ô');
UPDATE pmtext SET title = REPLACE(title,'Ã¹','ö');
UPDATE pmtext SET title = REPLACE(title,'Ãº','ù');
UPDATE pmtext SET title = REPLACE(title,'Ã¼','ú');
UPDATE pmtext SET title = REPLACE(title,'Ã»','ü');
UPDATE pmtext SET title = REPLACE(title,'â‚¬','û');
UPDATE pmtext SET title = REPLACE(title,'Ã','à');
UPDATE pmtext SET title = REPLACE(title,'â‚¬','€')

UPDATE thread SET title = REPLACE(title,'Ã¡','á');
UPDATE thread SET title = REPLACE(title,'Ã¤','ä');
UPDATE thread SET title = REPLACE(title,'Ã¢','â');
UPDATE thread SET title = REPLACE(title,'Ã©','é');
UPDATE thread SET title = REPLACE(title,'Ã¨','è');
UPDATE thread SET title = REPLACE(title,'Ãª','ê');
UPDATE thread SET title = REPLACE(title,'Ã«','ë');
UPDATE thread SET title = REPLACE(title,'Ã¬','ì');
UPDATE thread SET title = REPLACE(title,'Ã*','í');
UPDATE thread SET title = REPLACE(title,'Ã®','î');
UPDATE thread SET title = REPLACE(title,'Ã¯o','ï');
UPDATE thread SET title = REPLACE(title,'Ã²','o');
UPDATE thread SET title = REPLACE(title,'Ã³','ò');
UPDATE thread SET title = REPLACE(title,'Ã´','ó');
UPDATE thread SET title = REPLACE(title,'Ã¶','ô');
UPDATE thread SET title = REPLACE(title,'Ã¹','ö');
UPDATE thread SET title = REPLACE(title,'Ãº','ù');
UPDATE thread SET title = REPLACE(title,'Ã¼','ú');
UPDATE thread SET title = REPLACE(title,'Ã»','ü');
UPDATE thread SET title = REPLACE(title,'â‚¬','û');
UPDATE thread SET title = REPLACE(title,'Ã','à');
UPDATE thread SET title = REPLACE(title,'â‚¬','€')

UPDATE sigparsed SET signatureparsed = REPLACE(signatureparsed,'Ã¡','á');
UPDATE sigparsed SET signatureparsed = REPLACE(signatureparsed,'Ã¤','ä');
UPDATE sigparsed SET signatureparsed = REPLACE(signatureparsed,'Ã¢','â');
UPDATE sigparsed SET signatureparsed = REPLACE(signatureparsed,'Ã©','é');
UPDATE sigparsed SET signatureparsed = REPLACE(signatureparsed,'Ã¨','è');
UPDATE sigparsed SET signatureparsed = REPLACE(signatureparsed,'Ãª','ê');
UPDATE sigparsed SET signatureparsed = REPLACE(signatureparsed,'Ã«','ë');
UPDATE sigparsed SET signatureparsed = REPLACE(signatureparsed,'Ã¬','ì');
UPDATE sigparsed SET signatureparsed = REPLACE(signatureparsed,'Ã*','í');
UPDATE sigparsed SET signatureparsed = REPLACE(signatureparsed,'Ã®','î');
UPDATE sigparsed SET signatureparsed = REPLACE(signatureparsed,'Ã¯o','ï');
UPDATE sigparsed SET signatureparsed = REPLACE(signatureparsed,'Ã²','o');
UPDATE sigparsed SET signatureparsed = REPLACE(signatureparsed,'Ã³','ò');
UPDATE sigparsed SET signatureparsed = REPLACE(signatureparsed,'Ã´','ó');
UPDATE sigparsed SET signatureparsed = REPLACE(signatureparsed,'Ã¶','ô');
UPDATE sigparsed SET signatureparsed = REPLACE(signatureparsed,'Ã¹','ö');
UPDATE sigparsed SET signatureparsed = REPLACE(signatureparsed,'Ãº','ù');
UPDATE sigparsed SET signatureparsed = REPLACE(signatureparsed,'Ã¼','ú');
UPDATE sigparsed SET signatureparsed = REPLACE(signatureparsed,'Ã»','ü');
UPDATE sigparsed SET signatureparsed = REPLACE(signatureparsed,'â‚¬','û');
UPDATE sigparsed SET signatureparsed = REPLACE(signatureparsed,'Ã','à');
UPDATE sigparsed SET signatureparsed = REPLACE(signatureparsed,'â‚¬','€')

Per quanto riguarda le tabelle in generale purtroppo me le da tutte in latin_swedish, anche se il database è in utf8, e non riesco a trovare il modo per cambiarle di massa.

Si cambiano una per una con phpMyAdmin. Però quando converti il primo ti suggerisce la query, che la prendi e con un copia incolla e sostituzione globale i sistemi abbastanza in fretta.

Con

Codice:

SHOW TABLES

ti elenca tutte le tabelle da copiare in un file di testo, ad esempio tabelle.txt. Se selezioni la prima e trascini il mouse verso il basso, prendi tutte

Clicca l'immagine per ingrandirla.

Nome: tables.png
Visualizzazioni: 16
Dimensione: 14.9 KB
ID: 1625

Se sei in Linux, allora puoi usare uno script per generare le query, ad esempio:

Codice:

#!/bin/sh

[ -f miequery.sql ] && rm miequery.sql

for i in `cat tabelle.txt`
do
    echo "ALTER TABLE $i DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;">>miequery.sql
done

exit 0

Se non hai Linux, fatti fare da qualcuno il file miequery.sql con questo script e la lista delle tabelle.

Il contenuto del file è quindi costituito da 200+ query che si possono incollare nella finestra SQL di phpMyAdmin ed eseguire in blocco.

Discussione: Problema Post Migrazione con Impex da PHPbb3 a VB 4.2.0

Strumenti Discussione

Discussioni Simili

Problema importazione avatar da phpbb3 a vB4.0.5 con ImpEx

importazione avatar da phpbb3 a vB4.0 con ImpEx

[Retribuito] Installazione - Skin - Migrazione dati (i dettagli nel post)

vBulletin 3.7.x Problema con impex

vBulletin 3.7.x Impex, post e DB

Segnalibri

Segnalibri

Permessi di Scrittura