Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Negative Link Count

Quote Reply
Negative Link Count
I have a problem with some categories showing a negative number of links. I am almost certain this happens only when a link owner submits a listing to the wrong category. I then change the category before validating the link.

The original category then shows a -1 link in the link count (or more if this happened more than once). What's more, the category in which I moved those links into, presents an accessive number of links - in the same amount...

For instance look here:

http://www.meowhoo.com/...d_Showing/index.html

I've had 5 users submitting their link into Home : Breeders and Showing : Clubs and Associations : Persian

But as these were in fact breeders, when I reviewed their entries, I changed the category into: Home : Breeders and Showing : Breeders (by Breed) : Persian

Now if you look here: http://www.meowhoo.com/...ociations/index.html

you'll see that the number of listings under Persians shows -5 listings (when in fact there are zero listings)

If you look here:

http://www.meowhoo.com/...by_Breed_/index.html

You'll see that the number of listings under Persians shows 11 listings (when in fact there are only 8)

I did look it up on the forums and asked my server support team to repair the tables. They said they did but the problems persists :(

If you love cats - visit www.TheCatSite.com

Visit my LinkSQL based Cat Site - www.Meowhoo.com
Quote Reply
Re: [Anat] Negative Link Count In reply to
You can repair negative link counts by running a forced link count repiar and re-building (all).
nph-build.cgi?do=repair&force=1


http://www.iuni.com/...tware/web/index.html
Links Plugins

Last edited by:

Ian: Sep 4, 2002, 7:37 AM
Quote Reply
Re: [Ian] Negative Link Count In reply to
How do I do that? Is that done through LSQL? Is that something I run through my browser (as a web address)?

A "For Dummies" version is needed please! Blush

If you love cats - visit www.TheCatSite.com

Visit my LinkSQL based Cat Site - www.Meowhoo.com
Quote Reply
Re: [Anat] Negative Link Count In reply to
Just call it from your browser. I.e

http://www.yoursite.com/cgi-bin/links_sql/admin/nph-build.cgi?do=repair&force=1

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: [Anat] Negative Link Count In reply to
Just run it from the browser:

http://www.yoursite.com/...o=repair&force=1


http://www.iuni.com/...tware/web/index.html
Links Plugins

Last edited by:

Ian: Sep 4, 2002, 9:16 AM
Quote Reply
Re: [Ian] Negative Link Count In reply to
LOL...beat ya by a few seconds Wink

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] Negative Link Count In reply to
well, I did it and seemed to run it with the following results:

Checking category stats ...
Updating Cat Health counters ... 4 ok!
Updating Behavior & Training counters ... 1 ok!
Updating Basic Pet Supplies counters ... 11 ok!
Updating Cat Furniture counters ... 6 ok!
Updating Grooming & Skin Care counters ... 8 ok!
Updating Breeders and Showing counters ... 24 ok!
Updating Pet Insurance counters ... 0 ok!
Updating Cat Themed Gifts counters ... 12 ok!
Updating Art, Leisure and Entertainment counters ... 10 ok!
Updating Cat Food counters ... 3 ok!
Updating Grief Management counters ... 3 ok!
Updating Cat Fashion counters ... 1 ok!
Updating Rescue counters ... 0 ok!
Updating Web Resources counters ... 0 ok!
Updating Specialized Pet Services counters ... 5 ok!
Done (2.00 s)

Resetting hits and rates ...
Done (0.00 s)

Checking for orphan links ...
Done (0.00 s)

Updating New Flags ...
Done (0.00 s)

Updating Changed Flags ...
Done (0.00 s)

Updating Cool Flags ...
Done (0.00 s)

All done. Total Time: (2.00 s)


I then ran "Build All" and refreshed the pages in my browser but it still shows the same errors:

http://www.meowhoo.com/...d_Showing/index.html



Unsure

If you love cats - visit www.TheCatSite.com

Visit my LinkSQL based Cat Site - www.Meowhoo.com
Quote Reply
Re: [Anat] Negative Link Count In reply to
Looks fine to me (I actually counted the links....).

Ivan
-----
Iyengar Yoga Resources / GT Plugins
Quote Reply
Re: [Anat] Negative Link Count In reply to
I don't see any negative numbers there....are you sure its not just a cached version on your PC?

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] Negative Link Count In reply to
BlushBlushBlushBlushHow many times should ine click refresh?

5th time worked for me...

If you love cats - visit www.TheCatSite.com

Visit my LinkSQL based Cat Site - www.Meowhoo.com
Quote Reply
Re: [Anat] Negative Link Count In reply to
Try holding down the SHIFT key when you click Refresh as it forces a new request to the server for the page and a gives you a complete reload (without using anything from the browser's cache).

I used to get frustrated at not seeing the changes in page until I realised my browser was throwing the exact same cached page back at me time and again Smile

Hope this helps.
Shaun
Quote Reply
Re: [qango] Negative Link Count In reply to
what a useful tip!

Thank you!

If you love cats - visit www.TheCatSite.com

Visit my LinkSQL based Cat Site - www.Meowhoo.com