Paul....i have 96341 links in 16 categories with over 11043 subcategories.. So i can imagine the sitemap takes some time to show... (i think) But whenever i look at the sitemap i get on top:
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/public_html/databases/mysqli.php on line 20
But all does show from the first in A to the last one in Z
And line 20 = function numrows($q) { return mysqli_num_rows($q); }
Query 1: SELECT `name`,`content` FROM wsnlinks_settings WHERE id>0 ORDER BY id ASC
Number of rows is 476
Load time so far: 0.08 seconds.
Query 2: SELECT `name`,`value` FROM wsnlinks_switches WHERE id>0
Number of rows is 93
Load time so far: 0.08 seconds.
Query 3: SELECT `id`,`type`,`original`,`replacement`,`description`,`original close`,`replacementclose`,`sortorder` FROM wsnlinks_markup WHERE type='wsncode' ORDER BY sortorder
Number of rows is 26
Creating markup with Array as row
HERE COME MANY DUPLICATES OFF "Creating markup with Array as row"
Query 5: SELECT `id`,`name`,`links`,`comments`,`time`,`usergroup`,`password` ,`ip`,`totalhits`,`totalhitsin`,`email`,`validated`,`templat e`,`language`,`lastattempt`,`allowemail`,`signature`,`avatar name`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempt s`,`totalbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezon e`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookiedur ation`,`banned`,`location`,`homepage`,`occupation`,`bio`,`ai m`,`icq`,`msn`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`b uddies`,`ignored`,`isonline`,`acceptims`,`adminpermissions`, `referrer`,`groupreverttime`,`grouprevertto`,`moderationpm`, `secondarygroups`,`linksperpage`,`commentsperpage`,`shouts`, `customtitle`,`shoutban`,`topicbans`,`forumbans`,`visibility `,`birthdate`,`lastsession`,`interests`,`posteditor`,`foruma ccess`,`pmpopup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,` lastmodnote`,`newpms`,`imflag`,`orderalbums`,`lastguestnote` ,`autosubscribe`,`notifymethod`,`showavatars`,`showsigs`,`wa rninglevel`,`topics`,`posts`,`chatcolor`,`traderrating`,`inv itessent`,`validatedemail`,`calsub`,`macros`,`guestnotify`,` keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss` ,`positivepct`,`notifytrader` FROM wsnlinks_members WHERE id='1' AND validated=1
Load time so far: 0.12 seconds.
Query 6: SELECT `original`,`replacement`,`description`,`id`,`sortorder` FROM wsnlinks_markup WHERE type='smilie' ORDER BY sortorder
Number of rows is 14
Load time so far: 0.12 seconds.
Query 7: SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM wsnlinks_email WHERE timesent=0 AND inprogress=0 ORDER BY id ASC LIMIT 0,10
Number of rows is 0
Load time so far: 0.12 seconds.
Query 8: UPDATE wsnlinks_email SET inprogress='0' WHERE
Warning: Cannot modify header information - headers already sent by (output started at /home/public_html/classes/database.php:249) in /home/public_html/end.php on line 71
Load time so far: 0.29 seconds.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Query 9: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`paren tnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom `,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`t ype`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`order links`,`totalcomments`,`ulsearchmax`,`ulsearchquery`,`ulsear chadult`,`alias`,`catcols`,`linkcols`,`dmozpath`,`sponsorlin ks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`req linksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpost ername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,` linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actasli nk`,`countposts`,`subcatshtml`,`linksperpage`,`wysihtml`,`nu monline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`l astthreadurl`,`lastposturl` FROM wsnlinks_categories WHERE hide=0 AND validated=1 AND deleted=0 ORDER BY id ASC
Number of rows is 11046
Creating category with Array as row
HERE COME MANY DUPLICATES OFF "Creating markup with Array as row"
CONTINUING AFFTER THAT.....
Load time so far: 43.57 seconds.
Query 10: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime` ,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,` inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`accept ims`,`visibility`,`profileurl` FROM wsnlinks_sessions WHERE memberid=1
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/public_html/databases/mysqli.php on line 20
Number of rows is MySQL server has gone away
Creating online with new as new
Load time so far: 43.58 seconds.
MySQL server has gone away
Query 11: UPDATE wsnlinks_members SET isonline='1', lastvisit='1218499689' WHERE id='1'
Query 12: INSERT INTO wsnlinks_sessions(`memberid`,`location`,`time`,`ip`,`browser `,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`no permission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnames tyle`,`acceptims`,`visibility`,`profileurl`) VALUES('1','http://www.googles.nl/sitemap.php?debug=1','1218499689','77.248.201.248','Mozilla/5.0 (Windows; U; Windows NT 5.1; nl; rv:1.8.1.16) Gecko/20080702 Firefox/2.0.0.16','1218499689','0','0','Site Map','','0','0','admin','','','admincolor','','','http://www.xxxxxxxx.nl/members/admin-1.html')
Load time so far: 43.58 seconds.
MySQL server has gone away
Query 13: DELETE FROM wsnlinks_sessions WHERE memberid=0 AND ip='xxxxxxxxx'
The problem is simply that the page is taking 43 seconds, at which point mysql gives up. The sitemap isn't going to be able to show 11,000 categories and it's not even useful since a human being can't read a list of 11,000 categories, so disable it.
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 Warning: mysqli_num_rows sitemap error
Forum Regular
Usergroup: Customer
Joined: Jul 09, 2008
Total Topics: 22
Total Comments: 110
Hello,
Paul....i have 96341 links in 16 categories with over 11043 subcategories..
So i can imagine the sitemap takes some time to show... (i think)
But whenever i look at the sitemap i get on top:
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/public_html/databases/mysqli.php on line 20
But all does show from the first in A to the last one in Z
And line 20 = function numrows($q) { return mysqli_num_rows($q); }
Any solution?
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
scripts.webmastersite.net/w...icles/mysql-errors-66.html
Forum Regular
Usergroup: Customer
Joined: Jul 09, 2008
Total Topics: 22
Total Comments: 110
Here is debug paul :
Load time so far: 0.05 seconds.
Query 1: SELECT `name`,`content` FROM wsnlinks_settings WHERE id>0 ORDER BY id ASC
Number of rows is 476
Load time so far: 0.08 seconds.
Query 2: SELECT `name`,`value` FROM wsnlinks_switches WHERE id>0
Number of rows is 93
Load time so far: 0.08 seconds.
Query 3: SELECT `id`,`type`,`original`,`replacement`,`description`,`original close`,`replacementclose`,`sortorder` FROM wsnlinks_markup WHERE type='wsncode' ORDER BY sortorder
Number of rows is 26
Creating markup with Array as row
HERE COME MANY DUPLICATES OFF "Creating markup with Array as row"
CONTINUING AFFTER THAT.....
Load time so far: 0.09 seconds.
Query 4: SELECT `id`,`title`,`caneditown`,`caneditall`,`canvote`,`isadmin`,` canpost`,`canemail`,`validatecats`,`validatecomments`,`valid atelinks`,`validateedits`,`cansubmitlinks`,`cansubmitcategor ies`,`cansubmitcomments`,`caneditownlinks`,`caneditowncatego ries`,`caneditowncomments`,`caneditownprofile`,`caneditallli nks`,`caneditallcategories`,`caneditallcomments`,`caneditall profiles`,`candownloadfiles`,`canupload`,`canviewip`,`limitl inks`,`canemailmembers`,`canusehtml`,`limitlinksdaily`,`cana lias`,`cancopy`,`candeleteown`,`candeleteall`,`candofulledit `,`candeletecategories`,`candeletecomments`,`candeleteowncat egories`,`candeleteowncomments`,`candeletemembers`,`candelet eownmembers`,`canaliascategories`,`canviewpages`,`caneditvot es`,`numaliases`,`canviewvotes`,`canhideownlinks`,`canhideow ncategories`,`canhideowncomments`,`canhidealllinks`,`canhide allcategories`,`canhideallcomments`,`canratecomments`,`bytes permem`,`canpm`,`canim`,`canharddelete`,`limitpms`,`limitpms daily`,`canviewdeleted`,`cansubmitpolls`,`candeletepolls`,`c andeleteownpolls`,`caneditpolls`,`caneditownpolls`,`attachpe rpost`,`attachperpm`,`canviewshouts`,`caneditshouts`,`canedi townshouts`,`candeleteshouts`,`candeleteownshouts`,`cansubmi tshouts`,`canpollvote`,`customtitle`,`canviewinvisible`,`nam estyle`,`canpmimportant`,`canviewmodlog`,`isleader`,`cansubm itquotes`,`validatequotes`,`candeletequotes`,`candeleteownqu otes`,`canreport`,`canusesearch`,`attachperlink`,`validateat tachments`,`caneditownquotes`,`caneditallquotes`,`canviewcha t`,`caneditownevents`,`caneditallevents`,`candeleteownevents `,`candeleteevents`,`cansubmitevents`,`validateevents`,`bulk pms`,`issupermod`,`numinv`,`allowugspec`,`validateemails`,`v alidatesponsorlinks`,`cansubmittags`,`candeletetags`,`cansub mitfeeds`,`validatefeeds`,`validatefeeditems`,`numaliasestot `,`shoutsperday`,`validatetrader`,`renewdays`,`renewtimes`,` canviewownfulltrc`,`canviewallfulltrc` FROM wsnlinks_membergroups WHERE id>0
Load time so far: 0.1 seconds.
Query 5: SELECT `id`,`name`,`links`,`comments`,`time`,`usergroup`,`password` ,`ip`,`totalhits`,`totalhitsin`,`email`,`validated`,`templat e`,`language`,`lastattempt`,`allowemail`,`signature`,`avatar name`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempt s`,`totalbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezon e`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookiedur ation`,`banned`,`location`,`homepage`,`occupation`,`bio`,`ai m`,`icq`,`msn`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`b uddies`,`ignored`,`isonline`,`acceptims`,`adminpermissions`, `referrer`,`groupreverttime`,`grouprevertto`,`moderationpm`, `secondarygroups`,`linksperpage`,`commentsperpage`,`shouts`, `customtitle`,`shoutban`,`topicbans`,`forumbans`,`visibility `,`birthdate`,`lastsession`,`interests`,`posteditor`,`foruma ccess`,`pmpopup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,` lastmodnote`,`newpms`,`imflag`,`orderalbums`,`lastguestnote` ,`autosubscribe`,`notifymethod`,`showavatars`,`showsigs`,`wa rninglevel`,`topics`,`posts`,`chatcolor`,`traderrating`,`inv itessent`,`validatedemail`,`calsub`,`macros`,`guestnotify`,` keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss` ,`positivepct`,`notifytrader` FROM wsnlinks_members WHERE id='1' AND validated=1
Load time so far: 0.12 seconds.
Query 6: SELECT `original`,`replacement`,`description`,`id`,`sortorder` FROM wsnlinks_markup WHERE type='smilie' ORDER BY sortorder
Number of rows is 14
Load time so far: 0.12 seconds.
Query 7: SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM wsnlinks_email WHERE timesent=0 AND inprogress=0 ORDER BY id ASC LIMIT 0,10
Number of rows is 0
Load time so far: 0.12 seconds.
Query 8: UPDATE wsnlinks_email SET inprogress='0' WHERE
Warning: Cannot modify header information - headers already sent by (output started at /home/public_html/classes/database.php:249) in /home/public_html/end.php on line 71
Load time so far: 0.29 seconds.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Query 9: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`paren tnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom `,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`t ype`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`order links`,`totalcomments`,`ulsearchmax`,`ulsearchquery`,`ulsear chadult`,`alias`,`catcols`,`linkcols`,`dmozpath`,`sponsorlin ks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`req linksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpost ername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,` linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actasli nk`,`countposts`,`subcatshtml`,`linksperpage`,`wysihtml`,`nu monline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`l astthreadurl`,`lastposturl` FROM wsnlinks_categories WHERE hide=0 AND validated=1 AND deleted=0 ORDER BY id ASC
Number of rows is 11046
Creating category with Array as row
HERE COME MANY DUPLICATES OFF "Creating markup with Array as row"
CONTINUING AFFTER THAT.....
Load time so far: 43.57 seconds.
Query 10: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime` ,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,` inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`accept ims`,`visibility`,`profileurl` FROM wsnlinks_sessions WHERE memberid=1
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/public_html/databases/mysqli.php on line 20
Number of rows is MySQL server has gone away
Creating online with new as new
Load time so far: 43.58 seconds.
MySQL server has gone away
Query 11: UPDATE wsnlinks_members SET isonline='1', lastvisit='1218499689' WHERE id='1'
Query 12: INSERT INTO wsnlinks_sessions(`memberid`,`location`,`time`,`ip`,`browser `,`starttime`,`catid`,`threadid`,`areaname`,`lastsearch`,`no permission`,`inchat`,`name`,`isrobot`,`lastchat`,`groupnames tyle`,`acceptims`,`visibility`,`profileurl`) VALUES('1','http://www.googles.nl/sitemap.php?debug=1','1218499689','77.248.201.248','Mozilla/5.0 (Windows; U; Windows NT 5.1; nl; rv:1.8.1.16) Gecko/20080702 Firefox/2.0.0.16','1218499689','0','0','Site Map','','0','0','admin','','','admincolor','','','http://www.xxxxxxxx.nl/members/admin-1.html')
Load time so far: 43.58 seconds.
MySQL server has gone away
Query 13: DELETE FROM wsnlinks_sessions WHERE memberid=0 AND ip='xxxxxxxxx'
thats it..
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
The problem is simply that the page is taking 43 seconds, at which point mysql gives up. The sitemap isn't going to be able to show 11,000 categories and it's not even useful since a human being can't read a list of 11,000 categories, so disable it.