XF 2.1 vB importer stuck in messages

[cfox]

I am doing a test import from vb 4.2 (2.5 M messages). Using the CLI importer with this command as recommended here:

php -d memory_limit=2000M cmd.php xf:import

It gets stuck in Step 16 of 26: Messages [1740831] 88,45%

Any tips?

 

[AndyB]

Just a guess, but take a look at the vB database and look at post_id 1740831. Is there anything unusual with the message in that post?

 

[cfox]

I checked the latest imported post, it's thread id and what the next thread would be and deleted it from the source (old threads with lot of replies). I got to almost 100% now but got these messages:

In AbstractStatement.php line 228:

MySQL query error [1406]: Data too long for column 'delete_reason' at row 1

xf:import [--processes PROCESSES] [--finalize]

Exception query:

INSERT INTO xf_deletion_log (content_type, content_id, delete_date, delete_user_id, delete_username, delete_reason) VALUES (?, ?, ?, ?, ?, ?) ON DUPLICATE KEY UPDATE delete_date = LEAST(delete_date, VALUES(delete_date))

 

[Paul B]

deleted it from the source (old threads with lot of replies)

Most likely the import was still running - you may want to start over so you don't lose that content.

Data too long for column 'delete_reason' at row 1

That's a known bug which was fixed in 1.3.2: https://xenforo.com/community/threads/delete_reason-in-xf_deletion_log.176874/

Which version of the importer are you running?

 

[cfox]

Import was stuck in the same position for 6 hours and deleting the threads worked.

I'm using 1.3.2, should be fixed then? I'll just try delete longer reasons in the vb source tables (editlog and deletionlog).

 

[Mike]

I'm not seeing an obvious cause of that issue in 1.3.2 with the workaround applied. Just to confirm though, would it be possible to see the full error backtrace? This should be available in the server error logs section of the control panel.

 

[cfox]

I was able to finalize the import (only profile messages missing).

Error logs are empty, sorry it's a new nginx server I'm not familiar with and may have not been set up completely.

 

[Paul B]

Mike was referring to the error log in the XF ACP - admin.php?logs/server-errors/

 

[cfox]

Yes I checked that too, empty.