1. 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)

Discussion in 'XenForo Questions and Support' started by vFranky, Aug 1, 2015.

  1. vFranky

    vFranky Active Member

    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 =>

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

    Kind regards,
    Frank
     
  2. Dakis

    Dakis Well-Known Member

    vFranky likes this.
  3. vFranky

    vFranky Active Member

    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.
     
    Dakis likes this.

Share This Page