:::
XOOPS使用討論區
敬愛的tad老師，又來請教您~
不曉得是不是因為新增移除太多模組
結果即使允許所有人註冊
也允許註冊會員擁有所有權限
但都還是無法註冊
顯示為無權限
如附圖
然後錯誤訊息竟然有30個
今天早上就是試安裝了wordpress for xoops 然後又移除掉而已
不知道問題出在哪裡
真抱歉又要麻煩您幫我看看~
0.000157 - SET NAMES 'utf8'
0.000091 - SET SQL_BIG_SELECTS = 1
0.000158 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
0.000357 - SELECT sess_data, sess_ip FROM session WHERE sess_id = '9rfqmdqr8hpnu3jd8pnjugt3u3'
0.000118 - SELECT * FROM users WHERE uid = '1'
0.017059 - SELECT * FROM modules WHERE dirname = 'vegpad'
0.000562 - SELECT * FROM config WHERE (conf_modid = '26') ORDER BY conf_order ASC
0.000240 - DELETE FROM protector_access WHERE expire < UNIX_TIMESTAMP()
0.000307 - SELECT COUNT(*) FROM protector_access WHERE ip='1.164.107.130' AND request_uri='/xoops/modules/vegpad/'
0.000240 - SELECT COUNT(*) FROM protector_access WHERE ip='1.164.107.130'
0.000289 - INSERT INTO protector_access SET ip='1.164.107.130',request_uri='/xoops/modules/vegpad/',expire=UNIX_TIMESTAMP()+'60'
0.000179 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
0.000835 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (1,2)
0.001390 - SELECT b.* FROM newblocks b, block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,26) AND b.bid IN (1,2,233,3,229,4,5,6,7,8,9,77,10,11,12,228,13,226,72,71,227,232,220,221,230,223,224,225,222,76,75,74,73,234,78,93,231,62,64,68,59,66,65,69,58,63,61,67,70,60,80) ORDER BY b.weight, m.block_id
0.000104 - SELECT COUNT(*) FROM vegpad
0.000165 - SELECT * FROM vegpad WHERE 1 = '1' ORDER BY id DESC LIMIT 0, 15
0.000207 - SELECT * FROM smiles
0.000126 - SELECT * FROM modules WHERE dirname = 'tad_themes'
0.000101 - SELECT * FROM modules WHERE dirname = 'tadtools'
0.000106 - SELECT * FROM config WHERE (conf_modid = '6') ORDER BY conf_order ASC
0.000107 - SELECT * FROM config WHERE (conf_modid = '16') ORDER BY conf_order ASC
0.000132 - select * from tad_themes where `theme_name`='school2014'
0.000092 - select conf_value from config where conf_title ='_MD_AM_DEBUGMODE'
0.000116 - select * from tad_themes_blocks where `theme_id`='4'
0.000122 - select `name`, `type`, `value` from tad_themes_config2 where `theme_id`='4'
0.000115 - select menuid,itemname,itemurl,target,icon from tad_themes_menu where of_level='0' and status='1' order by position
0.000130 - select a.*,b.slide_width,b.slide_height from tad_themes_files_center as a left join tad_themes as b on a.col_sn=b.theme_id where a.`col_name`='slide' and b.`theme_name`='school2014'
0.000138 - select name,dirname from modules where isactive='1' and hasmain='1' and weight!=0 order by weight
0.000120 - select `menuid`,`itemname`,`itemurl` from tad_themes_menu
0.000131 - select a.*,b.slide_width,b.slide_height from tad_themes_files_center as a left join tad_themes as b on a.col_sn=b.theme_id where a.`col_name`='slide' and b.`theme_name`='school2014'
結果即使允許所有人註冊
也允許註冊會員擁有所有權限
但都還是無法註冊
顯示為無權限
如附圖
然後錯誤訊息竟然有30個
今天早上就是試安裝了wordpress for xoops 然後又移除掉而已
不知道問題出在哪裡
真抱歉又要麻煩您幫我看看~
0.000157 - SET NAMES 'utf8'
0.000091 - SET SQL_BIG_SELECTS = 1
0.000158 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
0.000357 - SELECT sess_data, sess_ip FROM session WHERE sess_id = '9rfqmdqr8hpnu3jd8pnjugt3u3'
0.000118 - SELECT * FROM users WHERE uid = '1'
0.017059 - SELECT * FROM modules WHERE dirname = 'vegpad'
0.000562 - SELECT * FROM config WHERE (conf_modid = '26') ORDER BY conf_order ASC
0.000240 - DELETE FROM protector_access WHERE expire < UNIX_TIMESTAMP()
0.000307 - SELECT COUNT(*) FROM protector_access WHERE ip='1.164.107.130' AND request_uri='/xoops/modules/vegpad/'
0.000240 - SELECT COUNT(*) FROM protector_access WHERE ip='1.164.107.130'
0.000289 - INSERT INTO protector_access SET ip='1.164.107.130',request_uri='/xoops/modules/vegpad/',expire=UNIX_TIMESTAMP()+'60'
0.000179 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
0.000835 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (1,2)
0.001390 - SELECT b.* FROM newblocks b, block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,26) AND b.bid IN (1,2,233,3,229,4,5,6,7,8,9,77,10,11,12,228,13,226,72,71,227,232,220,221,230,223,224,225,222,76,75,74,73,234,78,93,231,62,64,68,59,66,65,69,58,63,61,67,70,60,80) ORDER BY b.weight, m.block_id
0.000104 - SELECT COUNT(*) FROM vegpad
0.000165 - SELECT * FROM vegpad WHERE 1 = '1' ORDER BY id DESC LIMIT 0, 15
0.000207 - SELECT * FROM smiles
0.000126 - SELECT * FROM modules WHERE dirname = 'tad_themes'
0.000101 - SELECT * FROM modules WHERE dirname = 'tadtools'
0.000106 - SELECT * FROM config WHERE (conf_modid = '6') ORDER BY conf_order ASC
0.000107 - SELECT * FROM config WHERE (conf_modid = '16') ORDER BY conf_order ASC
0.000132 - select * from tad_themes where `theme_name`='school2014'
0.000092 - select conf_value from config where conf_title ='_MD_AM_DEBUGMODE'
0.000116 - select * from tad_themes_blocks where `theme_id`='4'
0.000122 - select `name`, `type`, `value` from tad_themes_config2 where `theme_id`='4'
0.000115 - select menuid,itemname,itemurl,target,icon from tad_themes_menu where of_level='0' and status='1' order by position
0.000130 - select a.*,b.slide_width,b.slide_height from tad_themes_files_center as a left join tad_themes as b on a.col_sn=b.theme_id where a.`col_name`='slide' and b.`theme_name`='school2014'
0.000138 - select name,dirname from modules where isactive='1' and hasmain='1' and weight!=0 order by weight
0.000120 - select `menuid`,`itemname`,`itemurl` from tad_themes_menu
0.000131 - select a.*,b.slide_width,b.slide_height from tad_themes_files_center as a left join tad_themes as b on a.col_sn=b.theme_id where a.`col_name`='slide' and b.`theme_name`='school2014'
1.這些不是錯誤訊息，而是資料庫的處理流程（簡單講，對除錯沒幫助）
2.從描述看來，無關移除模組，而是群組權限沒設好而已。
2.從描述看來，無關移除模組，而是群組權限沒設好而已。
