Gossamer Forum
Home : Products : Gossamer Links : Discussions :

How Can I Reset Link ID?

Quote Reply
How Can I Reset Link ID?
Two of my glinks installs were being hit hard by spammers, so the link ID numbers are insanely high

On one of them the ID is has gone past 55 million, while on the other the link ID is in the high thousands

What I'd like to do is reset the link IDs ie. update all existing links to use consecutive IDs and thus remove the rather large gaps in the ID numbers

It used to be quite easy to do this using the old flatfile version of Links, but I've no idea what the safest and sanest way of doing it on glinks sql would be

TIA

Michele
Blacknight Solutions - Hosting
Search.ie
Armchair.ie
Subject Author Views Date
Thread How Can I Reset Link ID? blacknight 4669 Jul 20, 2008, 6:24 AM
Thread Re: [blacknight] How Can I Reset Link ID?
Andy 4607 Jul 20, 2008, 6:32 AM
Thread Re: [Andy] How Can I Reset Link ID?
blacknight 4566 Jul 20, 2008, 6:33 AM
Thread Re: [blacknight] How Can I Reset Link ID?
Andy 4559 Jul 20, 2008, 6:37 AM
Thread Re: [Andy] How Can I Reset Link ID?
blacknight 4553 Jul 20, 2008, 6:38 AM
Thread Re: [blacknight] How Can I Reset Link ID?
Andy 4563 Jul 20, 2008, 6:39 AM
Thread Re: [Andy] How Can I Reset Link ID?
blacknight 4567 Jul 20, 2008, 6:40 AM
Post Re: [blacknight] How Can I Reset Link ID?
Wychwood 4522 Jul 22, 2008, 2:40 AM