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

[Thatoo]

Thank you, I solved my problem!

[Enes]

Thank you for instructions, I follow them and import all comments for frontend succesfully...

But from admin panel, I can not see comments in Manage Comments and also Latest Comments module can not display comments...

So comments can be displayed only in articles. How to fix that?

Thanks...

[Enes]

OK I just fixed it... I changed table prefix manually and it is done.

Last time I changed it with Notepad++ Find&Change and it didn't work but manually it is OK.
Thanks for your instructions again, our comments came back.

[hayatt]

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

THANK YOU! I've wasted a lot of time in trial and error.
I followed these steps, and all went well.
Thanks!

[drhaley]

From http://www.joomlatune.com/forum/index.php/topic,3571.0.html... I think I am getting close to a fix of my similar problem... but in step 3, why are the good tables being renamed to j17? should it be j25? I actually tried both, but was not completely successful. I think I am getting tables mixed... that is, I had 7 of the 9 "jos" tables. Can I bring all those to the j25 names and leave to other two empty j25 tables? Where do I find someone that understands this stuff for hire?

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

[ABTOP]

...but in step 3, why are the good tables being renamed to j17? should it be j25?

Because the instructions were written specifically for totohariko.
See

The table j17_jcomments is empty.

In your case the prefix needs to be whatever your installation is using. If you have j25_, then use that. If you have jhmfc_, then use jhmfc_ and so on.

Where do I find someone that understands this stuff for hire?

Indeed, where?

[hayatt]

Hello ... and Help! 
I tried your way ABTOP, and it worked perfectly on my test site!

Now, I did the real migration today ( Iused SP Upgrade instead of Jupgrade).
Things went fine, but the back end does not reflect the real content of the tables!
There are no comments in my control panel, and another funny thing is that when I try to chance the settings (like choose category or edit any settings) it tells me it saved it successfully, but when I open the settings again, I find nothing has changed.

It is as if my tables are frozen or locked, or that jcomments is refusing to take t=data from them.


I tried removing everything and doing it all gain, and the same

PS:
The only difference between jupgrade and SP upgrade is that SP upgrade uses a new database for 2.5
So what I did is that I downloaded my old 1.5 tables and imported them to the new database which has 2.5, and renamed them. But that did not work

I tried another plan. I used the operation tab in my old database and copied the tables to my new database, and that did not work either.

I need help please asap

Thank you.

[hayatt]

Update:
Nevermind, I was doing something stupid!
I was renaming the tables newprefix_jos_jcomments
I should have removed the _jos  thing! 

[riga75]

I followed the steps, I have comments in the db but then if I go to admin and upgrade but does not load the old comments.
Can you help?
thanks a lot


stefano