Announcement

Collapse
No announcement yet.

Some interesting things to do after an import...

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Some interesting things to do after an import...

    (I'm going to speak out of my experience with importing from phpBB3)
    Few reasons why I'm write this:
    I always forget to do those things... & how to do it...
    -----------------------------------------------------------------------------
    The story:

    I just did a new test part, and saw that after the import, only stickies were showing... I redid a few modules time after time, and still the same... Even reinstalled vB... but still the same... Then re-researched the impex documentation, couldn't found anything... then searched this forum... And finally saw something...
    https://www.vbulletin.com/forum/show...=1#post2229387
    but thought by myself... Am I going to need to do that for each forum??? there must be an easier way to do that....
    That remembered me to the following:
    https://www.vbulletin.com/forum/show...=1#post1507930
    So to make it that each forum shows all threads, you can execute a queries that makes that happen...
    Automatic Query: "Show All Threads"
    Originally posted by Jake Bunce View Post
    Run these queries:
    Code:
    UPDATE forum
    SET defaultsortorder = 'desc'
    Code:
    UPDATE forum
    SET defaultsortfield = 'lastpost'
    But still, it wouldn't worked... and redid those queries a few times... And thought, how the hell doesn't it work???
    Re-read that post and saw:
    Originally posted by Jake Bunce View Post
    Then you will need to update your forum info:
    Admin CP -> Maintenance -> Update Counters
    So that's it for the story... (later about attachments...)
    -----------------------------------------------------------------------------
    Step-by-step part (how I (will) do it):
    After importing

    Admin CP -> Maintenance -> Execute SQL Query -> Automatic Query: "Show All Threads" (this will make that each forum shows all threads (instead of only threads from last month))
    Admin CP -> Maintenance -> Execute SQL Query -> Manual Query:
    Code:
      UPDATE forum
      SET defaultsortfield = 'lastpost'
    Admin CP -> Maintenance -> Execute SQL Query -> Manual Query:
    Code:
     UPDATE forum
     SET defaultsortorder = 'desc'
    And NOT to forget!!!:
    Admin CP -> Maintenance -> Update Counters
    ("Rebuild Thread Information" & "Rebuild Forum Information") (thats what I personally do...)
    5
    Yes, thanks you.
    20.00%
    1
    Nope, knew that already.
    40.00%
    2
    Just old news... Learn how to use the Search fields.
    0.00%
    0
    They should make some articles or blogs around such things...
    20.00%
    1
    Why the story? The steps at the end were just enough...
    20.00%
    1
    A Post I made (mostly for myself): Some interesting things to do after an import...

widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X