| Message Text |
I found some small issues:
when running the dead link check I get a couple of little textboxes with these error messages:
Error occurred at [url=http://link-lounge.com/thelinks/admin/linkchecks.php?filled=1&amp;amp;action=downcheck&amp;amp;perpage=25&amp;amp;start=1248&amp;amp;reload=1&amp;amp;showdetails=&amp;amp;sendemails={EMAILS]http://link-lounge.com/thelinks/ad...mp;sendemails={EMAILS[/url]}&amp;amp;checknonrecip={CHECKNONRECIP}&amp;amp;autodelete= on 2009-10-28 10:43:02. Error text: Error #2: 'file_get_contents() [<a href='function.file-get-contents'>function.file-get-contents</a>]: Couldn't resolve host name' in /home/linkloun/public_html/thelinks/includes/filefunctions.php on line 435. Step 1 of backtrace: File: /home/linkloun/public_html/thelinks/includes/filefunctions.php Line: 435 Function: file_get_contents Arguments: [url=http://www.stephen-dorff.net]http://www.stephen-dorff.net[/url] Resource id #129 Step 2 of backtrace: File: /home/linkloun/public_html/thelinks/admin/linkchecks.php Line: 242 Function: geturl Arguments: [url=http://www.stephen-dorff.net]http://www.stephen-dorff.net[/url]
and
Error occurred at [url=http://link-lounge.com/thelinks/admin/linkchecks.php?filled=1&amp;amp;action=downcheck&amp;amp;perpage=25&amp;amp;start=1248&amp;amp;reload=1&amp;amp;showdetails=&amp;amp;sendemails={EMAILS]http://link-lounge.com/thelinks/ad...mp;sendemails={EMAILS[/url]}&amp;amp;checknonrecip={CHECKNONRECIP}&amp;amp;autodelete= on 2009-10-28 10:43:02. Error text: Error #2: 'file_get_contents([url=http://www.stephen-dorff.net]http://www.stephen-dorff.net[/url]) [<a href='function.file-get-contents'>function.file-get-contents</a>]: failed to open stream: operation failed' in /home/linkloun/public_html/thelinks/includes/filefunctions.php on line 435. Step 1 of backtrace: File: /home/linkloun/public_html/thelinks/includes/filefunctions.php Line: 435 Function: file_get_contents Arguments: [url=http://www.stephen-dorff.net]http://www.stephen-dorff.net[/url] Resource id #129 Step 2 of backtrace: File: /home/linkloun/public_html/thelinks/admin/linkchecks.php Line: 242 Function: geturl Arguments: [url=http://www.stephen-dorff.net]http://www.stephen-dorff.net[/url]
However the function itself seems to run correctly and some dead links are found and noted.
In addition I encountered some blank category pages. I have had this problem before and I was able to fix it by going through every single link and deleting the descriptions although I didn't see anything special about the description text that caused this problem. Since I had the same thing happening again this morning I though I should post the debug output for you:
Query 7:[/b] SHOW COLUMNS FROM wsnlinksclone1_members
Getting field list for table wsnlinksclone1_members: 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,newemail,calsub,macros,guestnotify,keychecktime,notifykeywords,autosubscribepost,blogrss,positivepct,notifytrader,inactiveemail,repliesreceived,sponsorendtime
Load time so far: [b]0.06[/b] seconds.
[b]Query 8:[/b] SHOW COLUMNS FROM wsnlinksclone1_members
n
Getting field list for table wsnlinksclone1_members: 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,newemail,calsub,macros,guestnotify,keychecktime,notifykeywords,autosubscribepost,blogrss,positivepct,notifytrader,inactiveemail,repliesreceived,sponsorendtime
Load time so far: [b]0.07[/b] seconds.
Load time so far: [b]0.07[/b] seconds.
[b]Query 9:[/b] SELECT option_value FROM wp_options WHERE option_name='siteurl'
[b]Query 10:[/b] SELECT `table_name` FROM information_schema.tables WHERE table_schema = 'linkloun_links' AND table_name = 'wp_users'
Load time so far: [b]0.31[/b] seconds.
Number of rows is 1
[b]Query 11:[/b] SHOW COLUMNS FROM linkloun_links.wp_users
Getting field list for table linkloun_links.wp_users: ID,user_login,user_pass,user_nicename,user_email,user_url,user_registered,user_activation_key,user_status,display_name,links,comments,ip,totalhits,totalhitsin,validated,template,language,lastattempt,allowemail,signature,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,funds,notifyoflinks,lastvisit,timezone,rating,pmfolders,notifyofpms,acceptpms,cookieduration,banned,location,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,newemail,calsub,macros,guestnotify,keychecktime,notifykeywords,autosubscribepost,blogrss,positivepct,notifytrader,inactiveemail,repliesreceived,sponsorendtime
Load time so far: [b]0.32[/b] seconds.
[b]Query 12:[/b] SHOW COLUMNS FROM linkloun_links.wp_users
Getting field list for table linkloun_links.wp_users: ID,user_login,user_pass,user_nicename,user_email,user_url,user_registered,user_activation_key,user_status,display_name,links,comments,ip,totalhits,totalhitsin,validated,template,language,lastattempt,allowemail,signature,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,funds,notifyoflinks,lastvisit,timezone,rating,pmfolders,notifyofpms,acceptpms,cookieduration,banned,location,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,newemail,calsub,macros,guestnotify,keychecktime,notifykeywords,autosubscribepost,blogrss,positivepct,notifytrader,inactiveemail,repliesreceived,sponsorendtime
Load time so far: [b]0.32[/b] seconds.
[b]Query 13:[/b] 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`,`cansuggestban`,`limittags`,`cansubmitbulk`,`cancreatealbum` FROM wsnlinksclone1_membergroups
Load time so far: [b]0.32[/b] seconds.
[b]Query 14:[/b] SELECT `ID`,`user_login`,`user_pass`,`user_nicename`,`user_email`,`user_url`,`user_registered`,`user_activation_key`,`user_status`,`display_name`,`links`,`comments`,`ip`,`totalhits`,`totalhitsin`,`validated`,`template`,`language`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`totalbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,`banned`,`location`,`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`,`newemail`,`calsub`,`macros`,`guestnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss`,`positivepct`,`notifytrader`,`inactiveemail`,`repliesreceived`,`sponsorendtime` FROM linkloun_links.wp_users WHERE ID = '1' AND validated = 1
Load time so far: [b]0.33[/b] seconds.
Creating member with as viewer
Creating category with 551 as id
[b]Query 15:[/b] 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`,`specialurl`,`invisibleto`,`customsubmit`,`customedit`,`customsubmitfeed`,`actassearch` FROM wsnlinksclone1_categories WHERE id = 551
Load time so far: [b]0.35[/b] seconds.
Number of rows is 1
[b]Query 16:[/b] SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM wsnlinksclone1_email WHERE timesent=0 AND inprogress=0 ORDER BY id ASC LIMIT 0,10
Load time so far: [b]0.35[/b] seconds.
Number of rows is 0
[b]Query 17:[/b] SELECT `memberid`,`starttime`,`time` FROM wsnlinksclone1_sessions WHERE time < 1256725607 AND memberid > 0
Load time so far: [b]0.36[/b] seconds.
Number of rows is 0
Load time so far: [b]0.36[/b] seconds.
[b]Query 18:[/b] DELETE FROM wsnlinksclone1_sessions WHERE time < 1256725607
[b]Query 19:[/b] SELECT `id`,`frequency`,`filename`,`nextrun` FROM wsnlinksclone1_crons WHERE nextrun < 1256726507 ORDER BY id ASC LIMIT 0,1
Load time so far: [b]0.36[/b] seconds.
Number of rows is 0
Creating category with 551 as id
[b]Query 20:[/b] 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`,`specialurl`,`invisibleto`,`customsubmit`,`customedit`,`customsubmitfeed`,`actassearch` FROM wsnlinksclone1_categories WHERE id = 551
Load time so far: [b]0.36[/b] seconds.
Number of rows is 1
[b]Query 21:[/b] 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`,`specialurl`,`invisibleto`,`customsubmit`,`customedit`,`customsubmitfeed`,`actassearch` FROM wsnlinksclone1_categories WHERE parent=551 AND validated=1 AND hide=0 AND deleted=0 AND isalbum=0 ORDER BY name ASC,time ASC LIMIT 0,150
Load time so far: [b]0.36[/b] seconds.
Number of rows is 0
Load time so far: [b]0.36[/b] seconds.
[b]Query 22:[/b] SELECT COUNT(*) FROM wsnlinksclone1_links WHERE catid=551 AND hide=0 AND deleted=0 AND validated=1 AND effectivetime < 1256726507
Count is 8
[b]Query 23:[/b] 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`,`spotlight`,`top100`,`comment`,`validatedemail`,`unpaid`,`recipverified`,`effectivetime`,`sugcatid`,`pagerank`,`wysihtml`,`movedid`,`unrevised`,`feedurl`,`feedcache`,`feedcachetime`,`tags`,`xmlsource`,`ordercomments`,`lastpadupdate`,`padfile`,`lastmonthlycheck`,`invisibleto`,`profileurl`,`lastprofileurl`,`timesrenewed`,`timedeleted`,`sponsorend`,`address`,`city`,`state`,`country`,`latitude`,`longitude`,`zip`,`phone`,`summary`,`active`,`sponsorendtime`,`price` FROM wsnlinksclone1_links WHERE catid=551 AND hide=0 AND deleted=0 AND validated=1 AND effectivetime < 1256726507 ORDER BY title ASC,title ASC LIMIT 0,30
Load time so far: [b]0.44[/b] seconds.
Number of rows is 8
Creating link with Array as row
Creating link with Array as row
Creating link with Array as row
Creating link with Array as row
Creating link with Array as row
Creating link with Array as row
Creating link with Array as row
Creating link with Array as row
[b]Query 24:[/b] 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`,`specialurl`,`invisibleto`,`customsubmit`,`customedit`,`customsubmitfeed`,`actassearch` FROM wsnlinksclone1_categories WHERE deleted=0 AND validated=1 AND isalbum=0 AND alias=0 AND hide=0 AND MATCH (name) AGAINST('Pirates Of The Caribbean ') AND id != 551 LIMIT 0,5
Load time so far: [b]0.51[/b] seconds.
Number of rows is 0
Load time so far: [b]0.51[/b] seconds.
[b]Query 25:[/b] SELECT COUNT(*) FROM wsnlinksclone1_categories WHERE deleted=0 AND validated=1 AND isalbum=0 AND alias=0 AND hide=0 AND MATCH (name) AGAINST('Pirates Of The Caribbean ') AND id != 551
Count is 0
Load time so far: [b]0.51[/b] seconds.
[b]Query 26:[/b] SELECT COUNT(*) FROM wsnlinksclone1_links WHERE catid=551 AND hide=0 AND deleted=0 AND validated=1 AND effectivetime < 1256726507
Count is 8
Load time so far: [b]0.51[/b] seconds.
[b]Query 27:[/b] SELECT COUNT(*) FROM wsnlinksclone1_links WHERE catid=551 AND hide=0 AND deleted=0 AND validated=1 AND effectivetime < 1256726507
Count is 8
Creating category with 1944 as id
[b]Query 28:[/b] 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`,`specialurl`,`invisibleto`,`customsubmit`,`customedit`,`customsubmitfeed`,`actassearch` FROM wsnlinksclone1_categories WHERE id = 1944
Load time so far: [b]0.52[/b] seconds.
Number of rows is 1
Creating category with 61 as id
[b]Query 29:[/b] 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`,`specialurl`,`invisibleto`,`customsubmit`,`customedit`,`customsubmitfeed`,`actassearch` FROM wsnlinksclone1_categories WHERE id = 61
Load time so far: [b]0.52[/b] seconds.
Number of rows is 1
Setting cookie with name thelinks_returnto, value </small>[url=http://link-lounge.com/thelinks/index.php?action=displaycat&catid=551]<small>http://link-lounge.com/thelinks/in...n=displaycat&catid=551</small>[/url]<small> and expiration time 0
Load time so far: [b]0.53[/b] seconds.
[b]Query 30:[/b] SELECT COUNT(*) FROM wsnlinksclone1_links WHERE catid=551 AND validated=1 AND hide=0 AND deleted=0 AND type='regular' AND effectivetime < 1256726507
Count is 8
Load time so far: [b]0.57[/b] seconds.
[b]Query 31:[/b] SELECT COUNT(*) FROM wsnlinksclone1_links WHERE catid=551 AND validated=1 AND hide=0 AND deleted=0 AND type='recip' AND effectivetime < 1256726507
Count is 0
Load time so far: [b]0.61[/b] seconds.
[b]Query 32:[/b] SELECT COUNT(*) FROM wsnlinksclone1_links WHERE catid=551 AND hide=0 AND deleted=0 AND validated=1 AND effectivetime < 1256726507
Count is 8
Load time so far: [b]0.61[/b] seconds.
[b]Query 33:[/b] SELECT COUNT(*) FROM wsnlinksclone1_links WHERE catid=551 AND hide=0 AND deleted=0 AND validated=1 AND effectivetime < 1256726507
Count is 8
[b]Query 34:[/b] 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`,`spotlight`,`top100`,`comment`,`validatedemail`,`unpaid`,`recipverified`,`effectivetime`,`sugcatid`,`pagerank`,`wysihtml`,`movedid`,`unrevised`,`feedurl`,`feedcache`,`feedcachetime`,`tags`,`xmlsource`,`ordercomments`,`lastpadupdate`,`padfile`,`lastmonthlycheck`,`invisibleto`,`profileurl`,`lastprofileurl`,`timesrenewed`,`timedeleted`,`sponsorend`,`address`,`city`,`state`,`country`,`latitude`,`longitude`,`zip`,`phone`,`summary`,`active`,`sponsorendtime`,`price` FROM wsnlinksclone1_
links WHERE validated=1 AND hide=0 AND deleted=0 AND inhidden=0 AND (spotlight = 'yes' AND invisibleto NOT LIKE '%|3|%') AND effectivetime < 1256726507 AND alias=0 AND inalbum=0 ORDER BY rand() ASC LIMIT 0,1
Load time so far: [b]0.67[/b] seconds.
Number of rows is 1
Creating link with Array as row
[b]Query 35:[/b] 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`,`spotlight`,`top100`,`comment`,`validatedemail`,`unpaid`,`recipverified`,`effectivetime`,`sugcatid`,`pagerank`,`wysihtml`,`movedid`,`unrevised`,`feedurl`,`feedcache`,`feedcachetime`,`tags`,`xmlsource`,`ordercomments`,`lastpadupdate`,`padfile`,`lastmonthlycheck`,`invisibleto`,`profileurl`,`lastprofileurl`,`timesrenewed`,`timedeleted`,`sponsorend`,`address`,`city`,`state`,`country`,`latitude`,`longitude`,`zip`,`phone`,`summary`,`active`,`sponsorendtime`,`price` FROM wsnlinksclone1_links WHERE validated=1 AND hide=0 AND deleted=0 AND inhidden=0 AND (invisibleto NOT LIKE '%|3|%') AND effectivetime < 1256726507 AND alias=0 AND inalbum=0 ORDER BY hitsin desc,hits LIMIT 0,5
Load time so far: [b]0.73[/b] seconds.
Number of rows is 5
Creating link with Array as row
Creating link with Array as row
Creating link with Array as row
Creating link with Array as row
Creating link with Array as row
[b]Query 36:[/b] 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`,`spotlight`,`top100`,`comment`,`validatedemail`,`unpaid`,`recipverified`,`effectivetime`,`sugcatid`,`pagerank`,`wysihtml`,`movedid`,`unrevised`,`feedurl`,`feedcache`,`feedcachetime`,`tags`,`xmlsource`,`ordercomments`,`lastpadupdate`,`padfile`,`lastmonthlycheck`,`invisibleto`,`profileurl`,`lastprofileurl`,`timesrenewed`,`timedeleted`,`sponsorend`,`address`,`city`,`state`,`country`,`latitude`,`longitude`,`zip`,`phone`,`summary`,`active`,`sponsorendtime`,`price` FROM wsnlinksclone1_links WHERE validated=1 AND hide=0 AND deleted=0 AND inhidden=0 AND (invisibleto NOT LIKE '%|3|%') AND effectivetime < 1256726507 AND alias=0 AND inalbum=0 ORDER BY id DESC LIMIT 0,5
Load time so far: [b]0.81[/b] seconds.
Number of rows is 5
Creating link with Array as row
Creating link with Array as row
Creating link with Array as row
Creating link with Array as row
Creating link with Array as row
Load time so far: [b]0.84[/b] seconds.
[b]Query 37:[/b] SELECT COUNT(*) FROM wsnlinksclone1_categories WHERE id=5 and alias>0
Count is 0
[b]Query 38:[/b] SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility`,`profileurl` FROM wsnlinksclone1_sessions WHERE time > 1256725607 AND (catid=551 AND memberid>0) ORDER BY time DESC LIMIT 0,100
Load time so far: [b]0.84[/b] seconds.
Number of rows is 1
Creating online with Array as row
[b]Query 39:[/b] 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`,`specialurl`,`invisibleto`,`customsubmit`,`customedit`,`customsubmitfeed`,`actassearch` FROM wsnlinksclone1_categories WHERE deleted=0 AND validated=1 AND ((defaultnoaccess='no' AND permissions LIKE '%]canviewpages[VALUE]1[FIELD]%') OR (defaultnoaccess='yes'))
Load time so far: [b]0.85[/b] seconds.
[b]Query 40:[/b] SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`acceptims`,`visibility`,`profileurl` FROM wsnlinksclone1_sessions WHERE memberid=1
Load time so far: [b]0.87[/b] seconds.
Number of rows is 1
Creating online with Array as row
Load time so far: [b]0.87[/b] seconds.
[b]Query 41:[/b] UPDATE wsnlinksclone1_sessions SET starttime = '1256721557', name = 'Jenny', time = '1256726507', location = 'http://link-lounge.com/thelinks/index.php?action=displaycat&catid=551', catid = '551', threadid = '', areaname = 'Pirates Of The Caribbean ', nopermission = '0', inchat = '0', ip = '87.183.231.66' WHERE id=3
ETA: it looks like a simple ' (as in Jenny's) in the description is screwing it up. As soon as I take that out the page comes back. |
