1
Currently I'm using XOOPS 2.2.3 and NewBB 1.0 not the ideal combination.
When I try to directly upgrade to CBB (overwriting files, update module, reset templates) I can no longer see any of my forums. But I can see categories.
When I trie to upgrade by running a NewwBB1 > NewBB2 upgrade script and then overwrite files, update module and reset templates I've got my forums back. Looks like solved but it isn't.
When trying to open a forum the next message appears (all permissions are set correctly):
Quote:
An Error Occured
SELECT t.*, p.post_time as last_post_time, p.poster_name as last_poster_name, p.icon, p.post_id, p.uid, p.post_karma, p.require_reply, pt.post_text FROM xoops_bb_topics t LEFT JOIN xoops_bb_posts p ON p.post_id = t.topic_last_post_id LEFT JOIN xoops_bb_posts_text pt ON pt.post_id = t.topic_last_post_id WHERE (p.post_time > 1128291194 OR t.topic_sticky=1) AND t.forum_id = 1 AND t.approved = 1 AND p.approved = 1 ORDER BY t.topic_sticky DESC, p.post_time DESC
Hopefully anyone has exprienced the same and knows a workaround.
Cheers,
Bob
