MySQLのデバックモードにすると下記メッセージが出ていま
す。
Queries
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
= '2ba4**c008ae***'
SELECT * FROM xoops_users WHERE uid=1
SELECT * FROM xoops_modules WHERE dirname = 'newbb'
SELECT * FROM xoops_config WHERE (conf_modid = 23)
ORDER BY conf_order ASC
SELECT * FROM xoops_config WHERE (conf_modid = 0 AND
conf_catid = 3) ORDER BY conf_order ASC
SELECT COUNT(*) FROM xoops_banner
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,23)
AND b.bid IN
(27,41,40,129,30,3,4,31,53,11,51,71,50,34,32,7,6,26,12,
37,130,36,35,15,33,25,49,48,69,68,42,16,14,13,10,72,28,
9,8,5,86,2,1,113,70,107,106,105,54,55,118,52,122,120,12
1,124,123,119,115,73,114,74,29,75,95,76,90,89,88,87,96,
97,131) 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 OR gperm_groupid = 2))
SELECT gperm_itemid FROM xoops_group_permission WHERE
gperm_modid='' AND gperm_name='myalbum_global' AND
(gperm_groupid IN (1,2))
SELECT id_form, desc_form FROM xoops_formmail_id WHERE
form_req='on' ORDER BY form_order
SELECT * FROM xoops_users WHERE (level > 0) ORDER BY
user_regdate DESC LIMIT 0, 10
SELECT COUNT(*) FROM xoops_modules WHERE dirname
= 'news'
SELECT COUNT(*) FROM xoops_stories WHERE published=0
SELECT COUNT(*) FROM xoops_modules WHERE dirname
= 'mylinks'
SELECT COUNT(*) FROM xoops_mylinks_links WHERE
status=0
SELECT COUNT(*) FROM xoops_mylinks_broken
SELECT COUNT(*) FROM xoops_mylinks_mod
SELECT COUNT(*) FROM xoops_modules WHERE dirname
= 'mydownloads'
SELECT COUNT(*) FROM xoops_mydownloads_downloads WHERE
status=0
SELECT COUNT(*) FROM xoops_mydownloads_broken
SELECT COUNT(*) FROM xoops_mydownloads_mod
SELECT COUNT(*) FROM xoops_xoopscomments WHERE
com_status=1
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
SELECT COUNT(*) FROM xoops_online WHERE online_uid=1
UPDATE xoops_online SET online_updated=1118427602,
online_module = 23 WHERE online_uid = 1
SELECT * FROM xoops_online
SELECT COUNT(*) FROM xoops_online WHERE online_module
= 23
SELECT cfgname, cfgvalue FROM xoops_logcounterx_cfg;
DELETE FROM xoops_logcounterx_ip WHERE acctime <
1118427002;
SELECT accip FROM xoops_logcounterx_ip WHERE accip
= '2**.***.**.***';
SELECT recid, uname FROM xoops_logcounterx_log WHERE
remote_host = '2**.***.**.***' ORDER BY accday DESC,
acctime DESC LIMIT 1;
UPDATE xoops_logcounterx_ip SET acctime = 1118427602
WHERE accip = '2**.***.**.***';
SELECT c.* FROM xoops_bb_categories c, xoops_bb_forums
f WHERE f.cat_id=c.cat_id GROUP BY c.cat_id,
c.cat_title, c.cat_order ORDER BY c.cat_order
SELECT COUNT(*) AS total FROM xoops_bb_topics
SELECT COUNT(*) AS total FROM xoops_bb_posts
SELECT f.*, u.uname, u.uid, p.topic_id, p.post_time,
p.subject, p.icon FROM xoops_bb_forums f LEFT JOIN
xoops_bb_posts p ON p.post_id = f.forum_last_post_id
LEFT JOIN xoops_users u ON u.uid = p.uid ORDER BY
f.cat_id, f.forum_id
SELECT * FROM xoops_smiles
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 1 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 2 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 3 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 4 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 5 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 6 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 7 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 8 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 9 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 10 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 11 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 12 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 13 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 14 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 17 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 18 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 21 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 22 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 15 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 16 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 23 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 19 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 20 and
f.user_id = u.uid
SELECT * FROM xoops_xoopsnotifications WHERE
(not_modid = 23 AND not_category = 'global' AND
not_uid = 1) ORDER BY not_id ASC
SELECT * FROM xoops_modules WHERE mid = 23
Total: 66 queries
【サーバ環境】
Apache : 1-3-27
PHP : 4-2-3
MySQL : 3-23-58
した。2.0.9.2からのアップデートです。
フォーラム投稿記事が管理者環境で実施できません。
[XOOPS環境]
XOOPS 2.0.9.2/2.0.9.3→2.0.10 JPのダウンロードファイル
を利用して2.0.9.2から2.0.10 JPにアップデートしました。
[現象]
管理者環境でフォーラムの投稿を削除できない。
[再現手順]
1.管理者権限のユーザーでログインします。
2.削除したい投稿を開きます。
3.[削除]ボタンをクリックします。
[結果]
下記エラーが表示されます。
「エラー: フォーラムが選択されていません
ページが自動的に更新されない場合はここをクリックしてく
ださい」
[対応]
MySQLのデバックモードにすると下記メッセージが出ていま
す。
Queries
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
= '2ba4**c008ae***'
SELECT * FROM xoops_users WHERE uid=1
SELECT * FROM xoops_modules WHERE dirname = 'newbb'
SELECT * FROM xoops_config WHERE (conf_modid = 23)
ORDER BY conf_order ASC
SELECT * FROM xoops_config WHERE (conf_modid = 0 AND
conf_catid = 3) ORDER BY conf_order ASC
SELECT COUNT(*) FROM xoops_banner
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,23)
AND b.bid IN
(27,41,40,129,30,3,4,31,53,11,51,71,50,34,32,7,6,26,12,
37,130,36,35,15,33,25,49,48,69,68,42,16,14,13,10,72,28,
9,8,5,86,2,1,113,70,107,106,105,54,55,118,52,122,120,12
1,124,123,119,115,73,114,74,29,75,95,76,90,89,88,87,96,
97,131) 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 OR gperm_groupid = 2))
SELECT gperm_itemid FROM xoops_group_permission WHERE
gperm_modid='' AND gperm_name='myalbum_global' AND
(gperm_groupid IN (1,2))
SELECT id_form, desc_form FROM xoops_formmail_id WHERE
form_req='on' ORDER BY form_order
SELECT * FROM xoops_users WHERE (level > 0) ORDER BY
user_regdate DESC LIMIT 0, 10
SELECT COUNT(*) FROM xoops_modules WHERE dirname
= 'news'
SELECT COUNT(*) FROM xoops_stories WHERE published=0
SELECT COUNT(*) FROM xoops_modules WHERE dirname
= 'mylinks'
SELECT COUNT(*) FROM xoops_mylinks_links WHERE
status=0
SELECT COUNT(*) FROM xoops_mylinks_broken
SELECT COUNT(*) FROM xoops_mylinks_mod
SELECT COUNT(*) FROM xoops_modules WHERE dirname
= 'mydownloads'
SELECT COUNT(*) FROM xoops_mydownloads_downloads WHERE
status=0
SELECT COUNT(*) FROM xoops_mydownloads_broken
SELECT COUNT(*) FROM xoops_mydownloads_mod
SELECT COUNT(*) FROM xoops_xoopscomments WHERE
com_status=1
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
SELECT COUNT(*) FROM xoops_online WHERE online_uid=1
UPDATE xoops_online SET online_updated=1118427602,
online_module = 23 WHERE online_uid = 1
SELECT * FROM xoops_online
SELECT COUNT(*) FROM xoops_online WHERE online_module
= 23
SELECT cfgname, cfgvalue FROM xoops_logcounterx_cfg;
DELETE FROM xoops_logcounterx_ip WHERE acctime <
1118427002;
SELECT accip FROM xoops_logcounterx_ip WHERE accip
= '2**.***.**.***';
SELECT recid, uname FROM xoops_logcounterx_log WHERE
remote_host = '2**.***.**.***' ORDER BY accday DESC,
acctime DESC LIMIT 1;
UPDATE xoops_logcounterx_ip SET acctime = 1118427602
WHERE accip = '2**.***.**.***';
SELECT c.* FROM xoops_bb_categories c, xoops_bb_forums
f WHERE f.cat_id=c.cat_id GROUP BY c.cat_id,
c.cat_title, c.cat_order ORDER BY c.cat_order
SELECT COUNT(*) AS total FROM xoops_bb_topics
SELECT COUNT(*) AS total FROM xoops_bb_posts
SELECT f.*, u.uname, u.uid, p.topic_id, p.post_time,
p.subject, p.icon FROM xoops_bb_forums f LEFT JOIN
xoops_bb_posts p ON p.post_id = f.forum_last_post_id
LEFT JOIN xoops_users u ON u.uid = p.uid ORDER BY
f.cat_id, f.forum_id
SELECT * FROM xoops_smiles
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 1 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 2 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 3 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 4 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 5 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 6 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 7 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 8 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 9 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 10 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 11 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 12 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 13 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 14 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 17 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 18 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 21 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 22 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 15 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 16 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 23 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 19 and
f.user_id = u.uid
SELECT u.uid, u.uname FROM xoops_users u,
xoops_bb_forum_mods f WHERE f.forum_id = 20 and
f.user_id = u.uid
SELECT * FROM xoops_xoopsnotifications WHERE
(not_modid = 23 AND not_category = 'global' AND
not_uid = 1) ORDER BY not_id ASC
SELECT * FROM xoops_modules WHERE mid = 23
Total: 66 queries
【サーバ環境】
Apache : 1-3-27
PHP : 4-2-3
MySQL : 3-23-58