VBulletin 3.8 to Discourse on Docker Migration Test Take Four


 
Thread Tools Search this Thread
The Lounge What is on Your Mind? VBulletin 3.8 to Discourse on Docker Migration Test Take Four
# 15  
Old 03-17-2020
Moving along.....

Code:
Closing topics...
	``````````
Postprocessing posts...
   556410 / 1027936 ( 54.1%)

# 16  
Old 03-17-2020
Close to baked:

Code:
Postprocessing posts...
  1027939 / 1027939 (100.0%)  
Creating Permalink File...


updating banned users
     3134 / 3134 (100.0%)  

Updating topic status

Updating bumped_at on topics

Updating last posted at on users

Updating last seen at on users

Updating topic reply counts...
    12466 / 138032 (  9.0%)  [9565 items/min]

# 17  
Old 03-17-2020
Code:
discourse=> select id, name from groups;
discourse=> update users set primary_group_id = 2 where primary_group_id = 48;      #moved all moderators in vb to mod group on discourse

In addition:
  • Moved all moderators and moderator emeritus to trust_factor_4 (Leader)
  • Moved all forum advisors to trust_factor_3
# 18  
Old 03-17-2020
Done...

Code:
Updating topic reply counts...
   138032 / 138032 (100.0%)  [10714 items/min]    
Updating first_post_created_at...

Updating user post_count...

Updating user topic_count...

Updating topic users

Updating post timings

Updating featured topic users

Updating featured topics in categories
      123 / 123 (100.0%)  [81 items/min]   n]  
Updating user topic reply counts
   138032 / 138032 (100.0%)  [11368 items/min]  ]  
Resetting topic counters


Done

Backing up now.....

Then will try to migrate "vb thanks" to "discourse likes" with the new script vbulletin_neo5.rb
These 3 Users Gave Thanks to Neo For This Post:
# 19  
Old 03-17-2020
All is done, for the initial migrations except for "vb thanks" to "discourse likes".

(of course the discourse site is behind the vb site as far as the most recent posts....)

It's looking good, but I would like to get the "vb thanks" to "discourse likes" working.
This User Gave Thanks to Neo For This Post:
# 20  
Old 03-18-2020
Have been debugging ruby code this morning for 2 to 3 hours (more like 3) to migrate "thanks" to "likes" and I'm getting close.

I am hopeful I this get this script done today, and have a working script to transfer all our vb3 thanks plugin "thanks" to discourse "likes".....

This migration has been a task "not for the faint of heart" and there is no doubt anyone who tries this must have a lot of technical skills.

Just now, for example, I debugged a lot of ruby code were I was getting "trying to update DB errors, unique" and searched the code in ruby, found the tables and found the unique index. I deleted the "unique index" which allowed the process to move forward and then after it was complete, I could see the error in the results and was about to go back and make the change to the original DB user mappings.

Code:
root@discourse1-app:/var/www/discourse# rake posts:delete_all_likes   
    65028 / 65028 (100.0%)
65028 likes deleted!

Sometimes you have to break something to fix it.

I started this "feasibility study" caper around a week ago, and I'm getting close to finishing (the entire migration) ; that's not bad for a vB3 migration where the folks at meta discourse gave me the serious "get out of here" cold shoulder when they found out I was migrating a vB3 forum to discourse.
# 21  
Old 03-18-2020
OK.. it worked... forum vb "thanks" were migrated to discourse "thanks":

VBulletin 3.8 to Discourse on Docker Migration Test Take Four-screen-shot-2020-03-18-113003-amjpg


VBulletin 3.8 to Discourse on Docker Migration Test Take Four-screen-shot-2020-03-18-112822-amjpg


I think there may be some counters (like total likes given to a user) which have not updated in the migration; but maybe they will update based on an internal cron. If not, I can easily write code to update the users profile "likes" counter(s).
Login or Register to Ask a Question

Previous Thread | Next Thread

7 More Discussions You Might Find Interesting

1. What is on Your Mind?

Under Consideration: Migrate the Forums to Discourse

Dear All, After being active on the Node-RED forum for the last few weeks, I have been very impressed with Discourse, and my eyes have been opened. https://www.discourse.org/ but not the paid /hosted offering, but using the open distribution: https://github.com/discourse/discourse ... (52 Replies)
Discussion started by: Neo
52 Replies

2. What is on Your Mind?

VBulletin 3.8 to Discourse on Docker Migration Test Take Two

OK. Like we all do, we learn a lot from tests, test migrations, and so forth. Today, I started from scratch on test migration 2, armed with a lot more knowledge, The main differences are as follows: Installed discourse plugin ruby-bbcode-to-md before starting the install Modified... (30 Replies)
Discussion started by: Neo
30 Replies

3. Docker

Docker learning Phase-I

Hello All, I had recently learnt a bit of Docker(which provides containerization process). Here are some of my learning points from it. Let us start first with very basic question: What is Docker: Docker is a platform for sysadmins and developers to DEPLOY, DEVELOP and RUN applications ... (7 Replies)
Discussion started by: RavinderSingh13
7 Replies

4. Shell Programming and Scripting

Problem in extracting yocto SDK for docker

Actually I was facing the following issue while building my Yocto SDK on Docker container sudo docker build --tag="akash/eclipse-che:6.5.0-1" --tag="akash/eclipse-che:latest" /home/akash/dockerimage.yocto.support/ Sending build context to Docker daemon 26.93MB Step 1/5 : FROM eclipse/cpp_gcc ... (3 Replies)
Discussion started by: Akash BHardwaj
3 Replies

5. AIX

AIX - FC Switch migration, SAN Migration question!

I'm New to AIX / VIOS We're doing a FC switch cutover on an ibm device, connected via SAN. How do I tell if one path to my remote disk is lost? (aix lvm) How do I tell when my link is down on my HBA port? Appreciate your help, very much! (4 Replies)
Discussion started by: BG_JrAdmin
4 Replies

6. Linux

Docker and pipework,ip with other subnet

Recently i found this for give to docker a "personal" ip ip addr del 10.1.1.133/24 dev eth0 ip link add link eth0 dev eth0m type macvlan mode bridge ip link set eth0m up ip addr add 10.1.1.133/24 dev eth0m route add default gw 10.1.1.1On container i did ... (0 Replies)
Discussion started by: Linusolaradm1
0 Replies

7. Web Development

Removing VBSEO for vbulletin – Reverting back to vbulletin URLs

Please note, this information was copied from vbseo.com, now showing a database error. This is posted for reference since vbSEO seems to be going out of business: If you ever need to uninstall vBSEO , you can use the following instructions. Make sure you carefully follow each step. Login... (37 Replies)
Discussion started by: Neo
37 Replies
Login or Register to Ask a Question