ASPPlayground Date Error

[Mosaicvb]

There seems to be quite a few dates coming over as 1970? Any ideas?

[Mosaicvb]

The importer seems to create Two of the following:
Administrator Group
Imported_Users Group
Moderators Group

[Steve Machol]

Did you update all the counters?

[Mosaicvb]

Yep I did

[Jerry]

And they are still 1970 after updating ?

Are these post dates or join dates ? or just all dates in general ?

[Mosaicvb]

Update :

Here are some MS SQL queries to double check the imports.

select forumtitle, pgd_Forums.forumid, subject, body from dbo.pgd_Messages, dbo.pgd_Forums where
pgd_Forums.forumid=pgd_Messages.forumid and
parent = 0 and (subject like '%just wonder%' or subject like '%Martinsville%')

This allows you to search for post titles.

select forumtitle, count(distinct(threadid)) AS Threads, count(distinct(messageid)) AS Posts from pgd_Messages, pgd_Forums where
pgd_Forums.forumid=pgd_Messages.forumid
group by forumtitle

This gives you the counts from the database for threads and posts.

[Mosaicvb]

The date errors are on signup and last login. All show as 1970. I checked the data in the original database Jerry used and the dates are valid in the signup column and last visit date column

[Jerry]

Okies, have caught them now, all sorted in 1.45.

[Mosaicvb]

Thanks Jerry!

[Mosaicvb]

Whats with the double groups as mentioned earlier? Should I just delete them?

[Jerry]

All custom groups that appear after and import will be from the source board, you can either manage the users in thoese groups or move them to the default groups the delete them, its up to you.

I'd suggest moveing the users to the default groups then deleting them as if you ever do another import, the groups will be created again for the next source board, and again for the next and so on.