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 (https://www.simplemachines.org/community/index.php?topic=554897.0) with some changes :
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 [NE,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
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.
it's an honor to join this big community .
thanks for all the things you do...
Congratulations and well done!
Hi, are you sure that this is correct?
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
index.php?topic=1.msg2%23msg2
# is converted to %23 and links aren't valid.
OK fixed, after read this (https://httpd.apache.org/docs/trunk/en/rewrite/flags.html)I understood that is missing NE
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!
Quote from: _max_ on January 20, 2019, 12:08:35 PM
OK fixed, after read this (https://httpd.apache.org/docs/trunk/en/rewrite/flags.html)I understood that is missing NE
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...
I have just converted from VBulletin 3.8.5 (using convertor vbulletin37), I went to SMF v2.0 and then v2.1. I hadn't thought about redirecting old VB URLs until reading this thread. Is it too late? If not, I'd be really grateful if someone could advise how I go about doing so.
thanks
Quote from: MartyHunter on June 20, 2023, 08:46:03 PMI hadn't thought about redirecting old VB URLs until reading this thread. Is it too late? If not, I'd be really grateful if someone could advise how I go about doing so
For anyone about to answer, this question has it already been asked in the relevant support board. - https://www.simplemachines.org/community/index.php?topic=586252.msg4154695#msg4154695
@MartyHunter - please don't crosspost. It just causes confusion. Thanks.
Quote from: Steve on June 21, 2023, 03:04:07 PM@MartyHunter - please don't crosspost. It just causes confusion. Thanks.
Sorry Steve. I forgot I had posted it there (and nobody has spotted it there either!). I will raise it again over there once the current issue is dealt with. Apologies again.
No worries. :)