Another funny behavior.
I backup my cbb 3.08 database.
then uninstall the module.
reinstall it. and then manually loaded all the database back.
Everything looks ok.
but when click on the topics, all the postings seemed to be missing.
but the pages numbers can be seen.
I sync the database from the cbb.
then manually repair, optimize the table.
still doesn't work.
on debug. i get this.
Notice: Deprecated function 'mod_getip', use XoopsUserUtility directly. in file Frameworks/art/functions.user.php line 20
Notice: Only variables should be assigned by reference in file modules/newbb/class/permission.php line 117
Notice: Undefined index: shoutbox_smibar in file modules/shoutbox/blocks/shoutbox.php line 60
Warning: Class XoopsEditorHandler does not exist
Handler Name: editor in file include/functions.php line 446
Notice: Only variables should be assigned by reference in file modules/newbb/viewtopic.php line 584
Queries Error
SET NAMES 'ISO-8859-1'
Error number: 1115
Error message: Unknown character set: 'ISO-8859-1'
SELECT * FROM xt3x4_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data, sess_ip FROM xt3x4_session WHERE sess_id = '1c293d7dac9f24845a177f59e9bbecff'
SELECT * FROM xt3x4_users WHERE uid = '1963'
SELECT * FROM xt3x4_modules WHERE dirname = 'newbb'
SELECT * FROM xt3x4_config WHERE (conf_modid = '257') ORDER BY conf_order ASC
DELETE FROM xt3x4_protector_access WHERE expire < UNIX_TIMESTAMP()
SELECT COUNT(*) FROM xt3x4_protector_access WHERE ip='60.52.8.53' AND request_uri='/modules/newbb/viewtopic.php?topic_id=2081&viewmode=flat&order=ASC&type=&mode=0&start=2360'
SELECT COUNT(*) FROM xt3x4_protector_access WHERE ip='60.52.8.53'
INSERT INTO xt3x4_protector_access SET ip='60.52.8.53',request_uri='/modules/newbb/viewtopic.php?topic_id=2081&viewmode=flat&order=ASC&type=&mode=0&start=2360',expire=UNIX_TIMESTAMP()+'60'
SELECT * FROM xt3x4_bb_topics WHERE topic_id = '2081'
SELECT * FROM xt3x4_bb_forums WHERE forum_id = '33'
SELECT COUNT(l.groupid) FROM xt3x4_groups_users_link AS l LEFT JOIN xt3x4_group_permission AS p ON p.gperm_groupid=l.groupid WHERE l.uid=1963 AND p.gperm_modid = '1' AND p.gperm_name = 'module_admin' AND p.gperm_itemid = '257'
SELECT * FROM xt3x4_group_permission WHERE (gperm_modid = '257' AND gperm_groupid IN (1,2) AND gperm_itemid = '33' AND gperm_name IN ('forum_access','forum_view','forum_post','forum_reply','forum_edit','forum_delete','forum_addpoll','forum_vote','forum_attach','forum_noapprove'))
SELECT COUNT(*) FROM `xt3x4_bb_posts` WHERE (topic_id = '2081' AND approved = '1')
SELECT p.*, t.* FROM xt3x4_bb_posts p, xt3x4_bb_posts_text t WHERE p.topic_id=2081 AND p.post_id = t.post_id AND p.approved = 1 ORDER BY p.post_id ASC LIMIT 2360, 10
UPDATE xt3x4_bb_topics SET topic_views = topic_views + 1 WHERE topic_id =2081
UPDATE xt3x4_bb_reads_topic SET post_id = 69812, read_time =1233788690 WHERE read_item = 2081 AND uid = 1963
SELECT COUNT(*) FROM xt3x4_banner
SELECT * FROM xt3x4_banner LIMIT 0, 1
UPDATE xt3x4_banner SET impmade = impmade+1 WHERE bid = 20
SELECT * FROM xt3x4_config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
SELECT DISTINCT gperm_itemid FROM xt3x4_group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (1,2)
SELECT b.* FROM xt3x4_newblocks b, xt3x4_block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,257) AND b.bid IN (345,347,5,346,191,165,9,123,13,8,356,96,354,268,54,309,355,100,3,348,320,321,322,323,324,325,326,327,328,307,277,278,279,280,269,266,265,264,119,157,267,235,196,192,194,195,193,171,158,156,154,155,190,118,66,294,97,55,10,169,124,98,117,116,164,302,297,99,120,121,122,102,101,243,62,53,69,52,12,11,42,7,6,4,2,1,353,339,338,14,298,168,174,301,299,281,350,360,359,358,78,77,76,75,74,73,68,67,65,64,63,61,60,59,58,57,56,51,357,50,49,48,47,46,45,44,43,29,28,27,23) ORDER BY b.weight,b.bid
SELECT * FROM xt3x4_modules WHERE (hasmain = '1' AND isactive = '1' AND weight > '0') ORDER BY weight ASC, mid ASC
SELECT * FROM xt3x4_group_permission WHERE (gperm_name = 'module_read' AND gperm_modid = '1' AND (gperm_groupid = '1' OR gperm_groupid = '2'))
SELECT * FROM xt3x4_modules WHERE dirname = 'news'
SELECT * FROM xt3x4_groups
SELECT * FROM xt3x4_groups
SELECT * FROM xt3x4_modules WHERE dirname = 'pm'
SELECT COUNT(*) FROM xt3x4_priv_msgs WHERE (read_msg = '0' AND to_userid = '1963')
SELECT * FROM xt3x4_modules WHERE dirname = 'shoutbox'
SELECT * FROM xt3x4_config WHERE (conf_modid = '218') ORDER BY conf_order ASC
SELECT COUNT(*) FROM xt3x4_online WHERE online_uid=1963
UPDATE xt3x4_online SET online_updated=1233788690, online_module = 257 WHERE online_uid = 1963
SELECT * FROM xt3x4_online
SELECT COUNT(*) FROM xt3x4_online WHERE online_module = '257'
SELECT COUNT(*) FROM xt3x4_online WHERE online_uid=1963
UPDATE xt3x4_online SET online_updated=1233788690, online_module = 257 WHERE online_uid = 1963
SELECT COUNT(*) FROM xt3x4_bb_online WHERE online_uid=1963
UPDATE xt3x4_bb_online SET online_updated= '1233788690', online_forum = '33', online_topic = '2081' WHERE online_uid = 1963
DELETE FROM xt3x4_bb_online WHERE ( online_uid > 0 AND online_uid NOT IN ( SELECT online_uid FROM xt3x4_online WHERE online_module =257 ) ) OR ( online_uid = 0 AND online_ip NOT IN ( SELECT online_ip FROM xt3x4_online WHERE online_module =257 AND online_uid = 0 ) )
SELECT * FROM xt3x4_bb_online WHERE online_topic = '2081'
SELECT COUNT(l.groupid) AS count, l.uid FROM xt3x4_groups_users_link AS l LEFT JOIN xt3x4_group_permission AS p ON p.gperm_groupid=l.groupid WHERE l.uid IN (1963) AND p.gperm_modid = '1' AND p.gperm_name = 'module_admin' AND p.gperm_itemid = '257' GROUP BY l.uid
SELECT cat_title, cat_id FROM xt3x4_bb_categories WHERE cat_id = '18'
SELECT * FROM xt3x4_groups
SELECT * FROM `xt3x4_bb_categories` WHERE 1 = '1' ORDER BY cat_order ASC
SELECT * FROM `xt3x4_bb_forums` WHERE (1 = '1' AND cat_id IN (18, 5, 25, 14, 4)) ORDER BY forum_order ASC
SELECT MIN(post_id) AS post_id FROM xt3x4_bb_posts WHERE topic_id = 2081 AND pid = 0
Total: 49 queries
