WBB 2.3.6 --> vB 3.8, ImpEx Import, special character problems

[rubstudent]

Dear all,

I tried for several hours, including the night, to solve this problem but with absolute no success. :-(

I'd like to import my data from a wBB 2.3.6 via ImpEx 1.92 in a fresh installed vB 3.8.1. This problems pops up, when I want to import the users:

ImpEx Database errormysql error: Invalid SQL: SELECT username FROM vb3_user WHERE username = 'André'

mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Andr?' at line 1

mysql error number: 1064

Date: Friday 30th 2009f January 2009 09:21:50 PM
Database: rubstudent_vb
MySQL error:

There seems to be a problem with special characters. When I change the name of this user, the next person with a special character makes problems. In the example above it is the "é" what the import machinery not like. Maybe the problem is, that my provider changed the servers. The MySQL-Version now is "5.0.32".


After a change I could improve this problem a small step:

In der ImpExConfig.php

$impexconfig['source']['charset']        = '';

abgeändert auf

$impexconfig['source']['charset']        = 'utf8';

After that, there is a direkt change visible: During the import the names are visible for a short time. Before the change above the special characters were visible as normal, like é,ä,ö,ü. After the change the special characters during the import are some cryptic ASCII-Codes. But all users were imported.

But now there is an another problem during import the "threads":

ImpEx Database errormysql error: Invalid SQL: 
                    INSERT INTO vb3_thread
                    (
                        forumid, title, importforumid,
                        importthreadid, firstpostid, lastpost,
                        pollid, open, replycount,
                        postusername, postuserid, lastposter,
                        dateline, views, iconid,
                        notes, visible, sticky,
                        votenum, votetotal, attach, similar,
                        hiddencount, deletedcount
                    )
                    VALUES
                    (
                        '18',
                        'Mathe -Test',
                        '12',
                        '621',
                        '',
                        '1074687655',
                        '0',
                        '1',
                        '17',
                        'André',
                        '288',
                        '302',
                        '1074442829',
                        '2081',
                        '4',
                        'Imported thread',
                        '1',
                        '0',
                        '0',
                        '0',
                        '',
                        '',
                        '',
                        ''
                    )
                

mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '288',
                        '302',
                        '1074442829',
                        '2081',
                        '4',
                        'Imported ' at line 23

mysql error number: 1064

Date: Friday 30th 2009f January 2009 11:56:33 PM
Database: rubstudent_vb
MySQL error:

The same MySQL issue 1064. And there is the same user "André" with his é involved in...

What can I do else??? I have absolute no idea how to solve this problems...
I'm grateful about any help. It's really to become desperate.

Best wishes, Mathias

[rubstudent]

Thanks to the german support team for the solution:

Via FTP make the following changes in the impex/systems/wbb/007.php to solve the issue with the user names (é vs. e etc.):

$try->set_value('nonmandatory', 'postusername',    $user_names["$thread[lastposterid]"]);

change it in

$try->set_value('nonmandatory', 'postusername', utf8_encode($user_names["$thread[lastposterid]"]));

Again a lot of thanks to the support team!