Es werden nicht alle User importiert

[Stefan]

Hat von euch schon jemand mit diesem Importer Erfahrung:
vBulletin Big Board Importer [vBulletin 3 + vBulletin 4] 1.1.0
http://xenforo.com/community/resources/vbulletin-big-board-importer-vbulletin-3-vbulletin-4.1981/

Der Import lief länger als erwartet aber dann klappte so gut wie alles, aber irgendwie sind nicht alle User drin. Und zwar fehlen alle, die noch nicht ihre Mails aktiviert hatte in vbulletin 3.8. Ich erneuere gerade den Cache für alle User, aber das dauert ja auch sehr lange bei über 300.000 Mitglieder.

Oder was sollte man noch alles nach einem Import machen. Jeden Punkt anklicken beim Import beim Cache-Neuaufbau im Admin.php?

 

[Walter]

Hast Du beim Export oder Import irgendwelche Fehlermeldungen bezüglich dieser User bekommen?
Sind diese User in den Textdateien im Verzeichnis importData enthalten oder nicht?
Hast Du kontrolliert ob Dein Usergruppen-Matching stimmt?

 

[Stefan]

Also in der config vom Importer steht das:

public static $groupMap = array(
1 => 1,
2 => 2,
3 => 1,
4 => 1,
5 => 4,
6 => 3,
7 => 4,
11 => 5,
13 => 6,
28 => 7,
29 => 8,
30 => 9,
31 => 10,
32 => 11,
33 => 12,
35 => 13,
40 => 14,
42 => 15,
43 => 16,
44 => 17,
45 => 18,
);

Und in vBulletin siehe Anhang. Komischerweise sind auch alle Admins und Moderatoren nicht der korrekten Gruppe zugewiesen. Wie kommt das?

 

[Walter]

Mapping sieht auf den ersten Blick vernünftig aus.

 

[Stefan]

Ok dann werde ich mal den gesamten Cache neu aufbauen oder was schlägst Du vor? Es kamen aber auch diverse Fehlermeldungen beim Import

Importing...
xf_conversation_master0
(36.16s)...
xf_conversation_message156833
Warning 1261 Row 1 doesn't contain data for all columns
Warning 1261 Row 2 doesn't contain data for all columns
Warning 1261 Row 3 doesn't contain data for all columns
...

(125.07s)...
xf_conversation_recipient32
Warning 1366 Incorrect integer value: 'NULL' for column 'last_read_date' at row 34423
Warning 1366 Incorrect integer value: 'NULL' for column 'last_read_date' at row 34424
Warning 1366 Incorrect integer value: 'NULL' for column 'last_read_date' at row 34425
Warning 1366 Incorrect integer value: 'NULL' for column 'last_read_date' at row 34426
Warning 1366 Incorrect integer value: 'NULL' for column 'last_read_date' at row 34428
Warning 1366 Incorrect integer value: 'NULL' for column 'last_read_date' at row 61715
..
(36.30s)...
xf_conversation_user272566
Warning 1261 Row 1 doesn't contain data for all columns
Warning 1261 Row 2 doesn't contain data for all columns
Warning 1261 Row 3 doesn't contain data for all columns
Warning 1261 Row 4 doesn't contain data for all columns
Warning 1261 Row 5 doesn't contain data for all columns
Warning 1261 Row 6 doesn't contain data for all columns
Warning 1261 Row 7 doesn't contain data for all columns
Warning 1261 Row 8 doesn't contain data for all columns
Warning 1261 Row 9 doesn't contain data for all columns
Warning 1261 Row 10 doesn't contain data for all columns
..
(431.53s)...
xf_deletion_log61
Warning 1265 Data truncated for column 'delete_reason' at row 1024
Warning 1265 Data truncated for column 'delete_reason' at row 1817
Warning 1265 Data truncated for column 'delete_reason' at row 1871
Warning 1265 Data truncated for column 'delete_reason' at row 1891
..
(6.38s)...
xf_edit_history0
(366.72s)...
xf_forum0
(0.12s)...
xf_forum_read0
(0.08s)...
xf_ip13178
Warning 1366 Incorrect integer value: 'NULL' for column 'ip' at row 2132335
Warning 1366 Incorrect integer value: 'NULL' for column 'ip' at row 2132336
Warning 1366 Incorrect integer value: 'NULL' for column 'ip' at row 2132337
..
(3,361.32s)...
xf_liked_content0
(0.61s)...
xf_link_forum0
(0.01s)...
xf_moderator_log0
(3.28s)...
xf_node242
Warning 1366 Incorrect integer value: '' for column 'depth' at row 1
Warning 1261 Row 1 doesn't contain data for all columns
Warning 1366 Incorrect integer value: '' for column 'depth' at row 2
Warning 1261 Row 2 doesn't contain data for all columns
Warning 1366 Incorrect integer value: '' for column 'depth' at row 3
Warning 1261 Row 3 doesn't contain data for all columns
Warning 1366 Incorrect integer value: '' for column 'depth' at row 4
Warning 1261 Row 4 doesn't contain data for all columns
Warning 1366 Incorrect integer value: '' for column 'depth' at row 5
Warning 1261 Row 5 doesn't contain data for all columns
Warning 1366 Incorrect integer value: '' for column 'depth' at row 6
Warning 1261 Row 6 doesn't contain data for all columns
..
(0.05s)...
xf_poll0
(0.04s)...
xf_poll_response1804
Warning 1265 Data truncated for column 'response' at row 55
Warning 1265 Data truncated for column 'response' at row 739
Warning 1265 Data truncated for column 'response' at row 1246
Warning 1265 Data truncated for column 'response' at row 1248
..
(0.10s)...
xf_poll_vote0
(2.81s)...
xf_post.0
.0
.0
(2,170.80s)...
xf_profile_post0
(1.94s)...
xf_report0
(0.03s)...
xf_report_comment0
(0.01s)...
xf_stats_daily0
(0.97s)...
xf_thread0
(10.19s)...
xf_thread_read0
(0.03s)...
xf_thread_user_post0
(181.98s)...
xf_thread_watch0
(718.79s)...
xf_user1629
Warning 1366 Incorrect integer value: '' for column 'user_group_id' at row 79
Warning 1366 Incorrect integer value: '' for column 'display_style_group_id' at row 79
Warning 1366 Incorrect integer value: '' for column 'user_group_id' at row 131
Warning 1366 Incorrect integer value: '' for column 'display_style_group_id' at row 131
Warning 1366 Incorrect integer value: '' for column 'user_group_id' at row 312
Warning 1366 Incorrect integer value: '' for column 'display_style_group_id' at row 312
Warning 1366 Incorrect integer value: '' for column 'user_group_id' at row 463
Warning 1366 Incorrect integer value: '' for column 'display_style_group_id' at row 463
Warning 1366 Incorrect integer value: '' for column 'user_group_id' at row 579
Warning 1366 Incorrect integer value: '' for column 'display_style_group_id' at row 579
..
(996.16s)...
xf_user_authenticate0
(11.05s)...
xf_user_ban813
Warning 1261 Row 1 doesn't contain data for all columns
Warning 1261 Row 2 doesn't contain data for all columns
Warning 1261 Row 3 doesn't contain data for all columns

..
(0.14s)...
xf_user_external_authc1psdcssxforum2.xf_user_external_auth repair note The storage engine for the table doesn't support repair
ERROR 2 (HY000) at line 1: File '/importData/xf_user_external_auth.txt' not found (Errcode: 2)
(0.39s)...
xf_user_field_valueERROR 2 (HY000) at line 1: File '/importData/xf_user_field_value.txt' not found (Errcode: 2)
(0.03s)...
xf_user_follow0
(0.25s)...
xf_user_ignored0
(0.01s)...
xf_user_option0
(4.79s)...
xf_user_privacy0
(3.44s)...
xf_user_profile433
Warning 1265 Data truncated for column 'occupation' at row 121
Warning 1265 Data truncated for column 'occupation' at row 278
Warning 1265 Data truncated for column 'occupation' at row 441
Warning 1265 Data truncated for column 'occupation' at row 448
Warning 1265 Data truncated for column 'occupation' at row 495
Warning 1265 Data truncated for column 'occupation' at row 596
Warning 1265 Data truncated for column 'occupation' at row 1398
Warning 1265 Data truncated for column 'occupation' at row 2427
Warning 1265 Data truncated for column 'occupation' at row 2717
Warning 1265 Data truncated for column 'occupation' at row 3476
Warning 1265 Data truncated for column 'occupation' at row 3712
Warning 1265 Data truncated for column 'occupation' at row 4229
Warning 1265 Data truncated for column 'occupation' at row 4709
Warning 1265 Data truncated for column 'occupation' at row 5442
Warning 1265 Data truncated for column 'occupation' at row 5486
Warning 1265 Data truncated for column 'occupation' at row 6046
Warning 1265 Data truncated for column 'occupation' at row 6624
Warning 1265 Data truncated for column 'occupation' at row 7917
Warning 1265 Data truncated for column 'occupation' at row 8120
Warning 1265 Data truncated for column 'occupation' at row 8187
Warning 1265 Data truncated for column 'location' at row 8236
Warning 1265 Data truncated for column 'occupation' at row 8638
..

(10.64s)...
xf_warning1
Warning 1264 Out of range value for column 'points' at row 415
(0.11s)...
xf_warning_action_trigger0
(0.11s)...

Import Total Time: 8,485.52s)...

Cleaning Up...
trim thread titles
building import log

 

[Stefan]

Ich sehe gerade, dass die User doch alle da sind, er zählt nur die noch nicht dazu, die sich noch autorisieren müssen. Es fehlen aber die benutzerdefinierten angelegten Felder.

 

[Viddek]

Wie lange hat der Import bei dir gedauert?

 

[Stefan]

Ich glaube eine Stunde ...