• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

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

vFranky

Active member
#1
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 =>

Code:
 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
 

vFranky

Active member
#3
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.