I've just upgraded newbb 1 to CBB 1.6.
Everything went fine and dandy, I can add categories and forums, and the layout is all fine. I can even post a new topic, however, when ever I try and look at topic posts I just get a blank screen.
I did a test install on a separate installation of XOOPS and this DIDN'T happen! So i'm at a loss to why this has happened now. I've posted the debug reports below. There appears to be no MySQL erros, just 1 PHP error. Help please!
PHP debug
Version 2.0.13.0
Notice [PHP]: Constant _MI_TEXT already defined in file modules/xoopspartners/language/english/modinfo.php line 38
MySQL Debug
SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data FROM xoops_session WHERE sess_id = '765481adc1352edea8d605f8fae3bfaf'
SELECT * FROM xoops_users WHERE uid=2
SELECT * FROM xoops_modules WHERE dirname = 'newbb'
SELECT * FROM xoops_config WHERE (conf_modid = '4') ORDER BY conf_order ASC
SELECT * FROM xoops_bb_topics WHERE topic_id=6
SELECT * FROM xoops_bb_forums WHERE forum_id = 13
SELECT * FROM xoops_group_permission WHERE (gperm_name = 'module_admin' AND gperm_itemid = '4' AND gperm_modid = '1')
SELECT uid FROM xoops_groups_users_link WHERE groupid=4
SELECT uid FROM xoops_groups_users_link WHERE groupid=5
SELECT uid FROM xoops_groups_users_link WHERE groupid=1
SELECT * FROM xoops_group_permission WHERE (gperm_modid = '4' AND gperm_groupid IN (1,2,4) AND gperm_itemid = '13' AND gperm_name IN ('forum_can_post','forum_can_view','forum_can_reply','forum_can_edit','forum_can_delete','forum_can_addpoll','forum_can_vote','forum_can_attach','forum_can_noapprove'))
SELECT t.topic_id, t.topic_title, t.topic_poster, t.topic_status, t.topic_subject, t.topic_sticky, t.topic_digest, t.digest_time, t.topic_time, t.topic_last_post_id, t.approved, t.poster_name, t.rating, t.votes, t.topic_haspoll, t.poll_id, f.forum_id, f.forum_name, f.allow_html, f.allow_sig, f.hot_threshold, f.forum_type, f.allow_attachments, f.attach_maxkb, f.attach_ext, f.allow_polls, f.parent_forum FROM xoops_bb_topics t LEFT JOIN xoops_bb_forums f ON f.forum_id = t.forum_id WHERE t.topic_id = 6
SELECT * FROM xoops_bb_topics WHERE topic_id=6
SELECT COUNT(*) FROM xoops_bb_posts WHERE topic_id=6 AND approved = 1
SELECT p.*, t.* FROM xoops_bb_posts p, xoops_bb_posts_text t WHERE p.topic_id=6 AND p.post_id = t.post_id AND p.approved = 1 ORDER BY p.post_id ASC LIMIT 0, 10
SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
SELECT COUNT(*) FROM xoops_banner
SELECT * FROM xoops_banner LIMIT 0, 1
UPDATE xoops_banner SET impmade = impmade+1 WHERE bid = 1
SELECT DISTINCT gperm_itemid FROM xoops_group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (1,2,4)
SELECT b.* FROM xoops_newblocks b, xoops_block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,4) AND b.bid IN (31,30,47,40,38,5,2,35,1,37,36,33,32,28,27,26,25,24,23,22,21,44,20,19,18,43,17,16,42,15,14,13,12,11,49,10,9,8,7,6,4,3,39,34,29,46,50,51,52,53,54,55,56,57,58,59,60,61) ORDER BY b.weight,b.bid
SELECT COUNT(*) FROM xoops_multimenu01 WHERE hide = 1
SELECT id, pid, groups, link, submenu, title, target, imageurl, weight FROM xoops_multimenu01 WHERE hide = 1 ORDER BY weight ASC
SELECT * FROM xoops_smiles
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'multimenu_block_01.html') ORDER BY tpl_refid
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'multimenu_dyn_vert.html') ORDER BY tpl_refid
SELECT COUNT(*) FROM xoops_priv_msgs WHERE (read_msg = '0' AND to_userid = '2')
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_user.html') ORDER BY tpl_refid
SELECT COUNT(*) FROM xoops_multimenu04 WHERE hide = 1
SELECT id, pid, groups, link, submenu, title, target, imageurl, weight FROM xoops_multimenu04 WHERE hide = 1 ORDER BY weight ASC
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'multimenu_block_04.html') ORDER BY tpl_refid
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'multimenu_dyn_vert_css.html') ORDER BY tpl_refid
SELECT COUNT(*) FROM xoops_multimenu02 WHERE hide = 1
SELECT id, pid, groups, link, submenu, title, target, imageurl, weight FROM xoops_multimenu02 WHERE hide = 1 ORDER BY weight ASC
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'multimenu_block_02.html') ORDER BY tpl_refid
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'multimenu_dyn_vert_css.html') ORDER BY tpl_refid
SELECT * FROM xoops_modules WHERE (hasmain = '1' AND isactive = '1' AND weight > '0') ORDER BY weight ASC, mid ASC
SELECT * FROM xoops_group_permission WHERE (gperm_name = 'module_read' AND gperm_modid = '1' AND (gperm_groupid = '1' OR gperm_groupid = '2' OR gperm_groupid = '4'))
SELECT * FROM xoops_bb_forums ORDER BY forum_order
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_mainmenu.html') ORDER BY tpl_refid
SELECT COUNT(*) FROM xoops_online WHERE online_uid=2
UPDATE xoops_online SET online_updated=1185941057, online_module = 4 WHERE online_uid = 2
SELECT COUNT(*) FROM xoops_bb_online WHERE online_uid=2
UPDATE xoops_bb_online SET online_updated= '1185941057', online_forum = '13', online_topic = '6' WHERE online_uid = 2
SELECT online_uid, online_ip FROM xoops_online WHERE online_module = 4
DELETE FROM xoops_bb_online WHERE ( online_uid NOT IN (2) )
SELECT COUNT(*) FROM xoops_bb_online WHERE online_topic = '6'
SELECT * FROM xoops_bb_online WHERE (online_topic = '6' AND online_uid <> '0')
SELECT * FROM xoops_users WHERE uid IN (2)
SELECT * FROM xoops_bb_online WHERE online_uid IN (2)
SELECT * FROM xoops_groups
SELECT groupid FROM xoops_groups_users_link WHERE uid=2
SELECT rank_title AS title, rank_image AS image FROM xoops_ranks WHERE rank_min <= 4 AND rank_max >= 4 AND rank_special = 0
SELECT * FROM xoops_bb_categories WHERE cat_id = 5
SELECT * FROM xoops_bb_categories ORDER BY cat_order
SELECT * FROM xoops_bb_forums ORDER BY forum_order
SELECT post_id FROM xoops_bb_posts WHERE topic_id = 6 AND pid = 0
SELECT COUNT(*) FROM xoops_xoopsnotifications WHERE (not_modid = '4' AND not_category = 'thread' AND not_itemid = '6' AND not_event = 'new_post' AND not_uid = '2')
SELECT * FROM xoops_xoopsnotifications WHERE (not_modid = '4' AND not_category = 'thread' AND not_itemid = '6' AND not_uid = '2') ORDER BY not_id ASC
SELECT * FROM xoops_modules WHERE mid = 4
SELECT * FROM xoops_xoopsnotifications WHERE (not_modid = '4' AND not_category = 'forum' AND not_itemid = '13' AND not_uid = '2') ORDER BY not_id ASC
SELECT * FROM xoops_xoopsnotifications WHERE (not_modid = '4' AND not_category = 'global' AND not_uid = '2') ORDER BY not_id ASC
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'newbb_viewtopic_flat.html') ORDER BY tpl_refid
Info
XOOPS Version:2.0.13.2
Module Name/Version:CBB - 1.16
PHP Version: 5.0.5
MySQL Version: 4.1.20
Web Server Software (Apache/IIS/Other):Apache/2.2.2
Operating System:
Theme you are using:blue lagoon
Custom template: (Yes/No)
PHP Debug Messages: See above
MySQL Debug Messages: See above
Thanks,
Nick
