Hi, I just moved my directory to apache2 from apache1.3 with PHP. Didn't change the data or any of the files, yet when accessing pages that should be showing link entries, the page comes back blank. It correctly shows categories, but clicking on a category with links in it returns a totally blank page.
I turned query trace on for the blank page and it shows result hits, but no page is generated. See below.
Thank you for any ideas.
----
Load time so far: 0.11 seconds. Performing query: 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 FROM wsnlinks_categories WHERE id=37 ;
Load time so far: 0.12 seconds. Performing query: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE;
Load time so far: 0.12 seconds. Performing query: SELECT id,`to`,subject,message,headers,replacement,mime FROM wsnlinks_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10;
Number of rows is 0 for Resource id #50
Load time so far: 0.13 seconds. Performing query: UNLOCK TABLES;
Load time so far: 0.13 seconds. Performing query: SELECT id,frequency,filename,nextrun FROM wsnlinks_crons WHERE nextrun < 1185317333 ORDER BY id ASC LIMIT 0,1;
Number of rows is 0 for Resource id #52
Load time so far: 0.14 seconds. Performing query: 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 FROM wsnlinks_categories WHERE parent=37 AND validated=1 AND hide=0 AND deleted=0 AND isalbum=0 ORDER BY priority ASC,name ASC LIMIT 0,16;
Number of rows is 4 for Resource id #54
Load time so far: 0.17 seconds. Performing query: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=37 AND hide=0 AND deleted=0 AND validated=1 ;
Count is 13
Load time so far: 0.17 seconds. Performing query: UPDATE wsnlinks_categories SET linkshere='13' WHERE id=37;
Load time so far: 0.17 seconds. Performing query: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=37 AND validated=1 AND hide=0 AND deleted=0 AND type='regular' ;
Count is 13
Load time so far: 0.17 seconds. Performing query: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=37 AND validated=1 AND hide=0 AND deleted=0 AND type='recip' ;
Count is 0
Load time so far: 0.18 seconds. Performing query: 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,pagerank,includes,nwnversion,site,ownersite FROM wsnlinks_links WHERE catid=37 AND hide=0 AND deleted=0 AND validated=1 ORDER BY time DESC,title ASC LIMIT 0,10;
Comments on Directory returns blank page
Member
Usergroup: Customer
Joined: May 24, 2006
Total Topics: 11
Total Comments: 26
Hi,
I just moved my directory to apache2 from apache1.3 with PHP. Didn't change the data or any of the files, yet when accessing pages that should be showing link entries, the page comes back blank. It correctly shows categories, but clicking on a category with links in it returns a totally blank page.
I turned query trace on for the blank page and it shows result hits, but no page is generated. See below.
Thank you for any ideas.
----
Load time so far: 0.11 seconds.
Performing query: 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 FROM wsnlinks_categories WHERE id=37 ;
Load time so far: 0.12 seconds.
Performing query: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE;
Load time so far: 0.12 seconds.
Performing query: SELECT id,`to`,subject,message,headers,replacement,mime FROM wsnlinks_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10;
Number of rows is 0 for Resource id #50
Load time so far: 0.13 seconds.
Performing query: UNLOCK TABLES;
Load time so far: 0.13 seconds.
Performing query: SELECT id,frequency,filename,nextrun FROM wsnlinks_crons WHERE nextrun < 1185317333 ORDER BY id ASC LIMIT 0,1;
Number of rows is 0 for Resource id #52
Load time so far: 0.14 seconds.
Performing query: 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 FROM wsnlinks_categories WHERE parent=37 AND validated=1 AND hide=0 AND deleted=0 AND isalbum=0 ORDER BY priority ASC,name ASC LIMIT 0,16;
Number of rows is 4 for Resource id #54
Load time so far: 0.17 seconds.
Performing query: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=37 AND hide=0 AND deleted=0 AND validated=1 ;
Count is 13
Load time so far: 0.17 seconds.
Performing query: UPDATE wsnlinks_categories SET linkshere='13' WHERE id=37;
Load time so far: 0.17 seconds.
Performing query: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=37 AND validated=1 AND hide=0 AND deleted=0 AND type='regular' ;
Count is 13
Load time so far: 0.17 seconds.
Performing query: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=37 AND validated=1 AND hide=0 AND deleted=0 AND type='recip' ;
Count is 0
Load time so far: 0.18 seconds.
Performing query: 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,pagerank,includes,nwnversion,site,ownersite FROM wsnlinks_links WHERE catid=37 AND hide=0 AND deleted=0 AND validated=1 ORDER BY time DESC,title ASC LIMIT 0,10;
Number of rows is 10 for Resource id #58
Member
Usergroup: Customer
Joined: May 24, 2006
Total Topics: 11
Total Comments: 26
I found the answer from a related topic. sorry for the extraneous post.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7867
PHP 5.2 requires WSN Links 4.0 or higher.