Recently I've been getting the following error when trying to load my site -
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/h/i/f/hifalls/path/to/databases/mysql.php on line 26
it doesn't happen every time, but most times. I get that same error repeated about 13 times some show line 26 and some show line 29 and then the rest of the wrapper template loads minus the main index template. When I refresh the page everything is fine though.
Could it be that I have too many categories on my main page? I have about 175 categories, but no sub-categories.
following is the out put from index.php?dorand=1&debug=1
Load time so far: 0.05 seconds.
Query 1: SELECT `name`,`content` FROM mikeslist_settings WHERE id>0 ORDER BY id ASC
Load time so far: 0.13 seconds.
Query 2: SELECT `name`,`value` FROM mikeslist_switches WHERE id>0
Number of rows is 91
Load time so far: 0.14 seconds.
Query 3: SELECT `id`,`type`,`original`,`replacement`,`description`,`originalclose`,`replacementclose`,`sortorder` FROM mikeslist_markup WHERE type='wsncode' ORDER BY sortorder
Number of rows is 23
Load time so far: 0.15 seconds.
Query 4: SELECT `id`,`title`,`caneditown`,`caneditall`,`canvote`,`isadmin`,`canpost`,`canemail`,`validatecats`,`validatecomments`,`validatelinks`,`validateedits`,`cansubmitlinks`,`cansubmitcategories`,`cansubmitcomments`,`caneditownlinks`,`caneditowncategories`,`caneditowncomments`,`caneditownprofile`,`caneditalllinks`,`caneditallcategories`,`caneditallcomments`,`caneditallprofiles`,`candownloadfiles`,`canupload`,`canviewip`,`limitlinks`,`canemailmembers`,`canusehtml`,`limitlinksdaily`,`canalias`,`cancopy`,`candeleteown`,`candeleteall`,`candofulledit`,`candeletecategories`,`candeletecomments`,`candeleteowncategories`,`candeleteowncomments`,`candeletemembers`,`candeleteownmembers`,`canaliascategories`,`canviewpages`,`caneditvotes`,`numaliases`,`canviewvotes`,`canhideownlinks`,`canhideowncategories`,`canhideowncomments`,`canhidealllinks`,`canhideallcategories`,`canhideallcomments`,`canratecomments`,`bytespermem`,`canpm`,`canim`,`canharddelete`,`limitpms`,`limitpmsdaily`,`canviewdeleted`,`cansubmitpolls`,`candeletepolls`,`candeleteownpolls`,`caneditpolls`,`caneditownpolls`,`attachperpost`,`attachperpm`,`canviewshouts`,`caneditshouts`,`caneditownshouts`,`candeleteshouts`,`candeleteownshouts`,`cansubmitshouts`,`canpollvote`,`customtitle`,`canviewinvisible`,`namestyle`,`canpmimportant`,`canviewmodlog`,`isleader`,`cansubmitquotes`,`validatequotes`,`candeletequotes`,`candeleteownquotes`,`canreport`,`canusesearch`,`attachperlink`,`validateattachments`,`caneditownquotes`,`caneditallquotes`,`canviewchat`,`caneditownevents`,`caneditallevents`,`candeleteownevents`,`candeleteevents`,`cansubmitevents`,`validateevents`,`bulkpms`,`issupermod`,`numinv`,`allowugspec`,`validateemails`,`validatesponsorlinks`,`cansubmittags`,`candeletetags`,`cansubmitfeeds`,`validatefeeds`,`validatefeeditems`,`numaliasestot`,`shoutsperday`,`validatetrader`,`renewdays`,`renewtimes` FROM mikeslist_membergroups WHERE id>0
Load time so far: 0.15 seconds.
Query 5: SELECT `id`,`name`,`links`,`comments`,`time`,`usergroup`,`password`,`ip`,`totalhits`,`totalhitsin`,`email`,`validated`,`template`,`language`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`totalbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,`banned`,`location`,`homepage`,`occupation`,`bio`,`aim`,`icq`,`msn`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`buddies`,`ignored`,`isonline`,`acceptims`,`adminpermissions`,`referrer`,`groupreverttime`,`grouprevertto`,`moderationpm`,`secondarygroups`,`linksperpage`,`commentsperpage`,`shouts`,`customtitle`,`shoutban`,`topicbans`,`forumbans`,`visibility`,`birthdate`,`lastsession`,`interests`,`posteditor`,`forumaccess`,`pmpopup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,`lastmodnote`,`newpms`,`imflag`,`orderalbums`,`lastguestnote`,`autosubscribe`,`notifymethod`,`showavatars`,`showsigs`,`warninglevel`,`topics`,`posts`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`calsub`,`macros`,`guestnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss`,`positivepct` FROM mikeslist_members WHERE id='2' AND validated=1
Load time so far: 0.17 seconds.
Query 6: SELECT `original`,`replacement`,`description`,`id`,`sortorder` FROM mikeslist_markup WHERE type='smilie' ORDER BY sortorder
Query 8: SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM mikeslist_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10
Number of rows is 0
Query 9: UNLOCK TABLES
Setting cookie with name testcookie, value 1 and expiration time 12395220539
Warning: Cannot modify header information - headers already sent by (output started at /home/content/h/i/f/hifalls/html/thelist/classes/database.php:249) in /home/content/h/i/f/hifalls/html/thelist/includes/commonfuncs.php on line 686
Warning: Cannot modify header information - headers already sent by (output started at /home/content/h/i/f/hifalls/html/thelist/classes/database.php:249) in /home/content/h/i/f/hifalls/html/thelist/includes/commonfuncs.php on line 690
Load time so far: 0.36 seconds.
Query 10: SELECT `memberid`,`starttime`,`time` FROM mikeslist_sessions WHERE time < 1197609370 AND memberid > 0
Number of rows is 0
Load time so far: 0.37 seconds.
Query 11: DELETE FROM mikeslist_sessions WHERE time < 1197609370
Load time so far: 0.37 seconds.
Query 12: SELECT `id`,`url`,`ownerid`,`lastfetched`,`validated`,`catid`,`time`,`title`,`description`,`homepage` FROM mikeslist_xmlfeeds WHERE validated=1 AND lastfetched < 1197567070 ORDER BY lastfetched ASC LIMIT 0,1
Number of rows is 0
Load time so far: 0.37 seconds.
Query 13: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`validated`,`ownerip`,`catid`,`importurl` FROM mikeslist_attachments WHERE importurl != '' ORDER BY id ASC LIMIT 0,1
Number of rows is 0
Load time so far: 0.37 seconds.
Query 14: SELECT `id`,`name`,`links`,`comments`,`time`,`usergroup`,`password`,`ip`,`totalhits`,`totalhitsin`,`email`,`validated`,`template`,`language`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`totalbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,`banned`,`location`,`homepage`,`occupation`,`bio`,`aim`,`icq`,`msn`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`buddies`,`ignored`,`isonline`,`acceptims`,`adminpermissions`,`referrer`,`groupreverttime`,`grouprevertto`,`moderationpm`,`secondarygroups`,`linksperpage`,`commentsperpage`,`shouts`,`customtitle`,`shoutban`,`topicbans`,`forumbans`,`visibility`,`birthdate`,`lastsession`,`interests`,`posteditor`,`forumaccess`,`pmpopup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,`lastmodnote`,`newpms`,`imflag`,`orderalbums`,`lastguestnote`,`autosubscribe`,`notifymethod`,`showavatars`,`showsigs`,`warninglevel`,`topics`,`posts`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`calsub`,`macros`,`guestnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss`,`positivepct` FROM mikeslist_members WHERE banned='' AND notifykeywords != '' AND keychecktime < 1197523870 ORDER BY id ASC LIMIT 0,1
Number of rows is 0
Load time so far: 0.37 seconds.
Query 15: SELECT `id`,`frequency`,`filename`,`nextrun` FROM mikeslist_crons WHERE nextrun < 1197610270 ORDER BY id ASC LIMIT 0,1
Number of rows is 1
Load time so far: 0.38 seconds.
Query 16: UPDATE mikeslist_crons SET nextrun='1197612924' WHERE id=6
Load time so far: 0.41 seconds.
Query 17: DELETE FROM mikeslist_links WHERE deleted=1 and timedeleted < 333696670
Load time so far: 30.56 seconds.
Query 18: UPDATE mikeslist_settings SET content='1197610301' WHERE name='lastrotation'
Load time so far: 30.56 seconds.
Lost connection to MySQL server during query
Query 19: UPDATE mikeslist_settings SET content='I' WHERE name='currentletter'
Load time so far: 30.56 seconds.
MySQL server has gone away
Query 20: SELECT `id`,`title`,`url`,`description`,`rating`,`votes`,`validated`,`catid`,`sumofvotes`,`email`,`time`,`hits`,`numcomments`,`hide`,`ownerid`,`voterips`,`voterids`,`lastedit`,`type`,`notify`,`suspect`,`pendingedit`,`funds`,`suspended`,`alias`,`expire`,`ip`,`inalbum`,`typeorder`,`recipurl`,`hitsin`,`recipwith`,`hitsinips`,`hitsoutips`,`lastcomment`,`related`,`inhidden`,`viewers`,`threadviewers`,`hitsintemp`,`hitsouttemp`,`origtype`,`importance`,`parentids`,`timesdead`,`timesemailed`,`threadclosed`,`threadposters`,`lastposterid`,`lastpostername`,`ownername`,`deleted`,`deletionreason`,`movedto`,`deletedby`,`timevalidated`,`filefield`,`message`,`sticky`,`downloads`,`pollid`,`posticon`,`savedby`,`validatedemail`,`unpaid`,`recipverified`,`effectivetime`,`sugcatid`,`pagerank`,`wysihtml`,`movedid`,`unrevised`,`feedurl`,`feedcache`,`feedcachetime`,`nocds`,`showlocation`,`grade`,`source`,`tags`,`xmlsource`,`ordercomments`,`lastpadupdate`,`padfile`,`lastmonthlycheck`,`invisibleto`,`profileurl`,`lastprofileurl`,`timesrenewed`,`timedeleted` FROM mikeslist_links WHERE deleted=0 AND hide=0 AND expire > 0 AND expire < 1197610301
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/h/i/f/hifalls/html/thelist/databases/mysql.php on line 26
Number of rows is MySQL server has gone away
Load time so far: 30.56 seconds.
MySQL server has gone away
Query 21: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`validated`,`ownerip`,`catid`,`importurl` FROM mikeslist_attachments WHERE objectid=0 AND time>1197580301
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/h/i/f/hifalls/html/thelist/databases/mysql.php on line 26
Number of rows is MySQL server has gone away
Load time so far: 30.56 seconds.
MySQL server has gone away
Query 22: SELECT `id`,`name`,`links`,`comments`,`time`,`usergroup`,`password`,`ip`,`totalhits`,`totalhitsin`,`email`,`validated`,`template`,`language`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`totalbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,`banned`,`location`,`homepage`,`occupation`,`bio`,`aim`,`icq`,`msn`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`buddies`,`ignored`,`isonline`,`acceptims`,`adminpermissions`,`referrer`,`groupreverttime`,`grouprevertto`,`moderationpm`,`secondarygroups`,`linksperpage`,`commentsperpage`,`shouts`,`customtitle`,`shoutban`,`topicbans`,`forumbans`,`visibility`,`birthdate`,`lastsession`,`interests`,`posteditor`,`forumaccess`,`pmpopup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,`lastmodnote`,`newpms`,`imflag`,`orderalbums`,`lastguestnote`,`autosubscribe`,`notifymethod`,`showavatars`,`showsigs`,`warninglevel`,`topics`,`posts`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`calsub`,`macros`,`guestnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss`,`positivepct` FROM mikeslist_members WHERE groupreverttime > 0 AND groupreverttime < 1197610301
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/h/i/f/hifalls/html/thelist/databases/mysql.php on line 26
Number of rows is MySQL server has gone away
Load time so far: 30.73 seconds.
MySQL server has gone away
Query 23: SELECT COUNT(id) FROM mikeslist_categories WHERE parent=0 AND deleted=0 AND hide=0 AND isalbum=0 AND validated=1
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/content/h/i/f/hifalls/html/thelist/databases/mysql.php on line 29 Count is
Load time so far: 30.73 seconds.
MySQL server has gone away
Query 24: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`subscriber`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`dmozpath`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl` FROM mikeslist_categories WHERE parent=0 AND validated=1 AND hide=0 AND isalbum=0 AND deleted=0 ORDER BY priority DESC,name ASC LIMIT 0,200
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/h/i/f/hifalls/html/thelist/databases/mysql.php on line 26
Warning: Cannot modify header information - headers already sent by (output started at /home/content/h/i/f/hifalls/html/thelist/classes/database.php:249) in /home/content/h/i/f/hifalls/html/thelist/includes/commonfuncs.php on line 686
Warning: Cannot modify header information - headers already sent by (output started at /home/content/h/i/f/hifalls/html/thelist/classes/database.php:249) in /home/content/h/i/f/hifalls/html/thelist/includes/commonfuncs.php on line 690
Warning: Cannot modify header information - headers already sent by (output started at /home/content/h/i/f/hifalls/html/thelist/classes/database.php:249) in /home/content/h/i/f/hifalls/html/thelist/end.php on line 66
Load time so far: 30.88 seconds.
MySQL server has gone away
Query 25: SELECT COUNT(id) FROM mikeslist_sessions WHERE memberid>0
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/content/h/i/f/hifalls/html/thelist/databases/mysql.php on line 29 Count is
Load time so far: 30.88 seconds.
MySQL server has gone away
Query 26: SELECT COUNT(id) FROM mikeslist_sessions WHERE memberid=0 AND isrobot=0
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/content/h/i/f/hifalls/html/thelist/databases/mysql.php on line 29 Count is
Load time so far: 30.88 seconds.
MySQL server has gone away
Query 27: SELECT COUNT(id) FROM mikeslist_sessions WHERE memberid=0 AND isrobot=1
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/content/h/i/f/hifalls/html/thelist/databases/mysql.php on line 29 Count is
Load time so far: 30.9 seconds.
MySQL server has gone away
Query 28: SELECT `id`,`title`,`url`,`description`,`rating`,`votes`,`validated`,`catid`,`sumofvotes`,`email`,`time`,`hits`,`numcomments`,`hide`,`ownerid`,`voterips`,`voterids`,`lastedit`,`type`,`notify`,`suspect`,`pendingedit`,`funds`,`suspended`,`alias`,`expire`,`ip`,`inalbum`,`typeorder`,`recipurl`,`hitsin`,`recipwith`,`hitsinips`,`hitsoutips`,`lastcomment`,`related`,`inhidden`,`viewers`,`threadviewers`,`hitsintemp`,`hitsouttemp`,`origtype`,`importance`,`parentids`,`timesdead`,`timesemailed`,`threadclosed`,`threadposters`,`lastposterid`,`lastpostername`,`ownername`,`deleted`,`deletionreason`,`movedto`,`deletedby`,`timevalidated`,`filefield`,`message`,`sticky`,`downloads`,`pollid`,`posticon`,`savedby`,`validatedemail`,`unpaid`,`recipverified`,`effectivetime`,`sugcatid`,`pagerank`,`wysihtml`,`movedid`,`unrevised`,`feedurl`,`feedcache`,`feedcachetime`,`nocds`,`showlocation`,`grade`,`source`,`tags`,`xmlsource`,`ordercomments`,`lastpadupdate`,`padfile`,`lastmonthlycheck`,`invisibleto`,`profileurl`,`lastprofileurl`,`timesrenewed`,`timedeleted` FROM mikeslist_links WHERE validated=1 AND hide=0 AND deleted=0 AND inhidden=0 AND (invisibleto NOT LIKE '%|3|%') AND effectivetime < 1197610270 AND alias=0 AND inalbum=0 ORDER BY id DESC LIMIT 0,5
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/h/i/f/hifalls/html/thelist/databases/mysql.php on line 26
Number of rows is MySQL server has gone away
Load time so far: 30.9 seconds.
MySQL server has gone away
Query 29: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility`,`profileurl` FROM mikeslist_sessions WHERE time > 1197609401 AND (memberid>0) ORDER BY time DESC LIMIT 0,100
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/h/i/f/hifalls/html/thelist/databases/mysql.php on line 26
Number of rows is MySQL server has gone away
Load time so far: 30.9 seconds.
MySQL server has gone away
Query 30: SELECT `content`,`author`,`id`,`source`,`ownerid`,`ownername`,`validated` FROM mikeslist_quotes WHERE validated=1 ORDER BY rand() ASC LIMIT 0,1
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/h/i/f/hifalls/html/thelist/databases/mysql.php on line 26
Number of rows is MySQL server has gone away
Load time so far: 30.9 seconds.
MySQL server has gone away
Query 31: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility`,`profileurl` FROM mikeslist_sessions WHERE time > 1197609401 AND (inchat=1 AND memberid>0) ORDER BY time DESC LIMIT 0,100
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/h/i/f/hifalls/html/thelist/databases/mysql.php on line 26
Number of rows is MySQL server has gone away
Load time so far: 31.1 seconds.
MySQL server has gone away
Query 32: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility`,`profileurl` FROM mikeslist_sessions WHERE memberid=2
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/h/i/f/hifalls/html/thelist/databases/mysql.php on line 26
Number of rows is MySQL server has gone away
Load time so far: 31.1 seconds.
MySQL server has gone away
Query 33: UPDATE mikeslist_members SET isonline='1', lastvisit='1197610301' WHERE id='2'
Query 34: INSERT INTO mikeslist_sessions(`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility`,`profileurl`) VALUES('2','http://www.hifalls.net/thelist/index.php?dorand=1&debug=1','1197610301','24.191.0.57','Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Avant Browser; .NET CLR 1.1.4322; .NET CLR 2.0.50727)','1197610301','0','0','index.php?dorand=1&debug=','','0','0','Admin','','','admincolor','all','everyone','http://www.hifalls.net/thelist/memberlist.php?action=profile&id=2')
Load time so far: 31.1 seconds.
MySQL server has gone away
Query 35: DELETE FROM mikeslist_sessions WHERE memberid=0 AND ip='24.191.0.57'
following is the output of index.php?docrons=1&debug=1
Load time so far: 0.14 seconds.
Query 1: SELECT `name`,`content` FROM mikeslist_settings WHERE id>0 ORDER BY id ASC
Load time so far: 0.33 seconds.
Query 2: SELECT `name`,`value` FROM mikeslist_switches WHERE id>0
Number of rows is 91
Load time so far: 0.4 seconds.
Query 3: SELECT `id`,`type`,`original`,`replacement`,`description`,`originalclose`,`replacementclose`,`sortorder` FROM mikeslist_markup WHERE type='wsncode' ORDER BY sortorder
Number of rows is 23
Load time so far: 0.42 seconds.
Query 4: SELECT `id`,`title`,`caneditown`,`caneditall`,`canvote`,`isadmin`,`canpost`,`canemail`,`validatecats`,`validatecomments`,`validatelinks`,`validateedits`,`cansubmitlinks`,`cansubmitcategories`,`cansubmitcomments`,`caneditownlinks`,`caneditowncategories`,`caneditowncomments`,`caneditownprofile`,`caneditalllinks`,`caneditallcategories`,`caneditallcomments`,`caneditallprofiles`,`candownloadfiles`,`canupload`,`canviewip`,`limitlinks`,`canemailmembers`,`canusehtml`,`limitlinksdaily`,`canalias`,`cancopy`,`candeleteown`,`candeleteall`,`candofulledit`,`candeletecategories`,`candeletecomments`,`candeleteowncategories`,`candeleteowncomments`,`candeletemembers`,`candeleteownmembers`,`canaliascategories`,`canviewpages`,`caneditvotes`,`numaliases`,`canviewvotes`,`canhideownlinks`,`canhideowncategories`,`canhideowncomments`,`canhidealllinks`,`canhideallcategories`,`canhideallcomments`,`canratecomments`,`bytespermem`,`canpm`,`canim`,`canharddelete`,`limitpms`,`limitpmsdaily`,`canviewdeleted`,`cansubmitpolls`,`candeletepolls`,`candeleteownpolls`,`caneditpolls`,`caneditownpolls`,`attachperpost`,`attachperpm`,`canviewshouts`,`caneditshouts`,`caneditownshouts`,`candeleteshouts`,`candeleteownshouts`,`cansubmitshouts`,`canpollvote`,`customtitle`,`canviewinvisible`,`namestyle`,`canpmimportant`,`canviewmodlog`,`isleader`,`cansubmitquotes`,`validatequotes`,`candeletequotes`,`candeleteownquotes`,`canreport`,`canusesearch`,`attachperlink`,`validateattachments`,`caneditownquotes`,`caneditallquotes`,`canviewchat`,`caneditownevents`,`caneditallevents`,`candeleteownevents`,`candeleteevents`,`cansubmitevents`,`validateevents`,`bulkpms`,`issupermod`,`numinv`,`allowugspec`,`validateemails`,`validatesponsorlinks`,`cansubmittags`,`candeletetags`,`cansubmitfeeds`,`validatefeeds`,`validatefeeditems`,`numaliasestot`,`shoutsperday`,`validatetrader`,`renewdays`,`renewtimes` FROM mikeslist_membergroups WHERE id>0
Load time so far: 0.44 seconds.
Query 5: SELECT `id`,`name`,`links`,`comments`,`time`,`usergroup`,`password`,`ip`,`totalhits`,`totalhitsin`,`email`,`validated`,`template`,`language`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`totalbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,`banned`,`location`,`homepage`,`occupation`,`bio`,`aim`,`icq`,`msn`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`buddies`,`ignored`,`isonline`,`acceptims`,`adminpermissions`,`referrer`,`groupreverttime`,`grouprevertto`,`moderationpm`,`secondarygroups`,`linksperpage`,`commentsperpage`,`shouts`,`customtitle`,`shoutban`,`topicbans`,`forumbans`,`visibility`,`birthdate`,`lastsession`,`interests`,`posteditor`,`forumaccess`,`pmpopup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,`lastmodnote`,`newpms`,`imflag`,`orderalbums`,`lastguestnote`,`autosubscribe`,`notifymethod`,`showavatars`,`showsigs`,`warninglevel`,`topics`,`posts`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`calsub`,`macros`,`guestnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss`,`positivepct` FROM mikeslist_members WHERE id='2' AND validated=1
Load time so far: 0.57 seconds.
Query 6: SELECT `original`,`replacement`,`description`,`id`,`sortorder` FROM mikeslist_markup WHERE type='smilie' ORDER BY sortorder
Query 8: SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM mikeslist_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10
Number of rows is 0
Query 9: UNLOCK TABLES
Setting cookie with name testcookie, value 1 and expiration time 12395220879
Warning: Cannot modify header information - headers already sent by (output started at /home/content/h/i/f/hifalls/html/thelist/classes/database.php:249) in /home/content/h/i/f/hifalls/html/thelist/includes/commonfuncs.php on line 686
Warning: Cannot modify header information - headers already sent by (output started at /home/content/h/i/f/hifalls/html/thelist/classes/database.php:249) in /home/content/h/i/f/hifalls/html/thelist/includes/commonfuncs.php on line 690
Load time so far: 3.94 seconds.
Query 10: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`validated`,`ownerip`,`catid`,`importurl` FROM mikeslist_attachments WHERE importurl != '' ORDER BY id ASC LIMIT 0,1
Number of rows is 0
Load time so far: 3.95 seconds.
Query 11: SELECT `id`,`frequency`,`filename`,`nextrun` FROM mikeslist_crons WHERE nextrun < 1197610440 ORDER BY id ASC LIMIT 0,1
Number of rows is 0
Load time so far: 4.01 seconds.
Query 12: SELECT COUNT(id) FROM mikeslist_categories WHERE parent=0 AND deleted=0 AND hide=0 AND isalbum=0 AND validated=1
Count is 175
Load time so far: 4.03 seconds.
Query 13: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`subscriber`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`dmozpath`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl` FROM mikeslist_categories WHERE parent=0 AND validated=1 AND hide=0 AND isalbum=0 AND deleted=0 ORDER BY priority DESC,name ASC LIMIT 0,200
Warning: Cannot modify header information - headers already sent by (output started at /home/content/h/i/f/hifalls/html/thelist/classes/database.php:249) in /home/content/h/i/f/hifalls/html/thelist/includes/commonfuncs.php on line 686
Warning: Cannot modify header information - headers already sent by (output started at /home/content/h/i/f/hifalls/html/thelist/classes/database.php:249) in /home/content/h/i/f/hifalls/html/thelist/includes/commonfuncs.php on line 690
Warning: Cannot modify header information - headers already sent by (output started at /home/content/h/i/f/hifalls/html/thelist/classes/database.php:249) in /home/content/h/i/f/hifalls/html/thelist/end.php on line 66
Load time so far: 10.41 seconds.
Query 14: SELECT COUNT(id) FROM mikeslist_sessions WHERE memberid>0
Count is 0
Load time so far: 10.41 seconds.
Query 15: SELECT COUNT(id) FROM mikeslist_sessions WHERE memberid=0 AND isrobot=0
Count is 0
Load time so far: 10.41 seconds.
Query 16: SELECT COUNT(id) FROM mikeslist_sessions WHERE memberid=0 AND isrobot=1
Count is 1
Load time so far: 10.54 seconds.
Query 17: SELECT `id`,`title`,`url`,`description`,`rating`,`votes`,`validated`,`catid`,`sumofvotes`,`email`,`time`,`hits`,`numcomments`,`hide`,`ownerid`,`voterips`,`voterids`,`lastedit`,`type`,`notify`,`suspect`,`pendingedit`,`funds`,`suspended`,`alias`,`expire`,`ip`,`inalbum`,`typeorder`,`recipurl`,`hitsin`,`recipwith`,`hitsinips`,`hitsoutips`,`lastcomment`,`related`,`inhidden`,`viewers`,`threadviewers`,`hitsintemp`,`hitsouttemp`,`origtype`,`importance`,`parentids`,`timesdead`,`timesemailed`,`threadclosed`,`threadposters`,`lastposterid`,`lastpostername`,`ownername`,`deleted`,`deletionreason`,`movedto`,`deletedby`,`timevalidated`,`filefield`,`message`,`sticky`,`downloads`,`pollid`,`posticon`,`savedby`,`validatedemail`,`unpaid`,`recipverified`,`effectivetime`,`sugcatid`,`pagerank`,`wysihtml`,`movedid`,`unrevised`,`feedurl`,`feedcache`,`feedcachetime`,`nocds`,`showlocation`,`grade`,`source`,`tags`,`xmlsource`,`ordercomments`,`lastpadupdate`,`padfile`,`lastmonthlycheck`,`invisibleto`,`profileurl`,`lastprofileurl`,`timesrenewed`,`timedeleted` FROM mikeslist_links WHERE validated=1 AND hide=0 AND deleted=0 AND inhidden=0 AND (invisibleto NOT LIKE '%|3|%') AND effectivetime < 1197610437 AND alias=0 AND inalbum=0 ORDER BY id DESC LIMIT 0,5
Number of rows is 5
Load time so far: 10.56 seconds.
Query 18: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`subscriber`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`dmozpath`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl` FROM mikeslist_categories WHERE id=81
Load time so far: 10.58 seconds.
Query 19: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`subscriber`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`dmozpath`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl` FROM mikeslist_categories WHERE id=81
Load time so far: 10.59 seconds.
Query 20: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`subscriber`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`dmozpath`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl` FROM mikeslist_categories WHERE id=81
Load time so far: 10.6 seconds.
Query 21: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`subscriber`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`dmozpath`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl` FROM mikeslist_categories WHERE id=81
Load time so far: 10.61 seconds.
Query 22: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`subscriber`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`dmozpath`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl` FROM mikeslist_categories WHERE id=81
Load time so far: 10.62 seconds.
Query 23: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility`,`profileurl` FROM mikeslist_sessions WHERE time > 1197609547 AND (memberid>0) ORDER BY time DESC LIMIT 0,100
Number of rows is 0
Load time so far: 10.63 seconds.
Query 24: SELECT `content`,`author`,`id`,`source`,`ownerid`,`ownername`,`validated` FROM mikeslist_quotes WHERE validated=1 ORDER BY rand() ASC LIMIT 0,1
Number of rows is 0
Load time so far: 10.64 seconds.
Query 25: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility`,`profileurl` FROM mikeslist_sessions WHERE time > 1197609547 AND (inchat=1 AND memberid>0) ORDER BY time DESC LIMIT 0,100
Number of rows is 0
Load time so far: 11.97 seconds.
Query 26: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility`,`profileurl` FROM mikeslist_sessions WHERE memberid=2
Number of rows is 0
Load time so far: 11.98 seconds.
Query 27: UPDATE mikeslist_members SET isonline='1', lastvisit='1197610448' WHERE id='2'
Query 28: INSERT INTO mikeslist_sessions(`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility`,`profileurl`) VALUES('2','http://www.hifalls.net/thelist/index.php?docrons=1&debug=1','1197610448','24.191.0.57','Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Avant Browser; .NET CLR 1.1.4322; .NET CLR 2.0.50727)','1197610448','0','0','Main','','0','0','Admin','','','admincolor','all','everyone','http://www.hifalls.net/thelist/memberlist.php?action=profile&id=2')
Load time so far: 11.98 seconds.
Query 29: DELETE FROM mikeslist_sessions WHERE memberid=0 AND ip='24.191.0.57'
Apparently something is taking 30 seconds, causing mysql to die. It happens just after the crons table query, so there may be something wrong with that table. Try repairing and optimizing (top of Admin -> Misc -> Advanced, or in phpmyadmin).
I tried repairing and optimizing from w/in WSN and it seemed to work, but then today I got the same errors. I just tried repairing and optimizing the crons table from w/in phpmyadmin and hopefully that will be it, I will let you know.
Ok, just when I'm about ready to thank you for helping me fix this I get the errors again. This is after I tried repairing from w/in myphpadmin.
You mention that the crons db is causing this. Is there anyway to not have it query that db? I don't have any cron jobs setup - or at least none that I've setup manually.
Even when I wasn't getting the errors the index page was taking a long time to load which I attributed to having almost 200 categories, but I don't have any sub categories. If there's something I can remove from the index page that would help load time I would give it serious thought.
You do have 3 crons, everyone does. It's a very small table which rarely changes, so just about the least likely to become corrupt, but I guess yours has. Maybe you could downlaoding an SQL backup of the database, deleting it and recreating. Or you could ask your web host to have a look at the database.
200 top level categories would be a problem. From a useability point of view it's an impossible website to use, so I don't know how you expect your visitors to deal with it, but at Admin -> Settings -> General you can set the number of categories per page to something like 30.
Although, normally I would agree with you that 200 categories is an unmanageable amount to have listed on one page, I am using categories for artist names which actually makes it a little bit easier to have them all listed on one page. Most people know what they're looking for so it's a lot easier to either scroll down one page or CTRL-F the page to find what they're looking for instead of having to keep clicking around the site.
In any case, I am trying your suggestion, for the time being, to reduce the number of artists (categories) listed per page to 25. Unfortunately, now when I click on any of the page numbers it just keeps re-loading the first 25 artists (categories). When I click a page number I get a url that looks like - http://www.hifalls.net/thelist/index.php?subpage=5, but if I edit the url directly to be - http://www.hifalls.net/thelist/index.php?page=5 then the correct page loads. I tried changing {SUBPAGINATION} TO {PAGINATION} but that didn't work.
I guess you can ignore my last statement since I actually found a post that this was a bug fixed after 4.1.17 and since I'm still at 4.1.15 I'm going to assume this is the reason it's not working. So until I have enough time to dedicate to upgrading I will have to leave the site as it is.
Ok, so I finally got around to updating and I've changed the number of categories per page to 25. I've repaired and optimized the tables through the admin panel again as well as w/in phpmyadmin. Unfortunaately, I still get sql errors at the top of the page.
I've re-run the debug options you gave me at the beginning of this post have pasted that info below. If you see about 3/4 of the way down there is an error about not being able to modify headers. A quick google search tells me it means that there may be whitespace around the <?php code. I checked the wrapper and the only <?php does not have whitespace around it and the main index template doesn't have that tag at all. Is there anywhere else I can possibly check? Or am I "barking up the wrong tree?"
Load time so far: 0.05 seconds.
Query 1: SELECT `name`,`content` FROM mikeslist_settings WHERE id>0 ORDER BY id ASC
Number of rows is 473
Load time so far: 0.13 seconds.
Query 2: SELECT `name`,`value` FROM mikeslist_switches WHERE id>0
Number of rows is 93
Load time so far: 0.14 seconds.
Query 3: SELECT `id`,`type`,`original`,`replacement`,`description`,`originalclose`,`replacementclose`,`sortorder` FROM mikeslist_markup WHERE type='wsncode' ORDER BY sortorder
Number of rows is 23
Load time so far: 0.15 seconds.
Query 4: SELECT `id`,`title`,`caneditown`,`caneditall`,`canvote`,`isadmin`,`canpost`,`canemail`,`validatecats`,`validatecomments`,`validatelinks`,`validateedits`,`cansubmitlinks`,`cansubmitcategories`,`cansubmitcomments`,`caneditownlinks`,`caneditowncategories`,`caneditowncomments`,`caneditownprofile`,`caneditalllinks`,`caneditallcategories`,`caneditallcomments`,`caneditallprofiles`,`candownloadfiles`,`canupload`,`canviewip`,`limitlinks`,`canemailmembers`,`canusehtml`,`limitlinksdaily`,`canalias`,`cancopy`,`candeleteown`,`candeleteall`,`candofulledit`,`candeletecategories`,`candeletecomments`,`candeleteowncategories`,`candeleteowncomments`,`candeletemembers`,`candeleteownmembers`,`canaliascategories`,`canviewpages`,`caneditvotes`,`numaliases`,`canviewvotes`,`canhideownlinks`,`canhideowncategories`,`canhideowncomments`,`canhidealllinks`,`canhideallcategories`,`canhideallcomments`,`canratecomments`,`bytespermem`,`canpm`,`canim`,`canharddelete`,`limitpms`,`limitpmsdaily`,`canviewdeleted`,`cansubmitpolls`,`candeletepolls`,`candeleteownpolls`,`caneditpolls`,`caneditownpolls`,`attachperpost`,`attachperpm`,`canviewshouts`,`caneditshouts`,`caneditownshouts`,`candeleteshouts`,`candeleteownshouts`,`cansubmitshouts`,`canpollvote`,`customtitle`,`canviewinvisible`,`namestyle`,`canpmimportant`,`canviewmodlog`,`isleader`,`cansubmitquotes`,`validatequotes`,`candeletequotes`,`candeleteownquotes`,`canreport`,`canusesearch`,`attachperlink`,`validateattachments`,`caneditownquotes`,`caneditallquotes`,`canviewchat`,`caneditownevents`,`caneditallevents`,`candeleteownevents`,`candeleteevents`,`cansubmitevents`,`validateevents`,`bulkpms`,`issupermod`,`numinv`,`allowugspec`,`validateemails`,`validatesponsorlinks`,`cansubmittags`,`candeletetags`,`cansubmitfeeds`,`validatefeeds`,`validatefeeditems`,`numaliasestot`,`shoutsperday`,`validatetrader`,`renewdays`,`renewtimes`,`canviewownfulltrc`,`canviewallfulltrc` FROM mikeslist_membergroups WHERE id>0
Load time so far: 0.15 seconds.
Query 5: SELECT `id`,`name`,`links`,`comments`,`time`,`usergroup`,`password`,`ip`,`totalhits`,`totalhitsin`,`email`,`validated`,`template`,`language`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`totalbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,`banned`,`location`,`homepage`,`occupation`,`bio`,`aim`,`icq`,`msn`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`buddies`,`ignored`,`isonline`,`acceptims`,`adminpermissions`,`referrer`,`groupreverttime`,`grouprevertto`,`moderationpm`,`secondarygroups`,`linksperpage`,`commentsperpage`,`shouts`,`customtitle`,`shoutban`,`topicbans`,`forumbans`,`visibility`,`birthdate`,`lastsession`,`interests`,`posteditor`,`forumaccess`,`pmpopup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,`lastmodnote`,`newpms`,`imflag`,`orderalbums`,`lastguestnote`,`autosubscribe`,`notifymethod`,`showavatars`,`showsigs`,`warninglevel`,`topics`,`posts`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`calsub`,`macros`,`guestnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss`,`positivepct`,`notifytrader` FROM mikeslist_members WHERE id='2' AND validated=1
Load time so far: 0.18 seconds.
Query 6: SELECT `original`,`replacement`,`description`,`id`,`sortorder` FROM mikeslist_markup WHERE type='smilie' ORDER BY sortorder
Query 8: SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM mikeslist_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10
Number of rows is 0
Query 9: UNLOCK TABLES
Load time so far: 0.35 seconds.
Query 10: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`validated`,`ownerip`,`catid`,`importurl` FROM mikeslist_attachments WHERE importurl != '' ORDER BY id ASC LIMIT 0,1
Number of rows is 0
Load time so far: 0.35 seconds.
Query 11: SELECT `id`,`name`,`links`,`comments`,`time`,`usergroup`,`password`,`ip`,`totalhits`,`totalhitsin`,`email`,`validated`,`template`,`language`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`totalbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,`banned`,`location`,`homepage`,`occupation`,`bio`,`aim`,`icq`,`msn`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`buddies`,`ignored`,`isonline`,`acceptims`,`adminpermissions`,`referrer`,`groupreverttime`,`grouprevertto`,`moderationpm`,`secondarygroups`,`linksperpage`,`commentsperpage`,`shouts`,`customtitle`,`shoutban`,`topicbans`,`forumbans`,`visibility`,`birthdate`,`lastsession`,`interests`,`posteditor`,`forumaccess`,`pmpopup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,`lastmodnote`,`newpms`,`imflag`,`orderalbums`,`lastguestnote`,`autosubscribe`,`notifymethod`,`showavatars`,`showsigs`,`warninglevel`,`topics`,`posts`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`calsub`,`macros`,`guestnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss`,`positivepct`,`notifytrader` FROM mikeslist_members WHERE banned='' AND notifykeywords != '' AND keychecktime < 1201280275 ORDER BY id ASC LIMIT 0,1
Number of rows is 0
Load time so far: 0.35 seconds.
Query 12: SELECT `id`,`frequency`,`filename`,`nextrun` FROM mikeslist_crons WHERE nextrun < 1201366675 ORDER BY id ASC LIMIT 0,1
Number of rows is 0
Load time so far: 0.36 seconds.
Query 13: SELECT COUNT(id) FROM mikeslist_categories WHERE parent=0 AND deleted=0 AND hide=0 AND isalbum=0 AND validated=1
Count is 181
Load time so far: 0.36 seconds.
Query 14: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`subscriber`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`dmozpath`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl` FROM mikeslist_categories WHERE parent=0 AND validated=1 AND hide=0 AND isalbum=0 AND deleted=0 ORDER BY priority DESC,name ASC LIMIT 0,25
Warning: Cannot modify header information - headers already sent by (output started at /home/content/h/i/f/hifalls/html/thelist/classes/database.php:249) in /home/content/h/i/f/hifalls/html/thelist/includes/commonfuncs.php on line 705
Warning: Cannot modify header information - headers already sent by (output started at /home/content/h/i/f/hifalls/html/thelist/classes/database.php:249) in /home/content/h/i/f/hifalls/html/thelist/includes/commonfuncs.php on line 709
Warning: Cannot modify header information - headers already sent by (output started at /home/content/h/i/f/hifalls/html/thelist/classes/database.php:249) in /home/content/h/i/f/hifalls/html/thelist/end.php on line 66
Load time so far: 0.7 seconds.
Query 15: SELECT COUNT(id) FROM mikeslist_sessions WHERE memberid>0
Count is 1
Load time so far: 0.7 seconds.
Query 16: SELECT COUNT(id) FROM mikeslist_sessions WHERE memberid=0 AND isrobot=0
Count is 1
Load time so far: 0.7 seconds.
Query 17: SELECT COUNT(id) FROM mikeslist_sessions WHERE memberid=0 AND isrobot=1
Count is 1
Load time so far: 0.73 seconds.
Query 18: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility`,`profileurl` FROM mikeslist_sessions WHERE time > 1201365776 AND (memberid>0) ORDER BY time DESC LIMIT 0,100
Number of rows is 1
Load time so far: 0.74 seconds.
Query 19: SELECT `content`,`author`,`id`,`source`,`ownerid`,`ownername`,`validated` FROM mikeslist_quotes WHERE validated=1 ORDER BY rand() ASC LIMIT 0,1
Number of rows is 0
Load time so far: 0.76 seconds.
Query 20: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility`,`profileurl` FROM mikeslist_sessions WHERE time > 1201365776 AND (inchat=1 AND memberid>0) ORDER BY time DESC LIMIT 0,100
Number of rows is 0
Load time so far: 1.14 seconds.
Query 21: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility`,`profileurl` FROM mikeslist_sessions WHERE memberid=2
Number of rows is 1
Load time so far: 1.14 seconds.
Query 22: UPDATE mikeslist_sessions SET starttime='1201366487', time='1201366676', location='http://www.hifalls.net/thelist/index.php?docrons=1&debug=1', catid='0', threadid='', areaname='Main', nopermission='0', inchat='0', ip='24.191.0.57' WHERE id=164
Does this debug give you any additional information?
Load time so far: 0.1 seconds.
Query 1: SELECT `name`,`content` FROM mikeslist_settings WHERE id>0 ORDER BY id ASC
Number of rows is 473
Load time so far: 0.19 seconds.
Query 2: SELECT `name`,`value` FROM mikeslist_switches WHERE id>0
Number of rows is 93
Load time so far: 0.2 seconds.
Query 3: SELECT `id`,`type`,`original`,`replacement`,`description`,`originalclose`,`replacementclose`,`sortorder` FROM mikeslist_markup WHERE type='wsncode' ORDER BY sortorder
Number of rows is 23
Load time so far: 0.21 seconds.
Query 4: SELECT `id`,`title`,`caneditown`,`caneditall`,`canvote`,`isadmin`,`canpost`,`canemail`,`validatecats`,`validatecomments`,`validatelinks`,`validateedits`,`cansubmitlinks`,`cansubmitcategories`,`cansubmitcomments`,`caneditownlinks`,`caneditowncategories`,`caneditowncomments`,`caneditownprofile`,`caneditalllinks`,`caneditallcategories`,`caneditallcomments`,`caneditallprofiles`,`candownloadfiles`,`canupload`,`canviewip`,`limitlinks`,`canemailmembers`,`canusehtml`,`limitlinksdaily`,`canalias`,`cancopy`,`candeleteown`,`candeleteall`,`candofulledit`,`candeletecategories`,`candeletecomments`,`candeleteowncategories`,`candeleteowncomments`,`candeletemembers`,`candeleteownmembers`,`canaliascategories`,`canviewpages`,`caneditvotes`,`numaliases`,`canviewvotes`,`canhideownlinks`,`canhideowncategories`,`canhideowncomments`,`canhidealllinks`,`canhideallcategories`,`canhideallcomments`,`canratecomments`,`bytespermem`,`canpm`,`canim`,`canharddelete`,`limitpms`,`limitpmsdaily`,`canviewdeleted`,`cansubmitpolls`,`candeletepolls`,`candeleteownpolls`,`caneditpolls`,`caneditownpolls`,`attachperpost`,`attachperpm`,`canviewshouts`,`caneditshouts`,`caneditownshouts`,`candeleteshouts`,`candeleteownshouts`,`cansubmitshouts`,`canpollvote`,`customtitle`,`canviewinvisible`,`namestyle`,`canpmimportant`,`canviewmodlog`,`isleader`,`cansubmitquotes`,`validatequotes`,`candeletequotes`,`candeleteownquotes`,`canreport`,`canusesearch`,`attachperlink`,`validateattachments`,`caneditownquotes`,`caneditallquotes`,`canviewchat`,`caneditownevents`,`caneditallevents`,`candeleteownevents`,`candeleteevents`,`cansubmitevents`,`validateevents`,`bulkpms`,`issupermod`,`numinv`,`allowugspec`,`validateemails`,`validatesponsorlinks`,`cansubmittags`,`candeletetags`,`cansubmitfeeds`,`validatefeeds`,`validatefeeditems`,`numaliasestot`,`shoutsperday`,`validatetrader`,`renewdays`,`renewtimes`,`canviewownfulltrc`,`canviewallfulltrc` FROM mikeslist_membergroups WHERE id>0
Load time so far: 0.21 seconds.
Query 5: SELECT `id`,`name`,`links`,`comments`,`time`,`usergroup`,`password`,`ip`,`totalhits`,`totalhitsin`,`email`,`validated`,`template`,`language`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`totalbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,`banned`,`location`,`homepage`,`occupation`,`bio`,`aim`,`icq`,`msn`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`buddies`,`ignored`,`isonline`,`acceptims`,`adminpermissions`,`referrer`,`groupreverttime`,`grouprevertto`,`moderationpm`,`secondarygroups`,`linksperpage`,`commentsperpage`,`shouts`,`customtitle`,`shoutban`,`topicbans`,`forumbans`,`visibility`,`birthdate`,`lastsession`,`interests`,`posteditor`,`forumaccess`,`pmpopup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,`lastmodnote`,`newpms`,`imflag`,`orderalbums`,`lastguestnote`,`autosubscribe`,`notifymethod`,`showavatars`,`showsigs`,`warninglevel`,`topics`,`posts`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`calsub`,`macros`,`guestnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss`,`positivepct`,`notifytrader` FROM mikeslist_members WHERE id='2' AND validated=1
Load time so far: 0.23 seconds.
Query 6: SELECT `original`,`replacement`,`description`,`id`,`sortorder` FROM mikeslist_markup WHERE type='smilie' ORDER BY sortorder
Query 8: SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM mikeslist_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10
Number of rows is 0
Query 9: UNLOCK TABLES
Setting cookie with name testcookie, value 1 and expiration time 12404196333
Warning: Cannot modify header information - headers already sent by (output started at /home/content/h/i/f/hifalls/html/thelist/classes/database.php:249) in /home/content/h/i/f/hifalls/html/thelist/includes/commonfuncs.php on line 705
Warning: Cannot modify header information - headers already sent by (output started at /home/content/h/i/f/hifalls/html/thelist/classes/database.php:249) in /home/content/h/i/f/hifalls/html/thelist/includes/commonfuncs.php on line 709
Load time so far: 0.49 seconds.
Query 10: SELECT `memberid`,`starttime`,`time` FROM mikeslist_sessions WHERE time < 1202097267 AND memberid > 0
Number of rows is 0
Load time so far: 0.49 seconds.
Query 11: DELETE FROM mikeslist_sessions WHERE time < 1202097267
Load time so far: 0.49 seconds.
Query 12: SELECT `id`,`url`,`ownerid`,`lastfetched`,`validated`,`catid`,`time`,`title`,`description`,`homepage` FROM mikeslist_xmlfeeds WHERE validated=1 AND lastfetched < 1202054967 ORDER BY lastfetched ASC LIMIT 0,1
Number of rows is 0
Load time so far: 0.51 seconds.
Query 13: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`validated`,`ownerip`,`catid`,`importurl` FROM mikeslist_attachments WHERE importurl != '' ORDER BY id ASC LIMIT 0,1
Number of rows is 0
Load time so far: 0.52 seconds.
Query 14: SELECT `id`,`name`,`links`,`comments`,`time`,`usergroup`,`password`,`ip`,`totalhits`,`totalhitsin`,`email`,`validated`,`template`,`language`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`totalbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,`banned`,`location`,`homepage`,`occupation`,`bio`,`aim`,`icq`,`msn`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`buddies`,`ignored`,`isonline`,`acceptims`,`adminpermissions`,`referrer`,`groupreverttime`,`grouprevertto`,`moderationpm`,`secondarygroups`,`linksperpage`,`commentsperpage`,`shouts`,`customtitle`,`shoutban`,`topicbans`,`forumbans`,`visibility`,`birthdate`,`lastsession`,`interests`,`posteditor`,`forumaccess`,`pmpopup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,`lastmodnote`,`newpms`,`imflag`,`orderalbums`,`lastguestnote`,`autosubscribe`,`notifymethod`,`showavatars`,`showsigs`,`warninglevel`,`topics`,`posts`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`calsub`,`macros`,`guestnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss`,`positivepct`,`notifytrader` FROM mikeslist_members WHERE banned='' AND notifykeywords != '' AND keychecktime < 1202011767 ORDER BY id ASC LIMIT 0,1
Number of rows is 0
Load time so far: 0.53 seconds.
Query 15: SELECT `id`,`frequency`,`filename`,`nextrun` FROM mikeslist_crons WHERE nextrun < 1202098167 ORDER BY id ASC LIMIT 0,1
Number of rows is 1
Load time so far: 0.53 seconds.
Query 16: UPDATE mikeslist_crons SET nextrun='1202101767' WHERE id=6
Load time so far: 0.73 seconds.
Query 17: DELETE FROM mikeslist_links WHERE deleted=1 and timedeleted < 338184568
Load time so far: 49.63 seconds.
Query 18: UPDATE mikeslist_settings SET content='1202098216' WHERE name='lastrotation'
Load time so far: 49.63 seconds.
Lost connection to MySQL server during query
Query 19: UPDATE mikeslist_settings SET content='D' WHERE name='currentletter'
Load time so far: 49.63 seconds.
MySQL server has gone away
Query 20: SELECT `id`,`title`,`url`,`description`,`rating`,`votes`,`validated`,`catid`,`sumofvotes`,`email`,`time`,`hits`,`numcomments`,`hide`,`ownerid`,`voterips`,`voterids`,`lastedit`,`type`,`notify`,`suspect`,`pendingedit`,`funds`,`suspended`,`alias`,`expire`,`ip`,`inalbum`,`typeorder`,`recipurl`,`hitsin`,`recipwith`,`hitsinips`,`hitsoutips`,`lastcomment`,`related`,`inhidden`,`viewers`,`threadviewers`,`hitsintemp`,`hitsouttemp`,`origtype`,`importance`,`parentids`,`timesdead`,`timesemailed`,`threadclosed`,`threadposters`,`lastposterid`,`lastpostername`,`ownername`,`deleted`,`deletionreason`,`movedto`,`deletedby`,`timevalidated`,`filefield`,`message`,`sticky`,`downloads`,`pollid`,`posticon`,`savedby`,`validatedemail`,`unpaid`,`recipverified`,`effectivetime`,`sugcatid`,`pagerank`,`wysihtml`,`movedid`,`unrevised`,`feedurl`,`feedcache`,`feedcachetime`,`nocds`,`showlocation`,`grade`,`source`,`tags`,`xmlsource`,`ordercomments`,`lastpadupdate`,`padfile`,`lastmonthlycheck`,`invisibleto`,`profileurl`,`lastprofileurl`,`timesrenewed`,`timedeleted` FROM mikeslist_links WHERE deleted=0 AND hide=0 AND expire > 0 AND expire < 1202098216
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/h/i/f/hifalls/html/thelist/databases/mysql.php on line 27
Number of rows is MySQL server has gone away
Load time so far: 49.63 seconds.
MySQL server has gone away
Query 21: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`width`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads`,`validated`,`ownerip`,`catid`,`importurl` FROM mikeslist_attachments WHERE objectid=0 AND time>1202068216
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/h/i/f/hifalls/html/thelist/databases/mysql.php on line 27
Number of rows is MySQL server has gone away
Load time so far: 49.63 seconds.
MySQL server has gone away
Query 22: SELECT `id`,`name`,`links`,`comments`,`time`,`usergroup`,`password`,`ip`,`totalhits`,`totalhitsin`,`email`,`validated`,`template`,`language`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`totalbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,`banned`,`location`,`homepage`,`occupation`,`bio`,`aim`,`icq`,`msn`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`buddies`,`ignored`,`isonline`,`acceptims`,`adminpermissions`,`referrer`,`groupreverttime`,`grouprevertto`,`moderationpm`,`secondarygroups`,`linksperpage`,`commentsperpage`,`shouts`,`customtitle`,`shoutban`,`topicbans`,`forumbans`,`visibility`,`birthdate`,`lastsession`,`interests`,`posteditor`,`forumaccess`,`pmpopup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,`lastmodnote`,`newpms`,`imflag`,`orderalbums`,`lastguestnote`,`autosubscribe`,`notifymethod`,`showavatars`,`showsigs`,`warninglevel`,`topics`,`posts`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`calsub`,`macros`,`guestnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss`,`positivepct`,`notifytrader` FROM mikeslist_members WHERE groupreverttime > 0 AND groupreverttime < 1202098216
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/h/i/f/hifalls/html/thelist/databases/mysql.php on line 27
Number of rows is MySQL server has gone away
Load time so far: 49.78 seconds.
MySQL server has gone away
Query 23: SELECT COUNT(id) FROM mikeslist_categories WHERE parent=0 AND deleted=0 AND hide=0 AND isalbum=0 AND validated=1
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/content/h/i/f/hifalls/html/thelist/databases/mysql.php on line 30 Count is
Load time so far: 49.78 seconds.
MySQL server has gone away
Query 24: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`subscriber`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`dmozpath`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl` FROM mikeslist_categories WHERE parent=0 AND validated=1 AND hide=0 AND isalbum=0 AND deleted=0 ORDER BY priority DESC,name ASC LIMIT 0,25
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/h/i/f/hifalls/html/thelist/databases/mysql.php on line 27
Warning: Cannot modify header information - headers already sent by (output started at /home/content/h/i/f/hifalls/html/thelist/classes/database.php:249) in /home/content/h/i/f/hifalls/html/thelist/includes/commonfuncs.php on line 705
Warning: Cannot modify header information - headers already sent by (output started at /home/content/h/i/f/hifalls/html/thelist/classes/database.php:249) in /home/content/h/i/f/hifalls/html/thelist/includes/commonfuncs.php on line 709
Warning: Cannot modify header information - headers already sent by (output started at /home/content/h/i/f/hifalls/html/thelist/classes/database.php:249) in /home/content/h/i/f/hifalls/html/thelist/end.php on line 66
Load time so far: 49.96 seconds.
MySQL server has gone away
Query 25: SELECT COUNT(id) FROM mikeslist_sessions WHERE memberid>0
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/content/h/i/f/hifalls/html/thelist/databases/mysql.php on line 30 Count is
Load time so far: 49.96 seconds.
MySQL server has gone away
Query 26: SELECT COUNT(id) FROM mikeslist_sessions WHERE memberid=0 AND isrobot=0
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/content/h/i/f/hifalls/html/thelist/databases/mysql.php on line 30 Count is
Load time so far: 49.96 seconds.
MySQL server has gone away
Query 27: SELECT COUNT(id) FROM mikeslist_sessions WHERE memberid=0 AND isrobot=1
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/content/h/i/f/hifalls/html/thelist/databases/mysql.php on line 30 Count is
Load time so far: 49.98 seconds.
MySQL server has gone away
Query 28: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility`,`profileurl` FROM mikeslist_sessions WHERE time > 1202097317 AND (memberid>0) ORDER BY time DESC LIMIT 0,100
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/h/i/f/hifalls/html/thelist/databases/mysql.php on line 27
Number of rows is MySQL server has gone away
Load time so far: 49.98 seconds.
MySQL server has gone away
Query 29: SELECT `content`,`author`,`id`,`source`,`ownerid`,`ownername`,`validated` FROM mikeslist_quotes WHERE validated=1 ORDER BY rand() ASC LIMIT 0,1
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/h/i/f/hifalls/html/thelist/databases/mysql.php on line 27
Number of rows is MySQL server has gone away
Load time so far: 49.98 seconds.
MySQL server has gone away
Query 30: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility`,`profileurl` FROM mikeslist_sessions WHERE time > 1202097317 AND (inchat=1 AND memberid>0) ORDER BY time DESC LIMIT 0,100
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/h/i/f/hifalls/html/thelist/databases/mysql.php on line 27
Number of rows is MySQL server has gone away
Load time so far: 50.16 seconds.
MySQL server has gone away
Query 31: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility`,`profileurl` FROM mikeslist_sessions WHERE memberid=2
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/h/i/f/hifalls/html/thelist/databases/mysql.php on line 27
Number of rows is MySQL server has gone away
Load time so far: 50.16 seconds.
MySQL server has gone away
Query 32: UPDATE mikeslist_members SET isonline='1', lastvisit='1202098217' WHERE id='2'
Query 33: INSERT INTO mikeslist_sessions(`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility`,`profileurl`) VALUES('2','http://www.hifalls.net/thelist/index.php?dorand=1&debug=1','1202098217','24.191.0.57','Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Avant Browser; .NET CLR 1.1.4322; .NET CLR 2.0.50727)','1202098217','0','0','index.php?dorand=1&debug=','','0','0','Admin','','','admincolor','all','everyone','http://www.hifalls.net/thelist/memberlist.php?action=profile&id=2')
Load time so far: 50.16 seconds.
MySQL server has gone away
Query 34: DELETE FROM mikeslist_sessions WHERE memberid=0 AND ip='24.191.0.57'
It states the same thing -- that it takes 48 seconds between two simple queries and at the end the mysql server is gone. The 48 seconds could the result of the mysql server going away, or the cause of it. I don't see how such a point could be a cause unless you have an extremely complex cron, so contact your web host if it's the former.
I haven't created any crons so the only ones that should be loading are what comes with wsn.
At your previous suggestion I've tried contacting the host, but they tell me that they do not offer any database support unless it is a problem with mysql itself. In other words they cannot look at my database and offer an opinion or suggestion so at this point I'm stuck. I'm not sure where else to turn or to look.
Thanks again for your help and I'm sorry this has been such a long drawn out problem.
MySQL dying during script execution is a problem with MySQL.
Were you the one on the old PHP 4.3 server? If it also has MySQL 3 then it'd be slower than modern servers... but not by that much. But if you're the one I'm thinking of it also had a broken curl/fopen, so it wouldn't be surprising to find a lot of other things broken on it.
0/5
1
2
3
4
5
Sorry, you don't have permission to post posts. Log in, or register if you haven't yet.
Comments on my sql error when page loads
Forum Regular
Usergroup: Customer
Joined: Apr 03, 2007
Location: NY & PA
Total Topics: 94
Total Comments: 339
Recently I've been getting the following error when trying to load my site -
it doesn't happen every time, but most times. I get that same error repeated about 13 times some show line 26 and some show line 29 and then the rest of the wrapper template loads minus the main index template. When I refresh the page everything is fine though.
Could it be that I have too many categories on my main page? I have about 175 categories, but no sub-categories.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Try to get the debug output: scripts.webmastersite.net/w...icles/mysql-errors-66.html
Try index.php?dorand=1&debug=1 and index.php?docrons=1&debug=1, and see if it reappears on those.
Forum Regular
Usergroup: Customer
Joined: Apr 03, 2007
Location: NY & PA
Total Topics: 94
Total Comments: 339
following is the out put from index.php?dorand=1&debug=1
following is the output of index.php?docrons=1&debug=1
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Apparently something is taking 30 seconds, causing mysql to die. It happens just after the crons table query, so there may be something wrong with that table. Try repairing and optimizing (top of Admin -> Misc -> Advanced, or in phpmyadmin).
Forum Regular
Usergroup: Customer
Joined: Apr 03, 2007
Location: NY & PA
Total Topics: 94
Total Comments: 339
I tried repairing and optimizing from w/in WSN and it seemed to work, but then today I got the same errors.
I just tried repairing and optimizing the crons table from w/in phpmyadmin and hopefully that will be it,
I will let you know.
Thanks.
Forum Regular
Usergroup: Customer
Joined: Apr 03, 2007
Location: NY & PA
Total Topics: 94
Total Comments: 339
Ok, just when I'm about ready to thank you for helping me fix this I get the errors again. This is
after I tried repairing from w/in myphpadmin.
You mention that the crons db is causing this. Is there anyway to not have it query that db? I don't have
any cron jobs setup - or at least none that I've setup manually.
Even when I wasn't getting the errors the index page was taking a long time to load which I attributed
to having almost 200 categories, but I don't have any sub categories. If there's something I can remove
from the index page that would help load time I would give it serious thought.
Thanks again for your help.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
You do have 3 crons, everyone does. It's a very small table which rarely changes, so just about the least likely to become corrupt, but I guess yours has. Maybe you could downlaoding an SQL backup of the database, deleting it and recreating. Or you could ask your web host to have a look at the database.
200 top level categories would be a problem. From a useability point of view it's an impossible website to use, so I don't know how you expect your visitors to deal with it, but at Admin -> Settings -> General you can set the number of categories per page to something like 30.
Forum Regular
Usergroup: Customer
Joined: Apr 03, 2007
Location: NY & PA
Total Topics: 94
Total Comments: 339
Although, normally I would agree with you that 200 categories is an unmanageable amount to have listed on one page, I am using
categories for artist names which actually makes it a little bit easier to have them all listed on one page. Most people know
what they're looking for so it's a lot easier to either scroll down one page or CTRL-F the page to find what they're looking
for instead of having to keep clicking around the site.
In any case, I am trying your suggestion, for the time being, to reduce the number of artists (categories) listed per page to 25. Unfortunately,
now when I click on any of the page numbers it just keeps re-loading the first 25 artists (categories). When I click a page number I
get a url that looks like - http://www.hifalls.net/thelist/index.php?subpage=5, but if I edit the url directly to be -
http://www.hifalls.net/thelist/index.php?page=5 then the correct page loads. I tried changing {SUBPAGINATION} TO {PAGINATION} but that
didn't work.
Any ideas?
Forum Regular
Usergroup: Customer
Joined: Apr 03, 2007
Location: NY & PA
Total Topics: 94
Total Comments: 339
I guess you can ignore my last statement since I actually found a post that this was a bug fixed after
4.1.17 and since I'm still at 4.1.15 I'm going to assume this is the reason it's not working. So until
I have enough time to dedicate to upgrading I will have to leave the site as it is.
Forum Regular
Usergroup: Customer
Joined: Apr 03, 2007
Location: NY & PA
Total Topics: 94
Total Comments: 339
Dear Paul,
Ok, so I finally got around to updating and I've changed the number of categories per page to 25. I've
repaired and optimized the tables through the admin panel again as well as w/in phpmyadmin. Unfortunaately,
I still get sql errors at the top of the page.
I've re-run the debug options you gave me at the beginning of this post have pasted that info below. If
you see about 3/4 of the way down there is an error about not being able to modify headers. A quick google
search tells me it means that there may be whitespace around the <?php code. I checked the wrapper and the
only <?php does not have whitespace around it and the main index template doesn't have that tag at all. Is
there anywhere else I can possibly check? Or am I "barking up the wrong tree?"
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
There are no errors in what you posted there.
scripts.webmastersite.net/w...eader-information-216.html
See #2.
Forum Regular
Usergroup: Customer
Joined: Apr 03, 2007
Location: NY & PA
Total Topics: 94
Total Comments: 339
Does this debug give you any additional information?
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
It states the same thing -- that it takes 48 seconds between two simple queries and at the end the mysql server is gone. The 48 seconds could the result of the mysql server going away, or the cause of it. I don't see how such a point could be a cause unless you have an extremely complex cron, so contact your web host if it's the former.
Forum Regular
Usergroup: Customer
Joined: Apr 03, 2007
Location: NY & PA
Total Topics: 94
Total Comments: 339
I haven't created any crons so the only ones that should be loading are what comes with wsn.
At your previous suggestion I've tried contacting the host, but they tell me that they do not
offer any database support unless it is a problem with mysql itself. In other words they cannot
look at my database and offer an opinion or suggestion so at this point I'm stuck. I'm not sure
where else to turn or to look.
Thanks again for your help and I'm sorry this has been such a long drawn out problem.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
MySQL dying during script execution is a problem with MySQL.
Were you the one on the old PHP 4.3 server? If it also has MySQL 3 then it'd be slower than modern servers... but not by that much. But if you're the one I'm thinking of it also had a broken curl/fopen, so it wouldn't be surprising to find a lot of other things broken on it.