XF 1.4 manually import mybb likes

[Jake Bunce]

I am posting this here for reference.

This assumes you enabled the option during the import to preserve the source ids.

The mybb_g33k_thankyoulike_thankyoulike table might be from an addon for MyBB. But if you have that table then you can import the likes using this query:

INSERT INTO XFdbname.`xf_liked_content` (content_type, content_id, like_user_id, like_date, content_user_id)
	SELECT 'post', vl.pid, vl.uid, vl.dateline, vl.puid
        FROM MyBBdbname.`mybb_g33k_thankyoulike_thankyoulike` AS vl
ON DUPLICATE KEY UPDATE
        content_id = VALUES(content_id);

Then run this script:

https://xenforo.com/community/threa...t-profile-post-like-caches.42384/#post-457352