1,000,000 Posts Import Completed

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • URLJet
    Member
    • Sep 2005
    • 37

    1,000,000 Posts Import Completed

    I just completed my import from UBB.

    I’m concerned about ubb code that did not make the transition, such as this post on the original forum:
    http://duc.digidesign.com/showflat.php?Number=1300545

    Looks very different on the new forum:
    http://208.86.158.125/showthread.php?p=1265341

    It appears the bulletin points are the issue. Has anyone seen this before? Can it be corrected?
    URLJet.com -- Performance vBulletin Hosting it's what we do!
    Free upgrades, hack installs, and more
    True Hourly Backups including DB's
    15K RPM Drives | Secure RIAD 5 & 10 Disk Arrays
  • Jerry
    Senior Member
    • Dec 2002
    • 9137
    • 1.1.x

    #2
    Just needs some cleanup with the bb code, all imports typically have some HTML that is parsed that doesn't make it correctly.
    I wrote ImpEx.

    Blog | Me

    Comment

    • URLJet
      Member
      • Sep 2005
      • 37

      #3
      Thanks for the reply.

      Is that something I just go through manaully or is there something I'm missing?
      URLJet.com -- Performance vBulletin Hosting it's what we do!
      Free upgrades, hack installs, and more
      True Hourly Backups including DB's
      15K RPM Drives | Secure RIAD 5 & 10 Disk Arrays

      Comment

      • Jerry
        Senior Member
        • Dec 2002
        • 9137
        • 1.1.x

        #4
        Originally posted by okctalk
        Thanks for the reply.

        Is that something I just go through manaully or is there something I'm missing?
        Is there any other HTML that is broken or that you'd want to clean up ?
        I wrote ImpEx.

        Blog | Me

        Comment

        • URLJet
          Member
          • Sep 2005
          • 37

          #5
          Thank you for you help Jerry. I've come across about 2 nagging issues.

          It seems that imported quotes have an extra space in the BB code so they parse in the posts like:

          [ QUOTE ]
          I just added 5 buttons to move one item at a time.

          [/ QUOTE ]

          Is there some query I can run to clean that up and remove the space?

          Also, if you go to this thread and review post #6 you will see a sample of what many of the signatures are doing:

          You will also notice in that same posts smilies that are not meant to be there are parsed.
          Last edited by URLJet; Fri 18 Jul '08, 9:18pm.
          URLJet.com -- Performance vBulletin Hosting it's what we do!
          Free upgrades, hack installs, and more
          True Hourly Backups including DB's
          15K RPM Drives | Secure RIAD 5 & 10 Disk Arrays

          Comment

          • URLJet
            Member
            • Sep 2005
            • 37

            #6
            Oh man, another issue I have is whenever you view any of our 82,000 member profiles this error is parsed at the top.

            Warning: mktime() expects parameter 4 to be long, string given in [path]/includes/class_userprofile.php on line 260

            I can fix the issue by manually completing the birthday fields but to do all 82,000 might take a while. Can I run a query for that also and enter some default data?

            See attachment or image below:

            Attached Files
            URLJet.com -- Performance vBulletin Hosting it's what we do!
            Free upgrades, hack installs, and more
            True Hourly Backups including DB's
            15K RPM Drives | Secure RIAD 5 & 10 Disk Arrays

            Comment

            • Jerry
              Senior Member
              • Dec 2002
              • 9137
              • 1.1.x

              #7
              Yes this SQL will reset the birthdays :

              Code:
              UPDATE user SET  birthday='', birthday_search  = '0000-00-00';
              I wrote ImpEx.

              Blog | Me

              Comment

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