| Forum Text Missing |
| by limecity on 2009/2/4 23:06:17 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. le="color: #000000"><?php 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 le="color: #000000"><?php 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
|
Search
Recent Posts
Who's Online
Donat-O-Meter
| Stats | |
| Goal: | $15.00 |
| Due Date: | Jul 31 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $15.00 |
|
|