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

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.

ratenberg: Are you referring to the problems discussed in Last post date "42 years ago" - access denied to topic - database errors ?

Did you read Kunena 2.0.3 known issues ?

Thanks a lot sozzled.

Reading " Kunena 2.0.3 known issues " again helped.


it's a 2 step process, and I missed the 2nd step:

1. Run the SQL scriopt (correct JOS_ to match your table prefix):
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

2. Activate "Recount Statistics" in "Forum Tools"

"When you have a problem look in your manual.
If you still have a problem, read the f... manual!"

Merry X-Mas

Did you create a backup of your site? Or at least the SQL file (database)? This could be one of a few issues here. The migration from J 1.5 to J 2.5 was a bit tricky for me. I made a careful evaluation before completely switching. Fortunately it worked fine on my end but I did not integrate my site with phpbb3 which would further complicate things.

So the issues you might have:
1. The posts tables might not even exist.
2. Everything is their but cannot be properly be read
3. Something beyond my understanding.

Also do you have access to the database via MySQL?