When going to the category in question without debug on:
Fatal error: Maximum execution time of 30 seconds exceeded in /home/jjvh82b/public_html/commonfuncs.php on line 428
When going to the category in question with debug on: Load time so far: 0.09 seconds. Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 ORDER BY id DESC LIMIT 0,1;
Warning: Cannot modify header information - headers already sent by (output started at /home/jjvh82b/public_html/classes/database.php:230) in /home/jjvh82b/public_html/prestart.php on line 115
Load time so far: 0.09 seconds. Performing query: SELECT name,value FROM wsnlinks_switches WHERE id>0 ;
Number of rows is 23 for Resource id #31
Load time so far: 0.1 seconds. Performing query: SELECT id,type,original,replacement,description,originalclose,replacementclose,sortorder FROM wsnlinks_markup WHERE type='wsncode' ORDER BY sortorder ;
Number of rows is 5 for Resource id #34
Load time so far: 0.1 seconds. Performing query: SELECT original,replacement,description,id,sortorder FROM wsnlinks_markup WHERE type='smilie' ORDER BY sortorder ;
Number of rows is 13 for Resource id #35
Load time so far: 0.1 seconds. Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 ;
Number of rows is 123 for Resource id #36
Load time so far: 0.1 seconds. Performing query: 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 FROM wsnlinks_membergroups WHERE id>0 ;
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 FROM wsnlinks_categories WHERE validated=1 AND hide=0 ;
Number of rows is 123 for Resource id #40
Load time so far: 0.14 seconds. Performing query: SELECT id,`to`,subject,message,headers,replacement,mime FROM wsnlinks_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,1;
Number of rows is 0 for Resource id #41
Load time so far: 0.14 seconds. Performing query: UPDATE wsnlinks_categories SET views='12' WHERE id=168;
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 FROM wsnlinks_categories WHERE alias=168 ;
Number of rows is 0 for Resource id #43
Warning: Cannot modify header information - headers already sent by (output started at /home/jjvh82b/public_html/classes/database.php:230) in /home/jjvh82b/public_html/commonfuncs.php on line 310
Load time so far: 0.15 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 FROM wsnlinks_categories WHERE parent=168 AND validated=1 AND hide=0 AND isalbum=0 ORDER BY name ASC LIMIT 0,15;
Number of rows is 0 for Resource id #51
Load time so far: 0.15 seconds. Performing query: SELECT id FROM wsnlinks_links WHERE catid=168 AND hide=0 AND validated=1 ;
Number of rows is 4 for Resource id #52
Load time so far: 0.15 seconds. Performing query: SELECT id FROM wsnlinks_links WHERE catid=168 AND validated=1 AND hide=0 AND type='Link' ;
Number of rows is 0 for Resource id #53
Load time so far: 0.15 seconds. Performing query: SELECT id FROM wsnlinks_links WHERE catid=168 AND validated=1 AND hide=0 AND type='Article' ;
Number of rows is 0 for Resource id #54
Load time so far: 0.15 seconds. Performing query: SELECT id FROM wsnlinks_links WHERE catid=168 AND validated=1 AND hide=0 AND type='File' ;
Number of rows is 0 for Resource id #55
Load time so far: 0.15 seconds. Performing query: SELECT id FROM wsnlinks_links WHERE catid=168 AND validated=1 AND hide=0 AND type='Image' ;
Number of rows is 4 for Resource id #56
Load time so far: 0.16 seconds. Performing query: SELECT id,title,url,description,rating,votes,validated,recipurl,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,hitsin,voterips,voterids,lastedit,customlanguage,filename,filetitle,notify,suspect,downloads,pendingedit,funds,suspended,recipwith,alias,expire,ip,inalbum,typeorder,customoutdated,custommembersection,customviews,customunique,customranking,hitsinips,hitsoutips,type,custommember,testcheck,lastcomment,related,inhidden,viewers,threadviewers,hitsintemp,hitsouttemp,origtype,importance,parentids,timesdead,timesemailed,threadclosed,threadposters FROM wsnlinks_links WHERE catid=168 AND hide=0 AND validated=1 ORDER BY typeorder ASC,rating DESC LIMIT 0,15;
Load time so far: 0.17 seconds. Performing query: 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,customstatistics,custommenus FROM wsnlinks_members WHERE id=1 ;
Load time so far: 0.21 seconds. Performing query: SELECT id FROM wsnlinks_links WHERE catid=168 AND validated=0 ;
Number of rows is 0 for Resource id #59
Load time so far: 0.21 seconds. Performing query: SELECT id FROM wsnlinks_comments WHERE catid=168 AND validated=0 ;
Number of rows is 0 for Resource id #60
Warning: Cannot modify header information - headers already sent by (output started at /home/jjvh82b/public_html/classes/database.php:230) in /home/jjvh82b/public_html/commonfuncs.php on line 310
Warning: Cannot modify header information - headers already sent by (output started at /home/jjvh82b/public_html/classes/database.php:230) in /home/jjvh82b/public_html/end.php on line 29
Load time so far: 0.23 seconds. Performing query: UPDATE wsnlinks_sessions SET starttime='0' WHERE time < 2400;
Load time so far: 0.23 seconds. Performing query: UPDATE wsnlinks_sessions SET time='0' WHERE time < 2400;
Load time so far: 0.23 seconds. Performing query: SELECT starttime FROM wsnlinks_sessions WHERE ip='80.61.71.156' AND memberid=0 ;
Number of rows is 1 for Resource id #63
Load time so far: 0.23 seconds. Performing query: UPDATE wsnlinks_sessions SET time='1104623159', location='[SITE]/index.php?action=displaycat&catid=168', catid='168', threadid='', areaname='Foto's' WHERE ip='80.61.71.156';
Load time so far: 0.36 seconds. Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND (parent = 160 and isalbum = 0) AND alias=0 ;
Number of rows is 10 for Resource id #66
Load time so far: 0.36 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 FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND (parent = 160 and isalbum = 0) AND alias=0 ORDER BY name ASC LIMIT 0,50;
Number of rows is 10 for Resource id #67
Load time so far: 0.36 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 FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND (parent = 160 and isalbum = 0) AND alias=0 ORDER BY name ASC LIMIT 10,50;
Load time so far: 0.37 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 FROM wsnlinks_categories WHERE parent=16 AND validated=1 AND hide=0 ORDER BY name ASC ;
Number of rows is 10 for Resource id #69
Load time so far: 0.4 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 FROM wsnlinks_categories WHERE parent=14 AND validated=1 AND hide=0 ORDER BY name ASC ;
Number of rows is 7 for Resource id #70
Load time so far: 0.43 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 FROM wsnlinks_categories WHERE parent=4 AND validated=1 AND hide=0 ORDER BY name ASC ;
Number of rows is 9 for Resource id #71
Load time so far: 0.46 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 FROM wsnlinks_categories WHERE parent=54 AND validated=1 AND hide=0 ORDER BY name ASC ;
Number of rows is 7 for Resource id #72
Load time so far: 0.49 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 FROM wsnlinks_categories WHERE parent=3 AND validated=1 AND hide=0 ORDER BY name ASC ;
Number of rows is 7 for Resource id #73
Load time so far: 0.52 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 FROM wsnlinks_categories WHERE parent=15 AND validated=1 AND hide=0 ORDER BY name ASC ;
Number of rows is 7 for Resource id #74
Load time so far: 0.54 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 FROM wsnlinks_categories WHERE parent=18 AND validated=1 AND hide=0 ORDER BY name ASC ;
Number of rows is 8 for Resource id #75
Load time so far: 0.57 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 FROM wsnlinks_categories WHERE parent=13 AND validated=1 AND hide=0 ORDER BY name ASC ;
Number of rows is 8 for Resource id #76
Load time so far: 0.6 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 FROM wsnlinks_categories WHERE parent=19 AND validated=1 AND hide=0 ORDER BY name ASC ;
Number of rows is 9 for Resource id #77
Load time so far: 0.63 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 FROM wsnlinks_categories WHERE parent=5 AND validated=1 AND hide=0 ORDER BY name ASC ;
Number of rows is 9 for Resource id #78
Load time so far: 0.66 seconds. Performing query: SELECT id FROM wsnlinks_links WHERE validated=1 AND hide=0 AND inhidden=0 AND alias=0 AND inalbum=0 ;
Number of rows is 529 for Resource id #79
Load time so far: 0.66 seconds. Performing query: SELECT id,title,url,description,rating,votes,validated,recipurl,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,hitsin,voterips,voterids,lastedit,customlanguage,filename,filetitle,notify,suspect,downloads,pendingedit,funds,suspended,recipwith,alias,expire,ip,inalbum,typeorder,customoutdated,custommembersection,customviews,customunique,customranking,hitsinips,hitsoutips,type,custommember,testcheck,lastcomment,related,inhidden,viewers,threadviewers,hitsintemp,hitsouttemp,origtype,importance,parentids,timesdead,timesemailed,threadclosed,threadposters FROM wsnlinks_links WHERE validated=1 AND hide=0 AND inhidden=0 AND alias=0 AND inalbum=0 ORDER BY lastedit DESC LIMIT 0,1;
Number of rows is 1 for Resource id #80
Load time so far: 0.66 seconds. Performing query: SELECT id,title,url,description,rating,votes,validated,recipurl,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,hitsin,voterips,voterids,lastedit,customlanguage,filename,filetitle,notify,suspect,downloads,pendingedit,funds,suspended,recipwith,alias,expire,ip,inalbum,typeorder,customoutdated,custommembersection,customviews,customunique,customranking,hitsinips,hitsoutips,type,custommember,testcheck,lastcomment,related,inhidden,viewers,threadviewers,hitsintemp,hitsouttemp,origtype,importance,parentids,timesdead,timesemailed,threadclosed,threadposters FROM wsnlinks_links WHERE validated=1 AND hide=0 AND inhidden=0 AND alias=0 AND inalbum=0 ORDER BY lastedit DESC LIMIT 1,1;
Fatal error: Maximum execution time of 30 seconds exceeded in /home/jjvh82b/public_html/commonfuncs.php on line 428
Specifics: - The authorization is set to "can't view" for both guests and normal members. - The category in question is a third level subcategory - It contains only four links (linktype: image), no subcategories. - The images themselves were uploaded using the WSN Gallery tarupload.php (from a .gz file). - The page is part of a page on which a category menu is contained, which may account for the amount of queries related to that.
When logged in as the administrator it works normally.
The strangest thing seems to be that the totals don't add up to 30 (nowhere even close).
It really makes no sense to have "30 seconds exceeded" where it says "0.66 seconds" just above. I guess it must be something that's not query-related. Hvae you checked all the suggestions in the manual entry?
If you mean the Troubleshooting manual entry: Yes, now I have. Nothing that seems to help.
Other than that I only see two possible causes:
1. The difference in authorization that the category was set to. I can view the page normally as administrator, yet as guest or normal member it causes an error. It might be going into an eternal loop. (the only thing I changed in authorization is that both can't view this particular category).
2. The uploading of the images using tarupload. It might cause problems when used in combination with WSN Links (as i.e. the xwidth field is missing).
Note: After removing the four images it no longer causes the 30 seconds timeout.
[Sun Jan 2 04:58:06 2005] [error] PHP Fatal error: Maximum execution time of 30 seconds exceeded in /home/jjvh82b/public_html/classes/onelink.php on line 139 [Sun Jan 2 04:57:58 2005] [error] PHP Fatal error: Maximum execution time of 30 seconds exceeded in /home/jjvh82b/public_html/classes/onelink.php on line 106
Test results: (with member & guest can't view) - Guest: He gets the 30 second time out - Member: He gets the 30 second time out - Moderator: He gets to see the files in the category (correctly) - Administrator: He gets to see the files in the category
Test results: (with just guest can't view) - Guest: Can't view (="No") - Member: Can view (=standard) - Moderator: Can view (=standard) - Administrator: Can view (=standard)
Test results: (with all on standard) - Guest: Can view (=standard) - Member: Can view (=standard) - Moderator: Can view (=standard) - Administrator: Can view (=standard)
I looked at the link's in mySQL. Nothing weird seems to be going on. Alot of empty fields (due to batch import), but nothing that looks out of the order.
Can't email it as using the first setting, causes alot of nonsense items to be shown on my main page (see other bug a few bugs back). To prevent that from happening I'm temporarily hiding these categories.
Quantum wrote: Possibly related bug: If I use displaycat & catid to go to the page it doesn't work. Not even for the admin. Instead I'm directed to the main page:
Meaning: "index.php?action=displaycat&catid=160" goes to main page
"index.php?action=displaycat&catid=122" goes to the correct category.
That means the category 160 doesn't exist, or at least that its object can't be created (for which the only reason I can imagine is it not existing).
Comments on Maximum execution time exceeded
Forum Regular
Usergroup: Member
Joined: Jul 01, 2003
Total Topics: 38
Total Comments: 164
When going to the category in question without debug on:
Fatal error: Maximum execution time of 30 seconds exceeded in /home/jjvh82b/public_html/commonfuncs.php on line 428
When going to the category in question with debug on:
Load time so far: 0.09 seconds.
Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 ORDER BY id DESC LIMIT 0,1;
Warning: Cannot modify header information - headers already sent by (output started at /home/jjvh82b/public_html/classes/database.php:230) in /home/jjvh82b/public_html/prestart.php on line 115
Load time so far: 0.09 seconds.
Performing query: SELECT name,value FROM wsnlinks_switches WHERE id>0 ;
Number of rows is 23 for Resource id #31
Load time so far: 0.1 seconds.
Performing query: SELECT id,type,original,replacement,description,originalclose,replacementclose,sortorder FROM wsnlinks_markup WHERE type='wsncode' ORDER BY sortorder ;
Number of rows is 5 for Resource id #34
Load time so far: 0.1 seconds.
Performing query: SELECT original,replacement,description,id,sortorder FROM wsnlinks_markup WHERE type='smilie' ORDER BY sortorder ;
Number of rows is 13 for Resource id #35
Load time so far: 0.1 seconds.
Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 ;
Number of rows is 123 for Resource id #36
Load time so far: 0.1 seconds.
Performing query: 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 FROM wsnlinks_membergroups WHERE id>0 ;
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 FROM wsnlinks_categories WHERE validated=1 AND hide=0 ;
Number of rows is 123 for Resource id #40
Load time so far: 0.14 seconds.
Performing query: SELECT id,`to`,subject,message,headers,replacement,mime FROM wsnlinks_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,1;
Number of rows is 0 for Resource id #41
Load time so far: 0.14 seconds.
Performing query: UPDATE wsnlinks_categories SET views='12' WHERE id=168;
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 FROM wsnlinks_categories WHERE alias=168 ;
Number of rows is 0 for Resource id #43
Warning: Cannot modify header information - headers already sent by (output started at /home/jjvh82b/public_html/classes/database.php:230) in /home/jjvh82b/public_html/commonfuncs.php on line 310
Load time so far: 0.15 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 FROM wsnlinks_categories WHERE parent=168 AND validated=1 AND hide=0 AND isalbum=0 ORDER BY name ASC LIMIT 0,15;
Number of rows is 0 for Resource id #51
Load time so far: 0.15 seconds.
Performing query: SELECT id FROM wsnlinks_links WHERE catid=168 AND hide=0 AND validated=1 ;
Number of rows is 4 for Resource id #52
Load time so far: 0.15 seconds.
Performing query: SELECT id FROM wsnlinks_links WHERE catid=168 AND validated=1 AND hide=0 AND type='Link' ;
Number of rows is 0 for Resource id #53
Load time so far: 0.15 seconds.
Performing query: SELECT id FROM wsnlinks_links WHERE catid=168 AND validated=1 AND hide=0 AND type='Article' ;
Number of rows is 0 for Resource id #54
Load time so far: 0.15 seconds.
Performing query: SELECT id FROM wsnlinks_links WHERE catid=168 AND validated=1 AND hide=0 AND type='File' ;
Number of rows is 0 for Resource id #55
Load time so far: 0.15 seconds.
Performing query: SELECT id FROM wsnlinks_links WHERE catid=168 AND validated=1 AND hide=0 AND type='Image' ;
Number of rows is 4 for Resource id #56
Load time so far: 0.16 seconds.
Performing query: SELECT id,title,url,description,rating,votes,validated,recipurl,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,hitsin,voterips,voterids,lastedit,customlanguage,filename,filetitle,notify,suspect,downloads,pendingedit,funds,suspended,recipwith,alias,expire,ip,inalbum,typeorder,customoutdated,custommembersection,customviews,customunique,customranking,hitsinips,hitsoutips,type,custommember,testcheck,lastcomment,related,inhidden,viewers,threadviewers,hitsintemp,hitsouttemp,origtype,importance,parentids,timesdead,timesemailed,threadclosed,threadposters FROM wsnlinks_links WHERE catid=168 AND hide=0 AND validated=1 ORDER BY typeorder ASC,rating DESC LIMIT 0,15;
Load time so far: 0.17 seconds.
Performing query: 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,customstatistics,custommenus FROM wsnlinks_members WHERE id=1 ;
Load time so far: 0.21 seconds.
Performing query: SELECT id FROM wsnlinks_links WHERE catid=168 AND validated=0 ;
Number of rows is 0 for Resource id #59
Load time so far: 0.21 seconds.
Performing query: SELECT id FROM wsnlinks_comments WHERE catid=168 AND validated=0 ;
Number of rows is 0 for Resource id #60
Warning: Cannot modify header information - headers already sent by (output started at /home/jjvh82b/public_html/classes/database.php:230) in /home/jjvh82b/public_html/commonfuncs.php on line 310
Warning: Cannot modify header information - headers already sent by (output started at /home/jjvh82b/public_html/classes/database.php:230) in /home/jjvh82b/public_html/end.php on line 29
Load time so far: 0.23 seconds.
Performing query: UPDATE wsnlinks_sessions SET starttime='0' WHERE time < 2400;
Load time so far: 0.23 seconds.
Performing query: UPDATE wsnlinks_sessions SET time='0' WHERE time < 2400;
Load time so far: 0.23 seconds.
Performing query: SELECT starttime FROM wsnlinks_sessions WHERE ip='80.61.71.156' AND memberid=0 ;
Number of rows is 1 for Resource id #63
Load time so far: 0.23 seconds.
Performing query: UPDATE wsnlinks_sessions SET time='1104623159', location='[SITE]/index.php?action=displaycat&catid=168', catid='168', threadid='', areaname='Foto's' WHERE ip='80.61.71.156';
Load time so far: 0.36 seconds.
Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND (parent = 160 and isalbum = 0) AND alias=0 ;
Number of rows is 10 for Resource id #66
Load time so far: 0.36 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 FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND (parent = 160 and isalbum = 0) AND alias=0 ORDER BY name ASC LIMIT 0,50;
Number of rows is 10 for Resource id #67
Load time so far: 0.36 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 FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND (parent = 160 and isalbum = 0) AND alias=0 ORDER BY name ASC LIMIT 10,50;
Load time so far: 0.37 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 FROM wsnlinks_categories WHERE parent=16 AND validated=1 AND hide=0 ORDER BY name ASC ;
Number of rows is 10 for Resource id #69
Load time so far: 0.4 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 FROM wsnlinks_categories WHERE parent=14 AND validated=1 AND hide=0 ORDER BY name ASC ;
Number of rows is 7 for Resource id #70
Load time so far: 0.43 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 FROM wsnlinks_categories WHERE parent=4 AND validated=1 AND hide=0 ORDER BY name ASC ;
Number of rows is 9 for Resource id #71
Load time so far: 0.46 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 FROM wsnlinks_categories WHERE parent=54 AND validated=1 AND hide=0 ORDER BY name ASC ;
Number of rows is 7 for Resource id #72
Load time so far: 0.49 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 FROM wsnlinks_categories WHERE parent=3 AND validated=1 AND hide=0 ORDER BY name ASC ;
Number of rows is 7 for Resource id #73
Load time so far: 0.52 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 FROM wsnlinks_categories WHERE parent=15 AND validated=1 AND hide=0 ORDER BY name ASC ;
Number of rows is 7 for Resource id #74
Load time so far: 0.54 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 FROM wsnlinks_categories WHERE parent=18 AND validated=1 AND hide=0 ORDER BY name ASC ;
Number of rows is 8 for Resource id #75
Load time so far: 0.57 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 FROM wsnlinks_categories WHERE parent=13 AND validated=1 AND hide=0 ORDER BY name ASC ;
Number of rows is 8 for Resource id #76
Load time so far: 0.6 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 FROM wsnlinks_categories WHERE parent=19 AND validated=1 AND hide=0 ORDER BY name ASC ;
Number of rows is 9 for Resource id #77
Load time so far: 0.63 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 FROM wsnlinks_categories WHERE parent=5 AND validated=1 AND hide=0 ORDER BY name ASC ;
Number of rows is 9 for Resource id #78
Load time so far: 0.66 seconds.
Performing query: SELECT id FROM wsnlinks_links WHERE validated=1 AND hide=0 AND inhidden=0 AND alias=0 AND inalbum=0 ;
Number of rows is 529 for Resource id #79
Load time so far: 0.66 seconds.
Performing query: SELECT id,title,url,description,rating,votes,validated,recipurl,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,hitsin,voterips,voterids,lastedit,customlanguage,filename,filetitle,notify,suspect,downloads,pendingedit,funds,suspended,recipwith,alias,expire,ip,inalbum,typeorder,customoutdated,custommembersection,customviews,customunique,customranking,hitsinips,hitsoutips,type,custommember,testcheck,lastcomment,related,inhidden,viewers,threadviewers,hitsintemp,hitsouttemp,origtype,importance,parentids,timesdead,timesemailed,threadclosed,threadposters FROM wsnlinks_links WHERE validated=1 AND hide=0 AND inhidden=0 AND alias=0 AND inalbum=0 ORDER BY lastedit DESC LIMIT 0,1;
Number of rows is 1 for Resource id #80
Load time so far: 0.66 seconds.
Performing query: SELECT id,title,url,description,rating,votes,validated,recipurl,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,hitsin,voterips,voterids,lastedit,customlanguage,filename,filetitle,notify,suspect,downloads,pendingedit,funds,suspended,recipwith,alias,expire,ip,inalbum,typeorder,customoutdated,custommembersection,customviews,customunique,customranking,hitsinips,hitsoutips,type,custommember,testcheck,lastcomment,related,inhidden,viewers,threadviewers,hitsintemp,hitsouttemp,origtype,importance,parentids,timesdead,timesemailed,threadclosed,threadposters FROM wsnlinks_links WHERE validated=1 AND hide=0 AND inhidden=0 AND alias=0 AND inalbum=0 ORDER BY lastedit DESC LIMIT 1,1;
Fatal error: Maximum execution time of 30 seconds exceeded in /home/jjvh82b/public_html/commonfuncs.php on line 428
Forum Regular
Usergroup: Member
Joined: Jul 01, 2003
Total Topics: 38
Total Comments: 164
Specifics:
- The authorization is set to "can't view" for both guests and normal members.
- The category in question is a third level subcategory
- It contains only four links (linktype: image), no subcategories.
- The images themselves were uploaded using the WSN Gallery tarupload.php (from a .gz file).
- The page is part of a page on which a category menu is contained, which may account for the amount of queries related to that.
When logged in as the administrator it works normally.
The strangest thing seems to be that the totals don't add up to 30 (nowhere even close).
Forum Regular
Usergroup: Member
Joined: Jul 01, 2003
Total Topics: 38
Total Comments: 164
Note:
Cool that the execution time for the individual parts are now shown =).
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
It really makes no sense to have "30 seconds exceeded" where it says "0.66 seconds" just above. I guess it must be something that's not query-related. Hvae you checked all the suggestions in the manual entry?
Forum Regular
Usergroup: Member
Joined: Jul 01, 2003
Total Topics: 38
Total Comments: 164
If you mean the Troubleshooting manual entry: Yes, now I have. Nothing that seems to help.
Other than that I only see two possible causes:
1. The difference in authorization that the category was set to. I can view the page normally as administrator, yet as guest or normal member it causes an error. It might be going into an eternal loop. (the only thing I changed in authorization is that both can't view this particular category).
2. The uploading of the images using tarupload. It might cause problems when used in combination with WSN Links (as i.e. the xwidth field is missing).
Note: After removing the four images it no longer causes the 30 seconds timeout.
Forum Regular
Usergroup: Member
Joined: Jul 01, 2003
Total Topics: 38
Total Comments: 164
Possibly related bug:
If I use displaycat & catid to go to the page it doesn't work. Not even for the admin. Instead I'm directed to the main page:
Meaning:
"index.php?action=displaycat&catid=160" goes to main page
"index.php?action=displaycat&catid=122" goes to the correct category.
Note: Category name rewriting is on and using the category rewritten name works for both. (well at least it starts loading)
Only difference between the two is that 160 isn't viewable for members nor guests.
Forum Regular
Usergroup: Member
Joined: Jul 01, 2003
Total Topics: 38
Total Comments: 164
This may be helpful: (from my error log)
[Sun Jan 2 04:58:06 2005] [error] PHP Fatal error: Maximum execution time of 30 seconds exceeded in /home/jjvh82b/public_html/classes/onelink.php on line 139
[Sun Jan 2 04:57:58 2005] [error] PHP Fatal error: Maximum execution time of 30 seconds exceeded in /home/jjvh82b/public_html/classes/onelink.php on line 106
Forum Regular
Usergroup: Member
Joined: Jul 01, 2003
Total Topics: 38
Total Comments: 164
If I get another category like this, I'll try changing the authorization and seeing if it still gives the error then.
Forum Regular
Usergroup: Member
Joined: Jul 01, 2003
Total Topics: 38
Total Comments: 164
Ok, found another category.
Test results: (with member & guest can't view)
- Guest: He gets the 30 second time out
- Member: He gets the 30 second time out
- Moderator: He gets to see the files in the category (correctly)
- Administrator: He gets to see the files in the category
Test results: (with just guest can't view)
- Guest: Can't view (="No")
- Member: Can view (=standard)
- Moderator: Can view (=standard)
- Administrator: Can view (=standard)
Test results: (with all on standard)
- Guest: Can view (=standard)
- Member: Can view (=standard)
- Moderator: Can view (=standard)
- Administrator: Can view (=standard)
I looked at the link's in mySQL. Nothing weird seems to be going on. Alot of empty fields (due to batch import), but nothing that looks out of the order.
Can't email it as using the first setting, causes alot of nonsense items to be shown on my main page (see other bug a few bugs back). To prevent that from happening I'm temporarily hiding these categories.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Quantum wrote:
Possibly related bug:
If I use displaycat & catid to go to the page it doesn't work. Not even for the admin. Instead I'm directed to the main page:
Meaning:
"index.php?action=displaycat&catid=160" goes to main page
"index.php?action=displaycat&catid=122" goes to the correct category.
That means the category 160 doesn't exist, or at least that its object can't be created (for which the only reason I can imagine is it not existing).
Forum Regular
Usergroup: Member
Joined: Jul 01, 2003
Total Topics: 38
Total Comments: 164
Going by name to that category works strangely enough. And editting with that number also worked. Weird.
If it happens in a live site again, I'll look into the actual line number mentioned.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Quantum wrote:
I'll look into the actual line number mentioned.
It appears to be mentioning completely random different line numbers in each bit you've posted, so there is no specific line number.
Forum Regular
Usergroup: Member
Joined: Jul 01, 2003
Total Topics: 38
Total Comments: 164
Had this again (in 3.14). Once again with a category which Guests are not allowed to view.
If I try to view it using:
index.php?action=displaycat&catid=10
it times out.
If I try to view it using the
rewritten name (/Leden/)
it works normally.