Webmastersite.net
Register Log In

Maximum execution time exceeded

Comments on Maximum execution time exceeded

Quantum
Forum Regular

Usergroup: Member
Joined: Jul 01, 2003

Total Topics: 38
Total Comments: 164
Quantum
Posted Jan 01, 2005 - 3:50 PM:

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
Quantum
Forum Regular

Usergroup: Member
Joined: Jul 01, 2003

Total Topics: 38
Total Comments: 164
Quantum
Posted Jan 01, 2005 - 3:58 PM:

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).
Quantum
Forum Regular

Usergroup: Member
Joined: Jul 01, 2003

Total Topics: 38
Total Comments: 164
Quantum
Posted Jan 01, 2005 - 3:58 PM:

Note:
Cool that the execution time for the individual parts are now shown =).
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Jan 01, 2005 - 10:48 PM:

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?
Quantum
Forum Regular

Usergroup: Member
Joined: Jul 01, 2003

Total Topics: 38
Total Comments: 164
Quantum
Posted Jan 02, 2005 - 10:42 AM:

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.
Quantum
Forum Regular

Usergroup: Member
Joined: Jul 01, 2003

Total Topics: 38
Total Comments: 164
Quantum
Posted Jan 02, 2005 - 10:45 AM:

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.
Quantum
Forum Regular

Usergroup: Member
Joined: Jul 01, 2003

Total Topics: 38
Total Comments: 164
Quantum
Posted Jan 02, 2005 - 11:29 AM:

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
Quantum
Forum Regular

Usergroup: Member
Joined: Jul 01, 2003

Total Topics: 38
Total Comments: 164
Quantum
Posted Jan 02, 2005 - 11:37 AM:

If I get another category like this, I'll try changing the authorization and seeing if it still gives the error then.
Quantum
Forum Regular

Usergroup: Member
Joined: Jul 01, 2003

Total Topics: 38
Total Comments: 164
Quantum
Posted Jan 02, 2005 - 3:27 PM:

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.
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
#10 - Quote - Permalink
Posted Jan 03, 2005 - 1:01 AM:

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).
Quantum
Forum Regular

Usergroup: Member
Joined: Jul 01, 2003

Total Topics: 38
Total Comments: 164
Quantum
#11 - Quote - Permalink
Posted Jan 03, 2005 - 1:47 PM:

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.
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
#12 - Quote - Permalink
Posted Jan 03, 2005 - 4:38 PM:

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.
Quantum
Forum Regular

Usergroup: Member
Joined: Jul 01, 2003

Total Topics: 38
Total Comments: 164
Quantum
#13 - Quote - Permalink
Posted Mar 16, 2005 - 10:54 AM:

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.
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



This thread is closed, so you cannot post a reply.