Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

Where is the auto-increment num for reviews stored?

Mar 23, 2010, 6:33 AM
MJB
Enthusiast (559 posts)
MJB's avatar
Mar 23, 2010, 6:33 AM
Post #1 of 5
Views: 3387
Shortcut
Quote Reply
Where is the auto-increment num for reviews stored?
I want to tidy my reviews up as the numbering is all over the place. It sort of goes from 1 to15 the jumps for some reason to 299. Where is the auto-increment number for reviews stored?

Last edited by:

Andy: Mar 23, 2010, 7:26 AM
Mar 23, 2010, 7:28 AM
Andy
Veteran / Moderator (18436 posts)
Andy's avatar
Mar 23, 2010, 7:28 AM
Post #2 of 5
Views: 3283
Shortcut
Quote Reply
Re: [MJB] Where is the auto-increment num for reviews stored? In reply to
Hi,

I had to edit your subject to remove the # from it, as it wouldn't let me view the post :D

Code:
I want to tidy my reviews up as the numbering is all over the place. It sort of goes from 1 to15 the jumps for some reason to 299. Where is the auto-increment number for reviews stored?

The overall Auto incriment number is stored in the table itself.

To reset it, you would use:

Code:
ALTER TABLE theTableInQuestion AUTO_INCREMENT=1234

HOWEVER, this may not quite work for you - as you if you do that, then any existing records may end up broken. Before trying it, make sure you backup the table and its contents Smile

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!
Mar 23, 2010, 9:03 AM
MJB
Enthusiast (559 posts)
MJB's avatar
Mar 23, 2010, 9:03 AM
Post #3 of 5
Views: 3274
Shortcut
Quote Reply
Re: [Andy] Where is the auto-increment num for reviews stored? In reply to
Andy wrote:
The overall Auto incriment number is stored in the table itself.

So I can't just locate that number and change it manually? If the only option is what you propose above than I'll leave it as it is as I don't want to risk creating unnecessary work if it goes wrong.
Mar 23, 2010, 9:08 AM
Andy
Veteran / Moderator (18436 posts)
Andy's avatar
Mar 23, 2010, 9:08 AM
Post #4 of 5
Views: 3282
Shortcut
Quote Reply
Re: [MJB] Where is the auto-increment num for reviews stored? In reply to
Well, you could do something like this to find the highest ReviewID:

Code:
SELECT MAX(ReviewID) FROM glinks_Reviews

...and then once you know that, then do:

Code:
ALTER TABLE glinks_Review AUTO_INCREMENT= WHATEVER THE NUMBER WAS

Again though, be sure to backup your DB first :)

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!
Mar 23, 2010, 9:39 AM
MJB
Enthusiast (559 posts)
MJB's avatar
Mar 23, 2010, 9:39 AM
Post #5 of 5
Views: 3263
Shortcut
Quote Reply
Re: [Andy] Where is the auto-increment num for reviews stored? In reply to
Finger on Enter key, eyes shut, head under desk, "CLICK"! Crazy

Looks to have done the job. w00t

I've just tried a test review and it's incremented back down to the new value. Cool