PDA

View Full Version : Problem after Import with Impex! I need help.



RollingStones
Sat 17th Feb '07, 6:48am
Hi there,

i installed the vbulletin 3.6.4 yesterday and only registered the standard admin. so the database is empty.

then i installed impex and connected to my woltlab burning board database.
the import in the vbulletin admincp went good, but there is one problem:

users, postings, threads, forums and all the other tables are wrong now!
for example the original sentence in the original database(german):

"Hier ist Platz für ausführliche Berichte"
now it is:
"Hier ist Platz für (ausführliche) Berichte"

that are the informations from BOTH database..the original wbb and the vb:

language: German (de-utf-8 )
MySQL-charset: UTF-8 Unicode (utf-8 )
charset / collation MySQL-connection: utf8_general_ci

i dont know what to do now...?!
please help me. :-)

RS

RollingStones
Sat 17th Feb '07, 11:28am
Ahh, Something important: When importing the data from the old forum (wbb), impEx seems to read them correctly, as the characters appear normally on impEx procedure. I guess it has problems trying to to 'copy' the data to the vBulletin tables.(i copied this from a user here in forum, wo has the same problem!)

Steve Machol
Sat 17th Feb '07, 3:26pm
Try this. Edit impex/db_mysql.php and change this line:

$query_id = $query_type(utf8_encode($query_string), $this->link_id);

To this:

$query_id = $query_type($query_string, $this->link_id);

Then redo the import. Let me know if that works.

RollingStones
Sun 18th Feb '07, 6:07am
@Steve Machol: Yes, it works, thanks!
I posted my problem in the german vbulletin-board, too, a moderator gave me the same tip.

greetz
RS