Announcement

Collapse
No announcement yet.

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

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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:

    Code:
    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
    Code:
    $impexconfig['source']['charset']        = '';
    abgeändert auf
    Code:
    $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":

    Code:
    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

  • #2
    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.):

    Code:
    $try->set_value('nonmandatory', 'postusername',    $user_names["$thread[lastposterid]"]);
    change it in

    Code:
    $try->set_value('nonmandatory', 'postusername', utf8_encode($user_names["$thread[lastposterid]"]));
    Again a lot of thanks to the support team!

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X