i upgraded today from 1.00 to 2.0.2....
i followed these steps.

i turned XOOPS off.
i deleted all files in the newbb folder..
i uploaded the new files.

i make an update to the module/templates.
i did a sync forums
and now i cant view any of my forums or categories...
i can view them in the administration area, but not in the forum itself...
the forum can count how many posts/topics i have.
but it dont count how many users i have, it says i have only one registered user!

when i'm trying to modify forum/catogory permissions, i get a "database error"

when i'm clicking to "read all unread topics i'm getting this:

An Error Occured
SELECT t.*, u.name, u.uname,u2.name as last_post_name, u2.uname as last_poster, p.post_time as last_post_time, p.poster_name as last_poster_name, p.icon, p.post_id FROM xoops_bb_topics t LEFT JOIN xoops_users u ON u.uid = t.topic_poster LEFT JOIN xoops_bb_posts p ON p.post_id = t.topic_last_post_id LEFT JOIN xoops_users u2 ON u2.uid = p.uid WHERE p.post_time > 1117633540 AND t.approved = 1 AND p.approved = 1 ORDER BY p.post_time DESC
....
xoops version: 2.0.10
and this is a production site

For some cases, you need empty your template_c, cache

-- I did not have this problem, just heard of it