[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