Webmastersite.net
Register Log In

Sub categories
not appearing on main page

Comments on Sub categories

robinantill
Member

Usergroup: Customer
Joined: Aug 06, 2004

Total Topics: 10
Total Comments: 15
Posted Aug 27, 2008 - 10:26 AM:

I updated to version 4.1.64 and then run update.php.

When the front page - index.php - comes up it does not show the sub-categories which it did before.

When you click through to categories you can see the sub categories on that page. How can I make the sub categories appear on front page, as before? Can you advise?

Regards
babrees
Expert

Usergroup: Customer
Joined: Aug 19, 2005
Location: England

Total Topics: 391
Total Comments: 1303
babrees
Posted Aug 27, 2008 - 1:28 PM:

I can see the sub categories on the front page.

But what I do see, which I shouldn't, is {LOADSTATS}
Paul
developer

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

Total Topics: 61
Total Comments: 7868
Paul
Posted Aug 27, 2008 - 2:10 PM:

{LOADSTATS} was in 4.0 era templates, one of the reasons the instructions say to overwrite templates between 4.0 and 4.1.

There's a huge white gap which probably relates to the 43 html errors and 73 html warnings.

robinantill
Member

Usergroup: Customer
Joined: Aug 06, 2004

Total Topics: 10
Total Comments: 15
Posted Aug 27, 2008 - 2:34 PM:

Hi Paul,

I have now updated to version 5.02

Thanks for that. I have gone back to the original 5.02 templates and this produces the following:-

An error occoured at http://www.gardenbuildings.com/directory/index.ph... on 2008-08-27 18:27:40. Please relay this data to support. Error #2: 'mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given' in /home/gardscom/public_html/directory/databases/mysqli.php on line 42. Debug info:
ds.



Query 21: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=22 AND validated=1 AND hide=0 AND deleted=0 AND type='super' AND effectivetime < 1219861659

Count is 1

Load time so far: 0.18 seconds.



Query 22: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=22 AND validated=1 AND hide=0 AND deleted=0 AND type='full' AND effectivetime < 1219861659

Count is 0

Load time so far: 0.18 seconds.



Query 23: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=22 AND validated=1 AND hide=0 AND deleted=0 AND type='gb' AND effectivetime < 1219861659

Count is 0

Load time so far: 0.18 seconds.



Query 24: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=22 AND validated=1 AND hide=0 AND deleted=0 AND type='nolink' AND effectivetime < 1219861659

Count is 0

Query 25: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`paren tnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom `,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`t ype`,`permissions`,`subscribers`,`subscriber`,`mixtypes`,`is album`,`orderlinks`,`totalcomments`,`ulsearchmax`,`ulsearchq uery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`dmozpath `,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,` reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposter id`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastt hreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomme nts`,`actaslink`,`countposts`,`subcatshtml`,`linksperpage`,` wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaul tnoaccess`,`lastthreadurl`,`lastposturl`,`specialurl` FROM wsnlinks_categories WHERE deleted=0 AND validated=1 AND isalbum=0 AND alias=0 AND hide=0 AND MATCH (name) AGAINST('Decking Fencing Gates') AND id != 22 LIMIT 0,5

Load time so far: 0.19 seconds.

Can't find FULLTEXT index matching the column list

An error occoured at http://www.gardenbuildings.com/directory/index.ph... on 2008-08-27 18:27:40. Please relay this data to support. Error #2: 'mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given' in /home/gardscom/public_html/directory/databases/mysqli.php on line 45. Debug info:
='full' AND effectivetime < 1219861659

Count is 0

Load time so far: 0.18 seconds.



Query 23: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=22 AND validated=1 AND hide=0 AND deleted=0 AND type='gb' AND effectivetime < 1219861659

Count is 0

Load time so far: 0.18 seconds.



Query 24: SELECT COUNT(id) FROM wsnlinks_links WHERE catid=22 AND validated=1 AND hide=0 AND deleted=0 AND type='nolink' AND effectivetime < 1219861659

Count is 0

Query 25: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`paren tnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom `,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`t ype`,`permissions`,`subscribers`,`subscriber`,`mixtypes`,`is album`,`orderlinks`,`totalcomments`,`ulsearchmax`,`ulsearchq uery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`dmozpath `,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,` reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposter id`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastt hreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomme nts`,`actaslink`,`countposts`,`subcatshtml`,`linksperpage`,` wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaul tnoaccess`,`lastthreadurl`,`lastposturl`,`specialurl` FROM wsnlinks_categories WHERE deleted=0 AND validated=1 AND isalbum=0 AND alias=0 AND hide=0 AND MATCH (name) AGAINST('Decking Fencing Gates') AND id != 22 LIMIT 0,5

Load time so far: 0.19 seconds.

Can't find FULLTEXT index matching the column list

Number of rows is Can't find FULLTEXT index matching the column list

Load time so far: 0.19 seconds.

Can't find FULLTEXT index matching the column list

Query 26: SELECT COUNT(id) FROM wsnlinks_categories WHERE deleted=0 AND validated=1 AND isalbum=0 AND alias=0 AND hide=0 AND MATCH (name) AGAINST('Decking Fencing Gates') AND id != 22

Can you help? Regards.
Paul
developer

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

Total Topics: 61
Total Comments: 7868
Paul
Posted Aug 28, 2008 - 12:45 PM:

Responded to email copy -- 4.0->4.1 upgrade issue causing fulltext index to not be created.
Search thread for
Download thread as
  • 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.