Need to regenerate categories as I moved one, but got the following error and it didn't regenerate.
An error occoured at http://localhost/Free Web Bargains/admin/updatecounters.php?filled=1 on 2008-08-31 12:10:35. Please relay this data to support. Error #2: 'mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given' in C:wampwwwFree Web Bargainsdatabasesmysqli.php on line 42. Debug info: ame`,`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: 0.21 seconds.
Load time so far: 0.21 seconds.
Query 199: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=14 AND deleted=0 AND validated=0 Count is 0
Load time so far: 0.21 seconds.
Query 200: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=14 AND deleted=0 AND validated=0 Count is 0
Load time so far: 0.21 seconds.
Query 201: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=14 AND deleted=0 AND hide=0 AND validated=1 Count is 0
Query 202: 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`,`specialurl`,`merchanturl`,`bann er`,`smallbanner`,`tinybanner` 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: 0.22 seconds.
Out of memory; restart server and try again (needed 207864 bytes)
An error occoured at http://localhost/Free Web Bargains/admin/updatecounters.php?filled=1 on 2008-08-31 12:10:35. Please relay this data to support. Error #2: 'mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given' in C:wampwwwFree Web Bargainsdatabasesmysqli.php on line 42. Debug info: e`,`linkid` FROM wsnlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 16, %' OR catid = 16) ORDER BY time DESC LIMIT 0,1
Load time so far: 0.22 seconds.
Load time so far: 0.22 seconds.
Query 214: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=16 AND deleted=0 AND validated=0 Count is 0
Load time so far: 0.22 seconds.
Query 215: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=16 AND deleted=0 AND validated=0 Count is 0
Load time so far: 0.22 seconds.
Query 216: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=16 AND deleted=0 AND hide=0 AND validated=1 Count is 0
Query 217: 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`,`specialurl`,`merchanturl`,`bann er`,`smallbanner`,`tinybanner` FROM wsnlinks_categories WHERE parent=16 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: 0.22 seconds.
Out of memory; restart server and try again (needed 207864 bytes)
An error occoured at http://localhost/Free Web Bargains/admin/updatecounters.php?filled=1 on 2008-08-31 12:10:35. Please relay this data to support. Error #2: 'mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given' in C:wampwwwFree Web Bargainsdatabasesmysqli.php on line 42. Debug info: d` FROM wsnlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 17, %' OR catid = 17) ORDER BY time DESC LIMIT 0,1
Load time so far: 0.23 seconds.
Load time so far: 0.23 seconds.
Query 228: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=17 AND deleted=0 AND validated=0 Count is 0
Load time so far: 0.23 seconds.
Query 229: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=17 AND deleted=0 AND validated=0 Count is 0
Load time so far: 0.23 seconds.
Query 230: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=17 AND deleted=0 AND hide=0 AND validated=1 Count is 0
Query 231: 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`,`specialurl`,`merchanturl`,`bann er`,`smallbanner`,`tinybanner` FROM wsnlinks_categories WHERE parent=17 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,name ASC LIMIT 0,7
Load time so far: 0.23 seconds.
Out of memory; restart server and try again (needed 207864 bytes)
An error occoured at http://localhost/Free Web Bargains/admin/updatecounters.php?filled=1 on 2008-08-31 12:10:35. Please relay this data to support. Error #2: 'mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given' in C:wampwwwFree Web Bargainsdatabasesmysqli.php on line 42. Debug info: snlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 18, %' OR catid = 18) ORDER BY time DESC LIMIT 0,1
Load time so far: 0.23 seconds.
Load time so far: 0.23 seconds.
Query 243: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=18 AND deleted=0 AND validated=0 Count is 0
Load time so far: 0.23 seconds.
Query 244: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=18 AND deleted=0 AND validated=0 Count is 0
Load time so far: 0.23 seconds.
Query 245: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=18 AND deleted=0 AND hide=0 AND validated=1 Count is 0
Query 246: 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`,`specialurl`,`merchanturl`,`bann er`,`smallbanner`,`tinybanner` FROM wsnlinks_categories WHERE parent=18 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,name ASC,name ASC LIMIT 0,7
Load time so far: 0.24 seconds.
Out of memory; restart server and try again (needed 207864 bytes)
An error occoured at http://localhost/Free Web Bargains/admin/updatecounters.php?filled=1 on 2008-08-31 12:10:35. Please relay this data to support. Error #2: 'mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given' in C:wampwwwFree Web Bargainsdatabasesmysqli.php on line 42. Debug info: omments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 19, %' OR catid = 19) ORDER BY time DESC LIMIT 0,1
Load time so far: 0.24 seconds.
Load time so far: 0.24 seconds.
Query 258: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=19 AND deleted=0 AND validated=0 Count is 0
Load time so far: 0.24 seconds.
Query 259: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=19 AND deleted=0 AND validated=0 Count is 0
Load time so far: 0.24 seconds.
Query 260: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=19 AND deleted=0 AND hide=0 AND validated=1 Count is 0
Query 261: 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`,`specialurl`,`merchanturl`,`bann er`,`smallbanner`,`tinybanner` FROM wsnlinks_categories WHERE parent=19 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,name ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 0.24 seconds.
Out of memory; restart server and try again (needed 207864 bytes)
An error occoured at http://localhost/Free Web Bargains/admin/updatecounters.php?filled=1 on 2008-08-31 12:10:35. Please relay this data to support. Error #2: 'mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given' in C:wampwwwFree Web Bargainsdatabasesmysqli.php on line 42. Debug info: HERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 20, %' OR catid = 20) ORDER BY time DESC LIMIT 0,1
Load time so far: 0.25 seconds.
Load time so far: 0.25 seconds.
Query 273: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=20 AND deleted=0 AND validated=0 Count is 0
Load time so far: 0.25 seconds.
Query 274: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=20 AND deleted=0 AND validated=0 Count is 0
Load time so far: 0.25 seconds.
Query 275: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=20 AND deleted=0 AND hide=0 AND validated=1 Count is 0
Query 276: 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`,`specialurl`,`merchanturl`,`bann er`,`smallbanner`,`tinybanner` FROM wsnlinks_categories WHERE parent=20 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,name ASC,name ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 0.29 seconds.
Out of memory; restart server and try again (needed 207864 bytes)
An error occoured at http://localhost/Free Web Bargains/admin/updatecounters.php?filled=1 on 2008-08-31 12:10:35. Please relay this data to support. Error #2: 'mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given' in C:wampwwwFree Web Bargainsdatabasesmysqli.php on line 42. Debug info: (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 21, %' OR catid = 21) ORDER BY time DESC LIMIT 0,1
Load time so far: 0.3 seconds.
Load time so far: 0.3 seconds.
Query 288: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=21 AND deleted=0 AND validated=0 Count is 0
Load time so far: 0.3 seconds.
Query 289: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=21 AND deleted=0 AND validated=0 Count is 0
Load time so far: 0.3 seconds.
Query 290: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=21 AND deleted=0 AND hide=0 AND validated=1 Count is 0
Query 291: 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`,`specialurl`,`merchanturl`,`bann er`,`smallbanner`,`tinybanner` FROM wsnlinks_categories WHERE parent=21 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,name ASC,name ASC,name ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 0.3 seconds.
Out of memory; restart server and try again (needed 207864 bytes)
An error occoured at http://localhost/Free Web Bargains/admin/updatecounters.php?filled=1 on 2008-08-31 12:10:35. Please relay this data to support. Error #2: 'mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given' in C:wampwwwFree Web Bargainsdatabasesmysqli.php on line 42. Debug info: ed=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 22, %' OR catid = 22) ORDER BY time DESC LIMIT 0,1
Load time so far: 0.3 seconds.
Load time so far: 0.3 seconds.
Query 302: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=22 AND deleted=0 AND validated=0 Count is 0
Load time so far: 0.3 seconds.
Query 303: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=22 AND deleted=0 AND validated=0 Count is 0
Load time so far: 0.3 seconds.
Query 304: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=22 AND deleted=0 AND hide=0 AND validated=1 Count is 0
Query 305: 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`,`specialurl`,`merchanturl`,`bann er`,`smallbanner`,`tinybanner` FROM wsnlinks_categories WHERE parent=22 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,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 0.3 seconds.
Out of memory; restart server and try again (needed 207864 bytes) WSN Links 5.0.2 Admin Panel Updating next batch of categories starting at 21 (out of 21)...
Paul wrote: That should be plenty, mine is only 12M. Actually it looks like mysql is returning an out of memory error which eventually leads to the PHP one.
Can you reproduce this?
Yes, but only on my local computer! It happens every time. It also happens on all my local installed ones. I only have one test site for v.5 online.
Of course you are more than welcome to jump on a plane and come and see for yourself. I'll even buy you dinner
Paul wrote: You have the same category on remote installs where it doesn't happen?
not quite sure I understand you, but I have this site installed on both my local and now my server and get the problem with both of them. What I did was install a new version on my server at 123club.co.uk and then simply restore a back up of my local computer install. I was hoping to go live with this site but needed to check it out before putting it on the live site.
I do NOT get it on my other test site on the server - justearings.co.uk
I have 3 other installs on my local computer - 1 DOES have the problem and the other 2 do NOT
Then it sounds like it has to do with the particular category which is on one of the sites and not the other.
I have no idea what your usual password is, and thunderbird is enough of a pain to search in if there's only one email address involved while you've used a bunch.
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 Regen of cats error
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
Need to regenerate categories as I moved one, but got the following error and it didn't regenerate.
An error occoured at http://localhost/Free Web Bargains/admin/updatecounters.php?filled=1 on 2008-08-31 12:10:35. Please relay this data to support. Error #2: 'mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given' in C:wampwwwFree Web Bargainsdatabasesmysqli.php on line 42. Debug info:
ame`,`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: 0.21 seconds.
Load time so far: 0.21 seconds.
Query 199: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=14 AND deleted=0 AND validated=0
Count is 0
Load time so far: 0.21 seconds.
Query 200: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=14 AND deleted=0 AND validated=0
Count is 0
Load time so far: 0.21 seconds.
Query 201: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=14 AND deleted=0 AND hide=0 AND validated=1
Count is 0
Query 202: 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`,`specialurl`,`merchanturl`,`bann er`,`smallbanner`,`tinybanner` 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: 0.22 seconds.
Out of memory; restart server and try again (needed 207864 bytes)
An error occoured at http://localhost/Free Web Bargains/admin/updatecounters.php?filled=1 on 2008-08-31 12:10:35. Please relay this data to support. Error #2: 'mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given' in C:wampwwwFree Web Bargainsdatabasesmysqli.php on line 42. Debug info:
e`,`linkid` FROM wsnlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 16, %' OR catid = 16) ORDER BY time DESC LIMIT 0,1
Load time so far: 0.22 seconds.
Load time so far: 0.22 seconds.
Query 214: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=16 AND deleted=0 AND validated=0
Count is 0
Load time so far: 0.22 seconds.
Query 215: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=16 AND deleted=0 AND validated=0
Count is 0
Load time so far: 0.22 seconds.
Query 216: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=16 AND deleted=0 AND hide=0 AND validated=1
Count is 0
Query 217: 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`,`specialurl`,`merchanturl`,`bann er`,`smallbanner`,`tinybanner` FROM wsnlinks_categories WHERE parent=16 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: 0.22 seconds.
Out of memory; restart server and try again (needed 207864 bytes)
An error occoured at http://localhost/Free Web Bargains/admin/updatecounters.php?filled=1 on 2008-08-31 12:10:35. Please relay this data to support. Error #2: 'mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given' in C:wampwwwFree Web Bargainsdatabasesmysqli.php on line 42. Debug info:
d` FROM wsnlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 17, %' OR catid = 17) ORDER BY time DESC LIMIT 0,1
Load time so far: 0.23 seconds.
Load time so far: 0.23 seconds.
Query 228: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=17 AND deleted=0 AND validated=0
Count is 0
Load time so far: 0.23 seconds.
Query 229: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=17 AND deleted=0 AND validated=0
Count is 0
Load time so far: 0.23 seconds.
Query 230: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=17 AND deleted=0 AND hide=0 AND validated=1
Count is 0
Query 231: 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`,`specialurl`,`merchanturl`,`bann er`,`smallbanner`,`tinybanner` FROM wsnlinks_categories WHERE parent=17 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,name ASC LIMIT 0,7
Load time so far: 0.23 seconds.
Out of memory; restart server and try again (needed 207864 bytes)
An error occoured at http://localhost/Free Web Bargains/admin/updatecounters.php?filled=1 on 2008-08-31 12:10:35. Please relay this data to support. Error #2: 'mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given' in C:wampwwwFree Web Bargainsdatabasesmysqli.php on line 42. Debug info:
snlinks_comments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 18, %' OR catid = 18) ORDER BY time DESC LIMIT 0,1
Load time so far: 0.23 seconds.
Load time so far: 0.23 seconds.
Query 243: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=18 AND deleted=0 AND validated=0
Count is 0
Load time so far: 0.23 seconds.
Query 244: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=18 AND deleted=0 AND validated=0
Count is 0
Load time so far: 0.23 seconds.
Query 245: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=18 AND deleted=0 AND hide=0 AND validated=1
Count is 0
Query 246: 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`,`specialurl`,`merchanturl`,`bann er`,`smallbanner`,`tinybanner` FROM wsnlinks_categories WHERE parent=18 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,name ASC,name ASC LIMIT 0,7
Load time so far: 0.24 seconds.
Out of memory; restart server and try again (needed 207864 bytes)
An error occoured at http://localhost/Free Web Bargains/admin/updatecounters.php?filled=1 on 2008-08-31 12:10:35. Please relay this data to support. Error #2: 'mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given' in C:wampwwwFree Web Bargainsdatabasesmysqli.php on line 42. Debug info:
omments WHERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 19, %' OR catid = 19) ORDER BY time DESC LIMIT 0,1
Load time so far: 0.24 seconds.
Load time so far: 0.24 seconds.
Query 258: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=19 AND deleted=0 AND validated=0
Count is 0
Load time so far: 0.24 seconds.
Query 259: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=19 AND deleted=0 AND validated=0
Count is 0
Load time so far: 0.24 seconds.
Query 260: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=19 AND deleted=0 AND hide=0 AND validated=1
Count is 0
Query 261: 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`,`specialurl`,`merchanturl`,`bann er`,`smallbanner`,`tinybanner` FROM wsnlinks_categories WHERE parent=19 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,name ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 0.24 seconds.
Out of memory; restart server and try again (needed 207864 bytes)
An error occoured at http://localhost/Free Web Bargains/admin/updatecounters.php?filled=1 on 2008-08-31 12:10:35. Please relay this data to support. Error #2: 'mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given' in C:wampwwwFree Web Bargainsdatabasesmysqli.php on line 42. Debug info:
HERE (validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 20, %' OR catid = 20) ORDER BY time DESC LIMIT 0,1
Load time so far: 0.25 seconds.
Load time so far: 0.25 seconds.
Query 273: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=20 AND deleted=0 AND validated=0
Count is 0
Load time so far: 0.25 seconds.
Query 274: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=20 AND deleted=0 AND validated=0
Count is 0
Load time so far: 0.25 seconds.
Query 275: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=20 AND deleted=0 AND hide=0 AND validated=1
Count is 0
Query 276: 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`,`specialurl`,`merchanturl`,`bann er`,`smallbanner`,`tinybanner` FROM wsnlinks_categories WHERE parent=20 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,name ASC,name ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 0.29 seconds.
Out of memory; restart server and try again (needed 207864 bytes)
An error occoured at http://localhost/Free Web Bargains/admin/updatecounters.php?filled=1 on 2008-08-31 12:10:35. Please relay this data to support. Error #2: 'mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given' in C:wampwwwFree Web Bargainsdatabasesmysqli.php on line 42. Debug info:
(validated=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 21, %' OR catid = 21) ORDER BY time DESC LIMIT 0,1
Load time so far: 0.3 seconds.
Load time so far: 0.3 seconds.
Query 288: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=21 AND deleted=0 AND validated=0
Count is 0
Load time so far: 0.3 seconds.
Query 289: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=21 AND deleted=0 AND validated=0
Count is 0
Load time so far: 0.3 seconds.
Query 290: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=21 AND deleted=0 AND hide=0 AND validated=1
Count is 0
Query 291: 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`,`specialurl`,`merchanturl`,`bann er`,`smallbanner`,`tinybanner` FROM wsnlinks_categories WHERE parent=21 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,name ASC,name ASC,name ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 0.3 seconds.
Out of memory; restart server and try again (needed 207864 bytes)
An error occoured at http://localhost/Free Web Bargains/admin/updatecounters.php?filled=1 on 2008-08-31 12:10:35. Please relay this data to support. Error #2: 'mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given' in C:wampwwwFree Web Bargainsdatabasesmysqli.php on line 42. Debug info:
ed=1 AND hide=0 AND deleted=0) AND (parentids LIKE '%, 22, %' OR catid = 22) ORDER BY time DESC LIMIT 0,1
Load time so far: 0.3 seconds.
Load time so far: 0.3 seconds.
Query 302: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=22 AND deleted=0 AND validated=0
Count is 0
Load time so far: 0.3 seconds.
Query 303: SELECT COUNT(id) FROM wsnlinks_comments WHERE catid=22 AND deleted=0 AND validated=0
Count is 0
Load time so far: 0.3 seconds.
Query 304: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=22 AND deleted=0 AND hide=0 AND validated=1
Count is 0
Query 305: 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`,`specialurl`,`merchanturl`,`bann er`,`smallbanner`,`tinybanner` FROM wsnlinks_categories WHERE parent=22 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,name ASC,name ASC,name ASC,name ASC,name ASC,name ASC LIMIT 0,7
Load time so far: 0.3 seconds.
Out of memory; restart server and try again (needed 207864 bytes)
WSN Links 5.0.2 Admin Panel
Updating next batch of categories starting at 21 (out of 21)...
Continue
Logout | Browse Categories | Member List
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
What's your php.ini memory limit?
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
What's your php.ini memory limit?
No idea - If that is what is under admin > phpinfo > php core then it is 32M
I have never had a problem before.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
That should be plenty, mine is only 12M. Actually it looks like mysql is returning an out of memory error which eventually leads to the PHP one.
Can you reproduce this?
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
That should be plenty, mine is only 12M. Actually it looks like mysql is returning an out of memory error which eventually leads to the PHP one.
Can you reproduce this?
Yes, but only on my local computer! It happens every time. It also happens on all my local installed ones. I only have one test site for v.5 online.
Of course you are more than welcome to jump on a plane and come and see for yourself. I'll even buy you dinner
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
OK, I've now put this site up on a temp site. http://www.123club.co.uk
It is still giving this error when regenerating. If you need to take a look the Admin username is webmaster with my usual password.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
You have the same category on remote installs where it doesn't happen?
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
You have the same category on remote installs where it doesn't happen?
not quite sure I understand you, but I have this site installed on both my local and now my server and get the problem with both of them. What I did was install a new version on my server at 123club.co.uk and then simply restore a back up of my local computer install. I was hoping to go live with this site but needed to check it out before putting it on the live site.
I do NOT get it on my other test site on the server - justearings.co.uk
I have 3 other installs on my local computer - 1 DOES have the problem and the other 2 do NOT
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Then it sounds like it has to do with the particular category which is on one of the sites and not the other.
I have no idea what your usual password is, and thunderbird is enough of a pain to search in if there's only one email address involved while you've used a bunch.