Wierd issue with posts, Thread and USers

[rommy420]

Hi,

I have a forum and I had this issue long back but never thought of knowing the cause of it. Today I would like to discuss the issue with it.

3 of the Tables - post, thread and users have had some issue because of which the post, thread and user count has moved up abruptly from what it is in real.

Example:

I have 60k users but whenever new one registers he gets the ID 300000+
Total posts are Half a million but whenever some one posts fresh it gives it ID 4.5 million+
I have 2.5 Lakh thread but every new thread has values in millions+ n so on..

Any way i can fix it to bring it closer to the real stats on my site?

Ty.

[Lynne]

You can't really fix it now that you have left it that way for a while. The best thing to do would go back to a working database.

[rommy420]

Site is working fine so I think i should let it go like this ?

[borbole]

It looks like an increase of the auto-increment value for the userid field in the user table. The same goes for the other 2 fields (threadid and postid fields) in the thread and post tables. When did you notice this for the first time?