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 2666 Jul 20, 2008, 6:24 AM
Thread Re: [blacknight] How Can I Reset Link ID?
Andy 2639 Jul 20, 2008, 6:32 AM
Thread Re: [Andy] How Can I Reset Link ID?
blacknight 2601 Jul 20, 2008, 6:33 AM
Thread Re: [blacknight] How Can I Reset Link ID?
Andy 2595 Jul 20, 2008, 6:37 AM
Thread Re: [Andy] How Can I Reset Link ID?
blacknight 2591 Jul 20, 2008, 6:38 AM
Thread Re: [blacknight] How Can I Reset Link ID?
Andy 2602 Jul 20, 2008, 6:39 AM
Thread Re: [Andy] How Can I Reset Link ID?
blacknight 2593 Jul 20, 2008, 6:40 AM
Post Re: [blacknight] How Can I Reset Link ID?
Wychwood 2564 Jul 22, 2008, 2:40 AM