Ok so ive had time to play with my reamped site
and this means ive had time to hook up the debug
and here we go.
( server and XOOPS specs )
Operating system - Linux
Kernel version - 2.6.17-11_1.BHsmp
Apache version - 1.3.37 (Unix)
PERL version - 5.8.6
PHP version - 4.4.4
MySQL version - 4.1.21-standard-log
Xoops version - 2.0.15
System version - 1.02
CBB version - 3.07
Xoops frameworks version - dated 2006-10-10 ( 1.00 )
Xoops editor version - 1.00
every thiong was folowed to the " T "
from here.
http://xoopsdocs.net/modules/dokuwiki/doku.php?id=en:module:released:manual:newbb:installwhile making a reply to a topic.
mysite.com/modules/newbb/reply.php
( ERROR: Forum not selected! )
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 = '4716e918ebd8be0b9f5a339d1617b8d4'
SELECT * FROM xoops_users WHERE uid=1
SELECT * FROM xoops_modules WHERE dirname = 'newbb'
SELECT * FROM xoops_config WHERE (conf_modid = '2') ORDER BY conf_order ASC
Total: 5 queries
in the index we have.
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 = '4716e918ebd8be0b9f5a339d1617b8d4'
SELECT * FROM xoops_users WHERE uid=1
SELECT * FROM xoops_modules WHERE dirname = 'newbb'
SELECT * FROM xoops_config WHERE (conf_modid = '2') ORDER BY conf_order ASC
SELECT * FROM xoops_bb_categories WHERE 1 = '1' ORDER BY cat_order ASC
SELECT COUNT(l.groupid) FROM xoops_groups_users_link AS l LEFT JOIN xoops_group_permission AS p ON p.gperm_groupid=l.groupid WHERE l.uid=1 AND p.gperm_modid = '1' AND p.gperm_name = 'module_admin' AND p.gperm_itemid = '2'
SELECT COUNT(*) FROM xoops_banner
SELECT * FROM xoops_banner LIMIT 1, 1
UPDATE xoops_banner SET impmade = impmade+1 WHERE bid = 2
SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
SELECT DISTINCT gperm_itemid FROM xoops_group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (1,2)
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,2) AND b.bid IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17) ORDER BY b.weight,b.bid
SELECT COUNT(*) FROM xoops_priv_msgs WHERE (read_msg = '0' AND to_userid = '1')
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'zoid' AND tpl_file = 'system_block_user.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'))
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'zoid' AND tpl_file = 'system_block_mainmenu.html') ORDER BY tpl_refid
SELECT * FROM xoops_users WHERE (level > '0') ORDER BY posts DESC LIMIT 0, 10
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'zoid' AND tpl_file = 'system_block_topusers.html') ORDER BY tpl_refid
SELECT * FROM xoops_users WHERE (level > '0') ORDER BY user_regdate DESC LIMIT 0, 10
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'zoid' AND tpl_file = 'system_block_newusers.html') ORDER BY tpl_refid
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'zoid' AND tpl_file = 'system_block_themes.html') ORDER BY tpl_refid
SELECT * FROM xoops_smiles
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'zoid' AND tpl_file = 'system_block_dummy.html') ORDER BY tpl_refid
DELETE FROM xoops_bb_online WHERE online_updated < 1163658888
DELETE FROM xoops_online WHERE online_updated < 1163658888
SELECT COUNT(*) FROM xoops_online WHERE online_uid=1
INSERT INTO xoops_online (online_uid, online_uname, online_updated, online_ip, online_module) VALUES (1, 'northern', 1163659188, '216.152.188.83', 2)
SELECT COUNT(*) FROM xoops_bb_online WHERE online_uid=1
INSERT INTO xoops_bb_online (online_uid, online_uname, online_updated, online_ip, online_forum, online_topic) VALUES (1, 'northern', 1163659188, '216.152.188.83', 0, 0)
DELETE FROM xoops_bb_online WHERE ( online_uid > 0 AND online_uid NOT IN ( SELECT online_uid FROM xoops_online WHERE online_module =2 ) ) OR ( online_uid = 0 AND online_ip NOT IN ( SELECT online_ip FROM xoops_online WHERE online_module =2 AND online_uid = 0 ) )
SELECT * FROM xoops_bb_online
SELECT COUNT(l.groupid) AS count, l.uid FROM xoops_groups_users_link AS l LEFT JOIN xoops_group_permission AS p ON p.gperm_groupid=l.groupid WHERE l.uid IN (1) AND p.gperm_modid = '1' AND p.gperm_name = 'module_admin' AND p.gperm_itemid = '2' GROUP BY l.uid
SELECT COUNT(*) FROM xoops_bb_topics WHERE (approved > '0')
SELECT COUNT(*) FROM xoops_bb_posts WHERE (approved > '0')
SELECT * FROM xoops_bb_forums WHERE (1 = '1' AND cat_id IN (1)) ORDER BY forum_order ASC
SELECT uid,topic_id,post_time,subject,poster_name,icon,post_id FROM xoops_bb_posts WHERE post_id IN (0) ORDER BY post_id DESC
SELECT * FROM xoops_smiles
SELECT * FROM xoops_xoopsnotifications WHERE (not_modid = '2' AND not_category = 'global' AND not_uid = '1') ORDER BY not_id ASC
SELECT * FROM xoops_modules WHERE mid = 2
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'zoid' AND tpl_file = 'newbb_index.html') ORDER BY tpl_refid
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'zoid' AND tpl_file = 'newbb_online.html') ORDER BY tpl_refid
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'zoid' AND tpl_file = 'system_notification_select.html') ORDER BY tpl_refid
Total: 44 queries
your more then welcome to check it out.
http://www.northernneons.com/to gain access as a registered user
User : TEST
PW: TEST
