why are the id numbbers always start with 7?

A place to discuss and receive support for the Web Auction application.

why are the id numbbers always start with 7?

Postby 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
Image
Klaus G Schulz, CPP-OCP
Greyhound Adoption Squad-Canada
www.t-legs.com

Not everyone needs a Greyhound,
But every retired racing Greyhound, needs someone....
GrizBear
 
Posts: 30
Joined: Thu Sep 02, 2010 3:15 pm
Location: Montreal, QC, CANADA

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

Postby 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
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm

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

Postby 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.....
Image
Klaus G Schulz, CPP-OCP
Greyhound Adoption Squad-Canada
www.t-legs.com

Not everyone needs a Greyhound,
But every retired racing Greyhound, needs someone....
GrizBear
 
Posts: 30
Joined: Thu Sep 02, 2010 3:15 pm
Location: Montreal, QC, CANADA

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

Postby 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.
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm

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

Postby 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

GB
Image
Klaus G Schulz, CPP-OCP
Greyhound Adoption Squad-Canada
www.t-legs.com

Not everyone needs a Greyhound,
But every retired racing Greyhound, needs someone....
GrizBear
 
Posts: 30
Joined: Thu Sep 02, 2010 3:15 pm
Location: Montreal, QC, CANADA


Return to Web Auction Discussion

Who is online

Users browsing this forum: Google [Bot] and 3 guests

cron
Powered by Dataface
© 2005-2007 Steve Hannah All rights reserved