why are the id numbbers always start with 7?

Archived from the Web Auction Discussion forum.

GrizBear — Thu Mar 15, 2012 9:31 am

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

shannah — Fri Mar 16, 2012 9:42 am

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

GrizBear — Fri Mar 16, 2012 5:08 pm

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

shannah — Fri Mar 16, 2012 8:27 pm

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.

GrizBear — Sun Mar 18, 2012 6:32 pm

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