Support Forum
Support Forum
Offline
I am installing SP forum on a new website for a client who has a very active forum on their old site using SP. We have built a new website for them also in WP. The new WP install has caused the user accounts to no longer be in exactly the same order as they were on old website, changing the ID numbers. When I installed a the SP forum plugin, I then copied all the DB tables for SP from the old site to the new site. This works almost perfectly, except when someone wants to see the profile of a user, it brings up the WP Users info for whatever ID number that is associated with that user, but since the WP users and the SP members tables no longer line up, it brings up the wrong info.
I am willing to do whatever to make this work. The forum has thousands of posts now from hundreds of users, I do not want to lose it for the client, or cause it to have to be restarted. What is the best solution for importing the old forum so that it lines up with the new WP users table?
They also are using WishList Member because this forum and other parts of the website are in a password protected user area. So the WP User accounts also tie to the WL member accounts...
Offline
So if I follow you correctly this is not so much a new forum as an import of the current forum yes? The same website URL or a new one - I ask because that has implications later on...
I guess I am firstly curious as to why the WP user IDs would change if they were simply imported. But - that is probably not something I need to know now!
You really need to maintain the WP users, usermeta and all SP tables as a single unit and import all of these at the same time. This is the only way that relationships will be maintained. Simply backup up all of these tables in the source and then restoring them in the target database will keep everything in sync.
But perhaps a little more background and the methods you are using would be useful information to know...
 |
YELLOW
SWORDFISH
|
Offline
Thank you for your answer... though it does make me nervous. The client is not changing their domain name, that remains the same. The users were not simply exported and imported because we did such a major reorganization of their website. We completely changed how they are using WishList Member, and simplified how their website was managed, and in doing so, the users were brought over in groups and reassigned permissions to the different areas of the site (I did not do this, a coworker did, so I do not have any other specific details). When the users came over to the new site, they were reordered starting at user number 101 and on... where the old user accounts had started at 1 and went on.
I am using PHPMyAdmin to import and export the SP tables. The WP & WL tables were not imported using PHPMyAdmin, they were uploaded I believe using WP. I will export the WP, WL & SP tables from the old live site and import them into the new database using PHPMyAdmin, and hopefully that will solve the problem of user accounts. Then if I have to go through and reassign permissions in WishList, that is a much smaller problem than having to fix tables of users.
Please let me know if I need any other information, or if there is anything you can think of that I need to watch out for. I will try to solve this problem this morning so we can launch the client's new website.
I will let you know how it goes.
Offline
As long as they are bou8ght across in concert then it should be fine. This has happened with a lot of our users and I more or less do this regularly with test data.
About the only think that comes to mind is the question of whether you are also bringing the WP post and page records across as SP does create a page record for display. If that is not bought across then it will have to be manually created but that is just a minutes task.
|
YELLOW
SWORDFISH
|
Offline
Wanted to update... bringing over all the user tables at once (in WP, SP, and WishList Member) did the trick! Thank you for confirming my initial ideas about the migration process. Bringing over the tables was not perfect, but the clean up work after was minimal.
Thank you for your answers to my questions and help steering me in the correct direction.
All RSS1 Guest(s)