XOOPS Version: 2.0.16
Module Name/Version: News 1.53
PHP Version: 5.2.2
MySQL Version: 5
Web Server Software (Apache/IIS/Other): Apache 2.2.4
Operating System: Windows Server 2003 SP2
Theme you are using: Default
Custom template: No
PHP Debug Messages:
All errors (0) queries (35) blocks (6) 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 FROM xoops_session WHERE sess_id = 'rgqf0hq8l9l82pu24i97srm333'
SELECT * FROM xoops_users WHERE uid=2
SELECT * FROM xoops_modules WHERE dirname = 'news'
SELECT * FROM xoops_config WHERE (conf_modid = '2') ORDER BY conf_order ASC
SELECT COUNT(*) FROM xoops_banner
SELECT * FROM xoops_banner LIMIT 0, 1
UPDATE xoops_banner SET impmade = impmade+1 WHERE bid = 4
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,5,15,19)
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 (34,33,32,31,30,28,27,26,25,24,23,22,20,19,18,17,15,14,13,12,10,9,8,6,4,11,29,16,38,21,2,1,5,3,43,42,41,40,39,37,36,35,7) ORDER BY b.weight,b.bid
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 = '5' OR gperm_groupid = '15' OR gperm_groupid = '19'))
SELECT * FROM xoops_groups
SELECT COUNT(*) FROM xoops_priv_msgs WHERE (read_msg = '0' AND to_userid = '2')
SELECT * FROM xoops_tplfile WHERE (tpl_module = 'news') ORDER BY tpl_refid
SELECT * FROM xoops_newblocks WHERE mid=2
UPDATE xoops_users SET uname = 'Brian.Geng', name = 'Brian Geng', email = 'briang@blessings.com', url = '', user_avatar = 'blank.gif', user_icq = '', user_from = 'Blessings Central', user_sig = '', user_viewemail = 1, user_aim = '', user_yim = '', user_msnm = '', posts = 8, pass = '8d1235c33db3bafaeb36666c5afbc7be', attachsig = 0, rank = 10, level= 1, theme = '', timezone_offset = -8.00, umode = 'nest', last_login = 1186677621, uorder = 0, notify_method = 2, notify_mode = 0, user_occ = '', bio = '', user_intrest = '', user_mailok = 0 WHERE uid = 2
SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '4') ORDER BY conf_order ASC
INSERT INTO xoops_stories (storyid, uid, title, created, published, expired, hostname, nohtml, nosmiley, hometext, bodytext, counter, topicid, ihome, notifypub, story_type, topicdisplay, topicalign, comments, rating, votes, description, keywords) VALUES (0, 2, 'News Testing Still', 1186677712, 1186677712, 0, '192.168.12.1', 0, 0, 'disregard', 'disregard', 0, 26, 0, 0, 'admin', 0, 'R', 0, 0, 0, '', '')
SELECT * FROM xoops_modules WHERE mid = 2
SELECT * FROM xoops_xoopsnotifications WHERE (not_modid = '2' AND not_category = 'global' AND not_itemid = '0' AND not_event = 'new_story' AND (not_mode = '0' OR not_mode = '1' OR not_mode = '2')) ORDER BY not_id ASC
SELECT * FROM xoops_users WHERE uid=41
SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '6') ORDER BY conf_order ASC
SELECT * FROM xoops_users WHERE uid=47
SELECT * FROM xoops_users WHERE uid=27
SELECT * FROM xoops_users WHERE uid=21
SELECT * FROM xoops_users WHERE uid=13
SELECT * FROM xoops_users WHERE uid=28
SELECT * FROM xoops_users WHERE uid=17
SELECT * FROM xoops_users WHERE uid=59
SELECT * FROM xoops_users WHERE uid=31
SELECT * FROM xoops_users WHERE uid=4
SELECT * FROM xoops_users WHERE uid=19
SELECT * FROM xoops_users WHERE uid=42
Total: 35 queries
Blocks
Custom Block (PHP): No Cache
Search: No Cache
Main Menu: No Cache
User Menu: No Cache
Login: No Cache
Notification Options: No Cache
Total: 6 blocks
Extra
Timers
XOOPS took 31.149 seconds to load.
XOOPS Boot took 0.058 seconds to load.
Module init took 0.033 seconds to load.
XOOPS output init took 0.128 seconds to load.
Module display took 30.931 seconds to load.
A full description of the issue:
News submission worked fine during testing but now with the roll out to a larger number of users (currently 235) news submission is resulting in a blank screen. I have a number of users who are able to submit news and they're all experiencing the same behaviour - the news story is successfully posted but the page does not refresh as it should.
The main difference I see is that we now have more users signed up for News notification. I'm suspicious of this because some users are receiving news notifications but some are not. When I manually execute the query in MySQL listed above which gets the list of users to be notified:
SELECT * FROM xoops_xoopsnotifications WHERE (not_modid = '2' AND not_category = 'global' AND not_itemid = '0' AND not_event = 'new_story' AND (not_mode = '0' OR not_mode = '1' OR not_mode = '2')) ORDER BY not_id ASC
I get 20 rows returned but as I look down the list of the follow up queries in the debug code I find only 12 user id's are being queried. I'm suspicious that something is going wrong with the notification functionality but I'm not sure how to debug this further. Any help would be greatly appreciated.
