XF 1.4 Not subscribed/watching forum after vbulletin import

[Mr Lucky]

After an otherwise quite successful import, I found I was not watching a forum I was previously subscribed to in vbulletin. Is this normal, something I may have done wrong or a bug?

 

[Mike]

Forum watch records aren't currently imported.

 

[Jake Bunce]

If you wish to manually import those records then this query should work, assuming you enabled the option to preserve the source ids during the import.

You need to specify the two database names. And you may wish to change the column values in red. notify_on can be either 'thread' or 'message' in XF. send_alert can be 1 or 0.

INSERT INTO `xf_db_name`.xf_forum_watch
(
    user_id,
    node_id,
    notify_on,
    send_alert,
    send_email
)
SELECT
	userid,
	forumid,
	'message',
	1,
	IF(emailupdate > 0, 1, 0)
FROM `vb_db_name`.subscribeforum
ON DUPLICATE KEY UPDATE
	send_email = VALUES(send_email);