Missing threads & posts (UBB 6.3.11->vB 3.61)

[forteanajones]

UBB 6.3.11->vB 3.61

Everything is beautiful, aside from PM senders being missing, with one other exception: One specific forum arrived minus many threads and posts. I have repeated the import process a few times with the same result.

The one thing that stands out for that forum is the fact that only the board owner was permitted to post there, but everyone was permitted to view.

[Jerry]

Can you check the ForumXX folder (XX being the forum number), if there is a folder inside the ForumXX folder with private in the name, delete (after taking a backup) or as I do, just rename it to "moo/".

[forteanajones]

Can you check the ForumXX folder (XX being the forum number), if there is a folder inside the ForumXX folder with private in the name, delete (after taking a backup) or as I do, just rename it to "moo/".

Thanks for the suggestion. I will try this out.

I get a little confused when reading the documentation about running a subsequent import. I would like to import *only* this forum at this point so that I can avoid redoing the rest. How exactly would I accomplish this again? Would it be simplest to create a new copy of the source directory for that particular source forum?

[Jerry]

That is a differential import, with ImpEx its all or nothing per module.

[forteanajones]

I ended up having to go live without these missing posts, and am now trying to re-create them with the Adv. Editing Options for Mods and Admins hack from vb.org.

All is well except for two things:

1. Post dates in the "Last Post" column show up as the current date, instead of one of the dates in the thread itself. This is a problem I need to adress right away.

2. Number of views is not up-to-date and accurate since technically, these are now new posts. This is less urgent but I would also like to address it.

Can someone share the appropriate SQL I might use to make these two (ostensibly simple) corrections?

[Jerry]

1) Will update as the board is used and new posts are added.

2) That data isn't imported at the moment.

Hmmm, to update #2 would be :

UPDATE thread SET views=X WHERE threadid=Y;

Where X is the views and Y is the thread id, though that is going to be very manually intensive.