Bad date in "last posted" after import

[djbaxter]

vB 3.60

Imported from SMS 1.1 RC2.

Now most of the threads on the index page say "Never" under Last Post, and the dates on the threads all say:


December 31st, 1969 07:00 PM

Can I run an SQL query to change the appropriate field(s) to update this to say August 21, 2006 at 9:00 am (date I imported)? If so, what would be the MySQL syntax?

Or is there an admin function to update those fields automatically?

[Steve Machol]

Please follow the 'After the Import' instructions here:

http://www.vbulletin.com/docs/html/impex_cleanup?manualversion=30501500

This should solve those issues.

[djbaxter]

Is it this part?


Counters

Update the Threads and Forums counters after an import to reflect the true values for each forum and thread.

Maintenance > Update Counters > Rebuild Thread Information
Maintenance > Update Counters > Rebuild Forum Information

[Steve Machol]

That's part of it, yes.

[djbaxter]

Thanks. That did the trick. :)

[voice903fm]

I have that same problem. The December 31st, 1969 is listed as their last visit.

I've rebuildt the THREAD and the FORUM information and it's still showing the December 31st, 1969 date.

Is there anything else I'm missing?

[peterska2]

Please start your own thread with all the relevant details including what you have imported from.