• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.4 Not subscribed/watching forum after vbulletin import

Mr Lucky

Well-known member
#1
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?
 

Jake Bunce

XenForo moderator
Staff member
#3
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.

Code:
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);