Search Results

Making progress getting the vB "thanks" to convert and migration to discourse "like"...

Results from migration test run 5:

The number of discourse "likes" will not match the vb forums because...

OK... this new code works as intended:


#code to deal with how discourse tags the first post in a topic in the post_custom_fields table
$query = 'SELECT firstpostid FROM thread WHERE...

Regarding PHP code to create migration table for vb thanks to discourse likes, I have modified the code to make up for a mismatch between how vb3 and discourse deals with the first post in a topic...

Seems like the "likes" migrations worked well, and most of the profile counters have updated, except mine (for some strange reason, LOL)

The discourse system gives more weight to likes to people...

FYI:

Completed Migration vB3 to Discourse including Legacy vB3 Thank You to Likes - installation - Discourse Meta...

ubuntu:/var/www/includes/cron# cat thanks_to_discourse.php
<?php

/**************************************************
+-----------+------------+-----------+-----------+
| thanker | unixtime ...

Here is the working ruby import_likes function:

def import_likes
puts "\nimporting likes..."

# created mysql user_actions table in vb3 using PHP script and included that table with...

OK.. it worked... forum vb "thanks" were migrated to discourse "thanks":

8237

8238

I think there may be some counters (like total likes given to a user) which have not updated in the...

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...

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,...

Done...

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

Updating user post_count...

Updating user topic_count...
...

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:

...

Close to baked:

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


updating banned users
3134 / 3134 (100.0%)

Updating topic status

Updating...

Moving along.....

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

Found a ruby script in the import_scripts directory of the discourse app which I have modified to transfer vb3 plugin "thanks" to discourse "likes":

def import_likes
puts "\nimporting...

Some of my crude hacking worked ..... LOL

At least some attachments are working:

8235

Success! LOL

No one likes migrations....

LOL

Lots of error, but it's moving on past attachment migration errors now:

1026248 / 651677 (157.5%) Failed to create upload: undefined method `[]' for nil:NilClass
Upload not valid :(
Failed to...

Still problems with attachment migration:

importing attachments...
269043 / 651677 ( 41.3%) Couldn't find attachment record for post.id = 269043, import_id = thread-139764
323104 / 651677...

I have another potential solution to this "thanks to likes" (vb to discourse) issue:

This idea did not work. - The discourse postids do not match as expected.

Before the ruby migration...

Still moving along.....

importing posts...
548360 / 651677 ( 84.1%)

The only issues I see are related to:


Migrating "vb thanks" to "discourse likes" (have not found a reliable...

Hmmmm does not work consistently.... must be converting some chars in the pagetext of a vb post to postgres.

Update: Yes, the posts are preprocessed before migration for markdown and bbcode, so...

I have a solution to this issue, or at least a workaround:

EDIT: This method only works on posts with no bbcode because discourse preprocesses the raw posts and changes the post. Hence, the MD4...

puts shows we are getting vbpostid from the mysql db ok, but it's not writing to the postgres db.

My best guest was that the structure of the posts table for discourse is defined somewhere in a...

Import is going well. My custom code for our ICODE tag and BBCODE to markdown is working fine. Everything is looking good:


... still moving long now importing posts (replies):

importing...