Server Timeout when opening Categories: WSN Support

WSN Support » WSN Links » Server Timeout when opening Categories » Server Timeout when opening Categories

Server Timeout when opening Categories
I get a server timeout error when opening any cate

Version:

Server Timeout when opening Categories

Tantalus
Beginner

Usergroup: Member
Joined: May 03, 2004
Total Topics: 1
Total Posts: 2

Posted 10/15/04 - 10:36 AM:	#1
I have a new install of WSN3.12. There are only a few catetories (five including one subcategory) and 12 links. There were a few test links which have been deleted. Main page opens without trouble (maybe a little slow) but when I try to go to any of the categories, there is a long delay and I get a server timeout error (having exceeded the 30 second timeout on server). I have tried to regenerate the counters but encountered the following when I tried to use generate all counters option: The message "Updating next 12 links starting at 75" displayed, then said all links had been updated. (Again there are only 12 links altogether.) Then there are the following errors when updating categories: "Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/thesearc/public_html/classes/database.php on line 72 Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/thesearc/public_html/classes/database.php on line 59" and the message "Updating next categories starting at 0" seems to be in an endless loop, until I close it down. I thought this might be a problem with the database so I went to phpmyAdmin and repaired the database, but this had no effect. Any help would be most appreciated. Many thanks.

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6316

Posted 10/16/04 - 03:57 AM:	#2
Are you using url rewriting, or did you change something about categories before this happened? Warning: mysql_fetch_row(): Read the report procedure thread and manaul troubleshooting and follow those instructions. Edited by Paul on 10/16/04 - 03:59 AM
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

Tantalus
Beginner

Usergroup: Member
Joined: May 03, 2004
Total Topics: 1
Total Posts: 2

Posted 10/18/04 - 02:15 AM:	#3
Not the category, but a link type, found an extraneous ',' which caused it to hang up when loading the categories. Now I see what you mean about looking at debut script. Thanks. However, the regenerate counters still doesn't seem to work. I still get the above mentioned errors when doing a regenerate all, and here is the debug code: "Performing query: SELECT id FROM wsnlinks_categories WHERE id>0 ; Number of rows is 5 for Resource id #43 Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hi de,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,p ermissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments ,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sp onsorlinks,views,customwrap FROM wsnlinks_categories WHERE id>0 AND alias=0 ORDER BY id ASC LIMIT 0,; Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/thesearc/public_html/classes/database.php on line 72 Number of rows is for You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/thesearc/public_html/classes/database.php on line 59 Mysql error while fetching row for :You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND parent=0 AND hide=0 ; You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Number of rows is 4 for Resource id #47 Updating next categories starting at 0 ... " So I tried doing links individually. This went through, counted the 12 existing links, but even though I regenerated the totals, the number on the Admin main page still says 8 links total. I wonder if that is because four of them are aliases and I am just misinterpreting the figure? Could you explain how the link total works. As each alias is assigned its own link number, I thought they would be counted as unique links in the totals, but maybe this isn't the case? Also, are the totals of hits in and hits out specific to each alias, or to them all in one total? I do mean alias, not copy. Many thanks in advance.

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6316

Posted 10/18/04 - 09:23 PM:	#4
ORDER BY id ASC LIMIT 0,; How many did you tell it to regenerate per cycle? It appears as though you made the box blank.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

You don't have permission to post.

Please login or register.