1. 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

Discussion in 'Installation, Upgrade, and Import Support' started by Mr Lucky, Jun 19, 2015.

  1. Mr Lucky

    Mr Lucky Well-Known Member

    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?
     
  2. Mike

    Mike XenForo Developer Staff Member

    Forum watch records aren't currently imported.
     
  3. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

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

Share This Page