[solved] No comments after upgrade from joomla 1.5 to 2.5

[totohariko]

Hello,

I upgraded jcomments to 2.3 on my joomla 1.5 site and the result is fine, the comments are OK.

Then I applied Jupgrade to 2.5. Now the comments in Joomla 2.5 are gone. The table j17_jcomments is empty.
What did I wrong?

Thanks in advance.

[ABTOP]

You upgraded from Joomla 1.5 to Joomla 2.5?
How did you do the this upgrade?

[totohariko]

With Jupgrade 2.5.0

[ABTOP]

I know exactly what went wrong and it has nothing to do with jComments.

[totohariko]

How mysterious! Would you like to share? 

[ABTOP]

I will share if you answer one simple question: just because you installed JComments, do you expect us to help you with JUpgrade too?

[totohariko]

I used Jcomments on Joomla 1.5. I migrated to 2.5 and I suppose it would be normal that the migration of Jcomment works too. Maybe that is a Jpugrade issue, but I guess all people who waited for Jcomments 2.3 before migrating to Joomla 2.5 are likely to meet the same problem.

So if you know the answer, I would be happy that you share it with me!

Please ?

[ABTOP]

Fair enough.

Step one.
Make sure you still have the old JComments tables in J1.5
1. open the old Joomla 1.5 database (which in your case also contains the tables for the new Joomla 2.5) with a DB tool of your preference, such as phpMyAdmin, and verify that the old JComments tables are still there. These are the tables that begin with _jcomments, or in default installations, with jos_jcomments.

Here's the full list of JComments tables:
   jos_jcomments
   jos_jcomments_blacklist    
   jos_jcomments_custom_bbcodes    
   jos_jcomments_objects    
   jos_jcomments_reports    
   jos_jcomments_settings    
   jos_jcomments_subscriptions    
   jos_jcomments_version    
   jos_jcomments_votes

Step two
Delete the existing tables for JComment in Joomla 2.5.
Since you reported that j17_jcomments table is empty, i understand that JComments is installed for Joomla 2.5. This is fine, we just want to get rid of its empty tables.
Select all the tables that start with j17_jcomments and drop them, all nine of them.

Step three
Copy the old JComments tables into Joomla 2.5 installation.
Select each of the old JComments tables for Joomla 1.5 and rename them while copying
For this
a. open a table (i.e jos_jcomments)
b. click on "Operations"
c. in Copy table to (database.table): select "Structure and data" and type the new name for this table changing the prefix only in the empty name field above. That is "jos" will become "j17", the rest of the table name must stay the same. Do not change the database name for both Joomla1.5 and Joomla 2.5 are running on the same database right now.
d. repeat this procedure each of JComments tables

Step four
Inside Joomla 2.5 go to jComments -> Manage comments and click Refresh objects.

This will bring the old JComments data into Joomla 2.5

[totohariko]

Thank you very much for this very thourough answer. It works very well... except the comments don't match with the articles at all. Every discussion is attributed to a wrong article!

[ABTOP]

Well, Sergei will sure want to read this. 

This "remapping" is caused by JUpgrade. For some inexplicable reason JUpgrade changes the article IDs during the conversion from J1.5 to J2.5. I have no clue why IDs needed to be changed. I can't believe they couldn't be retained as they were. But the fact is - the article IDs are now different to what they used to be. So the comments are pointing to wrong articles.

Fixing this is a bit complicated, but not hopeless, but I want Sergei to read this before we go forward.
There are a couple of things I would like to find out though.
First, what is the total number of articles in your site?
Second, do they have internal links? That is, are there links within articles that point to other articles? if there are, do those links still work or do they "remap" to wrong articles just like comments do?

See if you can get this info before Sergei gets here, ko?

[totohariko]

There are about 600 articles in my site.
No internal links, am I lucky?

Who is Sergei, is he a kind of a Jupgrade guru, or something? 

[ABTOP]

Yes, you are lucky.

Sergei is smart, but probably not an JUpgrade guru yet. 

[monita]

Hello all,
This is my first post here...and let me tell you, i m very happy to have found this component!!
However, i m in the same problem as mentioned by the member above...I recently upgraded by joomla 2.5 website..well, not upgraded, in fact rebuilt everything again... i mean, i didn't use that clumsy jupgrade...but i used j2xml exporter/importer to import my articles, categories, users and images.. and rest everything like, menus and modules... i built them up again manually....
Then I installed jcomments in joomla25..deleted the empty tables from the database and imported the old jcomments tables from the old j15 database into it. So far, so good. I got all my comments back in the new joomla 25 website. But, now what I see is that the "Content Item Title" column is empty in the "Manage comments" section in Jcomments. That means, the comments are there but they're not assigned to any articles. Now what do i do?
Please someone give me workable solution. I shall be highly obliged to all of you
Thanks a lot for everything

[totohariko]

Yohoho! And a bottle of rum!

I found a beta version of jupgrade component that preserves the article IDs. Now the comments match the articles, I won't need Sergei's help on this one.

You'll find attached this beta of Jupgrade.

Thank you ABTOP, spasiba for your very efficient and very kind help, and for diagnosing the IDs problem. That is what drove me to the solution.

[Firekans]

The new jupgrade keeps the IDs: http://redcomponent.com/free-downloads/cat_view/931-jupgrade