when running the dead link check I get a couple of little textboxes with these error messages:
Error occurred at http://link-lounge.com/thelinks/ad...mp;sendemails={EMAILS}&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: http://www.stephen-dorff.net Resource id #129 Step 2 of backtrace: File: /home/linkloun/public_html/thelinks/admin/linkchecks.php Line: 242 Function: geturl Arguments: http://www.stephen-dorff.net
and
Error occurred at http://link-lounge.com/thelinks/ad...mp;sendemails={EMAILS}&amp;amp;checknonrecip={CHECKNONRECIP}&amp;amp;autodelete= on 2009-10-28 10:43:02. Error text: Error #2: 'file_get_contents(http://www.stephen-dorff.net) [<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: http://www.stephen-dorff.net Resource id #129 Step 2 of backtrace: File: /home/linkloun/public_html/thelinks/admin/linkchecks.php Line: 242 Function: geturl Arguments: http://www.stephen-dorff.net
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: 0.06 seconds.
Query 8: 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: 0.07 seconds.
Load time so far: 0.07 seconds.
Query 9: SELECT option_value FROM wp_options WHERE option_name='siteurl'
Query 10: SELECT `table_name` FROM information_schema.tables WHERE table_schema = 'linkloun_links' AND table_name = 'wp_users'
Load time so far: 0.31 seconds.
Number of rows is 1
Query 11: 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: 0.32 seconds.
Query 12: 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: 0.32 seconds.
Query 13: 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: 0.32 seconds.
Query 14: 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: 0.33 seconds.
Creating member with as viewer
Creating category with 551 as id
Query 15: 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: 0.35 seconds.
Number of rows is 1
Query 16: 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: 0.35 seconds.
Number of rows is 0
Query 17: SELECT `memberid`,`starttime`,`time` FROM wsnlinksclone1_sessions WHERE time < 1256725607 AND memberid > 0
Load time so far: 0.36 seconds.
Number of rows is 0
Load time so far: 0.36 seconds.
Query 18: DELETE FROM wsnlinksclone1_sessions WHERE time < 1256725607
Query 19: SELECT `id`,`frequency`,`filename`,`nextrun` FROM wsnlinksclone1_crons WHERE nextrun < 1256726507 ORDER BY id ASC LIMIT 0,1
Load time so far: 0.36 seconds.
Number of rows is 0
Creating category with 551 as id
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`,`specialurl`,`invisibleto`,`customsubmit`,`customedit`,`customsubmitfeed`,`actassearch` FROM wsnlinksclone1_categories WHERE id = 551
Load time so far: 0.36 seconds.
Number of rows is 1
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`,`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: 0.36 seconds.
Number of rows is 0
Load time so far: 0.36 seconds.
Query 22: SELECT COUNT(*) FROM wsnlinksclone1_links WHERE catid=551 AND hide=0 AND deleted=0 AND validated=1 AND effectivetime < 1256726507 Count is 8
Query 23: 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: 0.44 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
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`,`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: 0.51 seconds.
Number of rows is 0
Load time so far: 0.51 seconds.
Query 25: 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: 0.51 seconds.
Query 26: 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: 0.51 seconds.
Query 27: 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
Query 28: 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: 0.52 seconds.
Number of rows is 1
Creating category with 61 as id
Query 29: 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
Query 30: 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: 0.57 seconds.
Query 31: 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: 0.61 seconds.
Query 32: 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: 0.61 seconds.
Query 33: SELECT COUNT(*) FROM wsnlinksclone1_links WHERE catid=551 AND hide=0 AND deleted=0 AND validated=1 AND effectivetime < 1256726507 Count is 8
Query 34: 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: 0.67 seconds.
Number of rows is 1
Creating link with Array as row
Query 35: 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: 0.73 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
Query 36: 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: 0.81 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: 0.84 seconds.
Query 37: SELECT COUNT(*) FROM wsnlinksclone1_categories WHERE id=5 and alias>0 Count is 0
Query 38: 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: 0.84 seconds.
Number of rows is 1
Creating online with Array as row
Query 39: 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: 0.85 seconds.
Query 40: 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: 0.87 seconds.
Number of rows is 1
Creating online with Array as row
Load time so far: 0.87 seconds.
Query 41: 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.
A ' doesn't affect descriptions, but special Microsoft characters that look much like ' have been known to mess things up: http://bugs.mysql.com/bug.php?id=21972
The bug report says "this happens if i'm using charset=latin1 in the connectionstring, if set it to utf8 it works fine." WSN recommends utf8 for everyone now, and I believe this was one of the reasons. Are you using utf8?
Paul wrote: A ' doesn't affect descriptions, but special Microsoft characters that look much like ' have been known to mess things up: http://bugs.mysql.com/bug.php?id=21972
The bug report says "this happens if i'm using charset=latin1 in the connectionstring, if set it to utf8 it works fine." WSN recommends utf8 for everyone now, and I believe this was one of the reasons. Are you using utf8?
yes, it says utf8. I don't believe I changed this part from the original WSN template. I actually tested this to make sure it's not a weird character that I copied over from a site - the error occurs when I type the ' on my keyboard.
okay fine, maybe it's just my site again and I screwed up some settings somewhere, or maybe it had to do with the descriptions being pulled from the meta tags... I'll keep an eye out for more cases like this and let you know.
Now we're a few upgrades further down the road (5.1.19) and on a different server (I don't have to manually tweak .htaccess after each setting change anymore *yay*), but this problem just re-appeared. The pages are not blank anymore, but produce some nice error messages and hide the link descriptions. I didn't fix it so you can see it: link-lounge.com/thelinks/in...om=yes&TID=custom-newlinks
You can see the script is complaining about this description: "A female blogger's take on the geeky. Videogames, software, technology, online media and more." As soon as I replace the ' in blogger's with a ยด the error is gone. When I put it back it's there again. And this is a description that was added by the link owner. I am using the plain editor, WYSIWYG isn't activated.
You have some sort of template php that uses single quotes, and therefore breaks when there's a single quote in the text it's checking. Tell me what you have in your template below the </table> that would be showing up as this: <? echo substr('A female blogger's take on the geeky. Videogames, software, technology, online media and more.', 0, 150); ?>
This is not part of the standard templates, so I need to know what you're doing.
Now that you're actually pointing it out I feel a bit stupid. It's this line:
echo substr('A female blogger's take on the geeky. ...', 0, 150);
Obviously the ' in blogger's is breaking it. I just don't know what to replace it with, since both ' and " appear in descriptions. Or is there another way to simply limit the output of the description to 150 characters? Of course I set the limit to the text field on the submission and edit pages, but it seems there are ways around it, like copy&paste the text or use the Meta Tag button, and I get a lot of descriptions that are way longer than this. I thought this was an easy way out...
ETA: I just read about the summary switch - that should work, right? I turned it on and set the limit to 150. As no link actually has a summary the descriptions should be limited to 150, no?
Comments on Dead Link checking error/blank pages
Forum Regular
Usergroup: Customer
Joined: May 11, 2003
Total Topics: 64
Total Comments: 199
I found some small issues:
when running the dead link check I get a couple of little textboxes with these error messages:
and
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:
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.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
A ' doesn't affect descriptions, but special Microsoft characters that look much like ' have been known to mess things up: http://bugs.mysql.com/bug.php?id=21972
The bug report says "this happens if i'm using charset=latin1 in the connectionstring, if set
it to utf8 it works fine." WSN recommends utf8 for everyone now, and I believe this was one of the reasons. Are you using utf8?
Forum Regular
Usergroup: Customer
Joined: May 11, 2003
Total Topics: 64
Total Comments: 199
A ' doesn't affect descriptions, but special Microsoft characters that look much like ' have been known to mess things up: http://bugs.mysql.com/bug.php?id=21972
The bug report says "this happens if i'm using charset=latin1 in the connectionstring, if set
it to utf8 it works fine." WSN recommends utf8 for everyone now, and I believe this was one of the reasons. Are you using utf8?
yes, it says utf8. I don't believe I changed this part from the original WSN template. I actually tested this to make sure it's not a weird character that I copied over from a site - the error occurs when I type the ' on my keyboard.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Can you give me more detail? Here's a screenshot of what I thought you meant but it's fine so maybe you mean something totally different...
Attached Files:
Forum Regular
Usergroup: Customer
Joined: May 11, 2003
Total Topics: 64
Total Comments: 199
okay fine, maybe it's just my site again and I screwed up some settings somewhere, or maybe it had to do with the descriptions being pulled from the meta tags...
I'll keep an eye out for more cases like this and let you know.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
maybe it had to do with the descriptions being pulled from the meta tags.
Could. Can you give an exact procedure? Tell me whether you're using the plain or WYSIWYG editor as well.
Forum Regular
Usergroup: Customer
Joined: May 11, 2003
Total Topics: 64
Total Comments: 199
Now we're a few upgrades further down the road (5.1.19) and on a different server (I don't have to manually tweak .htaccess after each setting change anymore *yay*), but this problem just re-appeared. The pages are not blank anymore, but produce some nice error messages and hide the link descriptions. I didn't fix it so you can see it:
link-lounge.com/thelinks/in...om=yes&TID=custom-newlinks
You can see the script is complaining about this description: "A female blogger's take on the geeky. Videogames, software, technology, online media and more." As soon as I replace the ' in blogger's with a ยด the error is gone. When I put it back it's there again. And this is a description that was added by the link owner. I am using the plain editor, WYSIWYG isn't activated.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
You have some sort of template php that uses single quotes, and therefore breaks when there's a single quote in the text it's checking. Tell me what you have in your template below the </table> that would be showing up as this:
<?
echo substr('A female blogger's take on the geeky. Videogames, software, technology, online media and more.', 0, 150);
?>
This is not part of the standard templates, so I need to know what you're doing.
Forum Regular
Usergroup: Customer
Joined: May 11, 2003
Total Topics: 64
Total Comments: 199
Now that you're actually pointing it out I feel a bit stupid. It's this line:
echo substr('A female blogger's take on the geeky. ...', 0, 150);
Obviously the ' in blogger's is breaking it. I just don't know what to replace it with, since both ' and " appear in descriptions. Or is there another way to simply limit the output of the description to 150 characters? Of course I set the limit to the text field on the submission and edit pages, but it seems there are ways around it, like copy&paste the text or use the Meta Tag button, and I get a lot of descriptions that are way longer than this. I thought this was an easy way out...
ETA: I just read about the summary switch - that should work, right? I turned it on and set the limit to 150. As no link actually has a summary the descriptions should be limited to 150, no?
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Don't use PHP for that, use {LINKDESCRIPTION[150]}
scripts.webmastersite.net/w.../listing-variables-10.html