Hey guys,

I'm really hoping someone can help me here. We just switched from IIS to Apache on our Windows 2003 Server. Everything is working fine except that we're getting "Page Cannot Be Displayed" errors on Internet Explorer when we try to view our album.

Here is some more useful info:

1) This doesn't happen ALL the time. You can hit refresh, and every once in a while, the page will display fine.

2) I suspected that there was some sort of timeout or something.....so by checking my apache error logs, I noticed this line: C:\\Websites\\MyJokeMail\\content\\class\\database\\mysqldatabase.php on line 236

Since that file is the main MySql engine for running Xoops, I looked inside to see where it was timing out. Of course, it was timing out on the sql query:

$result =& mysql_query($sql, $this->conn);

3) So I decided to check what was in the $sql variable by echoing the value to the screen. So when clicking on a link to your album module (http://www.myjokemail.com/content/modules/myalbum/viewcat.php?cid=1&orderby=dateD), this is what gets echoed to the screen:

SELECT * FROM xoops_config WHERE (conf_modid = 0 AND conf_catid = 1) ORDER BY conf_order ASCSELECT sess_data FROM xoops_session WHERE sess_id = 'aeb4e137e10909b037947512c02b752f'SELECT * FROM xoops_users WHERE uid=1SELECT * FROM xoops_modules WHERE dirname = 'ipboard'SELECT * FROM xoops_config WHERE (conf_modid = 0 AND conf_catid = 3) ORDER BY conf_order ASCSELECT COUNT(*) FROM xoops_bannerSELECT * FROM xoops_banner LIMIT 7, 1UPDATE xoops_banner SET impmade = impmade+1 WHERE bid = 11SELECT DISTINCT gperm_itemid FROM xoops_group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (1,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,-1) AND b.bid IN (101,12,5,2,39,38,33,6,32,19,18,17,15,14,13,48,31,58,30,69,28,29,27,89,26,25,24,71,20,70,11,67,10,88,9,1,8,4,45,75,66,64,63,3,86,52,7,90,68,16,73,55,53,87,85,84,91,83,47,82,81,65,57,54,56,104,105,106) ORDER BY b.weight,b.bidSELECT COUNT(*) FROM xoops_ipb_messages WHERE recipient_id = '1' AND vid='in' AND read_state='0' SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'MyJokeMail2' AND tpl_file = 'xfs_block_new.html') ORDER BY tpl_refidSELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'MyJokeMail2' AND tpl_file = 'xfs_block_new.html') ORDER BY tpl_refidSELECT mid FROM xoops_modules WHERE dirname='myalbum'SELECT conf_name,conf_value FROM xoops_config WHERE conf_modid=22SELECT cid FROM xoops_myalbum_cat WHERE pid=1SELECT count(lid) FROM xoops_myalbum_photos WHERE status>0 AND cid IN (1) AND 1SELECT lid FROM xoops_myalbum_photos WHERE status>0 AND cid IN (1) AND 1SELECT lid , cid , title , ext , res_x , res_y , submitter , status , date AS unixtime , hits , rating , votes , comments FROM xoops_myalbum_photos WHERE status>0 AND lid IN (377,574,602,1086,1089)SELECT lid, cid, title, date, hits FROM xoops_mydownloads_downloads WHERE status>0 ORDER BY hits DESC LIMIT 0, 10SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'MyJokeMail2' AND tpl_file = 'xfs_block_new.html') ORDER BY tpl_refidSELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'MyJokeMail2' AND tpl_file = 'xfs_block_new.html') ORDER BY tpl_refidSELECT lid, cid, title, date, hits FROM xoops_mydownloads_downloads WHERE status>0 ORDER BY date DESC LIMIT 0, 10SELECT lid, cid, title, date, hits FROM xoops_mylinks_links WHERE status>0 ORDER BY hits DESC LIMIT 0, 10SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'MyJokeMail2' AND tpl_file = 'xfs_block_new.html') ORDER BY tpl_refidDELETE FROM xoops_online WHERE online_updated < 1103322950SELECT COUNT(*) FROM xoops_online WHERE online_uid=1UPDATE xoops_online SET online_updated=1103323250, online_module = 0 WHERE online_uid = 1SELECT * FROM xoops_onlineSELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=3087SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=1SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0SELECT member_id as uid FROM xoops_session WHERE login_type='1' AND member_id>0 AND member_id=0


How come there is so much data in the query? Is there anyway to speed this up? I am running version 2.8.3 of the album module.

I hope to hear back from you soon.

- Jeff Mash
http://MyJokeMail.com