:::
Tad書籍區
NEWBB驗證碼
Tad好!
1.這幾天將舊主機EnterPrise 4 AS 轉移到新伺服器(DXLL牌)，因為硬體網路晶片不支援的關係，只能安裝FedoraCore8來應急(別問我為何會這樣，我也很想問總公司採購人員？)。轉移成功後許多模組都不能使用，但是討論區Newbb1.0是OK的，以下是新伺服器版本資訊：
XOOPS:2.0.17.1(在新主機上從版本2.0.13.2BIG5升級上來的)
APACHE:2.2.6 (Fedora8內建)
MYSQL:5.0.45(Fedora8內建)
OS:Redhat Linux Fedora 8
2.接下來在台灣PHP聯盟網站下載[newbb 3.0.8]CBB討論區，並照上面的指示升級原本Newbb1.0。
3.結果出現以下畫面的情形?!
討論區管理頁面
前台頁面
4.請問文章數目都有但是卻無法顯示，可能是哪裡的錯誤呢？
請老師幫忙！由於是內網，無法讓您直接連入請見諒！
5.同文亦發表於中文正體延伸計畫尋找答案中。
1.這幾天將舊主機EnterPrise 4 AS 轉移到新伺服器(DXLL牌)，因為硬體網路晶片不支援的關係，只能安裝FedoraCore8來應急(別問我為何會這樣，我也很想問總公司採購人員？)。轉移成功後許多模組都不能使用，但是討論區Newbb1.0是OK的，以下是新伺服器版本資訊：
XOOPS:2.0.17.1(在新主機上從版本2.0.13.2BIG5升級上來的)
APACHE:2.2.6 (Fedora8內建)
MYSQL:5.0.45(Fedora8內建)
OS:Redhat Linux Fedora 8
2.接下來在台灣PHP聯盟網站下載[newbb 3.0.8]CBB討論區，並照上面的指示升級原本Newbb1.0。
3.結果出現以下畫面的情形?!
討論區管理頁面
前台頁面
4.請問文章數目都有但是卻無法顯示，可能是哪裡的錯誤呢？
請老師幫忙！由於是內網，無法讓您直接連入請見諒！
5.同文亦發表於中文正體延伸計畫尋找答案中。
Tad老師：
1.我已經重新安裝CBB3.08，之前的文章因為不多，我再手動還原嚕～現在已經可以新增討論區以及子討論區，但是一按下發表新主題，卻直接無法顯示網頁(HTTP 500 - 內部伺服器錯誤 Internet Explorer )？我開啟偵錯模式之後，出現已錯誤訊息：
All errors (0) queries (29) blocks (11) extra (0) timers (5)
Errors
Queries
SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data, sess_ip FROM xoops_session WHERE sess_id = 'ucn614sf0gc2n5sunue42j8bd1'
SELECT * FROM xoops_users WHERE uid=1
SELECT * FROM xoops_modules WHERE dirname = 'newbb'
SELECT * FROM xoops_config WHERE (conf_modid = '39') ORDER BY conf_order ASC
SELECT * FROM xoops_bb_forums WHERE forum_id = '2'
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 = '39'
SELECT COUNT(*) FROM xoops_online WHERE online_uid=1
UPDATE xoops_online SET online_updated=1198640724, online_module = 39 WHERE online_uid = 1
SELECT COUNT(*) FROM xoops_bb_online WHERE online_uid=1
UPDATE xoops_bb_online SET online_updated= '1198640724', online_forum = '2', online_topic = '0' WHERE online_uid = 1
DELETE FROM xoops_bb_online WHERE ( online_uid > 0 AND online_uid NOT IN ( SELECT online_uid FROM xoops_online WHERE online_module =39 ) ) OR ( online_uid = 0 AND online_ip NOT IN ( SELECT online_ip FROM xoops_online WHERE online_module =39 AND online_uid = 0 ) )
SELECT COUNT(*) FROM xoops_banner
SELECT * FROM xoops_banner LIMIT 0, 1
UPDATE xoops_banner SET impmade = impmade+1 WHERE bid = 3
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)
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,39) AND b.bid IN (1,31,10,29,36,30,27,108,6,12,9,4,3,8,13,11,5,77,78,76,68,110,7,2,37,49,54,58,59,60,79,71,67,109,111) ORDER BY b.weight,b.bid
SELECT COUNT(*) FROM xoops_priv_msgs WHERE (read_msg = '0' AND to_userid = '1')
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'))
SELECT COUNT(*) FROM xoops_online WHERE online_uid=1
UPDATE xoops_online SET online_updated=1198640724, online_module = 39 WHERE online_uid = 1
SELECT * FROM xoops_online
SELECT COUNT(*) FROM xoops_online WHERE online_module = '39'
SELECT * FROM xoops_smiles
SELECT * FROM xoops_users WHERE (level > '0') ORDER BY posts DESC LIMIT 0, 10
SELECT * FROM xoops_users WHERE (level > '0') ORDER BY user_regdate DESC LIMIT 0, 10
SELECT u.uid, u.uname, u.email, u.user_viewemail, u.user_avatar, g.name AS groupname FROM xoops_groups_users_link l LEFT JOIN xoops_users u ON l.uid=u.uid LEFT JOIN xoops_groups g ON l.groupid=g.groupid WHERE g.group_type='Admin' ORDER BY l.groupid, u.uid
Total: 29 queries
Blocks
?ϥΪ̿ﳦ: No Cache
?D?ﳦ: No Cache
?n?J: No Cache
?֦b?u?W: No Cache
?ۭq?϶?TML): No Cache
?j?M: No Cache
?ۭq?϶?۰ʮ榡 + ???): No Cache
?i?K?̱Ʀ溼/b> No Cache
?s?|??> No Cache
???????溼/b> No Cache
???x?갔: No Cache
Total: 11 blocks
Extra
Timers
XOOPS took 0.147 seconds to load.
XOOPS Boot took 0.047 seconds to load.
Module init took 0.021 seconds to load.
XOOPS output init took 0.063 seconds to load.
Module display took 0.016 seconds to load.
2.我的XOOPS是BIG5語系，我也有找到中文包，這些訊息我就看不懂了～＠＠
3.Frameworks 有解壓縮在xoops預設根目錄中
4.editor抓了一個editors.zip(內有fckeditor、htmlarea、spaw、wysiwyg目錄)，也都放在xoops根目錄/class/裡面了
5.請問Tad，哪裡我尚未注意到呢？
1.我已經重新安裝CBB3.08，之前的文章因為不多，我再手動還原嚕～現在已經可以新增討論區以及子討論區，但是一按下發表新主題，卻直接無法顯示網頁(HTTP 500 - 內部伺服器錯誤 Internet Explorer )？我開啟偵錯模式之後，出現已錯誤訊息：
All errors (0) queries (29) blocks (11) extra (0) timers (5)
Errors
Queries
SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data, sess_ip FROM xoops_session WHERE sess_id = 'ucn614sf0gc2n5sunue42j8bd1'
SELECT * FROM xoops_users WHERE uid=1
SELECT * FROM xoops_modules WHERE dirname = 'newbb'
SELECT * FROM xoops_config WHERE (conf_modid = '39') ORDER BY conf_order ASC
SELECT * FROM xoops_bb_forums WHERE forum_id = '2'
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 = '39'
SELECT COUNT(*) FROM xoops_online WHERE online_uid=1
UPDATE xoops_online SET online_updated=1198640724, online_module = 39 WHERE online_uid = 1
SELECT COUNT(*) FROM xoops_bb_online WHERE online_uid=1
UPDATE xoops_bb_online SET online_updated= '1198640724', online_forum = '2', online_topic = '0' WHERE online_uid = 1
DELETE FROM xoops_bb_online WHERE ( online_uid > 0 AND online_uid NOT IN ( SELECT online_uid FROM xoops_online WHERE online_module =39 ) ) OR ( online_uid = 0 AND online_ip NOT IN ( SELECT online_ip FROM xoops_online WHERE online_module =39 AND online_uid = 0 ) )
SELECT COUNT(*) FROM xoops_banner
SELECT * FROM xoops_banner LIMIT 0, 1
UPDATE xoops_banner SET impmade = impmade+1 WHERE bid = 3
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)
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,39) AND b.bid IN (1,31,10,29,36,30,27,108,6,12,9,4,3,8,13,11,5,77,78,76,68,110,7,2,37,49,54,58,59,60,79,71,67,109,111) ORDER BY b.weight,b.bid
SELECT COUNT(*) FROM xoops_priv_msgs WHERE (read_msg = '0' AND to_userid = '1')
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'))
SELECT COUNT(*) FROM xoops_online WHERE online_uid=1
UPDATE xoops_online SET online_updated=1198640724, online_module = 39 WHERE online_uid = 1
SELECT * FROM xoops_online
SELECT COUNT(*) FROM xoops_online WHERE online_module = '39'
SELECT * FROM xoops_smiles
SELECT * FROM xoops_users WHERE (level > '0') ORDER BY posts DESC LIMIT 0, 10
SELECT * FROM xoops_users WHERE (level > '0') ORDER BY user_regdate DESC LIMIT 0, 10
SELECT u.uid, u.uname, u.email, u.user_viewemail, u.user_avatar, g.name AS groupname FROM xoops_groups_users_link l LEFT JOIN xoops_users u ON l.uid=u.uid LEFT JOIN xoops_groups g ON l.groupid=g.groupid WHERE g.group_type='Admin' ORDER BY l.groupid, u.uid
Total: 29 queries
Blocks
?ϥΪ̿ﳦ: No Cache
?D?ﳦ: No Cache
?n?J: No Cache
?֦b?u?W: No Cache
?ۭq?϶?TML): No Cache
?j?M: No Cache
?ۭq?϶?۰ʮ榡 + ???): No Cache
?i?K?̱Ʀ溼/b> No Cache
?s?|??> No Cache
???????溼/b> No Cache
???x?갔: No Cache
Total: 11 blocks
Extra
Timers
XOOPS took 0.147 seconds to load.
XOOPS Boot took 0.047 seconds to load.
Module init took 0.021 seconds to load.
XOOPS output init took 0.063 seconds to load.
Module display took 0.016 seconds to load.
2.我的XOOPS是BIG5語系，我也有找到中文包，這些訊息我就看不懂了～＠＠
3.Frameworks 有解壓縮在xoops預設根目錄中
4.editor抓了一個editors.zip(內有fckeditor、htmlarea、spaw、wysiwyg目錄)，也都放在xoops根目錄/class/裡面了
5.請問Tad，哪裡我尚未注意到呢？
Tad老師：
我嘗試更新模組後，錯誤網頁還是一樣的。
[img width=300]http://benny25.myweb.hinet.net/images/newbberror.JPG[/img]
我的xoopseditor/放在/class/xoopseditor
我的Frameworks/放在網站的根目錄中
檢查/var/log/httpd/error_log
[Thu Dec 27 17:24:15 2007] [error] [client 10.102.81.50] PHP Warning: include(XOOPS_ROOT_PATH/modules/xmonitor/header.php) [function.include]: failed to open stream: No such file or directory in /var/www/html/html/mainfile.php on line 27, referer: http://10.102.81.8/modules/newbb/viewforum.php?forum=2
[Thu Dec 27 17:24:15 2007] [error] [client 10.102.81.50] PHP Warning: include() [function.include]: Failed opening 'XOOPS_ROOT_PATH/modules/xmonitor/header.php' for inclusion (include_path='.:/usr/share/pear:/usr/share/php') in /var/www/html/html/mainfile.php on line 27, referer: http://10.102.81.8/modules/newbb/viewforum.php?forum=2
除此之外，我的其他模組都正常。
請問還有哪邊我可以著手檢查的?
謝謝您喔～
