Additional vB Import Problem

gatoo

Member
Dear Community,

as described in a previous thread, I am having trouble importing data from an old vB into XF. The proposed solution was to transfer the old data from MySQL 4.1.22 into 5.6.19, and then try the import again.

As the database is pretty big, I cannot do this myself and the hosting company is helping. The problem: there are tons of errors while trying to import data from the "vb3_word" table (see listing below).

The strange thing is that I've looked at the table in dump file and there are actually no duplicate entries.

Do I actually need the "vb3_word" table or can I just delete it from the dump?

Or do I have to go through this file and fix it? And if so how?

Thanks for your help!

ERROR 1062 (23000) at line 11057570: Duplicate entry '2600' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057571: Duplicate entry '2601' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057572: Duplicate entry '2602' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057573: Duplicate entry '2603' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057574: Duplicate entry '2604' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057575: Duplicate entry '2605' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057576: Duplicate entry '2606' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057577: Duplicate entry '2607' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057578: Duplicate entry '2608' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057579: Duplicate entry '2609' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057580: Duplicate entry '2610' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057581: Duplicate entry '2611' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057582: Duplicate entry '2612' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057583: Duplicate entry '2613' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057584: Duplicate entry '2614' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057585: Duplicate entry '2615' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057586: Duplicate entry '2616' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057587: Duplicate entry '2617' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057588: Duplicate entry '2618' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057589: Duplicate entry '2619' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057590: Duplicate entry '2620' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057591: Duplicate entry '2621' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057592: Duplicate entry '2622' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057593: Duplicate entry '2623' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057594: Duplicate entry '2624' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057595: Duplicate entry '2625' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057596: Duplicate entry '2626' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057597: Duplicate entry '2627' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057598: Duplicate entry '2628' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057599: Duplicate entry '2629' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057600: Duplicate entry '2630' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057601: Duplicate entry '2631' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057602: Duplicate entry '2632' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057603: Duplicate entry '2633' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057604: Duplicate entry '2634' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057605: Duplicate entry '2635' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057606: Duplicate entry '2636' for key 'PRIMARY'
ERROR 1062 (23000) at line 11057607: Duplicate entry 'lies' for key 'title'
ERROR 1062 (23000) at line 11058265: Duplicate entry 'last' for key 'title'
ERROR 1062 (23000) at line 11060264: Duplicate entry 'frist' for key 'title'
ERROR 1062 (23000) at line 11073126: Duplicate entry 'ausreiser' for key 'title'
ERROR 1062 (23000) at line 11074573: Duplicate entry 'heishunger' for key 'title'
ERROR 1062 (23000) at line 11236917: Duplicate entry 'grosen' for key 'title'
ERROR 1062 (23000) at line 11253158: Duplicate entry 'gros' for key 'title'
ERROR 1062 (23000) at line 11268260: Duplicate entry 'einigermasen' for key 'title'
ERROR 1062 (23000) at line 11343945: Duplicate entry 'stres' for key 'title'
ERROR 1062 (23000) at line 11391912: Duplicate entry 'auszuschliesen' for key 'title'
ERROR 1062 (23000) at line 11412797: Duplicate entry 'ausschlieslich' for key 'title'
ERROR 1062 (23000) at line 11414972: Duplicate entry 'saay' for key 'title'
 
Last edited:
Update: the import into XF worked without the "vb3_word" table.

The only issue I had was an error with "import profile comments", but we don't need those.

Thanks for your help.
 
Back
Top Bottom