[TYPO3] uid in tt_content table hitting 2^31

tapio tapio.markula at dnainternet.net
Thu Jan 12 08:52:16 CET 2006


Michael Nardell wrote:
> Hi :: I am continuing to run into a problem in which the uid of the 
> tt_content is somehow creeping up to 2147483648 
> 
> I have been using the mysql command line to delete records that are in 
> the range of 2147483648 from tt_content. However, somehow things the 
> pages seem to creep up to this uid.

if you once get that quantity MySQL continues automatic from the last 
number.
What you can do is to create a SQL-dump and reset the counter

in SQL-files you see for example
TYPE=MyISAM AUTO_INCREMENT=561 ;

reset the  AUTO_INCREMENT - it must be at least NEXT value, which is in 
the current database



More information about the TYPO3-english mailing list