Advertisement:

Author Topic: Success Story from vBulletin 3.8 to SMF 2.0.15 with 670,000 Posts  (Read 1473 times)

Offline hydtah

  • Newbie
  • *
  • Posts: 4

Hi all,

After several months of testing, We've just successfully migrated from Vbulletin 3.8 (with latin1 charset & arabic language )  to  SMF 2.0.15 (UTF8 charset )

Stats of my forum:
Members:   250,000
Posts : 670,000
Topics: 90,000

To move from dedicated server for the vbulletin forum to VPS server for the SMF forum + reduce the size of database (than reduce the price of the server from 37 $  to 9 $  8)  ), I had to empty up some of tables like : customavatar; customprofilepic; picture; sigpic; socialgroupicon; socialgrouppicture; tag; reputation; tagsearch; humanverify; externalcache; visitormessage ; visitormessage_hash


To redirect all my vbulletin forum links to the new of SMF, i used this file .htaccess form https://www.simplemachines.org/community/index.php?topic=554897.0  with some changes :


Code: [Select]
RewriteEngine On
RewriteBase /
Redirect /index.htm /smf_forum/

# SMF rewrites for vBulletin after vBSEO removed (including forum directory)
RewriteCond %{QUERY_STRING} ^t=([0-9]+)&page=[0-9]+&p=([0-9]+)#[0-9]+(.*)?/?$ [OR]
RewriteCond %{QUERY_STRING} ^t=([0-9]+)&page=[0-9]+&p=([0-9]+)(.*)?/?$
RewriteRule ^(forum)?/?showthread.php$ /smf_forum/index.php?topic=%1.msg%2#msg%2 [L,R=301]

RewriteCond %{QUERY_STRING} ^t=([0-9]+)&page=[0-9]+(.*)?/?$ [OR]
RewriteCond %{QUERY_STRING} ^t=([0-9]+)(.*)?/?$
RewriteRule ^(forum)?/?showthread.php$ /smf_forum/index.php?topic=%1.0 [L,R=301]

RewriteCond %{QUERY_STRING} ^f=([0-9]+)&page=[0-9]+(.*)?/?$ [OR]
RewriteCond %{QUERY_STRING} ^f=([0-9]+)(.*)?/?$
RewriteRule ^(forum)?/?forumdisplay.php$ /smf_forum/index.php?board=%1.0 [L,R=301]

RewriteCond %{QUERY_STRING} ^do=newthread.f=([0-9]+)(.*)?/?$
RewriteRule ^(forum)?/?newthread.php$ /smf_forum/index.php?board=%1.0 [L,R=301]


# SMF rewrite for cms author
RewriteCond %{QUERY_STRING} ^author/([0-9]+)-.*/?$ [OR]
RewriteCond %{QUERY_STRING} ^r=author/([0-9]+)-.*/?$
RewriteRule ^cms/list.php$ /smf_forum/index.php?action=profile;u=%1? [L,R=301]

# SMF rewrite for calendar
RewriteRule ^calendar\.php /smf_forum/index.php?action=calendar? [L,R=301]

# Rewrite all non-existent directories and folders to /smf_forum/index.php
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ^(.*)$ /smf_forum/index.php? [QSD,L,R=301]

Thanks to all.

Good luck to all

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 21,298
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Success Story from vBulletin 3.8 to SMF 2.0.15 with 670,000 Posts
« Reply #1 on: January 13, 2019, 10:07:12 AM »
Nice! I am glad you were able to convert such as large forum.

Also if you want you can join our big boards group since you have over 500k posts with has extra ways for you to optimize your forum.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline hydtah

  • Newbie
  • *
  • Posts: 4
Re: Success Story from vBulletin 3.8 to SMF 2.0.15 with 670,000 Posts
« Reply #2 on: January 13, 2019, 10:19:45 AM »
it's an honor to join this big community .

thanks for all the things you do...
« Last Edit: January 13, 2019, 10:58:34 AM by hydtah »

Offline GL700Wing

  • Full Member
  • ***
  • Posts: 451
  • Gender: Female
Re: Success Story from vBulletin 3.8 to SMF 2.0.15 with 670,000 Posts
« Reply #3 on: January 15, 2019, 03:56:49 AM »
Congratulations and well done!

Offline Massl

  • Jr. Member
  • **
  • Posts: 253
Re: Success Story from vBulletin 3.8 to SMF 2.0.15 with 670,000 Posts
« Reply #4 on: January 20, 2019, 11:35:03 AM »
Hi, are you sure that this is correct?
Code: [Select]
RewriteRule ^(forum)?/?showthread.php$ /smf_forum/index.php?topic=%1.msg%2#msg%2 [L,R=301]
I'm testing and I get this address
Code: [Select]
index.php?topic=1.msg2%23msg2
# is converted to %23 and links aren't valid.

Offline Massl

  • Jr. Member
  • **
  • Posts: 253
Re: Success Story from vBulletin 3.8 to SMF 2.0.15 with 670,000 Posts
« Reply #5 on: January 20, 2019, 12:08:35 PM »
OK fixed, after read this I understood that is missing NE

Code: [Select]
RewriteRule ^(forum)?/?showthread.php$ /smf_forum/index.php?topic=%1.msg%2#msg%2 [NE,L,R=301]
Change it as soon as you can!

Offline hydtah

  • Newbie
  • *
  • Posts: 4
Re: Success Story from vBulletin 3.8 to SMF 2.0.15 with 670,000 Posts
« Reply #6 on: January 24, 2019, 09:41:25 AM »
OK fixed, after read hxxp:httpd.apache.org/docs/trunk/en/rewrite/flags.html [nonactive]I understood that is missing NE

Code: [Select]
RewriteRule ^(forum)?/?showthread.php$ /smf_forum/index.php?topic=%1.msg%2#msg%2 [NE,L,R=301]
Change it as soon as you can!

 Thank you very much...