Which table stores the forum stats ???

[micks80]

Hi Friends,
I had to move my site from shared to VPS hosting account and in process i had to manually update the SMF database table by table. Everything else looks fine,except this part:

Code Select Expand


Forum stats:
3 Posts in 3 Topics by 7000 Members.

Most Online Today: 3. Most Online Ever: 9 (October 10, 2007, 07:56:12 PM)
[code]

These both entries are wrong and they are not being picked up from the old database.I would appreciate if someone can help me by telling which table in the database these values are stored in and i can double check or try to restore the values from my old database back up.

Thanks for your help and time.[/code]

[Bulakbol]

The smf_log_online table fieldset:

date
hits
topics
posts
registers
monstOn

That's where the data are stored.

[Something like that]

Hi Friends,
I had to move my site from shared to VPS hosting account and in process i had to manually update the SMF database table by table. Everything else looks fine,except this part:

Code Select Expand


Forum stats:
3 Posts in 3 Topics by 7000 Members.

Most Online Today: 3. Most Online Ever: 9 (October 10, 2007, 07:56:12 PM)


These both entries are wrong and they are not being picked up from the old database.I would appreciate if someone can help me by telling which table in the database these values are stored in and i can double check or try to restore the values from my old database back up.

Thanks for your help and time.

Those are stored in the "smf_settings" table. The entries you want are mostOnline, mostOnlineToday, mostDate, etc. You should be able to figure them out

[micks80]

Thanks a lot friends..worked like a charm!!!