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 3182 Jul 20, 2008, 6:24 AM
Thread Re: [blacknight] How Can I Reset Link ID?
Andy 3142 Jul 20, 2008, 6:32 AM
Thread Re: [Andy] How Can I Reset Link ID?
blacknight 3099 Jul 20, 2008, 6:33 AM
Thread Re: [blacknight] How Can I Reset Link ID?
Andy 3093 Jul 20, 2008, 6:37 AM
Thread Re: [Andy] How Can I Reset Link ID?
blacknight 3089 Jul 20, 2008, 6:38 AM
Thread Re: [blacknight] How Can I Reset Link ID?
Andy 3100 Jul 20, 2008, 6:39 AM
Thread Re: [Andy] How Can I Reset Link ID?
blacknight 3097 Jul 20, 2008, 6:40 AM
Post Re: [blacknight] How Can I Reset Link ID?
Wychwood 3062 Jul 22, 2008, 2:40 AM