Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Where is the auto-increment num for reviews stored?

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
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!
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.
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!
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