Merged K 1.7 -> K 2.0.3 upgrade and now forum contents are "gone"

snehal wrote: i tried the way all guys has given in this post but it dint worked it out for me.

Ccould you try to take us through, step by step, "all the ways" that you tried to use to fix your problem and we may be able to get some clues as to why things did not work for you. There are a couple of things that you could have done. I just want to be sure that I understand exactly what you tried to do. Thank you.

1) i went to Kunena Forum >> Forum Tools >> Recount Statistics and perform this action. ,
2) Checked file permission for the com_kunena and finally updates the bellow query and again i did Recount Statistics from the backend.

UPDATE jos_kunena_topics AS tt
INNER JOIN (
SELECT thread, MIN(hold) AS hold FROM jos_kunena_messages WHERE hold IN (0,1) GROUP BY thread
) AS c ON tt.id=c.thread
SET tt.hold = c.hold
WHERE tt.moved_id=0

Let me guess, you're running J! 1.5?

Did you try the other approach? K 1.x -> K 2.0.2 and then K 2.0.2-> K 2.0.3? That was the other approach that could have worked for you. I don't think you tried "all the ways" that this topic has discussed. There are still other ways to solve your problem.

i upgraded K 2.0.2-> K 2.0.3 but still not getting answer is there any other way to do it. ?

Forum contents gone after upgrade to 2.0.3 (from 1.5.9) - on test upgrade
I definitely appreciate all your hard work and how difficult it can be to support the many different more or less literate users of Kunena and Joomla. I've been doing a substantial share of support myself...
Unfortunately I've spent most of a day looking for a solution to this issue, in spite of prepping my upgrade by reading through all the material I could find online and in the install package to support the upgrade from rel. 1.5.x to 2.0.x (I'm going from 1.5.9 to 2.0.3).
It was mentioned nowhere outside this thread, and it took me this long to find this post.
Matias' post with the SQL code did not seem to apply to my symptom:
- lost access to content of forum topics after upgrade from 1.5.9 to 2.0.3
Message: "Access Denied" and "You do not have permissions to access this page"
There is no date 0 (42 years in the past).

I would now try the approach of upgrading Kunena in smaller steps from 1.5.9 to 2.0.2, test it and then try 2.0.3 and test again.
Older versions than 2.0.3 are no longer available for download!
Any suggestion(s)?

Just tried another upgrade sequence to get Joomla 1.5.23 from Kunena 1.5.9 to 2.0.3 as part of a major site upgrade/migration to Joomla 2.5.
All done on my test environment.
1st time
- left Joomla 1.5.23 as is
- updated Kunena from 1.5.9 to 2.0.3
- updated Community Builder from 1.2.2 to 1.9

2nd time around
- updated Community Builder from 1.2.2 to 1.9
- attempting Kunena upgrade resulted in error message requiring Joomla update to 1.5.25+
- upgraded (patches) from J1.5.23 to J1.5.24 to J1.5.25 to J1.5.26
- updated Kunena from 1.5.9 to 2.0.3
No errors during upgrade, but in the end same symptoms as before: all messages gone
Again I get Message: "Access Denied" and "You do not have permissions to access this page"
The Kunena database still contains messages, but I can't see them.

Still no help to be found anywhere in the forums, in the Kunena installation notes etc.