Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Count Links

Quote Reply
Count Links
Seems i have again a problem, that i thought to have solved it.

My links come from an external source, they are added directly by a script to table Links/CatLinks.
To fix the number of Links i use Database > Repair Tables as usual.

Now i have

USA (608)
> Alabama (0)
>> Auburn (1)

I have checked the dataset of Alabama, DL and NoL are 0.
I have no idea why the root cat is calculated right, the level2 cat is calculated right, but the one between not.
Quote Reply
Re: [Robert] Count Links In reply to
I have checked everything twice, the tree also.
I have tried wrong numbers and "repair tables" makes the right job for root cats and last cats, but not between.
Quote Reply
Re: [Robert] Count Links In reply to
Ok. The trick is:

update Category set Number_of_Links = '7777777' where CatDepth = '0';
so we change the NoL of the RootCats; now the recalc does the job.
Quote Reply
Re: [Robert] Count Links In reply to
Mmm that is weird. Not sure I've seen that before.

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Count Links In reply to
I am not really shure. It seems one of my scripts makes problems with Full_Name;
It is a really funny story to work with two languages and two fields for path of cat pages, to care for Umlauts and UTF with our beloved (and old) lady.
Quote Reply
Re: [Robert] Count Links In reply to
Oh yes, incorrect Full_Name values can cause issues (especially if being carried over from another system)

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!