Stephen, I was able to convert from phpbb to bbpress and that was really smooth sailing, but now all my migrated usernames’ passwords don’t work. Ironically, for the earlier vbulletin conversion, the passwords were working fine but the threads and usernames were out of sync.
Now, the thread/posts/username relationship is fine, but all my passwords don’t work. I am not sure what the issue is. Hopefully you can direct me in the right direction to get this minor issue resolved.
I also forgot to add the “freshness” time is also out of sync on some pages.
hello Stephen.
i am running version 4.1.5
as for the sql limitation, i have own dedicated server so if I can get this corrected if you point me the right direction. I have never done this before.
the problem is still the same. I am now on 280K posts and all the topics are either assigned to wrong person, anonymous or its owners. once again The process came to a slow transfer once I reached the high treshold.
1. Users are not in sync with their topics and replies. Some topics with no replies downloaded yet are in ok, but many are not. Some topics are assigned to users who never posted anything, some are assigned to admin and the rest are assigned to their owners.
Until the repair tools are run after the import you will pretty much always see issues like this, the tools need to be run to get everything in sync.
2. At somewhere at 350,000 posts, the whole process slows down (10 posts per 20 seconds or worse) to turtle speed.
This can be your web host limiting the amount of SQL queries you can run per hour/day etc, contact your web host and ask them what limitations are on your hosting plan.
3. I repaired whatever I downloaded using the bbpress repair page and I don’t see anything fixed.
Odd, though it makes my first answer moot, but it is still important in that the execution order of the importer can significantly make these things look weird when it has imported a topic and expects there to be 12 replies but only sees 3.
So for now, kind of ignore my answers to 1 & 3 above and lets start on what version of vBulletin are you trying to import from? (and we can go from there)
I like bbpress but I am desperately trying to make it work for moving a large forum from vbulletin.
I tried to move my forum several times and everytime I move users, topics and some replies, I notice that users and some of their true replies are out of sync. In other words, some user are assigned to topics they didn’t start or reply to and other topics are assigned to admin. No, I didn’t wait for 1 million replies to be downloaded. I checked the first 350,000K replies and everything seems to be a mess.
1. Users are not in sync with their topics and replies. Some topics with no replies downloaded yet are in ok, but many are not. Some topics are assigned to users who never posted anything, some are assigned to admin and the rest are assigned to their owners.
2. At somewhere at 350,000 posts, the whole process slows down (10 posts per 20 seconds or worse) to turtle speed.
3. I repaired whatever I downloaded using the bbpress repair page and I don’t see anything fixed.
I am not sure what is causing this. Is this normal?
I need help. I can give links and login info to bbpress staff if required.
Onto the ‘other’ bits of your last post.
For the most part the standard /wp-admin/users.php user admin dashboard panel is ‘enough’ to get day to day tasks done for ‘most’ situations as it does have search (top right) to make this usable.
The delete users wp-admin/users.php?action=delete&user=123 is all WordPress and bbPress does not alter this behaviour though as you state it would be nice if this could be improved for sites with large user bases. To resolve this we will have to wait until WordPress implements some changes here.
None of the bbPress widgets do this Widgets – the list of users is loaded under one or more widgets
So yes, these things are not just under consideration they are actively thought about constantly and we have tried to keep from implementing this pain in bbPress, but for now until we can get some changes upstream in WordPress core some of this pain will remain.
As I mentioned above on the ‘clobber-spam-users’ plugin I mentioned this plugin as it is not very complex and could be modified to ‘help’ with your cleaning up of 17,000 users topics & replies.
Stephen, I don’t think I ever said I had a handful of users. The actual number is over 17,000
This snippet from your original post was the only context I was referring to for the ‘handful’ term so that even though the experience is painful it will get THIS part of your job done as long as you are not trying to do this for 17,000 users.
A way to delete users an reattribute their posts/topics/replies to another user (mainly for a handful of folks who already had accounts on the WordPress side before migrating vBulletin over)
Stephen, I don’t think I ever said I had a handful of users. The actual number is over 17,000.
There are several pages in the WordPress admin where a pick list with ALL users is displayed. These pages will tend to several minutes to load and allow me to use them. I mention this because for bbPress to be useful for a volume of users (> 10000) there needs to be some adjustment to the way the user lists are created.
Here are two problem pages:
- Delete Users – the list appears under “Attribute all posts to”
- Widgets – the list of users is loaded under one or more widgets
For the same reason that /wp-admin/users.php only displays 20 users per page, these lists should do something similar. Or rather than a list, use a search.
I figure this isn’t something quickly or easily fixed, but suggest that it be considered in the future. And certainly bbpress.org has the same issue… how do you/they deal with it?
Thank you very much this helped for me to as i have to a big users list.
Hello,
I am very new to bbpress.
I have successfully convert my 54000 user vbulletin forum in to bbpress. Also converted more than 1 gigabyte contents database without issues. There were some problematic turkish characters but i solved that issue too.
But, i am sure it was a very well written document about how to modify and adding new themes to bbpress, I understand completely nothing from them. I also read forum topics about the issue, but most of them pointing the links where the docs are.
I also tried copying folders and files in to wordpress themes directory or my theme’s directory, nothing is happening. Most probably i did not understand anything from the docs here:
http://codex.bbpress.org/theme-compatibility/
Can someone please explain to me what to do like explaining to an idiot.Assume my wordpress theme’s name is “wptheme” and please direct me into it by real examples like: Put your wp-content/plugins/bbpress/templates/bbpress folder to wp-content/themes/wordpresstheme folder. or whatever is true 🙂
Best regards
I understand it is quite unusable but as I stated previously if you only have a handful of users this is required for will it suffice, how many is a ‘handful’ in this case?
In regard to removing spam posts I found this plugin: https://wordpress.org/plugins/clobber-spam-users/
This looks like it could be easily forked and adjusting the search criteria to return the results that meet your criteria to then have it delete the topics & replies for you, then afterwards you will again have users with no posts/topics/replies etc and again masss delete those users.
Stephen, I know about the typeahead feature for select lists, but the list is so long (with thousands of names) that the widget page takes several minutes to load. I have to wait… and wait… and wait before I can even scroll on the page or do anything with any widget. Very unusable.
I’d also appreciate a comment on this ticket in Trac for any password issues you found.
https://bbpress.trac.wordpress.org/ticket/1969
I’d also appreciate a comment on this ticket in Trac for any password issues you found.
https://bbpress.trac.wordpress.org/ticket/1969
As I’ve spent the day playing with passwords, did any users have any issues with users logging into WordPress after the import? Did their existing vBulletin passwords work?
As I’ve spent the day playing with passwords, could you please let me know if any issues with users logging into WordPress after the import? Did their existing vBulletin passwords work?
As I’ve spent the day playing with passwords, did anyone have any issues with users logging into WordPress after the import? Did their existing vBulletin passwords work?
Download the latest and specific vBulletin v3 importer from https://bbpress.trac.wordpress.org/ticket/2417
https://bbpress.trac.wordpress.org/raw-attachment/ticket/2417/vBulletin3.php
Upload with FTP to your server into to /wp-content/plugibs/bbpress/includes/admin/converters
hi there,
same problem for me with my vbulletin 3.x-version. a tag-error during import.
it seems to stop the import.
do you have found a solution for this?
frank
@bigblueball Can I ask why you left vBulletin for bbPress?
I’m looking for an alternative to bbPress because I can’t fix it, it doesn’t work well and has poor support documentation.
I don’t want to make the same mistake again and so I’d appreciate a little feedback on vBulletin.
Thanks
Glad it helped 🙂
With the dropdown list, even though it is slow you can type the username to get you there quicker without relying on the mouse for 100%, once the dropdown is showing start typing the name, you have to type fast to get more than two or three characters but it is helpful.
The other option you have is to modify the entries directly in phpMyAdmin
UPDATE wp_posts SET post_author = 123 WHERE post_author = 789;
Where 123 is the new user id you want to attribute to the old user id 789
Thanks, Stephen. This was very helpful. I ran the queries to purge the accounts with no posts, and the membership dropped to about 17,000 — still a lot, but much more manageable.
As for the delete user function, the problem with the current design is that it creates a pick list to attribute the original users’ posts to someone else. For me, that’s a pick list with over 17,000 names. It takes a while to load to say the least!
Sage words? Nope 😉
I had a quick look around https://wordpress.org/plugins/search.php?q=bulk+users and nothing really stood out.
The most users I have played around with is ~4,000 and that was too many also for the WordPress admin dashboard. I ended up doing everything I needed directly in phpMyAdmin with SQL queries.
A way to delete users an reattribute their posts/topics/replies to another user (mainly for a handful of folks who already had accounts on the WordPress side before migrating vBulletin over)
With only a handful of these use WordPress’ built in user delete tool, when you select to delete a user you have the option to delete all posts (including topics & replies) or keep them an attribute them to another user.
A way to “nuke” users who have spammed the forums. This would delete the user as well as all of their topics and replies.
First you are going to have to find the spam and record each user id associated and this is painful indeed! I am not to sure on the specifics but there probably is a way to get Akismet to check all of this for you.
A way to purge all users with no forum topics or replies (or posts, for that matter).
I think the quickest way for this would be in phpMyAdmin directly using an SQL query.
The query (Good to verify this stuff before you delete them)
SELECT ID FROM wp_users
WHERE ID NOT IN (SELECT DISTINCT post_author FROM wp_posts);
The delete queries (Any user without a post gets deleted)
DELETE FROM wp_usermeta WHERE user_id NOT IN (SELECT DISTINCT post_author FROM wp_posts);
DELETE FROM wp_users WHERE ID NOT IN (SELECT DISTINCT post_author FROM wp_posts);
Okay, so I am working on a migration from vBulletin to bbPress. Everything moved over fine, but now I have over 60k users. This causes a real problem when I want to delete a user, because the Delete User screen creates a pick list with all 60k names!
Here’s what I’m looking for…
- A way to purge all users with no forum topics or replies (or posts, for that matter).
- A way to “nuke” users who have spammed the forums. This would delete the user as well as all of their topics and replies.
- A way to delete users an reattribute their posts/topics/replies to another user (mainly for a handful of folks who already had accounts on the WordPress side before migrating vBulletin over)
Any sage words of advice?
I have to do that for 400+ users? 😐 I guess Im not leaving vbulletin after all :\
