An update for folks -- in the next couple of weeks (likely in about a week) we will have completed one of the major outstanding items from the original migration from vBulletin to XenForo -- the translation of the "Thanks" received on the old forum by each member, to add to each corresponding member on the new forum as a "Thumbs Up"
Stay tuned on this. It's a very very complex thing to do, and I've been working on it for a long time. And finally close to getting it done.
Today (Sunday, March 29, 2020), approximately 5:00 PM EDT (2:00 PM PDT), I will be taking the forum off-line for approximately 5-10 minutes to work on the "integration" of the vBulletin "Likes" with the exising new XenForo "Likes" system. This is one of the last outstanding pieces (and member requests) in the migration process.
Much of this off-line time will be because I will perform a full database dump (backup) before I add and then execute the code required to perform the migration.
It may or may not work; if it does, great. If it doesn't, fine, I'll bring the forum back on-line and work on fixing the code to try it again in the near future.
Cheers,
Gerry
You may have seen this image, for several hours today.
Here is why:
Today, the forum was off-line for about three hours and 50 minutes. The reason for this was a very complex migration and integration of the "Likes" from the old vBulletin forum to the new forum.
This was an extremely complicated task from a technical standpoint, and one that I have worked on, on and off, over the past year. There were some snags that I ran into in doing this, starting yesterday (where the forum was off-line for about 20 minutes total while I was working on this) and continuing today. The snags involved the forum's database, and an incomplete migration.
It took ten tries to complete this migration of the "Thanks" from the old database -- you can see ten different new database tables created in the forum's main database, one for each attempt. Finally, on the 10th try, I was able to complete the integration of the old forum's "Thanks" with everyone's existing "Likes" count.
There were 61,557 "Thanks" on the old forum that were imported into this forum's database.
On the left side of the database management screen shot, you can see the old "vbulletin" database that ran the old vBulletin forum, as well as a new "xenforo1" database.
The "xenforo1" database is actually the old database that ran the forum, up until 12:00 noon today. This database was copied and renamed from "xenforo" to "xenforo1," and a new empty/blank "xenforo" database was created. Then, the database with the migrated "Thanks" (you can see it at the top, called "clients_500eboard_co" was imported into the blank "xenforo" database, and this became the new database that underpins the forum.
This took some time to do (the size of the "xenforo" and "xenforo1" databases is around 650 MB), and everything had to be properly vetted and tested after the migration was complete. If the database was corrupted in any way, then the whole process would be for naught.
And even this process took several tries, but I finally was able to get it right.
This morning, before I started the migration, I took the "Likes" stats for a few folks on the forum. I took them during the failed migration #1, above. And then I took the stats again after migration #10, which worked. Here are the "Thanks" stats for these individuals -- before, during and after the migration. So you can see that the migration re-added significant numbers of thanks for the folks who had them.
500Eboard Member | Thanks with 500Eboard only
(before migration) | Thanks total after botched
migration #1 | Total thanks after successful
migration (#10) |
@gsxr | 4508 | 7837 | 14421 |
@Glen | 309 | 1022 | 1533 |
@2phast | 395 | 553 | 10042 |
@JC220 | 2116 | 2771 | 5120 |
@5thscaleracer | 137 | 237 | 313 |
@gerryvz | 5607 | 8256 | 15151 |
@Trae | 118 | 478 | 1006 |
Thanks to everyone for putting up with a long day of the forum being down. While nothing was in jeopardy nor was any information lost, it was a lot of work to make the migration of the "Thanks" from the old forum happen on this new forum.
We can check off one more big item that was outstanding from the migration a year ago.