[TYPO3] uid in tt_content table hitting 2^31
media.res | alex widschwendter
a.widschwendter at mediares.at
Thu Jan 12 17:50:37 CET 2006
hi,
> Hi :: I am continuing to run into a problem in which the uid of the
> tt_content is somehow creeping up to 2147483648 (2^31 the limit of mysql
> ints.) As you may guess, I have nowhere near this many pages in my site.
> Somehow things have been corrupted. I am not sure of how to best clean
> up the tables to restore the CMS to a proper state.
>
> 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. Are there some other tables I need
> to clean up to lower the index of pages to a more reasonable number? If
> anyone has encountered this problem, and can suggest a solution, it
> wouldd be appreciated.
use the mysql repair command ...
hth alex
More information about the TYPO3-english
mailing list