Thursday, June 20, 2013
   
Text Size
Login

Migrate JComments from Joomla 1.5.x to Joomla 2.5.x

Print

Last Updated on Monday, 23 July 2012

Thought I'd add the migration script I've been using to test my JComments migration from my Joomla CMS site version 1.5.20 to Joomla CMS site version 2.5.6.

DISCLAIMER

  1. I do not work for either Joomla or JoomlaTune (Jcomments)
  2. This script is provided as is without warranty
  3. If you do not understand what this script is doing, let someone who does run it instead

INSTALL INSTRUCTIONS

  1. Install JComments on your upgraded website (at time of print: Jcomments v2.3.0 on Joomla v2.5.4)
  2. Copy the below script to a text file
    1. Change the database names to match your setup
    2. Change the table name prefixes to match your setup
  3. Run the modified SQL script against your database.
Note: It is not advisable to run this on a production website!

  1.  -- -------------------------------------------------------------------------------- 
  2.  -- MIGRATION SCRIPT FOR JCOMMENTS IN JOOMLA v1.5.x TO JOOMLA v2.5.x 
  3.  -- -------------------------------------------------------------------------------- 
  4.   
  5.  -- NOTE: Replace string "mydb_livecopy_j15" to your Joomla 1.5.x database name 
  6.  -- -- -- (example: "anolddatabase") -- 9 occurrences 
  7.  -- NOTE: Replace string "mydb_livecopy_j15.myprefix_" to your Joomla 1.5.x database name & table prefix 
  8.  -- -- -- (example: "anolddatabase.jos_") -- 8 occurrences 
  9.   
  10.  -- NOTE: Replace string "mydb_upgrade_j25" to your Joomla 2.5.x database name 
  11.  -- -- -- (example: "anewdatabase") -- 9 occurrences 
  12.  -- NOTE: Replace string "mydb_upgrade_j25.myprefix_" to your Joomla 2.5.x database name & table prefix 
  13.  -- -- -- (example: "anewdatabase.rndpfx1_") -- 8 occurrences 
  14.   
  15.  -- -------------------------------------------------------------------------------- 
  16.  -- _jcomments 
  17.  -- -------------------------------------------------------------------------------- 
  18.   
  19.  INSERT INTO 
  20.       mydb_upgrade_j25.myprefix_jcomments 
  21.       ( 
  22.            id, parent, thread_id, path, level, object_id, object_group, object_params, lang, 
  23.            userid, name, username, email, homepage, title, comment, ip, date, isgood, ispoor, 
  24.            published, subscribe, source, source_id, checked_out, checked_out_time, editor 
  25.       ) 
  26.  SELECT 
  27.       id, parent, 
  28.       CASE WHEN SUBSTRING(path, LOCATE(',', path)+1, LOCATE(',', path, 2))='' THEN 0 
  29.       ELSE SUBSTRING(path, LOCATE(',', path)+1, LOCATE(',', path, 2)) END AS thread_id, 
  30.       path, level, object_id, object_group, object_params, lang, 
  31.       userid, name, username, email, homepage, title, comment, ip, date, isgood, ispoor, 
  32.       published, subscribe, source, source_id, checked_out, checked_out_time, editor 
  33.  FROM 
  34.       mydb_livecopy_j15.myprefix_jcomments; 
  35.   
  36.   
  37.  -- -------------------------------------------------------------------------------- 
  38.  -- _jcomments_custom_bbcodes 
  39.  -- -------------------------------------------------------------------------------- 
  40.   
  41.  -- NOTE: This is disabled as the new version includes the old bbcodes setup (no change) 
  42.   
  43.  -- INSERT INTO 
  44.  --      mydb_upgrade_j25.myprefix_jcomments_custom_bbcodes 
  45.  --      ( 
  46.  --           id, `name`, simple_pattern, simple_replacement_html, simple_replacement_text, pattern, 
  47.  --           replacement_html, replacement_text, button_acl, button_open_tag, button_close_tag, 
  48.  --           button_title, button_prompt, button_image, button_css, button_enabled, ordering, 
  49.  --           published 
  50.  --      ) 
  51.  -- SELECT 
  52.  --      id, `name`, simple_pattern, simple_replacement_html, simple_replacement_text, pattern, 
  53.  --      replacement_html, replacement_text, button_acl, button_open_tag, button_close_tag, 
  54.  --      button_title, button_prompt, button_image, button_css, button_enabled, ordering, 
  55.  --      published 
  56.  -- FROM 
  57.  --      mydb_livecopy_j15.myprefix_jcomments_custom_bbcodes; 
  58.   
  59.   
  60.   
  61.  -- -------------------------------------------------------------------------------- 
  62.  -- _jcomments_reports 
  63.  -- -------------------------------------------------------------------------------- 
  64.   
  65.  INSERT INTO 
  66.       mydb_upgrade_j25.myprefix_jcomments_reports 
  67.       ( 
  68.            id, commentid, userid, name, ip, date, reason, status 
  69.       ) 
  70.  SELECT 
  71.       id, commentid, userid, name, ip, date, reason, status 
  72.  FROM 
  73.       mydb_livecopy_j15.myprefix_jcomments_reports; 
  74.   
  75.   
  76.  -- -------------------------------------------------------------------------------- 
  77.  -- _jcomments_settings -- ignored as this will load factory settings 
  78.  -- -------------------------------------------------------------------------------- 
  79.  /* 
  80.  INSERT INTO 
  81.       mydb_upgrade_j25.myprefix_jcomments_settings 
  82.       ( 
  83.            component, lang, name, value 
  84.       ) 
  85.  SELECT 
  86.       component, lang, name, value 
  87.  FROM 
  88.       mydb_livecopy_j15.myprefix_jcomments_settings; 
  89.  */ 
  90.   
  91.  -- -------------------------------------------------------------------------------- 
  92.  -- _jcomments_subscriptions 
  93.  -- -------------------------------------------------------------------------------- 
  94.   
  95.  INSERT INTO 
  96.       mydb_upgrade_j25.myprefix_jcomments_subscriptions 
  97.       ( 
  98.            id, object_id, object_group, lang, userid, name, email, hash, published 
  99.       ) 
  100.  SELECT 
  101.       id, object_id, object_group, lang, userid, name, email, hash, published 
  102.  FROM 
  103.       mydb_livecopy_j15.myprefix_jcomments_subscriptions; 
  104.   
  105.   
  106.  -- source=??? 
  107.   
  108.  -- -------------------------------------------------------------------------------- 
  109.  -- _jcomments_version 
  110.  -- -------------------------------------------------------------------------------- 
  111.   
  112.  INSERT INTO 
  113.       mydb_upgrade_j25.myprefix_jcomments_version 
  114.       ( 
  115.            version, previous, installed, updated 
  116.       ) 
  117.  SELECT 
  118.       version, previous, installed, updated 
  119.  FROM 
  120.       mydb_livecopy_j15.myprefix_jcomments_version; 
  121.   
  122.   
  123.  -- -------------------------------------------------------------------------------- 
  124.  -- _jcomments_votes 
  125.  -- -------------------------------------------------------------------------------- 
  126.   
  127.  INSERT INTO 
  128.       mydb_upgrade_j25.myprefix_jcomments_votes 
  129.       ( 
  130.            id, commentid, userid, ip, date, value 
  131.       ) 
  132.  SELECT 
  133.       id, commentid, userid, ip, date, value 
  134.  FROM 
  135.       mydb_livecopy_j15.myprefix_jcomments_votes; 
  136.   
  137.   
  138.   
  139.   
  140.  -- -------------------------------------------------------------------------------- 
  141.  -- _jcomments_objects  *** NEW FOR JOOMLA 2.5.X 
  142.  -- -------------------------------------------------------------------------------- 

Post-Installation

Go to JComments Settings and specify the same "Choose categories for JComments to work in" as you have for your 1.5 website. The above script ignores your previous settings and leaves the factory settings that come with the JComments extension. Check all JComments settings are what you want using the Joomla Admin interface.

If the article IDs match then the comments will also match. If however your article IDs don't match in both versions of your site, consider using the following update script, this will change the IDs of the JComments comments to be associated to articles from your Joomla 2.5 site (no changes to article IDs but backup your original database (J1.5) anyway before running the following):


  1.  UPDATE  
  2.       my_joomla_1_5_db.my_1_5_db_prefix_content j1a,    -- Joomla 1.5.x Content 
  3.       my_joomla_1_5_db.my_1_5_db_prefix_jcomments j1b,  -- Joomla 1.5.x JComments 
  4.       my_joomla_2_5_db.my_2_5_db_prefix_content j2a,    -- Joomla 2.5.x Content 
  5.       my_joomla_2_5_db.my_2_5_db_prefix_jcomments j2b   -- Joomla 2.5.x JComments 
  6.   
  7.  SET  
  8.       j2b.`object_id`=j2a.`id` 
  9.   
  10.  WHERE 
  11.       j1a.`alias`=j2a.`alias` 
  12.   
  13.  AND 
  14.       j1a.`id`=j1b.`object_id` 
  15.   
  16.  AND      
  17.       j2b.`comment`=j1b.`comment` 

Comments   

alexaner
# alexaner Fri, 5th April 2013
For non-techies I'd suggest automated tool for JComments conversion
http://www.cms2cms.com/
Like | Dislike | -1 Reply | Reply with quote | Quote
maxi
# maxi Wed, 24th April 2013
Excelente! me funcionooo, muchas gracias!! I mean, thanks a lot :P
Like | Dislike | +1 Reply | Reply with quote | Quote
Add Comment

Name:

Email:

Website:

Message:



Human Check:

Security code
Refresh

Please type what you see in the image above:

Main Menu

Latest Posts

  • Joes Quicklist Weblinks (JQW)

    • Tue 18-Jun-13
      Hi Joel, Great module, it really fills a need, and I'm not even using the thumbnails. It doesn't seem ...
      egrutz

  • Migrate Joomla! 1.5.x to 2.5.x+

    • Fri 07-Jun-13
      Hi Drew, I've got a silly question, are you sure the template you are using has been upgraded or ...
      Joel Lipman  
    • Wed 05-Jun-13
      Joel, Thanks for the newly updated instructions. I was nearly successful in getting everything working.
      drew  
    • Wed 05-Jun-13
      Hi Drew, Good point. You need to copy your images folder from your old site over to your new one. You ...
      Joel Lipman  
    • Tue 04-Jun-13
      Making a little progress here. I already had a copy of the live site running on this test server. So ...
      drew

Joes Word Cloud

Copyright © 1999-2013 Joel Lipman .Com

Restore Default Settings