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:
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
abgeändert auf
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":
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
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:
After a change I could improve this problem a small step:
In der ImpExConfig.php
Code:
$impexconfig['source']['charset'] = '';
Code:
$impexconfig['source']['charset'] = 'utf8';
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:
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
Comment