Item ID Incrementing Question - Joomla! Forum - community, help and support

ok , iv removed joomblog .. including database entries ... fine ,,  except  when create new item , id's still incrementing 88888899 ...  search database , cant find anywhere specifies item id start incrementing ? ...  iv removed item id 888888 in ..

can ??


p.s .. mods please dont move thread components ..  threads ingored there ... had figure 1 out self ,and far im concerned little joomla knowledge me here .. has nothing joomblog anymore ...


[mod note: please not *crosspost*. you've posted topic in http://forum.joomla.org/index.php/topic ... #msg612774
see forum rules: http://forum.joomla.org/index.php/topic,65.0.html

gazeek wrote:ok , iv removed joomblog .. including database entries ... fine ,,  except  when create new item , id's still incrementing 88888899 ...  search database , cant find anywhere specifies item id start incrementing ? ...  iv removed item id 888888 in ..

the autoincrement kept system variable mysql. cannot change in joomla.
with phpmyadmin export table structure (from table id= 88888899).
you might notice last line like:
) engine=myisam default charset=latin1 auto_increment=60 ;
here next inserted record id 60.

(if want lower autoincrement, can following @ own risk!!!:
backup first!
export structure + data of table
drop table
run sql query defines structure, change autoincrement in last line auto_increment=0 ;
run sql query inserts data.
that's it. autoincrement might lower)