I have finished an import from a simulated phpBB forum that I created myself. (You can read the gory details here.)
Versions:
I have three resulting problems/issues and would appreciate advice on dealing with them.
I don't need to know exactly how I got myself into this state (no doubt my fault in creating the source tables), but I'd like to know the easiest way to fix each problem. My first choice would be a way to fix things in admincp. My second choice would be to use SQL commands.
Issue #1. Number of views wrong after import
My imported threads came out OK, but in the forum display each imported thread shows as having a Number of Views equal to the number of posts in that thread, rather than 0. For example, an imported thread with 1000 posts shows as Replies=999 and Views=1000.
I followed the After the Import steps after my import, and in particular I used the Update Counters page to Update Post Counts, Rebuild Forum Information, Rebuild Thread Information, and Rebuild Post Cache. I even tried Rebuild Statistics, but the Views are still equal to the number of thread posts.
Issue #2. Wacky user title
My site is at somethingforums.org. My administrative user (user #1) is named "Somethingforums". Using admincp, I had set him to
One of my imported users was the same admin, with posts in the imported data, so I used Merge Users to merge the imported admin user into user "Somethingforums". (My includes/config.php file protected user #1 from changes, but I turned that off so I could do this.)
The posts merged correctly, and the other admin user correctly disappeared, but the user title of user "Somethingforums" changed to
I tried
I could do more experimenting with usergroup settings, but I can't imagine what's going on. The word "forum" is not on my list of censored words, and I did not import any word lists.
Issue #3. Imported users need profile change
Some of my imported users were previously registered members, and they were properly merged. I have the remaining members, who were imported but are not registered members, in their own usergroup. All of them came out with settings:
Thanks!
Versions:
ImpEx build version : 1.75
Source Board Format : phpBB2 2.0.21
Target Board Format: vBulletin 3.6.4
Source Board Format : phpBB2 2.0.21
Target Board Format: vBulletin 3.6.4
I have three resulting problems/issues and would appreciate advice on dealing with them.
I don't need to know exactly how I got myself into this state (no doubt my fault in creating the source tables), but I'd like to know the easiest way to fix each problem. My first choice would be a way to fix things in admincp. My second choice would be to use SQL commands.
Issue #1. Number of views wrong after import
My imported threads came out OK, but in the forum display each imported thread shows as having a Number of Views equal to the number of posts in that thread, rather than 0. For example, an imported thread with 1000 posts shows as Replies=999 and Views=1000.
I followed the After the Import steps after my import, and in particular I used the Update Counters page to Update Post Counts, Rebuild Forum Information, Rebuild Thread Information, and Rebuild Post Cache. I even tried Rebuild Statistics, but the Views are still equal to the number of thread posts.
Issue #2. Wacky user title
My site is at somethingforums.org. My administrative user (user #1) is named "Somethingforums". Using admincp, I had set him to
User Title: Somethingforums.org
Custom User Title: Yes, Admin Set
and his title came out as Somethingforums.org as intended.Custom User Title: Yes, Admin Set
One of my imported users was the same admin, with posts in the imported data, so I used Merge Users to merge the imported admin user into user "Somethingforums". (My includes/config.php file protected user #1 from changes, but I turned that off so I could do this.)
The posts merged correctly, and the other admin user correctly disappeared, but the user title of user "Somethingforums" changed to
Something*****s.org
as if the word "forum" was censored! I can type the word "forum" in a post without it changing to asterisks, but in a User Title it changes from Somethingforums.org to Something*****s.org.I tried
Title: Somethingforums.org
Custom User Title: Yes, User Set
and got the same thing. I tried removing the user title (Custom User Title: No), saving, and then adding it back again, but the asterisks reappeared.Custom User Title: Yes, User Set
I could do more experimenting with usergroup settings, but I can't imagine what's going on. The word "forum" is not on my list of censored words, and I did not import any word lists.
Issue #3. Imported users need profile change
Some of my imported users were previously registered members, and they were properly merged. I have the remaining members, who were imported but are not registered members, in their own usergroup. All of them came out with settings:
Receive Email from Other Members: Yes
Enable Private Messaging: Yes
I would like to change all of them toEnable Private Messaging: Yes
Receive Email from Other Members: No
Enable Private Messaging: No
so that registered members won't mistakenly try to PM or email someone who is not (or not yet) a forum member. I'd rather not have to do hundreds of profile edits by hand, so a "batch" way to do it is what I'm looking for.Enable Private Messaging: No
Thanks!
Comment