v.0.6.11-CVS Posting New Entry

Found a bug? Tell us!!
Post Reply
gwr02
Regular
Posts: 8
Joined: Thu Jul 22, 2004 6:50 pm
Contact:

v.0.6.11-CVS Posting New Entry

Post by gwr02 »

When I post a new entry it skips a number. I use MYSQL.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: v.0.6.11-CVS Posting New Entry

Post by garvinhicking »

gwr02 wrote:When I post a new entry it skips a number. I use MYSQL.
Please explain what exactly is happening and what you expect
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
gwr02
Regular
Posts: 8
Joined: Thu Jul 22, 2004 6:50 pm
Contact:

v.0.6.11-CVS Posting New Entry

Post by gwr02 »

I just noticed it only skips a number when I have deleted an entry.

If I make an entry #200 then delete it. Then make a new entry. The new entry is #201.

Or if I've deleted two entries it would be #202.

Even when I edit the database manually and change the id numbers in serendipityentries and entryid in serendipityentrycat the next entry I make still skips the deleted entries.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: v.0.6.11-CVS Posting New Entry

Post by garvinhicking »

This is a common database issue. IDs are autoincremented by the database, assigning new IDs everytime. It's not a malfunction :)
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Post Reply