XF 1.4 manually import dbtech thanks

[Jake Bunce]

I am posting this here for reference.

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

If you use the "dbtech thanks" addon in vB and you want to manually import those "thanks" as "likes" then run this query:

INSERT INTO XFdbname.`xf_liked_content` (content_type, content_id, like_user_id, like_date, content_user_id)
	SELECT 'post', dbt.contentid, dbt.userid, dbt.dateline, post.userid
        FROM vBdbname.`dbtech_thanks_entry` AS dbt
        LEFT JOIN vBdbname.`post` AS post ON (post.postid = dbt.contentid)
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

 

[Donny]

Thank you!

 

[Donny]

URLS need redirecting. You need an example?

Old domain.com/45-forum-category/565767-thread-title.html
New domain.com/threads/thread-title.75872/

etc

 

[Donny]

I am posting this here for reference.

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

If you use the "dbtech thanks" addon in vB and you want to manually import those "thanks" as "likes" then run this query:

INSERT INTO XFdbname.`xf_liked_content` (content_type, content_id, like_user_id, like_date, content_user_id)
    SELECT 'post', dbt.contentid, dbt.userid, dbt.dateline, post.userid
        FROM vBdbname.`dbtech_thanks_entry` AS dbt
        LEFT JOIN vBdbname.`post` AS post ON (post.postid = dbt.contentid)
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

The old and new forums are on different databases. The same server and IP, just different databases. I wanted to start a complete fresh this time. The old forum had been on that DB for around 8 years and with various customisations over the years it was very messy.

 

[murdercode]

1. Keyword not recognized (near "KEY)
2. Unexpected Token (near "=")

on query:

INSERT INTO XFDB.'xf_liked_content' (content_type, content_id, like_user_id, like_date, content_user_id)
SELECT 'post', dbt.contentid, dbt.userid, dbt.dateline, post.userid
        FROM VBDB.'dbtech_thanks_entry' AS dbt
        LEFT JOIN VBDB.'post' AS post ON (post.postid = dbt.contentid)
ON DUPLICATE KEY UPDATE content_id = VALUES(content_id);

There's any angel can help me? :3

 

[Jake Bunce]

@murdercode

I think your single quotes are messing up the syntax. Use backquotes like in my original post.

 

[Blackbeard]

Is there a way to run this when the tables are in two different databases?

 

[Slavik]

Is there a way to run this when the tables are in two different databases?

Thats what the query is doing.
XFdbname and VBdbname are different databases.

 

[Blackbeard]

Thats what the query is doing.
XFdbname and VBdbname are different databases.

I was being silly - I forgot the database prefix. lol.

Next time I'm going to sleep during the important instead of trying to stay awake.

 

[🔥Iggy🔥]

has anything changed with this recently....i tried running the query....pretty sure i got all the prefixes and everything in properly...tried a couple ways to be sure but the best result was this error....running latest xen1.5 btw...hope thats not why......source vb4.2.5

ideas?

MySQL said:
#1048 - Column 'content_user_id' cannot be null

 

[Slavik]

Your vbulletin database has some information missing, so it cant be inserted into the xenforo database.

 

[🔥Iggy🔥]

hmm not sure what that would be...it is a live database, havent had any issues there, can see all the dbtech likes everywhere...peeking into the content_user_id i can see values....some are zeros, but dont really understand why they wont import or how to resolve it

 

[markoroots]

Hi @Jake Bunce
does this query is good also for XF 2?

 

[Ivancas]

Hi @Jake Bunce
does this query is good also for XF 2?

For XenForo (likes) it is the following:

INSERT INTO XF.`xf_reaction_content` (reaction_id, content_type, content_id, reaction_user_id, reaction_date, content_user_id, is_counted)
    SELECT 1, 'post', dbt.contentid, dbt.userid, dbt.dateline, dbt.userid, 1
        FROM XF.`dbtech_thanks_entry` AS dbt WHERE `varname` LIKE 'likes'
        LEFT JOIN XF.`post` AS post ON (post.postid = dbt.contentid)
ON DUPLICATE KEY UPDATE
        content_id = VALUES(content_id);

 

[markoroots]

Great many thanks Ivancas, I have just solved times ago, but sure can be more helpful for many other users are moving from Vb because to import the Likes is really important

 

[Ivancas]

For XenForo (likes) it is the following:

INSERT INTO XF.`xf_reaction_content` (reaction_id, content_type, content_id, reaction_user_id, reaction_date, content_user_id, is_counted)
    SELECT 1, 'post', dbt.contentid, dbt.userid, dbt.dateline, dbt.userid, 1
        FROM XF.`dbtech_thanks_entry` AS dbt WHERE `varname` LIKE 'likes'
        LEFT JOIN XF.`post` AS post ON (post.postid = dbt.contentid)
ON DUPLICATE KEY UPDATE
        content_id = VALUES(content_id);

I can't edit the query so here is the right one:

INSERT INTO XFDB.`xf_reaction_content` (reaction_id, content_type, content_id, reaction_user_id, reaction_date, content_user_id, is_counted)
    SELECT 7, 'post', dbt.contentid, dbt.userid, dbt.dateline, dbt.receiveduserid, 1
        FROM VBDB.`dbtech_thanks_entry` AS dbt WHERE `varname` LIKE 'thanks'
ON DUPLICATE KEY UPDATE
        content_id = VALUES(content_id);

7 is the id of the reaction in XenForo you want to import to