Page 1 of 1

why are the id numbbers always start with 7?

PostPosted: Thu Mar 15, 2012 9:31 am
by GrizBear
Master Steve could you help with the ID numbers for articles, the first ID number is always 7

it's so annoying every-time you start a new auction, there is 1 category already in there, I don't need categories and the articles is always ID 7.....

Thanks a bunch...

GrizBear

Re: why are the id numbbers always start with 7?

PostPosted: Fri Mar 16, 2012 9:42 am
by shannah
Probably the install.sql script specifies that auto increment starts at 7. This is just an artifact of when I exported it from the original database. This could be removed without any negative side-effects.

-Steve

Re: why are the id numbbers always start with 7?

PostPosted: Fri Mar 16, 2012 5:08 pm
by GrizBear
shannah wrote:Probably the install.sql script specifies that auto increment starts at 7. This is just an artifact of when I exported it from the original database. This could be removed without any negative side-effects.

-Steve


Could you please tell me where I could do that....

Thank you Master....

PS: I would also thank you for your fast reply's.....

Re: why are the id numbbers always start with 7?

PostPosted: Fri Mar 16, 2012 8:27 pm
by shannah
In the install/install.sql file, there are a number of create table statements that include AUTO_INCREMENT=7 . Just delete these AUTO_INCREMENT=7 occurrences and it will fix the problem for future installs.

Re: why are the id numbbers always start with 7?

PostPosted: Sun Mar 18, 2012 6:32 pm
by GrizBear
shannah wrote:In the install/install.sql file, there are a number of create table statements that include AUTO_INCREMENT=7 . Just delete these AUTO_INCREMENT=7 occurrences and it will fix the problem for future installs.


Thanks I will try on the next auction install.....in one week..

Thanks a kajillion

GB