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 (511 posts)
MJB's avatar
Mar 23, 2010, 6:33 AM
Post #1 of 5
Views: 741
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 (17366 posts)
Andy's avatar
Mar 23, 2010, 7:28 AM
Post #2 of 5
Views: 730
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

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Mar 23, 2010, 9:03 AM
MJB
Enthusiast (511 posts)
MJB's avatar
Mar 23, 2010, 9:03 AM
Post #3 of 5
Views: 725
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 (17366 posts)
Andy's avatar
Mar 23, 2010, 9:08 AM
Post #4 of 5
Views: 722
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

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Mar 23, 2010, 9:39 AM
MJB
Enthusiast (511 posts)
MJB's avatar
Mar 23, 2010, 9:39 AM
Post #5 of 5
Views: 719
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