Announcement

Collapse
No announcement yet.

ASPPlayground Date Error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • ASPPlayground Date Error

    There seems to be quite a few dates coming over as 1970? Any ideas?
    Last edited by Mosaicvb; Sun 12 Dec '04, 5:08pm.

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

    Comment


    • #3
      Did you update all the counters?
      Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
      Change CKEditor Colors to Match Style (for 4.1.4 and above)

      Steve Machol Photography


      Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


      Comment


      • #4
        Yep I did

        Comment


        • #5
          And they are still 1970 after updating ?

          Are these post dates or join dates ? or just all dates in general ?
          I wrote ImpEx.

          Blog | Me

          Comment


          • #6
            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.

            Comment


            • #7
              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

              Comment


              • #8
                Okies, have caught them now, all sorted in 1.45.
                I wrote ImpEx.

                Blog | Me

                Comment


                • #9
                  Thanks Jerry!

                  Comment


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

                    Comment


                    • #11
                      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.
                      I wrote ImpEx.

                      Blog | Me

                      Comment

                      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                      Working...
                      X