That's just a random section of the admin wrapper. It doesn't make any sense if there was no context. There wasn't even an <html> or <body> tag in the page source?
You only have to regenerate before you want the site to show everything correctly to visitors. If you're not on a live site, and you're just going to be doing another import, don't bother regenerating until all imports are done.
I see.... But paul...any idea when it shows the javascript stuff ? it seems to be showing that after a long regeneration..... But then im not sure if the work is done....
html or body tag...i dont know. I see that in the right frame paul.... as the left frame with menu's still show.. As im importing cats again now (the slower way) and added a few cats before regenerating i saw the same script code again.... So it deffinately happens when the info gets to much.... But its weird as it worked without these errors before....
I think the regeneration process could use some attention on this...
Whatever web browser you use is bound to have a "view frame source" option. Right click in the frame and select that option. Until I get that source, I don't know anything about the page you're seeing.
when upgrading from 4.1.45 to latest 5... At the bottom you see: Out of memory; restart server and try again (needed 524280 bytes) Updating next 35 categories starting at 35 (out of 3940)...
Out of memory ? Thats bull paul..... Its given all the memory it needs... Also the cats shown (3940) is not correct ! Its much more then that.
i get the following on regenerating.....
An error occoured at localhost/wsn50/admin/updat...lidated=&skippermissions=1 on 2008-07-20 20:27:27. Please relay this data to support. Error #2: 'mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given' in C:\xampp\htdocs\wsn50\databases\mysqli.php on line 42. Debug info:
Query 1: SELECT `name`,`content` FROM wsnlinks_settings WHERE type is NULL OR type != 'special'
Load time so far: 0.03 seconds.
Number of rows is 455
Load time so far: 0.05 seconds.
Query 2: SHOW TABLES LIKE 'wsnlinks\_%'
Query 3: SELECT `name`,`value` FROM wsnlinks_switches
Load time so far: 0.06 seconds.
Getting all fields for table membergroupstable
Query 4: 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` FROM wsnlinks_membergroups
Load time so far: 0.06 seconds.
Getting all fields for table memberstable
Query 5: 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`,`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`,`calsub`,`macros`,`guestnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss`,`positivepct`,`notifytrader`,`inactiveemail` FROM wsnlinks_members WHERE id = '1' AND validated = 1
Load time so far: 0.07 seconds.
Query 6: SELECT `name`,`content` FROM wsnlinks_settings WHERE type='special'
Load time so far: 0.08 seconds.
Number of rows is 15
Query 7: SELECT `name`,`content` FROM wsnlinks_settings WHERE type='special'
Load time so far: 0.09 seconds.
Number of rows is 15
Load time so far: 0.09 seconds.
Query 8: SELECT COUNT(id) FROM wsnlinks_categories WHERE isalbum=0 AND deleted=0 AND alias=0 Count is 3940
Getting all fields for table categoriestable
Query 9: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`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` FROM wsnlinks_categories WHERE isalbum=0 AND deleted=0 AND alias=0 ORDER BY id ASC LIMIT 0,35
Load time so far: 0.1 seconds.
Number of rows is 35
Query 10: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=0
Load time so far: 0.11 seconds.
Load time so far: 0.11 seconds.
Query 11: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=1 AND validated=1 AND hide=0 AND deleted=0 Count is 30
Load time so far: 0.12 seconds.
Query 12: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=1 AND hide=0 AND deleted=0 AND validated=1 Count is 0
Load time so far: 0.12 seconds.
Query 13: SELECT COUNT(id) FROM wsnlinks_links WHERE (catid=1 OR parentids LIKE '%|1|%') AND hide=0 AND deleted=0 AND validated=1 AND (inhidden=0 OR inalbum=1) Count is 5365
Load time so far: 0.33 seconds.
Query 14: SELECT COUNT(id) FROM wsnlinks_comments WHERE (catid=1 OR parentids LIKE '%|1|%') AND hide=0 AND validated=1 AND deleted=0 Count is 0
Query 15: SELECT `time` FROM wsnlinks_links WHERE catid=1 AND deleted=0 AND validated=1 ORDER BY time DESC
Load time so far: 0.33 seconds.
Query 16: SELECT `ownerid`,`postername`,`time`,`linkid` FROM wsnlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 1, %' OR catid = 1) ORDER BY time DESC LIMIT 0,1
Load time so far: 0.33 seconds.
Load time so far: 0.33 seconds.
Query 17: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=1 AND deleted=0 AND validated=0 Count is 0
Load time so far: 0.33 seconds.
Query 18: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=1 AND deleted=0 AND validated=0 Count is 0
Load time so far: 0.33 seconds.
Query 19: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=1 AND deleted=0 AND hide=0 AND validated=1 Count is 30
Getting all fields for table categoriestable
Query 20: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`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` FROM wsnlinks_categories WHERE parent=1 AND deleted=0 AND hide=0 AND validated=1 ORDER BY priority ASC,name ASC LIMIT 0,7
Load time so far: 0.36 seconds.
Number of rows is 7
Load time so far: 0.36 seconds.
Query 21: UPDATE wsnlinks_links SET parentids='' WHERE catid=1
Query 23: UPDATE wsnlinks_categories SET levelsdeep='0' WHERE id=1
Query 24: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=1
Load time so far: 0.36 seconds.
Query 25: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=0 AND validated=1
Load time so far: 0.36 seconds.
Load time so far: 0.36 seconds.
Query 26: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=2 AND validated=1 AND hide=0 AND deleted=0 Count is 0
Load time so far: 0.37 seconds.
Query 27: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=2 AND hide=0 AND deleted=0 AND validated=1 Count is 165
Load time so far: 0.37 seconds.
Query 28: SELECT COUNT(id) FROM wsnlinks_links WHERE (catid=2 OR parentids LIKE '%|2|%') AND hide=0 AND deleted=0 AND validated=1 AND (inhidden=0 OR inalbum=1) Count is 165
Load time so far: 0.58 seconds.
Query 29: SELECT COUNT(id) FROM wsnlinks_comments WHERE (catid=2 OR parentids LIKE '%|2|%') AND hide=0 AND validated=1 AND deleted=0 Count is 0
Query 30: SELECT `time` FROM wsnlinks_links WHERE catid=2 AND deleted=0 AND validated=1 ORDER BY time DESC
Load time so far: 0.58 seconds.
Query 31: SELECT `ownerid`,`postername`,`time`,`linkid` FROM wsnlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 2, %' OR catid = 2) ORDER BY time DESC LIMIT 0,1
Load time so far: 0.58 seconds.
Load time so far: 0.58 seconds.
Query 32: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=2 AND deleted=0 AND validated=0 Count is 0
Load time so far: 0.58 seconds.
Query 33: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=2 AND deleted=0 AND validated=0 Count is 0
Load time so far: 0.58 seconds.
Query 34: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=2 AND deleted=0 AND hide=0 AND validated=1 Count is 0
Getting all fields for table categoriestable
Query 35: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`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` FROM wsnlinks_categories WHERE parent=2 AND deleted=0 AND hide=0 AND validated=1 ORDER BY priority ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 0.61 seconds.
Number of rows is 0
Load time so far: 0.61 seconds.
Query 36: UPDATE wsnlinks_links SET parentids=', 1, ' WHERE catid=2
Query 38: UPDATE wsnlinks_categories SET levelsdeep='1' WHERE id=2
Query 39: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=1
Load time so far: 0.61 seconds.
Query 40: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=0 AND validated=1
Load time so far: 0.61 seconds.
Load time so far: 0.61 seconds.
Query 41: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=3 AND validated=1 AND hide=0 AND deleted=0 Count is 32
Load time so far: 0.62 seconds.
Query 42: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=3 AND hide=0 AND deleted=0 AND validated=1 Count is 0
Load time so far: 0.62 seconds.
Query 43: SELECT COUNT(id) FROM wsnlinks_links WHERE (catid=3 OR parentids LIKE '%|3|%') AND hide=0 AND deleted=0 AND validated=1 AND (inhidden=0 OR inalbum=1) Count is 762
Load time so far: 0.83 seconds.
Query 44: SELECT COUNT(id) FROM wsnlinks_comments WHERE (catid=3 OR parentids LIKE '%|3|%') AND hide=0 AND validated=1 AND deleted=0 Count is 0
Query 45: SELECT `time` FROM wsnlinks_links WHERE catid=3 AND deleted=0 AND validated=1 ORDER BY time DESC
Load time so far: 0.83 seconds.
Query 46: SELECT `ownerid`,`postername`,`time`,`linkid` FROM wsnlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 3, %' OR catid = 3) ORDER BY time DESC LIMIT 0,1
Load time so far: 0.83 seconds.
Load time so far: 0.83 seconds.
Query 47: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=3 AND deleted=0 AND validated=0 Count is 0
Load time so far: 0.83 seconds.
Query 48: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=3 AND deleted=0 AND validated=0 Count is 0
Load time so far: 0.83 seconds.
Query 49: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=3 AND deleted=0 AND hide=0 AND validated=1 Count is 32
Getting all fields for table categoriestable
Query 50: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`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` FROM wsnlinks_categories WHERE parent=3 AND deleted=0 AND hide=0 AND validated=1 ORDER BY priority ASC,name ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 0.85 seconds.
Number of rows is 7
Load time so far: 0.86 seconds.
Query 51: UPDATE wsnlinks_links SET parentids=', 1, ' WHERE catid=3
Query 53: UPDATE wsnlinks_categories SET levelsdeep='1' WHERE id=3
Query 54: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=3
Load time so far: 0.86 seconds.
Query 55: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=1 AND validated=1
Load time so far: 0.86 seconds.
Query 56: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=0 AND validated=1
Load time so far: 0.86 seconds.
Load time so far: 0.86 seconds.
Query 57: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=4 AND validated=1 AND hide=0 AND deleted=0 Count is 0
Load time so far: 0.87 seconds.
Query 58: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=4 AND hide=0 AND deleted=0 AND validated=1 Count is 0
Load time so far: 0.87 seconds.
Query 59: SELECT COUNT(id) FROM wsnlinks_links WHERE (catid=4 OR parentids LIKE '%|4|%') AND hide=0 AND deleted=0 AND validated=1 AND (inhidden=0 OR inalbum=1) Count is 0
Load time so far: 1.07 seconds.
Query 60: SELECT COUNT(id) FROM wsnlinks_comments WHERE (catid=4 OR parentids LIKE '%|4|%') AND hide=0 AND validated=1 AND deleted=0 Count is 0
Query 61: SELECT `time` FROM wsnlinks_links WHERE catid=4 AND deleted=0 AND validated=1 ORDER BY time DESC
Load time so far: 1.07 seconds.
Query 62: SELECT `ownerid`,`postername`,`time`,`linkid` FROM wsnlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 4, %' OR catid = 4) ORDER BY time DESC LIMIT 0,1
Load time so far: 1.07 seconds.
Load time so far: 1.07 seconds.
Query 63: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=4 AND deleted=0 AND validated=0 Count is 0
Load time so far: 1.07 seconds.
Query 64: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=4 AND deleted=0 AND validated=0 Count is 0
Load time so far: 1.07 seconds.
Query 65: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=4 AND deleted=0 AND hide=0 AND validated=1 Count is 0
Getting all fields for table categoriestable
Query 66: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`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` FROM wsnlinks_categories WHERE parent=4 AND deleted=0 AND hide=0 AND validated=1 ORDER BY priority ASC,name ASC,name ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 1.1 seconds.
Number of rows is 0
Load time so far: 1.1 seconds.
Query 67: UPDATE wsnlinks_links SET parentids=', 3, 1, ' WHERE catid=4
Query 69: UPDATE wsnlinks_categories SET levelsdeep='2' WHERE id=4
Query 70: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=3
Load time so far: 1.1 seconds.
Query 71: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=1 AND validated=1
Load time so far: 1.1 seconds.
Query 72: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=0 AND validated=1
Load time so far: 1.11 seconds.
Load time so far: 1.11 seconds.
Query 73: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=5 AND validated=1 AND hide=0 AND deleted=0 Count is 0
Load time so far: 1.12 seconds.
Query 74: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=5 AND hide=0 AND deleted=0 AND validated=1 Count is 3
Load time so far: 1.12 seconds.
Query 75: SELECT COUNT(id) FROM wsnlinks_links WHERE (catid=5 OR parentids LIKE '%|5|%') AND hide=0 AND deleted=0 AND validated=1 AND (inhidden=0 OR inalbum=1) Count is 3
Load time so far: 1.32 seconds.
Query 76: SELECT COUNT(id) FROM wsnlinks_comments WHERE (catid=5 OR parentids LIKE '%|5|%') AND hide=0 AND validated=1 AND deleted=0 Count is 0
Query 77: SELECT `time` FROM wsnlinks_links WHERE catid=5 AND deleted=0 AND validated=1 ORDER BY time DESC
Load time so far: 1.32 seconds.
Query 78: SELECT `ownerid`,`postername`,`time`,`linkid` FROM wsnlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 5, %' OR catid = 5) ORDER BY time DESC LIMIT 0,1
Load time so far: 1.32 seconds.
Load time so far: 1.32 seconds.
Query 79: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=5 AND deleted=0 AND validated=0 Count is 0
Load time so far: 1.32 seconds.
Query 80: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=5 AND deleted=0 AND validated=0 Count is 0
Load time so far: 1.32 seconds.
Query 81: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=5 AND deleted=0 AND hide=0 AND validated=1 Count is 0
Getting all fields for table categoriestable
Query 82: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`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` FROM wsnlinks_categories WHERE parent=5 AND deleted=0 AND hide=0 AND validated=1 ORDER BY priority ASC,name ASC,name ASC,name ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 1.35 seconds.
Number of rows is 0
Load time so far: 1.35 seconds.
Query 83: UPDATE wsnlinks_links SET parentids=', 3, 1, ' WHERE catid=5
Query 85: UPDATE wsnlinks_categories SET levelsdeep='2' WHERE id=5
Query 86: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=3
Load time so far: 1.35 seconds.
Query 87: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=1 AND validated=1
Load time so far: 1.35 seconds.
Query 88: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=0 AND validated=1
Load time so far: 1.35 seconds.
Load time so far: 1.35 seconds.
Query 89: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=6 AND validated=1 AND hide=0 AND deleted=0 Count is 0
Load time so far: 1.37 seconds.
Query 90: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=6 AND hide=0 AND deleted=0 AND validated=1 Count is 2
Load time so far: 1.37 seconds.
Query 91: SELECT COUNT(id) FROM wsnlinks_links WHERE (catid=6 OR parentids LIKE '%|6|%') AND hide=0 AND deleted=0 AND validated=1 AND (inhidden=0 OR inalbum=1) Count is 2
Load time so far: 1.57 seconds.
Query 92: SELECT COUNT(id) FROM wsnlinks_comments WHERE (catid=6 OR parentids LIKE '%|6|%') AND hide=0 AND validated=1 AND deleted=0 Count is 0
Query 93: SELECT `time` FROM wsnlinks_links WHERE catid=6 AND deleted=0 AND validated=1 ORDER BY time DESC
Load time so far: 1.57 seconds.
Query 94: SELECT `ownerid`,`postername`,`time`,`linkid` FROM wsnlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 6, %' OR catid = 6) ORDER BY time DESC LIMIT 0,1
Load time so far: 1.57 seconds.
Load time so far: 1.57 seconds.
Query 95: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=6 AND deleted=0 AND validated=0 Count is 0
Load time so far: 1.57 seconds.
Query 96: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=6 AND deleted=0 AND validated=0 Count is 0
Load time so far: 1.57 seconds.
Query 97: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=6 AND deleted=0 AND hide=0 AND validated=1 Count is 0
Getting all fields for table categoriestable
Query 98: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`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` FROM wsnlinks_categories WHERE parent=6 AND deleted=0 AND hide=0 AND validated=1 ORDER BY priority ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 1.6 seconds.
Number of rows is 0
Load time so far: 1.6 seconds.
Query 99: UPDATE wsnlinks_links SET parentids=', 3, 1, ' WHERE catid=6
Query 101: UPDATE wsnlinks_categories SET levelsdeep='2' WHERE id=6
Query 102: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=3
Load time so far: 1.6 seconds.
Query 103: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=1 AND validated=1
Load time so far: 1.6 seconds.
Query 104: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=0 AND validated=1
Load time so far: 1.6 seconds.
Load time so far: 1.6 seconds.
Query 105: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=7 AND validated=1 AND hide=0 AND deleted=0 Count is 0
Load time so far: 1.61 seconds.
Query 106: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=7 AND hide=0 AND deleted=0 AND validated=1 Count is 2
Load time so far: 1.61 seconds.
Query 107: SELECT COUNT(id) FROM wsnlinks_links WHERE (catid=7 OR parentids LIKE '%|7|%') AND hide=0 AND deleted=0 AND validated=1 AND (inhidden=0 OR inalbum=1) Count is 2
Load time so far: 1.81 seconds.
Query 108: SELECT COUNT(id) FROM wsnlinks_comments WHERE (catid=7 OR parentids LIKE '%|7|%') AND hide=0 AND validated=1 AND deleted=0 Count is 0
Query 109: SELECT `time` FROM wsnlinks_links WHERE catid=7 AND deleted=0 AND validated=1 ORDER BY time DESC
Load time so far: 1.81 seconds.
Query 110: SELECT `ownerid`,`postername`,`time`,`linkid` FROM wsnlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 7, %' OR catid = 7) ORDER BY time DESC LIMIT 0,1
Load time so far: 1.82 seconds.
Load time so far: 1.82 seconds.
Query 111: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=7 AND deleted=0 AND validated=0 Count is 0
Load time so far: 1.82 seconds.
Query 112: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=7 AND deleted=0 AND validated=0 Count is 0
Load time so far: 1.82 seconds.
Query 113: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=7 AND deleted=0 AND hide=0 AND validated=1 Count is 0
Getting all fields for table categoriestable
Query 114: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`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` FROM wsnlinks_categories WHERE parent=7 AND deleted=0 AND hide=0 AND validated=1 ORDER BY priority ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 1.84 seconds.
Number of rows is 0
Load time so far: 1.84 seconds.
Query 115: UPDATE wsnlinks_links SET parentids=', 3, 1, ' WHERE catid=7
Query 117: UPDATE wsnlinks_categories SET levelsdeep='2' WHERE id=7
Query 118: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=3
Load time so far: 1.85 seconds.
Query 119: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=1 AND validated=1
Load time so far: 1.85 seconds.
Query 120: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=0 AND validated=1
Load time so far: 1.85 seconds.
Load time so far: 1.85 seconds.
Query 121: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=8 AND validated=1 AND hide=0 AND deleted=0 Count is 0
Load time so far: 1.86 seconds.
Query 122: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=8 AND hide=0 AND deleted=0 AND validated=1 Count is 37
Load time so far: 1.86 seconds.
Query 123: SELECT COUNT(id) FROM wsnlinks_links WHERE (catid=8 OR parentids LIKE '%|8|%') AND hide=0 AND deleted=0 AND validated=1 AND (inhidden=0 OR inalbum=1) Count is 37
Load time so far: 2.06 seconds.
Query 124: SELECT COUNT(id) FROM wsnlinks_comments WHERE (catid=8 OR parentids LIKE '%|8|%') AND hide=0 AND validated=1 AND deleted=0 Count is 0
Query 125: SELECT `time` FROM wsnlinks_links WHERE catid=8 AND deleted=0 AND validated=1 ORDER BY time DESC
Load time so far: 2.06 seconds.
Query 126: SELECT `ownerid`,`postername`,`time`,`linkid` FROM wsnlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 8, %' OR catid = 8) ORDER BY time DESC LIMIT 0,1
Load time so far: 2.06 seconds.
Load time so far: 2.06 seconds.
Query 127: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=8 AND deleted=0 AND validated=0 Count is 0
Load time so far: 2.06 seconds.
Query 128: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=8 AND deleted=0 AND validated=0 Count is 0
Load time so far: 2.06 seconds.
Query 129: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=8 AND deleted=0 AND hide=0 AND validated=1 Count is 0
Getting all fields for table categoriestable
Query 130: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`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` FROM wsnlinks_categories WHERE parent=8 AND deleted=0 AND hide=0 AND validated=1 ORDER BY priority ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 2.09 seconds.
Number of rows is 0
Load time so far: 2.09 seconds.
Query 131: UPDATE wsnlinks_links SET parentids=', 3, 1, ' WHERE catid=8
Query 133: UPDATE wsnlinks_categories SET levelsdeep='2' WHERE id=8
Query 134: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=3
Load time so far: 2.09 seconds.
Query 135: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=1 AND validated=1
Load time so far: 2.09 seconds.
Query 136: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=0 AND validated=1
Load time so far: 2.09 seconds.
Load time so far: 2.09 seconds.
Query 137: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=9 AND validated=1 AND hide=0 AND deleted=0 Count is 0
Load time so far: 2.11 seconds.
Query 138: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=9 AND hide=0 AND deleted=0 AND validated=1 Count is 24
Load time so far: 2.11 seconds.
Query 139: SELECT COUNT(id) FROM wsnlinks_links WHERE (catid=9 OR parentids LIKE '%|9|%') AND hide=0 AND deleted=0 AND validated=1 AND (inhidden=0 OR inalbum=1) Count is 24
Load time so far: 2.31 seconds.
Query 140: SELECT COUNT(id) FROM wsnlinks_comments WHERE (catid=9 OR parentids LIKE '%|9|%') AND hide=0 AND validated=1 AND deleted=0 Count is 0
Query 141: SELECT `time` FROM wsnlinks_links WHERE catid=9 AND deleted=0 AND validated=1 ORDER BY time DESC
Load time so far: 2.31 seconds.
Query 142: SELECT `ownerid`,`postername`,`time`,`linkid` FROM wsnlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 9, %' OR catid = 9) ORDER BY time DESC LIMIT 0,1
Load time so far: 2.31 seconds.
Load time so far: 2.31 seconds.
Query 143: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=9 AND deleted=0 AND validated=0 Count is 0
Load time so far: 2.31 seconds.
Query 144: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=9 AND deleted=0 AND validated=0 Count is 0
Load time so far: 2.31 seconds.
Query 145: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=9 AND deleted=0 AND hide=0 AND validated=1 Count is 0
Getting all fields for table categoriestable
Query 146: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`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` FROM wsnlinks_categories WHERE parent=9 AND deleted=0 AND hide=0 AND validated=1 ORDER BY priority ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 2.34 seconds.
Number of rows is 0
Load time so far: 2.34 seconds.
Query 147: UPDATE wsnlinks_links SET parentids=', 3, 1, ' WHERE catid=9
Query 149: UPDATE wsnlinks_categories SET levelsdeep='2' WHERE id=9
Query 150: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=3
Load time so far: 2.34 seconds.
Query 151: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=1 AND validated=1
Load time so far: 2.34 seconds.
Query 152: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=0 AND validated=1
Load time so far: 2.34 seconds.
Load time so far: 2.34 seconds.
Query 153: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=10 AND validated=1 AND hide=0 AND deleted=0 Count is 0
Load time so far: 2.35 seconds.
Query 154: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=10 AND hide=0 AND deleted=0 AND validated=1 Count is 35
Load time so far: 2.35 seconds.
Query 155: SELECT COUNT(id) FROM wsnlinks_links WHERE (catid=10 OR parentids LIKE '%|10|%') AND hide=0 AND deleted=0 AND validated=1 AND (inhidden=0 OR inalbum=1) Count is 35
Load time so far: 2.55 seconds.
Query 156: SELECT COUNT(id) FROM wsnlinks_comments WHERE (catid=10 OR parentids LIKE '%|10|%') AND hide=0 AND validated=1 AND deleted=0 Count is 0
Query 157: SELECT `time` FROM wsnlinks_links WHERE catid=10 AND deleted=0 AND validated=1 ORDER BY time DESC
Load time so far: 2.55 seconds.
Query 158: SELECT `ownerid`,`postername`,`time`,`linkid` FROM wsnlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 10, %' OR catid = 10) ORDER BY time DESC LIMIT 0,1
Load time so far: 2.55 seconds.
Load time so far: 2.55 seconds.
Query 159: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=10 AND deleted=0 AND validated=0 Count is 0
Load time so far: 2.55 seconds.
Query 160: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=10 AND deleted=0 AND validated=0 Count is 0
Load time so far: 2.55 seconds.
Query 161: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=10 AND deleted=0 AND hide=0 AND validated=1 Count is 0
Getting all fields for table categoriestable
Query 162: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`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` FROM wsnlinks_categories WHERE parent=10 AND deleted=0 AND hide=0 AND validated=1 ORDER BY priority ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 2.58 seconds.
Number of rows is 0
Load time so far: 2.58 seconds.
Query 163: UPDATE wsnlinks_links SET parentids=', 3, 1, ' WHERE catid=10
Query 165: UPDATE wsnlinks_categories SET levelsdeep='2' WHERE id=10
Query 166: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=3
Load time so far: 2.58 seconds.
Query 167: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=1 AND validated=1
Load time so far: 2.58 seconds.
Query 168: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=0 AND validated=1
Load time so far: 2.58 seconds.
Load time so far: 2.58 seconds.
Query 169: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=11 AND validated=1 AND hide=0 AND deleted=0 Count is 0
Load time so far: 2.59 seconds.
Query 170: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=11 AND hide=0 AND deleted=0 AND validated=1 Count is 42
Load time so far: 2.6 seconds.
Query 171: SELECT COUNT(id) FROM wsnlinks_links WHERE (catid=11 OR parentids LIKE '%|11|%') AND hide=0 AND deleted=0 AND validated=1 AND (inhidden=0 OR inalbum=1) Count is 42
Load time so far: 2.79 seconds.
Query 172: SELECT COUNT(id) FROM wsnlinks_comments WHERE (catid=11 OR parentids LIKE '%|11|%') AND hide=0 AND validated=1 AND deleted=0 Count is 0
Query 173: SELECT `time` FROM wsnlinks_links WHERE catid=11 AND deleted=0 AND validated=1 ORDER BY time DESC
Load time so far: 2.79 seconds.
Query 174: SELECT `ownerid`,`postername`,`time`,`linkid` FROM wsnlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 11, %' OR catid = 11) ORDER BY time DESC LIMIT 0,1
Load time so far: 2.79 seconds.
Load time so far: 2.79 seconds.
Query 175: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=11 AND deleted=0 AND validated=0 Count is 0
Load time so far: 2.79 seconds.
Query 176: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=11 AND deleted=0 AND validated=0 Count is 0
Load time so far: 2.79 seconds.
Query 177: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=11 AND deleted=0 AND hide=0 AND validated=1 Count is 0
Getting all fields for table categoriestable
Query 178: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`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` FROM wsnlinks_categories WHERE parent=11 AND deleted=0 AND hide=0 AND validated=1 ORDER BY priority ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 2.83 seconds.
Number of rows is 0
Load time so far: 2.83 seconds.
Query 179: UPDATE wsnlinks_links SET parentids=', 3, 1, ' WHERE catid=11
Query 181: UPDATE wsnlinks_categories SET levelsdeep='2' WHERE id=11
Query 182: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=3
Load time so far: 2.83 seconds.
Query 183: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=1 AND validated=1
Load time so far: 2.83 seconds.
Query 184: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=0 AND validated=1
Load time so far: 2.83 seconds.
Load time so far: 2.83 seconds.
Query 185: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=12 AND validated=1 AND hide=0 AND deleted=0 Count is 0
Load time so far: 2.84 seconds.
Query 186: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=12 AND hide=0 AND deleted=0 AND validated=1 Count is 16
Load time so far: 2.84 seconds.
Query 187: SELECT COUNT(id) FROM wsnlinks_links WHERE (catid=12 OR parentids LIKE '%|12|%') AND hide=0 AND deleted=0 AND validated=1 AND (inhidden=0 OR inalbum=1) Count is 16
Load time so far: 3.04 seconds.
Query 188: SELECT COUNT(id) FROM wsnlinks_comments WHERE (catid=12 OR parentids LIKE '%|12|%') AND hide=0 AND validated=1 AND deleted=0 Count is 0
Query 189: SELECT `time` FROM wsnlinks_links WHERE catid=12 AND deleted=0 AND validated=1 ORDER BY time DESC
Load time so far: 3.04 seconds.
Query 190: SELECT `ownerid`,`postername`,`time`,`linkid` FROM wsnlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 12, %' OR catid = 12) ORDER BY time DESC LIMIT 0,1
Load time so far: 3.04 seconds.
Load time so far: 3.04 seconds.
Query 191: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=12 AND deleted=0 AND validated=0 Count is 0
Load time so far: 3.04 seconds.
Query 192: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=12 AND deleted=0 AND validated=0 Count is 0
Load time so far: 3.04 seconds.
Query 193: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=12 AND deleted=0 AND hide=0 AND validated=1 Count is 0
Getting all fields for table categoriestable
Query 194: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`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` FROM wsnlinks_categories WHERE parent=12 AND deleted=0 AND hide=0 AND validated=1 ORDER BY priority ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 3.07 seconds.
Number of rows is 0
Load time so far: 3.07 seconds.
Query 195: UPDATE wsnlinks_links SET parentids=', 3, 1, ' WHERE catid=12
Query 197: UPDATE wsnlinks_categories SET levelsdeep='2' WHERE id=12
Query 198: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=3
Load time so far: 3.07 seconds.
Query 199: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=1 AND validated=1
Load time so far: 3.07 seconds.
Query 200: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=0 AND validated=1
Load time so far: 3.07 seconds.
Load time so far: 3.07 seconds.
Query 201: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=13 AND validated=1 AND hide=0 AND deleted=0 Count is 0
Load time so far: 3.08 seconds.
Query 202: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=13 AND hide=0 AND deleted=0 AND validated=1 Count is 8
Load time so far: 3.08 seconds.
Query 203: SELECT COUNT(id) FROM wsnlinks_links WHERE (catid=13 OR parentids LIKE '%|13|%') AND hide=0 AND deleted=0 AND validated=1 AND (inhidden=0 OR inalbum=1) Count is 8
Load time so far: 3.28 seconds.
Query 204: SELECT COUNT(id) FROM wsnlinks_comments WHERE (catid=13 OR parentids LIKE '%|13|%') AND hide=0 AND validated=1 AND deleted=0 Count is 0
Query 205: SELECT `time` FROM wsnlinks_links WHERE catid=13 AND deleted=0 AND validated=1 ORDER BY time DESC
Load time so far: 3.28 seconds.
Query 206: SELECT `ownerid`,`postername`,`time`,`linkid` FROM wsnlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 13, %' OR catid = 13) ORDER BY time DESC LIMIT 0,1
Load time so far: 3.28 seconds.
Load time so far: 3.28 seconds.
Query 207: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=13 AND deleted=0 AND validated=0 Count is 0
Load time so far: 3.28 seconds.
Query 208: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=13 AND deleted=0 AND validated=0 Count is 0
Load time so far: 3.28 seconds.
Query 209: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=13 AND deleted=0 AND hide=0 AND validated=1 Count is 0
Getting all fields for table categoriestable
Query 210: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`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` FROM wsnlinks_categories WHERE parent=13 AND deleted=0 AND hide=0 AND validated=1 ORDER BY priority ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 3.31 seconds.
Number of rows is 0
Load time so far: 3.31 seconds.
Query 211: UPDATE wsnlinks_links SET parentids=', 3, 1, ' WHERE catid=13
Query 213: UPDATE wsnlinks_categories SET levelsdeep='2' WHERE id=13
Query 214: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=3
Load time so far: 3.31 seconds.
Query 215: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=1 AND validated=1
Load time so far: 3.31 seconds.
Query 216: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=0 AND validated=1
Load time so far: 3.31 seconds.
Load time so far: 3.31 seconds.
Query 217: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=14 AND validated=1 AND hide=0 AND deleted=0 Count is 0
Load time so far: 3.32 seconds.
Query 218: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=14 AND hide=0 AND deleted=0 AND validated=1 Count is 12
Load time so far: 3.32 seconds.
Query 219: SELECT COUNT(id) FROM wsnlinks_links WHERE (catid=14 OR parentids LIKE '%|14|%') AND hide=0 AND deleted=0 AND validated=1 AND (inhidden=0 OR inalbum=1) Count is 12
Load time so far: 3.52 seconds.
Query 220: SELECT COUNT(id) FROM wsnlinks_comments WHERE (catid=14 OR parentids LIKE '%|14|%') AND hide=0 AND validated=1 AND deleted=0 Count is 0
Query 221: SELECT `time` FROM wsnlinks_links WHERE catid=14 AND deleted=0 AND validated=1 ORDER BY time DESC
Load time so far: 3.52 seconds.
Query 222: SELECT `ownerid`,`postername`,`time`,`linkid` FROM wsnlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 14, %' OR catid = 14) ORDER BY time DESC LIMIT 0,1
Load time so far: 3.52 seconds.
Load time so far: 3.52 seconds.
Query 223: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=14 AND deleted=0 AND validated=0 Count is 0
Load time so far: 3.52 seconds.
Query 224: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=14 AND deleted=0 AND validated=0 Count is 0
Load time so far: 3.52 seconds.
Query 225: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=14 AND deleted=0 AND hide=0 AND validated=1 Count is 0
Getting all fields for table categoriestable
Query 226: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`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` FROM wsnlinks_categories WHERE parent=14 AND deleted=0 AND hide=0 AND validated=1 ORDER BY priority ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 3.55 seconds.
Number of rows is 0
Load time so far: 3.55 seconds.
Query 227: UPDATE wsnlinks_links SET parentids=', 3, 1, ' WHERE catid=14
Query 229: UPDATE wsnlinks_categories SET levelsdeep='2' WHERE id=14
Query 230: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=3
Load time so far: 3.55 seconds.
Query 231: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=1 AND validated=1
Load time so far: 3.55 seconds.
Query 232: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=0 AND validated=1
Load time so far: 3.55 seconds.
Load time so far: 3.55 seconds.
Query 233: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=15 AND validated=1 AND hide=0 AND deleted=0 Count is 0
Load time so far: 3.56 seconds.
Query 234: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=15 AND hide=0 AND deleted=0 AND validated=1 Count is 16
Load time so far: 3.56 seconds.
Query 235: SELECT COUNT(id) FROM wsnlinks_links WHERE (catid=15 OR parentids LIKE '%|15|%') AND hide=0 AND deleted=0 AND validated=1 AND (inhidden=0 OR inalbum=1) Count is 16
Load time so far: 3.76 seconds.
Query 236: SELECT COUNT(id) FROM wsnlinks_comments WHERE (catid=15 OR parentids LIKE '%|15|%') AND hide=0 AND validated=1 AND deleted=0 Count is 0
Query 237: SELECT `time` FROM wsnlinks_links WHERE catid=15 AND deleted=0 AND validated=1 ORDER BY time DESC
Load time so far: 3.76 seconds.
Query 238: SELECT `ownerid`,`postername`,`time`,`linkid` FROM wsnlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 15, %' OR catid = 15) ORDER BY time DESC LIMIT 0,1
Load time so far: 3.76 seconds.
Load time so far: 3.76 seconds.
Query 239: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=15 AND deleted=0 AND validated=0 Count is 0
Load time so far: 3.76 seconds.
Query 240: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=15 AND deleted=0 AND validated=0 Count is 0
Load time so far: 3.76 seconds.
Query 241: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=15 AND deleted=0 AND hide=0 AND validated=1 Count is 0
Getting all fields for table categoriestable
Query 242: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`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` FROM wsnlinks_categories WHERE parent=15 AND deleted=0 AND hide=0 AND validated=1 ORDER BY priority ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 3.79 seconds.
Number of rows is 0
Load time so far: 3.79 seconds.
Query 243: UPDATE wsnlinks_links SET parentids=', 3, 1, ' WHERE catid=15
paul, must be something wrong. with new install 5.0.B6 and using small dmoz import files only total links and cats show,but nothing shows inside.....it stays at 0 Also secondary cats are not created... so there's deffinately something wrong there....
It took almost 24 hours of testing and im positive that i found what the problem is when importing files that are to big and the regenerating process drops dead after some time. All the time i was working with Firefox 2 and never tried it all with Internet explorer 7. The toggle javascript error i saw every time (from dynamicdrive) gave me idea that it might not be fully cross browser compatible. A person on the dynamicdrive forum was also wondering about that.
After testing it fully on 3 categories I'm pretty sure now.
My findings are:
With Firefox 2 and you import a large file like 2 or 3 mb it can drop dead after some time. And then when you still go ahead and start the regenerating then that process also stops when it does 20 or 30.000 links.
With Internet explorer 7 i was able to finish all processes successfully except the import. Even with Internet explorer 7 with an import of 4 MB file at some point the browser shows the standard page of a website not being available and if you have an Internet connection... But i noticed when i looked at my computer running processes that the importer was still working,something Firefox didn't do. So in short....the right page (right frame) went blank but all was still running..
At some point i could see the importing was done , as no processes showed anymore. After that i clicked the regenerate everything and it started and finished successfully and updated everything. Thats also something Firefox didn't do,that gave errors all the time.
But i think that the regenerating is difficult to run on a server enviroment,when having so many links. My computer has 2 duo CPU 2.66GHz and with the running import and regenerating process it pulled 53% constantly of the resources.
So i think hosts aren't to happy giving such memory so the script can run to regenerate up to 60,70,or 100.000 links. Naturally this is a situation that doesn't happen often but it can give problems if you want to import huge lists.
It is of course fully firefox compatible. I don't have IE. Tested in Firefox 3, Opera 9.27 and Konqueror. The HTML page is nowhere near 2 or 3 megabytes -- more like 100KB. Though I have loaded 10MB HTML files in Firefox. The amound of memory the server uses on backend stuff is unknown to the web browser.
People running google-sized databases shouldn't be on shared web hosts anyway.
been busy with this for 24 hours of regenerating etc.... I had 10 categories with over 50.000 links but after adding one more category it now has a problem doing what it should have done....counting cats and links of the last added. Sure it shows as a total but on front.....nothing shows at all. And when you do a search on one of the last links added it actualy shows that its in the category that doesnt show ! how weird can it be ? So im not the programmer here but to me it looks like the reneration process fails a bit when it all gets to big..
You generate report files in the wrong format and they won't work, as discussed much earlier. You generate a report file more than a megabyte and tulipchain is bound to have missed stuff, and it's not supported anyhow since the instructions say <1K links.
Verified yet again that all the proper report files work in 4.1.x. 5.0 will take a couple hours to regenerate but I expect the result to be the same.
Web browsers have no knowledge of the size of report files and regeneration has once again been verified to work the same in every browser. Your browser must be misconfigured or have a malfunctioning extension.
0/5
1
2
3
4
5
Sorry, you don't have permission to post posts. Log in, or register if you haven't yet.
Comments on DMOZ importer
Forum Regular
Usergroup: Customer
Joined: Jul 09, 2008
Total Topics: 22
Total Comments: 110
"figure out what you want to import and do all at once so you only have to regenerate it once"
You mean...you dont have to regenerate after an import ?
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
That's just a random section of the admin wrapper. It doesn't make any sense if there was no context. There wasn't even an <html> or <body> tag in the page source?
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
You only have to regenerate before you want the site to show everything correctly to visitors. If you're not on a live site, and you're just going to be doing another import, don't bother regenerating until all imports are done.
Forum Regular
Usergroup: Customer
Joined: Jul 09, 2008
Total Topics: 22
Total Comments: 110
I see....
But paul...any idea when it shows the javascript stuff ?
it seems to be showing that after a long regeneration.....
But then im not sure if the work is done....
Forum Regular
Usergroup: Customer
Joined: Jul 09, 2008
Total Topics: 22
Total Comments: 110
html or body tag...i dont know.
I see that in the right frame paul....
as the left frame with menu's still show..
As im importing cats again now (the slower way) and added a few cats before regenerating i saw the same script code again....
So it deffinately happens when the info gets to much....
But its weird as it worked without these errors before....
I think the regeneration process could use some attention on this...
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Whatever web browser you use is bound to have a "view frame source" option. Right click in the frame and select that option. Until I get that source, I don't know anything about the page you're seeing.
Forum Regular
Usergroup: Customer
Joined: Jul 09, 2008
Total Topics: 22
Total Comments: 110
when upgrading from 4.1.45 to latest 5...
At the bottom you see:
Out of memory; restart server and try again (needed 524280 bytes)
Updating next 35 categories starting at 35 (out of 3940)...
Out of memory ?
Thats bull paul.....
Its given all the memory it needs...
Also the cats shown (3940) is not correct !
Its much more then that.
i get the following on regenerating.....
An error occoured at localhost/wsn50/admin/updat...lidated=&skippermissions=1 on 2008-07-20 20:27:27. Please relay this data to support. Error #2: 'mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given' in C:\xampp\htdocs\wsn50\databases\mysqli.php on line 42. Debug info:
Query 1: SELECT `name`,`content` FROM wsnlinks_settings WHERE type is NULL OR type != 'special'
Load time so far: 0.03 seconds.
Number of rows is 455
Load time so far: 0.05 seconds.
Query 2: SHOW TABLES LIKE 'wsnlinks\_%'
Query 3: SELECT `name`,`value` FROM wsnlinks_switches
Load time so far: 0.06 seconds.
Getting all fields for table membergroupstable
Query 4: 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` FROM wsnlinks_membergroups
Load time so far: 0.06 seconds.
Getting all fields for table memberstable
Query 5: 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`,`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`,`calsub`,`macros`,`guestnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss`,`positivepct`,`notifytrader`,`inactiveemail` FROM wsnlinks_members WHERE id = '1' AND validated = 1
Load time so far: 0.07 seconds.
Query 6: SELECT `name`,`content` FROM wsnlinks_settings WHERE type='special'
Load time so far: 0.08 seconds.
Number of rows is 15
Query 7: SELECT `name`,`content` FROM wsnlinks_settings WHERE type='special'
Load time so far: 0.09 seconds.
Number of rows is 15
Load time so far: 0.09 seconds.
Query 8: SELECT COUNT(id) FROM wsnlinks_categories WHERE isalbum=0 AND deleted=0 AND alias=0
Count is 3940
Getting all fields for table categoriestable
Query 9: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`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` FROM wsnlinks_categories WHERE isalbum=0 AND deleted=0 AND alias=0 ORDER BY id ASC LIMIT 0,35
Load time so far: 0.1 seconds.
Number of rows is 35
Query 10: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=0
Load time so far: 0.11 seconds.
Load time so far: 0.11 seconds.
Query 11: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=1 AND validated=1 AND hide=0 AND deleted=0
Count is 30
Load time so far: 0.12 seconds.
Query 12: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=1 AND hide=0 AND deleted=0 AND validated=1
Count is 0
Load time so far: 0.12 seconds.
Query 13: SELECT COUNT(id) FROM wsnlinks_links WHERE (catid=1 OR parentids LIKE '%|1|%') AND hide=0 AND deleted=0 AND validated=1 AND (inhidden=0 OR inalbum=1)
Count is 5365
Load time so far: 0.33 seconds.
Query 14: SELECT COUNT(id) FROM wsnlinks_comments WHERE (catid=1 OR parentids LIKE '%|1|%') AND hide=0 AND validated=1 AND deleted=0
Count is 0
Query 15: SELECT `time` FROM wsnlinks_links WHERE catid=1 AND deleted=0 AND validated=1 ORDER BY time DESC
Load time so far: 0.33 seconds.
Query 16: SELECT `ownerid`,`postername`,`time`,`linkid` FROM wsnlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 1, %' OR catid = 1) ORDER BY time DESC LIMIT 0,1
Load time so far: 0.33 seconds.
Load time so far: 0.33 seconds.
Query 17: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=1 AND deleted=0 AND validated=0
Count is 0
Load time so far: 0.33 seconds.
Query 18: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=1 AND deleted=0 AND validated=0
Count is 0
Load time so far: 0.33 seconds.
Query 19: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=1 AND deleted=0 AND hide=0 AND validated=1
Count is 30
Getting all fields for table categoriestable
Query 20: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`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` FROM wsnlinks_categories WHERE parent=1 AND deleted=0 AND hide=0 AND validated=1 ORDER BY priority ASC,name ASC LIMIT 0,7
Load time so far: 0.36 seconds.
Number of rows is 7
Load time so far: 0.36 seconds.
Query 21: UPDATE wsnlinks_links SET parentids='' WHERE catid=1
Load time so far: 0.36 seconds.
Query 22: UPDATE wsnlinks_categories SET subhtml = '', totalcomments = '0', lastlinktime = '', parentids = '', parentnames = '', numsub = '30', numlinks = '5365', linkshere = '0', levelsdeep = '0', unvalidatedlinks = '0', unvalidatedcomments = '0', lastposterid = '', lastpostername = '', lastcommenttime = '0', lastthreadid = '', lastthreadtitle = '', lastposturl = '', lastthreadurl = '', lastprofileurl = '' WHERE id=1
Load time so far: 0.36 seconds.
Unknown column 'subhtml' in 'field list'
Query 23: UPDATE wsnlinks_categories SET levelsdeep='0' WHERE id=1
Query 24: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=1
Load time so far: 0.36 seconds.
Query 25: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=0 AND validated=1
Load time so far: 0.36 seconds.
Load time so far: 0.36 seconds.
Query 26: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=2 AND validated=1 AND hide=0 AND deleted=0
Count is 0
Load time so far: 0.37 seconds.
Query 27: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=2 AND hide=0 AND deleted=0 AND validated=1
Count is 165
Load time so far: 0.37 seconds.
Query 28: SELECT COUNT(id) FROM wsnlinks_links WHERE (catid=2 OR parentids LIKE '%|2|%') AND hide=0 AND deleted=0 AND validated=1 AND (inhidden=0 OR inalbum=1)
Count is 165
Load time so far: 0.58 seconds.
Query 29: SELECT COUNT(id) FROM wsnlinks_comments WHERE (catid=2 OR parentids LIKE '%|2|%') AND hide=0 AND validated=1 AND deleted=0
Count is 0
Query 30: SELECT `time` FROM wsnlinks_links WHERE catid=2 AND deleted=0 AND validated=1 ORDER BY time DESC
Load time so far: 0.58 seconds.
Query 31: SELECT `ownerid`,`postername`,`time`,`linkid` FROM wsnlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 2, %' OR catid = 2) ORDER BY time DESC LIMIT 0,1
Load time so far: 0.58 seconds.
Load time so far: 0.58 seconds.
Query 32: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=2 AND deleted=0 AND validated=0
Count is 0
Load time so far: 0.58 seconds.
Query 33: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=2 AND deleted=0 AND validated=0
Count is 0
Load time so far: 0.58 seconds.
Query 34: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=2 AND deleted=0 AND hide=0 AND validated=1
Count is 0
Getting all fields for table categoriestable
Query 35: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`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` FROM wsnlinks_categories WHERE parent=2 AND deleted=0 AND hide=0 AND validated=1 ORDER BY priority ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 0.61 seconds.
Number of rows is 0
Load time so far: 0.61 seconds.
Query 36: UPDATE wsnlinks_links SET parentids=', 1, ' WHERE catid=2
Load time so far: 0.61 seconds.
Query 37: UPDATE wsnlinks_categories SET subhtml = '', totalcomments = '0', lastlinktime = '1215978818', parentids = ', 1, ', parentnames = ', Computers, ', numsub = '0', numlinks = '165', linkshere = '165', levelsdeep = '1', unvalidatedlinks = '0', unvalidatedcomments = '0', lastposterid = '', lastpostername = '', lastcommenttime = '0', lastthreadid = '', lastthreadtitle = '', lastposturl = '', lastthreadurl = '', lastprofileurl = '' WHERE id=2
Load time so far: 0.61 seconds.
Unknown column 'subhtml' in 'field list'
Query 38: UPDATE wsnlinks_categories SET levelsdeep='1' WHERE id=2
Query 39: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=1
Load time so far: 0.61 seconds.
Query 40: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=0 AND validated=1
Load time so far: 0.61 seconds.
Load time so far: 0.61 seconds.
Query 41: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=3 AND validated=1 AND hide=0 AND deleted=0
Count is 32
Load time so far: 0.62 seconds.
Query 42: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=3 AND hide=0 AND deleted=0 AND validated=1
Count is 0
Load time so far: 0.62 seconds.
Query 43: SELECT COUNT(id) FROM wsnlinks_links WHERE (catid=3 OR parentids LIKE '%|3|%') AND hide=0 AND deleted=0 AND validated=1 AND (inhidden=0 OR inalbum=1)
Count is 762
Load time so far: 0.83 seconds.
Query 44: SELECT COUNT(id) FROM wsnlinks_comments WHERE (catid=3 OR parentids LIKE '%|3|%') AND hide=0 AND validated=1 AND deleted=0
Count is 0
Query 45: SELECT `time` FROM wsnlinks_links WHERE catid=3 AND deleted=0 AND validated=1 ORDER BY time DESC
Load time so far: 0.83 seconds.
Query 46: SELECT `ownerid`,`postername`,`time`,`linkid` FROM wsnlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 3, %' OR catid = 3) ORDER BY time DESC LIMIT 0,1
Load time so far: 0.83 seconds.
Load time so far: 0.83 seconds.
Query 47: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=3 AND deleted=0 AND validated=0
Count is 0
Load time so far: 0.83 seconds.
Query 48: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=3 AND deleted=0 AND validated=0
Count is 0
Load time so far: 0.83 seconds.
Query 49: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=3 AND deleted=0 AND hide=0 AND validated=1
Count is 32
Getting all fields for table categoriestable
Query 50: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`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` FROM wsnlinks_categories WHERE parent=3 AND deleted=0 AND hide=0 AND validated=1 ORDER BY priority ASC,name ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 0.85 seconds.
Number of rows is 7
Load time so far: 0.86 seconds.
Query 51: UPDATE wsnlinks_links SET parentids=', 1, ' WHERE catid=3
Load time so far: 0.86 seconds.
Query 52: UPDATE wsnlinks_categories SET subhtml = '', totalcomments = '0', lastlinktime = '', parentids = ', 1, ', parentnames = ', Computers, ', numsub = '32', numlinks = '762', linkshere = '0', levelsdeep = '1', unvalidatedlinks = '0', unvalidatedcomments = '0', lastposterid = '', lastpostername = '', lastcommenttime = '0', lastthreadid = '', lastthreadtitle = '', lastposturl = '', lastthreadurl = '', lastprofileurl = '' WHERE id=3
Load time so far: 0.86 seconds.
Unknown column 'subhtml' in 'field list'
Query 53: UPDATE wsnlinks_categories SET levelsdeep='1' WHERE id=3
Query 54: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=3
Load time so far: 0.86 seconds.
Query 55: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=1 AND validated=1
Load time so far: 0.86 seconds.
Query 56: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=0 AND validated=1
Load time so far: 0.86 seconds.
Load time so far: 0.86 seconds.
Query 57: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=4 AND validated=1 AND hide=0 AND deleted=0
Count is 0
Load time so far: 0.87 seconds.
Query 58: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=4 AND hide=0 AND deleted=0 AND validated=1
Count is 0
Load time so far: 0.87 seconds.
Query 59: SELECT COUNT(id) FROM wsnlinks_links WHERE (catid=4 OR parentids LIKE '%|4|%') AND hide=0 AND deleted=0 AND validated=1 AND (inhidden=0 OR inalbum=1)
Count is 0
Load time so far: 1.07 seconds.
Query 60: SELECT COUNT(id) FROM wsnlinks_comments WHERE (catid=4 OR parentids LIKE '%|4|%') AND hide=0 AND validated=1 AND deleted=0
Count is 0
Query 61: SELECT `time` FROM wsnlinks_links WHERE catid=4 AND deleted=0 AND validated=1 ORDER BY time DESC
Load time so far: 1.07 seconds.
Query 62: SELECT `ownerid`,`postername`,`time`,`linkid` FROM wsnlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 4, %' OR catid = 4) ORDER BY time DESC LIMIT 0,1
Load time so far: 1.07 seconds.
Load time so far: 1.07 seconds.
Query 63: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=4 AND deleted=0 AND validated=0
Count is 0
Load time so far: 1.07 seconds.
Query 64: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=4 AND deleted=0 AND validated=0
Count is 0
Load time so far: 1.07 seconds.
Query 65: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=4 AND deleted=0 AND hide=0 AND validated=1
Count is 0
Getting all fields for table categoriestable
Query 66: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`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` FROM wsnlinks_categories WHERE parent=4 AND deleted=0 AND hide=0 AND validated=1 ORDER BY priority ASC,name ASC,name ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 1.1 seconds.
Number of rows is 0
Load time so far: 1.1 seconds.
Query 67: UPDATE wsnlinks_links SET parentids=', 3, 1, ' WHERE catid=4
Load time so far: 1.1 seconds.
Query 68: UPDATE wsnlinks_categories SET subhtml = '', totalcomments = '0', lastlinktime = '', parentids = ', 3, 1, ', parentnames = ', Bedrijven, Computers, ', numsub = '0', numlinks = '0', linkshere = '0', levelsdeep = '2', unvalidatedlinks = '0', unvalidatedcomments = '0', lastposterid = '', lastpostername = '', lastcommenttime = '0', lastthreadid = '', lastthreadtitle = '', lastposturl = '', lastthreadurl = '', lastprofileurl = '' WHERE id=4
Load time so far: 1.1 seconds.
Unknown column 'subhtml' in 'field list'
Query 69: UPDATE wsnlinks_categories SET levelsdeep='2' WHERE id=4
Query 70: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=3
Load time so far: 1.1 seconds.
Query 71: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=1 AND validated=1
Load time so far: 1.1 seconds.
Query 72: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=0 AND validated=1
Load time so far: 1.11 seconds.
Load time so far: 1.11 seconds.
Query 73: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=5 AND validated=1 AND hide=0 AND deleted=0
Count is 0
Load time so far: 1.12 seconds.
Query 74: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=5 AND hide=0 AND deleted=0 AND validated=1
Count is 3
Load time so far: 1.12 seconds.
Query 75: SELECT COUNT(id) FROM wsnlinks_links WHERE (catid=5 OR parentids LIKE '%|5|%') AND hide=0 AND deleted=0 AND validated=1 AND (inhidden=0 OR inalbum=1)
Count is 3
Load time so far: 1.32 seconds.
Query 76: SELECT COUNT(id) FROM wsnlinks_comments WHERE (catid=5 OR parentids LIKE '%|5|%') AND hide=0 AND validated=1 AND deleted=0
Count is 0
Query 77: SELECT `time` FROM wsnlinks_links WHERE catid=5 AND deleted=0 AND validated=1 ORDER BY time DESC
Load time so far: 1.32 seconds.
Query 78: SELECT `ownerid`,`postername`,`time`,`linkid` FROM wsnlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 5, %' OR catid = 5) ORDER BY time DESC LIMIT 0,1
Load time so far: 1.32 seconds.
Load time so far: 1.32 seconds.
Query 79: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=5 AND deleted=0 AND validated=0
Count is 0
Load time so far: 1.32 seconds.
Query 80: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=5 AND deleted=0 AND validated=0
Count is 0
Load time so far: 1.32 seconds.
Query 81: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=5 AND deleted=0 AND hide=0 AND validated=1
Count is 0
Getting all fields for table categoriestable
Query 82: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`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` FROM wsnlinks_categories WHERE parent=5 AND deleted=0 AND hide=0 AND validated=1 ORDER BY priority ASC,name ASC,name ASC,name ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 1.35 seconds.
Number of rows is 0
Load time so far: 1.35 seconds.
Query 83: UPDATE wsnlinks_links SET parentids=', 3, 1, ' WHERE catid=5
Load time so far: 1.35 seconds.
Query 84: UPDATE wsnlinks_categories SET subhtml = '', totalcomments = '0', lastlinktime = '1215978818', parentids = ', 3, 1, ', parentnames = ', Bedrijven, Computers, ', numsub = '0', numlinks = '3', linkshere = '3', levelsdeep = '2', unvalidatedlinks = '0', unvalidatedcomments = '0', lastposterid = '', lastpostername = '', lastcommenttime = '0', lastthreadid = '', lastthreadtitle = '', lastposturl = '', lastthreadurl = '', lastprofileurl = '' WHERE id=5
Load time so far: 1.35 seconds.
Unknown column 'subhtml' in 'field list'
Query 85: UPDATE wsnlinks_categories SET levelsdeep='2' WHERE id=5
Query 86: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=3
Load time so far: 1.35 seconds.
Query 87: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=1 AND validated=1
Load time so far: 1.35 seconds.
Query 88: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=0 AND validated=1
Load time so far: 1.35 seconds.
Load time so far: 1.35 seconds.
Query 89: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=6 AND validated=1 AND hide=0 AND deleted=0
Count is 0
Load time so far: 1.37 seconds.
Query 90: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=6 AND hide=0 AND deleted=0 AND validated=1
Count is 2
Load time so far: 1.37 seconds.
Query 91: SELECT COUNT(id) FROM wsnlinks_links WHERE (catid=6 OR parentids LIKE '%|6|%') AND hide=0 AND deleted=0 AND validated=1 AND (inhidden=0 OR inalbum=1)
Count is 2
Load time so far: 1.57 seconds.
Query 92: SELECT COUNT(id) FROM wsnlinks_comments WHERE (catid=6 OR parentids LIKE '%|6|%') AND hide=0 AND validated=1 AND deleted=0
Count is 0
Query 93: SELECT `time` FROM wsnlinks_links WHERE catid=6 AND deleted=0 AND validated=1 ORDER BY time DESC
Load time so far: 1.57 seconds.
Query 94: SELECT `ownerid`,`postername`,`time`,`linkid` FROM wsnlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 6, %' OR catid = 6) ORDER BY time DESC LIMIT 0,1
Load time so far: 1.57 seconds.
Load time so far: 1.57 seconds.
Query 95: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=6 AND deleted=0 AND validated=0
Count is 0
Load time so far: 1.57 seconds.
Query 96: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=6 AND deleted=0 AND validated=0
Count is 0
Load time so far: 1.57 seconds.
Query 97: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=6 AND deleted=0 AND hide=0 AND validated=1
Count is 0
Getting all fields for table categoriestable
Query 98: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`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` FROM wsnlinks_categories WHERE parent=6 AND deleted=0 AND hide=0 AND validated=1 ORDER BY priority ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 1.6 seconds.
Number of rows is 0
Load time so far: 1.6 seconds.
Query 99: UPDATE wsnlinks_links SET parentids=', 3, 1, ' WHERE catid=6
Load time so far: 1.6 seconds.
Query 100: UPDATE wsnlinks_categories SET subhtml = '', totalcomments = '0', lastlinktime = '1215978818', parentids = ', 3, 1, ', parentnames = ', Bedrijven, Computers, ', numsub = '0', numlinks = '2', linkshere = '2', levelsdeep = '2', unvalidatedlinks = '0', unvalidatedcomments = '0', lastposterid = '', lastpostername = '', lastcommenttime = '0', lastthreadid = '', lastthreadtitle = '', lastposturl = '', lastthreadurl = '', lastprofileurl = '' WHERE id=6
Load time so far: 1.6 seconds.
Unknown column 'subhtml' in 'field list'
Query 101: UPDATE wsnlinks_categories SET levelsdeep='2' WHERE id=6
Query 102: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=3
Load time so far: 1.6 seconds.
Query 103: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=1 AND validated=1
Load time so far: 1.6 seconds.
Query 104: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=0 AND validated=1
Load time so far: 1.6 seconds.
Load time so far: 1.6 seconds.
Query 105: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=7 AND validated=1 AND hide=0 AND deleted=0
Count is 0
Load time so far: 1.61 seconds.
Query 106: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=7 AND hide=0 AND deleted=0 AND validated=1
Count is 2
Load time so far: 1.61 seconds.
Query 107: SELECT COUNT(id) FROM wsnlinks_links WHERE (catid=7 OR parentids LIKE '%|7|%') AND hide=0 AND deleted=0 AND validated=1 AND (inhidden=0 OR inalbum=1)
Count is 2
Load time so far: 1.81 seconds.
Query 108: SELECT COUNT(id) FROM wsnlinks_comments WHERE (catid=7 OR parentids LIKE '%|7|%') AND hide=0 AND validated=1 AND deleted=0
Count is 0
Query 109: SELECT `time` FROM wsnlinks_links WHERE catid=7 AND deleted=0 AND validated=1 ORDER BY time DESC
Load time so far: 1.81 seconds.
Query 110: SELECT `ownerid`,`postername`,`time`,`linkid` FROM wsnlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 7, %' OR catid = 7) ORDER BY time DESC LIMIT 0,1
Load time so far: 1.82 seconds.
Load time so far: 1.82 seconds.
Query 111: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=7 AND deleted=0 AND validated=0
Count is 0
Load time so far: 1.82 seconds.
Query 112: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=7 AND deleted=0 AND validated=0
Count is 0
Load time so far: 1.82 seconds.
Query 113: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=7 AND deleted=0 AND hide=0 AND validated=1
Count is 0
Getting all fields for table categoriestable
Query 114: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`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` FROM wsnlinks_categories WHERE parent=7 AND deleted=0 AND hide=0 AND validated=1 ORDER BY priority ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 1.84 seconds.
Number of rows is 0
Load time so far: 1.84 seconds.
Query 115: UPDATE wsnlinks_links SET parentids=', 3, 1, ' WHERE catid=7
Load time so far: 1.85 seconds.
Query 116: UPDATE wsnlinks_categories SET subhtml = '', totalcomments = '0', lastlinktime = '1215978818', parentids = ', 3, 1, ', parentnames = ', Bedrijven, Computers, ', numsub = '0', numlinks = '2', linkshere = '2', levelsdeep = '2', unvalidatedlinks = '0', unvalidatedcomments = '0', lastposterid = '', lastpostername = '', lastcommenttime = '0', lastthreadid = '', lastthreadtitle = '', lastposturl = '', lastthreadurl = '', lastprofileurl = '' WHERE id=7
Load time so far: 1.85 seconds.
Unknown column 'subhtml' in 'field list'
Query 117: UPDATE wsnlinks_categories SET levelsdeep='2' WHERE id=7
Query 118: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=3
Load time so far: 1.85 seconds.
Query 119: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=1 AND validated=1
Load time so far: 1.85 seconds.
Query 120: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=0 AND validated=1
Load time so far: 1.85 seconds.
Load time so far: 1.85 seconds.
Query 121: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=8 AND validated=1 AND hide=0 AND deleted=0
Count is 0
Load time so far: 1.86 seconds.
Query 122: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=8 AND hide=0 AND deleted=0 AND validated=1
Count is 37
Load time so far: 1.86 seconds.
Query 123: SELECT COUNT(id) FROM wsnlinks_links WHERE (catid=8 OR parentids LIKE '%|8|%') AND hide=0 AND deleted=0 AND validated=1 AND (inhidden=0 OR inalbum=1)
Count is 37
Load time so far: 2.06 seconds.
Query 124: SELECT COUNT(id) FROM wsnlinks_comments WHERE (catid=8 OR parentids LIKE '%|8|%') AND hide=0 AND validated=1 AND deleted=0
Count is 0
Query 125: SELECT `time` FROM wsnlinks_links WHERE catid=8 AND deleted=0 AND validated=1 ORDER BY time DESC
Load time so far: 2.06 seconds.
Query 126: SELECT `ownerid`,`postername`,`time`,`linkid` FROM wsnlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 8, %' OR catid = 8) ORDER BY time DESC LIMIT 0,1
Load time so far: 2.06 seconds.
Load time so far: 2.06 seconds.
Query 127: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=8 AND deleted=0 AND validated=0
Count is 0
Load time so far: 2.06 seconds.
Query 128: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=8 AND deleted=0 AND validated=0
Count is 0
Load time so far: 2.06 seconds.
Query 129: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=8 AND deleted=0 AND hide=0 AND validated=1
Count is 0
Getting all fields for table categoriestable
Query 130: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`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` FROM wsnlinks_categories WHERE parent=8 AND deleted=0 AND hide=0 AND validated=1 ORDER BY priority ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 2.09 seconds.
Number of rows is 0
Load time so far: 2.09 seconds.
Query 131: UPDATE wsnlinks_links SET parentids=', 3, 1, ' WHERE catid=8
Load time so far: 2.09 seconds.
Query 132: UPDATE wsnlinks_categories SET subhtml = '', totalcomments = '0', lastlinktime = '1215978818', parentids = ', 3, 1, ', parentnames = ', Bedrijven, Computers, ', numsub = '0', numlinks = '37', linkshere = '37', levelsdeep = '2', unvalidatedlinks = '0', unvalidatedcomments = '0', lastposterid = '', lastpostername = '', lastcommenttime = '0', lastthreadid = '', lastthreadtitle = '', lastposturl = '', lastthreadurl = '', lastprofileurl = '' WHERE id=8
Load time so far: 2.09 seconds.
Unknown column 'subhtml' in 'field list'
Query 133: UPDATE wsnlinks_categories SET levelsdeep='2' WHERE id=8
Query 134: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=3
Load time so far: 2.09 seconds.
Query 135: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=1 AND validated=1
Load time so far: 2.09 seconds.
Query 136: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=0 AND validated=1
Load time so far: 2.09 seconds.
Load time so far: 2.09 seconds.
Query 137: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=9 AND validated=1 AND hide=0 AND deleted=0
Count is 0
Load time so far: 2.11 seconds.
Query 138: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=9 AND hide=0 AND deleted=0 AND validated=1
Count is 24
Load time so far: 2.11 seconds.
Query 139: SELECT COUNT(id) FROM wsnlinks_links WHERE (catid=9 OR parentids LIKE '%|9|%') AND hide=0 AND deleted=0 AND validated=1 AND (inhidden=0 OR inalbum=1)
Count is 24
Load time so far: 2.31 seconds.
Query 140: SELECT COUNT(id) FROM wsnlinks_comments WHERE (catid=9 OR parentids LIKE '%|9|%') AND hide=0 AND validated=1 AND deleted=0
Count is 0
Query 141: SELECT `time` FROM wsnlinks_links WHERE catid=9 AND deleted=0 AND validated=1 ORDER BY time DESC
Load time so far: 2.31 seconds.
Query 142: SELECT `ownerid`,`postername`,`time`,`linkid` FROM wsnlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 9, %' OR catid = 9) ORDER BY time DESC LIMIT 0,1
Load time so far: 2.31 seconds.
Load time so far: 2.31 seconds.
Query 143: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=9 AND deleted=0 AND validated=0
Count is 0
Load time so far: 2.31 seconds.
Query 144: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=9 AND deleted=0 AND validated=0
Count is 0
Load time so far: 2.31 seconds.
Query 145: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=9 AND deleted=0 AND hide=0 AND validated=1
Count is 0
Getting all fields for table categoriestable
Query 146: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`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` FROM wsnlinks_categories WHERE parent=9 AND deleted=0 AND hide=0 AND validated=1 ORDER BY priority ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 2.34 seconds.
Number of rows is 0
Load time so far: 2.34 seconds.
Query 147: UPDATE wsnlinks_links SET parentids=', 3, 1, ' WHERE catid=9
Load time so far: 2.34 seconds.
Query 148: UPDATE wsnlinks_categories SET subhtml = '', totalcomments = '0', lastlinktime = '1215978818', parentids = ', 3, 1, ', parentnames = ', Bedrijven, Computers, ', numsub = '0', numlinks = '24', linkshere = '24', levelsdeep = '2', unvalidatedlinks = '0', unvalidatedcomments = '0', lastposterid = '', lastpostername = '', lastcommenttime = '0', lastthreadid = '', lastthreadtitle = '', lastposturl = '', lastthreadurl = '', lastprofileurl = '' WHERE id=9
Load time so far: 2.34 seconds.
Unknown column 'subhtml' in 'field list'
Query 149: UPDATE wsnlinks_categories SET levelsdeep='2' WHERE id=9
Query 150: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=3
Load time so far: 2.34 seconds.
Query 151: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=1 AND validated=1
Load time so far: 2.34 seconds.
Query 152: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=0 AND validated=1
Load time so far: 2.34 seconds.
Load time so far: 2.34 seconds.
Query 153: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=10 AND validated=1 AND hide=0 AND deleted=0
Count is 0
Load time so far: 2.35 seconds.
Query 154: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=10 AND hide=0 AND deleted=0 AND validated=1
Count is 35
Load time so far: 2.35 seconds.
Query 155: SELECT COUNT(id) FROM wsnlinks_links WHERE (catid=10 OR parentids LIKE '%|10|%') AND hide=0 AND deleted=0 AND validated=1 AND (inhidden=0 OR inalbum=1)
Count is 35
Load time so far: 2.55 seconds.
Query 156: SELECT COUNT(id) FROM wsnlinks_comments WHERE (catid=10 OR parentids LIKE '%|10|%') AND hide=0 AND validated=1 AND deleted=0
Count is 0
Query 157: SELECT `time` FROM wsnlinks_links WHERE catid=10 AND deleted=0 AND validated=1 ORDER BY time DESC
Load time so far: 2.55 seconds.
Query 158: SELECT `ownerid`,`postername`,`time`,`linkid` FROM wsnlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 10, %' OR catid = 10) ORDER BY time DESC LIMIT 0,1
Load time so far: 2.55 seconds.
Load time so far: 2.55 seconds.
Query 159: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=10 AND deleted=0 AND validated=0
Count is 0
Load time so far: 2.55 seconds.
Query 160: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=10 AND deleted=0 AND validated=0
Count is 0
Load time so far: 2.55 seconds.
Query 161: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=10 AND deleted=0 AND hide=0 AND validated=1
Count is 0
Getting all fields for table categoriestable
Query 162: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`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` FROM wsnlinks_categories WHERE parent=10 AND deleted=0 AND hide=0 AND validated=1 ORDER BY priority ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 2.58 seconds.
Number of rows is 0
Load time so far: 2.58 seconds.
Query 163: UPDATE wsnlinks_links SET parentids=', 3, 1, ' WHERE catid=10
Load time so far: 2.58 seconds.
Query 164: UPDATE wsnlinks_categories SET subhtml = '', totalcomments = '0', lastlinktime = '1215978818', parentids = ', 3, 1, ', parentnames = ', Bedrijven, Computers, ', numsub = '0', numlinks = '35', linkshere = '35', levelsdeep = '2', unvalidatedlinks = '0', unvalidatedcomments = '0', lastposterid = '', lastpostername = '', lastcommenttime = '0', lastthreadid = '', lastthreadtitle = '', lastposturl = '', lastthreadurl = '', lastprofileurl = '' WHERE id=10
Load time so far: 2.58 seconds.
Unknown column 'subhtml' in 'field list'
Query 165: UPDATE wsnlinks_categories SET levelsdeep='2' WHERE id=10
Query 166: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=3
Load time so far: 2.58 seconds.
Query 167: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=1 AND validated=1
Load time so far: 2.58 seconds.
Query 168: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=0 AND validated=1
Load time so far: 2.58 seconds.
Load time so far: 2.58 seconds.
Query 169: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=11 AND validated=1 AND hide=0 AND deleted=0
Count is 0
Load time so far: 2.59 seconds.
Query 170: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=11 AND hide=0 AND deleted=0 AND validated=1
Count is 42
Load time so far: 2.6 seconds.
Query 171: SELECT COUNT(id) FROM wsnlinks_links WHERE (catid=11 OR parentids LIKE '%|11|%') AND hide=0 AND deleted=0 AND validated=1 AND (inhidden=0 OR inalbum=1)
Count is 42
Load time so far: 2.79 seconds.
Query 172: SELECT COUNT(id) FROM wsnlinks_comments WHERE (catid=11 OR parentids LIKE '%|11|%') AND hide=0 AND validated=1 AND deleted=0
Count is 0
Query 173: SELECT `time` FROM wsnlinks_links WHERE catid=11 AND deleted=0 AND validated=1 ORDER BY time DESC
Load time so far: 2.79 seconds.
Query 174: SELECT `ownerid`,`postername`,`time`,`linkid` FROM wsnlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 11, %' OR catid = 11) ORDER BY time DESC LIMIT 0,1
Load time so far: 2.79 seconds.
Load time so far: 2.79 seconds.
Query 175: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=11 AND deleted=0 AND validated=0
Count is 0
Load time so far: 2.79 seconds.
Query 176: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=11 AND deleted=0 AND validated=0
Count is 0
Load time so far: 2.79 seconds.
Query 177: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=11 AND deleted=0 AND hide=0 AND validated=1
Count is 0
Getting all fields for table categoriestable
Query 178: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`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` FROM wsnlinks_categories WHERE parent=11 AND deleted=0 AND hide=0 AND validated=1 ORDER BY priority ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 2.83 seconds.
Number of rows is 0
Load time so far: 2.83 seconds.
Query 179: UPDATE wsnlinks_links SET parentids=', 3, 1, ' WHERE catid=11
Load time so far: 2.83 seconds.
Query 180: UPDATE wsnlinks_categories SET subhtml = '', totalcomments = '0', lastlinktime = '1215978818', parentids = ', 3, 1, ', parentnames = ', Bedrijven, Computers, ', numsub = '0', numlinks = '42', linkshere = '42', levelsdeep = '2', unvalidatedlinks = '0', unvalidatedcomments = '0', lastposterid = '', lastpostername = '', lastcommenttime = '0', lastthreadid = '', lastthreadtitle = '', lastposturl = '', lastthreadurl = '', lastprofileurl = '' WHERE id=11
Load time so far: 2.83 seconds.
Unknown column 'subhtml' in 'field list'
Query 181: UPDATE wsnlinks_categories SET levelsdeep='2' WHERE id=11
Query 182: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=3
Load time so far: 2.83 seconds.
Query 183: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=1 AND validated=1
Load time so far: 2.83 seconds.
Query 184: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=0 AND validated=1
Load time so far: 2.83 seconds.
Load time so far: 2.83 seconds.
Query 185: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=12 AND validated=1 AND hide=0 AND deleted=0
Count is 0
Load time so far: 2.84 seconds.
Query 186: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=12 AND hide=0 AND deleted=0 AND validated=1
Count is 16
Load time so far: 2.84 seconds.
Query 187: SELECT COUNT(id) FROM wsnlinks_links WHERE (catid=12 OR parentids LIKE '%|12|%') AND hide=0 AND deleted=0 AND validated=1 AND (inhidden=0 OR inalbum=1)
Count is 16
Load time so far: 3.04 seconds.
Query 188: SELECT COUNT(id) FROM wsnlinks_comments WHERE (catid=12 OR parentids LIKE '%|12|%') AND hide=0 AND validated=1 AND deleted=0
Count is 0
Query 189: SELECT `time` FROM wsnlinks_links WHERE catid=12 AND deleted=0 AND validated=1 ORDER BY time DESC
Load time so far: 3.04 seconds.
Query 190: SELECT `ownerid`,`postername`,`time`,`linkid` FROM wsnlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 12, %' OR catid = 12) ORDER BY time DESC LIMIT 0,1
Load time so far: 3.04 seconds.
Load time so far: 3.04 seconds.
Query 191: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=12 AND deleted=0 AND validated=0
Count is 0
Load time so far: 3.04 seconds.
Query 192: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=12 AND deleted=0 AND validated=0
Count is 0
Load time so far: 3.04 seconds.
Query 193: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=12 AND deleted=0 AND hide=0 AND validated=1
Count is 0
Getting all fields for table categoriestable
Query 194: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`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` FROM wsnlinks_categories WHERE parent=12 AND deleted=0 AND hide=0 AND validated=1 ORDER BY priority ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 3.07 seconds.
Number of rows is 0
Load time so far: 3.07 seconds.
Query 195: UPDATE wsnlinks_links SET parentids=', 3, 1, ' WHERE catid=12
Load time so far: 3.07 seconds.
Query 196: UPDATE wsnlinks_categories SET subhtml = '', totalcomments = '0', lastlinktime = '1215978818', parentids = ', 3, 1, ', parentnames = ', Bedrijven, Computers, ', numsub = '0', numlinks = '16', linkshere = '16', levelsdeep = '2', unvalidatedlinks = '0', unvalidatedcomments = '0', lastposterid = '', lastpostername = '', lastcommenttime = '0', lastthreadid = '', lastthreadtitle = '', lastposturl = '', lastthreadurl = '', lastprofileurl = '' WHERE id=12
Load time so far: 3.07 seconds.
Unknown column 'subhtml' in 'field list'
Query 197: UPDATE wsnlinks_categories SET levelsdeep='2' WHERE id=12
Query 198: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=3
Load time so far: 3.07 seconds.
Query 199: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=1 AND validated=1
Load time so far: 3.07 seconds.
Query 200: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=0 AND validated=1
Load time so far: 3.07 seconds.
Load time so far: 3.07 seconds.
Query 201: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=13 AND validated=1 AND hide=0 AND deleted=0
Count is 0
Load time so far: 3.08 seconds.
Query 202: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=13 AND hide=0 AND deleted=0 AND validated=1
Count is 8
Load time so far: 3.08 seconds.
Query 203: SELECT COUNT(id) FROM wsnlinks_links WHERE (catid=13 OR parentids LIKE '%|13|%') AND hide=0 AND deleted=0 AND validated=1 AND (inhidden=0 OR inalbum=1)
Count is 8
Load time so far: 3.28 seconds.
Query 204: SELECT COUNT(id) FROM wsnlinks_comments WHERE (catid=13 OR parentids LIKE '%|13|%') AND hide=0 AND validated=1 AND deleted=0
Count is 0
Query 205: SELECT `time` FROM wsnlinks_links WHERE catid=13 AND deleted=0 AND validated=1 ORDER BY time DESC
Load time so far: 3.28 seconds.
Query 206: SELECT `ownerid`,`postername`,`time`,`linkid` FROM wsnlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 13, %' OR catid = 13) ORDER BY time DESC LIMIT 0,1
Load time so far: 3.28 seconds.
Load time so far: 3.28 seconds.
Query 207: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=13 AND deleted=0 AND validated=0
Count is 0
Load time so far: 3.28 seconds.
Query 208: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=13 AND deleted=0 AND validated=0
Count is 0
Load time so far: 3.28 seconds.
Query 209: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=13 AND deleted=0 AND hide=0 AND validated=1
Count is 0
Getting all fields for table categoriestable
Query 210: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`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` FROM wsnlinks_categories WHERE parent=13 AND deleted=0 AND hide=0 AND validated=1 ORDER BY priority ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 3.31 seconds.
Number of rows is 0
Load time so far: 3.31 seconds.
Query 211: UPDATE wsnlinks_links SET parentids=', 3, 1, ' WHERE catid=13
Load time so far: 3.31 seconds.
Query 212: UPDATE wsnlinks_categories SET subhtml = '', totalcomments = '0', lastlinktime = '1215978818', parentids = ', 3, 1, ', parentnames = ', Bedrijven, Computers, ', numsub = '0', numlinks = '8', linkshere = '8', levelsdeep = '2', unvalidatedlinks = '0', unvalidatedcomments = '0', lastposterid = '', lastpostername = '', lastcommenttime = '0', lastthreadid = '', lastthreadtitle = '', lastposturl = '', lastthreadurl = '', lastprofileurl = '' WHERE id=13
Load time so far: 3.31 seconds.
Unknown column 'subhtml' in 'field list'
Query 213: UPDATE wsnlinks_categories SET levelsdeep='2' WHERE id=13
Query 214: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=3
Load time so far: 3.31 seconds.
Query 215: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=1 AND validated=1
Load time so far: 3.31 seconds.
Query 216: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=0 AND validated=1
Load time so far: 3.31 seconds.
Load time so far: 3.31 seconds.
Query 217: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=14 AND validated=1 AND hide=0 AND deleted=0
Count is 0
Load time so far: 3.32 seconds.
Query 218: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=14 AND hide=0 AND deleted=0 AND validated=1
Count is 12
Load time so far: 3.32 seconds.
Query 219: SELECT COUNT(id) FROM wsnlinks_links WHERE (catid=14 OR parentids LIKE '%|14|%') AND hide=0 AND deleted=0 AND validated=1 AND (inhidden=0 OR inalbum=1)
Count is 12
Load time so far: 3.52 seconds.
Query 220: SELECT COUNT(id) FROM wsnlinks_comments WHERE (catid=14 OR parentids LIKE '%|14|%') AND hide=0 AND validated=1 AND deleted=0
Count is 0
Query 221: SELECT `time` FROM wsnlinks_links WHERE catid=14 AND deleted=0 AND validated=1 ORDER BY time DESC
Load time so far: 3.52 seconds.
Query 222: SELECT `ownerid`,`postername`,`time`,`linkid` FROM wsnlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 14, %' OR catid = 14) ORDER BY time DESC LIMIT 0,1
Load time so far: 3.52 seconds.
Load time so far: 3.52 seconds.
Query 223: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=14 AND deleted=0 AND validated=0
Count is 0
Load time so far: 3.52 seconds.
Query 224: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=14 AND deleted=0 AND validated=0
Count is 0
Load time so far: 3.52 seconds.
Query 225: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=14 AND deleted=0 AND hide=0 AND validated=1
Count is 0
Getting all fields for table categoriestable
Query 226: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`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` FROM wsnlinks_categories WHERE parent=14 AND deleted=0 AND hide=0 AND validated=1 ORDER BY priority ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 3.55 seconds.
Number of rows is 0
Load time so far: 3.55 seconds.
Query 227: UPDATE wsnlinks_links SET parentids=', 3, 1, ' WHERE catid=14
Load time so far: 3.55 seconds.
Query 228: UPDATE wsnlinks_categories SET subhtml = '', totalcomments = '0', lastlinktime = '1215978818', parentids = ', 3, 1, ', parentnames = ', Bedrijven, Computers, ', numsub = '0', numlinks = '12', linkshere = '12', levelsdeep = '2', unvalidatedlinks = '0', unvalidatedcomments = '0', lastposterid = '', lastpostername = '', lastcommenttime = '0', lastthreadid = '', lastthreadtitle = '', lastposturl = '', lastthreadurl = '', lastprofileurl = '' WHERE id=14
Load time so far: 3.55 seconds.
Unknown column 'subhtml' in 'field list'
Query 229: UPDATE wsnlinks_categories SET levelsdeep='2' WHERE id=14
Query 230: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=3
Load time so far: 3.55 seconds.
Query 231: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=1 AND validated=1
Load time so far: 3.55 seconds.
Query 232: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=0 AND validated=1
Load time so far: 3.55 seconds.
Load time so far: 3.55 seconds.
Query 233: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=15 AND validated=1 AND hide=0 AND deleted=0
Count is 0
Load time so far: 3.56 seconds.
Query 234: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=15 AND hide=0 AND deleted=0 AND validated=1
Count is 16
Load time so far: 3.56 seconds.
Query 235: SELECT COUNT(id) FROM wsnlinks_links WHERE (catid=15 OR parentids LIKE '%|15|%') AND hide=0 AND deleted=0 AND validated=1 AND (inhidden=0 OR inalbum=1)
Count is 16
Load time so far: 3.76 seconds.
Query 236: SELECT COUNT(id) FROM wsnlinks_comments WHERE (catid=15 OR parentids LIKE '%|15|%') AND hide=0 AND validated=1 AND deleted=0
Count is 0
Query 237: SELECT `time` FROM wsnlinks_links WHERE catid=15 AND deleted=0 AND validated=1 ORDER BY time DESC
Load time so far: 3.76 seconds.
Query 238: SELECT `ownerid`,`postername`,`time`,`linkid` FROM wsnlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 15, %' OR catid = 15) ORDER BY time DESC LIMIT 0,1
Load time so far: 3.76 seconds.
Load time so far: 3.76 seconds.
Query 239: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=15 AND deleted=0 AND validated=0
Count is 0
Load time so far: 3.76 seconds.
Query 240: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=15 AND deleted=0 AND validated=0
Count is 0
Load time so far: 3.76 seconds.
Query 241: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=15 AND deleted=0 AND hide=0 AND validated=1
Count is 0
Getting all fields for table categoriestable
Query 242: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`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` FROM wsnlinks_categories WHERE parent=15 AND deleted=0 AND hide=0 AND validated=1 ORDER BY priority ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 3.79 seconds.
Number of rows is 0
Load time so far: 3.79 seconds.
Query 243: UPDATE wsnlinks_links SET parentids=', 3, 1, ' WHERE catid=15
Load time so far: 3.79 seconds.
Query 244: UPDATE wsnlinks_categories SET subhtml = '', totalcomments = '0', lastlinktime = '1215978818', parentids = ', 3, 1, ', parentnames = ', Bedrijven, Computers, ', numsub = '0', numlinks = '16', linkshere = '16', levelsdeep = '2', unvalidatedlinks = '0', unvalidatedcomments = '0', lastposterid = '', lastpostername = '', lastcommenttime = '0', lastthreadid = '', lastthreadtitle = '', lastposturl = '', lastthreadurl = '', lastprofileurl = '' WHERE id=15
Load time so far: 3.79 seconds.
Unknown column 'subhtml' in 'field list'
Query 245: UPDATE wsnlinks_categories SET levelsdeep='2' WHERE id=15
Query 246: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=3
Load time so far: 3.79 seconds.
Query 247: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=1 AND validated=1
Load time so far: 3.79 seconds.
Query 248: SELECT `id`,`name`,`parent` FROM wsnlinks_categories WHERE id=0 AND validated=1
Load time so far: 3.79 seconds.
Load time so far: 3.79 seconds.
Query 249: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=16 AND validated=1 AND hide=0 AND deleted=0
Count is 0
Load time so far: 3.8 seconds.
Query 250: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=16 AND hide=0 AND deleted=0 AND validated=1
Count is 53
Load time so far: 3.8 seconds.
Query 251: SELECT COUNT(id) FROM wsnlinks_links WHERE (catid=16 OR parentids LIKE '%|16|%') AND hide=0 AN
Forum Regular
Usergroup: Customer
Joined: Jul 09, 2008
Total Topics: 22
Total Comments: 110
paul, must be something wrong.
with new install 5.0.B6 and using small dmoz import files only total links and cats show,but nothing shows inside.....it stays at 0
Also secondary cats are not created...
so there's deffinately something wrong there....
Forum Regular
Usergroup: Customer
Joined: Jul 09, 2008
Total Topics: 22
Total Comments: 110
Hello paul,
It took almost 24 hours of testing and im positive that i found what the problem is when importing files that are to big and the regenerating process drops dead after some time.
All the time i was working with Firefox 2 and never tried it all with Internet explorer 7.
The toggle javascript error i saw every time (from dynamicdrive) gave me idea that it might not be fully cross browser compatible.
A person on the dynamicdrive forum was also wondering about that.
After testing it fully on 3 categories I'm pretty sure now.
My findings are:
With Firefox 2 and you import a large file like 2 or 3 mb it can drop dead after some time.
And then when you still go ahead and start the regenerating then that process also stops when it does 20 or 30.000 links.
With Internet explorer 7 i was able to finish all processes successfully except the import.
Even with Internet explorer 7 with an import of 4 MB file at some point the browser shows the standard page of a website not being available and if you have an Internet connection...
But i noticed when i looked at my computer running processes that the importer was still working,something Firefox didn't do.
So in short....the right page (right frame) went blank but all was still running..
At some point i could see the importing was done , as no processes showed anymore.
After that i clicked the regenerate everything and it started and finished successfully and updated everything.
Thats also something Firefox didn't do,that gave errors all the time.
But i think that the regenerating is difficult to run on a server enviroment,when having so many links.
My computer has 2 duo CPU 2.66GHz and with the running import and regenerating process it pulled 53% constantly of the resources.
So i think hosts aren't to happy giving such memory so the script can run to regenerate up to 60,70,or 100.000 links.
Naturally this is a situation that doesn't happen often but it can give problems if you want to import huge lists.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
It is of course fully firefox compatible. I don't have IE. Tested in Firefox 3, Opera 9.27 and Konqueror. The HTML page is nowhere near 2 or 3 megabytes -- more like 100KB. Though I have loaded 10MB HTML files in Firefox. The amound of memory the server uses on backend stuff is unknown to the web browser.
People running google-sized databases shouldn't be on shared web hosts anyway.
Forum Regular
Usergroup: Customer
Joined: Jul 09, 2008
Total Topics: 22
Total Comments: 110
The HTML page is nowhere near 2 or 3 megabytes -- more like 100KB. Though I have loaded 10MB HTML files in Firefox.
I mean the imported files are that large and even larger then that.
And im using firefox 2.
And i clearly acts different on IE7.
and im working with 4.1.55
Forum Regular
Usergroup: Customer
Joined: Jul 09, 2008
Total Topics: 22
Total Comments: 110
been busy with this for 24 hours of regenerating etc....
I had 10 categories with over 50.000 links
but after adding one more category it now has a problem doing what it should have done....counting cats and links of the last added.
Sure it shows as a total but on front.....nothing shows at all.
And when you do a search on one of the last links added it actualy shows that its in the category that doesnt show !
how weird can it be ?
So im not the programmer here but to me it looks like the reneration process fails a bit when it all gets to big..
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
You generate report files in the wrong format and they won't work, as discussed much earlier. You generate a report file more than a megabyte and tulipchain is bound to have missed stuff, and it's not supported anyhow since the instructions say <1K links.
Verified yet again that all the proper report files work in 4.1.x. 5.0 will take a couple hours to regenerate but I expect the result to be the same.
Web browsers have no knowledge of the size of report files and regeneration has once again been verified to work the same in every browser. Your browser must be misconfigured or have a malfunctioning extension.