XF 2.0 Incorrect integer value: 'solvedthread' when importing from vb4

[tradingville]

Hi, I have the following error right after the step importing Moderators 100%.

XF\Db\Exception: MySQL query error [1366]: Incorrect integer value: 'solvedthread' for column 'prefix_group_id' at row 1 in src/XF/Db/AbstractStatement.php at line 212

I tried to google the error but did not find a solution. I tried to skip some fields like thread prefix from being imported, but still had this error. At this point I just want the posts successfully imported. I appreciate the help.

 

[Kier]

You can bypass this error by running the import with retain IDs turned off, otherwise I'm afraid you'll have to wait for 2.0.1 for the fix, unless you want to edit the code yourself, in which case you could apply a temporary fix as follows:

if ($newGroupId = $importGroup->save($oldGroupId))

replace with

if ($newGroupId = $importGroup->save(false))

 

[tradingville]

Thanks Kier. I ended up importing in 1.5.6 and it worked well.

 

[Kier]

FWIW, I just realised you'd also need the following change:

if ($importPrefix->save($oldPrefixId))

to

if ($importPrefix->save(false))

... but as I said, all sorted in 2.0.1