XF 1.5 Converting vB-Thanks to XenForo-Likes (SQL-Problem)

[vFranky]

Hello,

I try to move the convert vB-Thanks to XenForo-Likes. I exported the vBulletin tables post und post_thanks from the vB-database and imported it to the XenForo-database. Then I try to use the following script to make the conversion =>

 INSERT INTO `xf_liked_content` (content_type, content_id, like_user_id, like_date, content_user_id)
SELECT 'post', vl.postid, vl.userid, vl.date, post.userid
FROM `post_thanks` AS vl
LEFT JOIN `post` AS post ON (post.postid = vl.postid)
ON DUPLICATE KEY UPDATE
content_id = VALUES(content_id);

But phpMyAdmin answers with an error =>

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'post\', vl.postid, vl.userid, vl.date, post.userid

FROM `post_thanks` AS ' at line 3

Any idea? I have not much mysql knowledge.
Thank you in advance.

Kind regards,
Frank

 

[Dakis]

I believe there's a couple of addons that you can use:

Import Post Thanks to Likes

 

[vFranky]

Thank you, Dakis. The problem is solved => phpMyAdmin sees a syntax error which doesn't exist. I finally used a Windows SQL frontend to overcome this obstacle. With it the SQL command is executed at once without any problems.

Then I used rebuildlikes.php to integrate the old vB-thanks into the XenForo-Likes.