XF 2.0 DBtech Likes to Xenforo Likes?

[Arun Kumar]

I just updated my board from vb4.x to Xenforo 2 without any issues. Is there any way in which I can import the Dbtech likes to xenforo likes. I searched over and couldn't find any solution.

Any help would be appreciated, I think we just need to map the likes from vb database to xf table?

Cheers

 

[Niro]

@DragonByte Tech will be able to help you ^^

 

[Arun Kumar]

@DragonByte Tech will be able to help you ^^

Yeah, i am patiently waiting for this to be ported.

 

[Arun Kumar]

Those of you who are on the same boat as me, Dbtech thanks to likes can be ported easily.

Just run this query.

https://xenforo.com/community/threads/manually-import-dbtech-thanks.93417/

Then you just have to rebuild your likes.

Bingo, this is beautiful

 

[The Dawg]

Those of you who are on the same boat as me, Dbtech thanks to likes can be ported easily.

Just run this query.

https://xenforo.com/community/threads/manually-import-dbtech-thanks.93417/

Then you just have to rebuild your likes.

Bingo, this is beautiful

I tried it, but got "Column 'content_user_id' cannot be null"

 

[Masetrix]

I tried it, but got "Column 'content_user_id' cannot be null"

I helped myself with the same mistake as follows:

INSERT IGNORE INTO XenForoDBName.`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);

"INSERT IGNORE" vs "INSERT ... ON DUPLICATE KEY UPDATE"

While executing an INSERT statement with many rows, I want to skip duplicate entries that would otherwise cause failure. After some research, my options appear to be the use of either: ON DUPLICAT...

stackoverflow.com