Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 18 May 2012, 09:10
rommy420 rommy420 is offline
 
Join Date: Jan 2010
Unhappy Wierd issue with posts, Thread and USers

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.
Reply With Quote
  #2  
Old 18 May 2012, 17:16
Lynne's Avatar
Lynne Lynne is online now
 
Join Date: Sep 2004
Real name: 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.
__________________
Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #3  
Old 18 May 2012, 21:20
rommy420 rommy420 is offline
 
Join Date: Jan 2010
Site is working fine so I think i should let it go like this ?
Reply With Quote
  #4  
Old 18 May 2012, 22:00
borbole's Avatar
borbole borbole is offline
 
Join Date: Jan 2010
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?
__________________
I am giving away some of my paid mods for free. Please pm me if you are interested.

My mods.
Reply With Quote
Reply


Similar Threads
Thread Thread Starter Forum Replies Last Post
Only Show A Specific Users Posts In A Thread NTLDR vBulletin 3.0 Full Releases 4 17 Jan 2004 08:37

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 21:10.

Layout Options | Width: Wide Color: