[Dr. Bantham]

Originally Posted by Cap'n Steve

About the alter query, that was a typo and it should actually be run on the quotes table. The table prefix is whatever you chose in your config.php. I have no experience altering the auto_increment value, but it should only affect new quotes. I'm not sure how the gaps would get there in the first place; have you restored backups of the quotes table before? That's the only thing I can think of that might mess with the auto_increment value.

I fixed this with:
[sql]ALTER TABLE quotes AUTO_INCREMENT=252[/SQL]Instead of using 1 as the variable, I used the next desired quote number. This set the Next Autoindex to the desired value. The huge gaps occurred when I had repeatedly deleted and imported quotes from a text file. Thanks for the lead!