Full database??

[Ajaxno1]

This night I deleted all of my member groups and made  new ones but at least half of te groups weren't saved. So I looked in the database en saw that the ID din't go futher than 127. But I delted every post but the databse stayed at 127. (does somebody know to set it to count 1 at the last ID) For now I made the ID from tinyint to smallint it worked but now I asked my self what is the post or reactions database is full?? And how can I solve this?

[Greg Robson]

By deleting the groups using a query like this:

DELETE FROM table_name WHERE id = 'x';

where x is a number, MySQL won't reset the start number, however:

DELETE FROM table_name;      or
TRUNCATE TABLE table_name;

should remove all the records and reset the next auto number data.

If you have altered the id to a smallint then you should have no problems in the forseeable future.

I've designed the DB for YSE 2 and I've ensured that this sort of thing won't happen (unless you're running a service like www.hardforum.com - in which case you'd be doing some hefty optimisation anyway!).