| User | Post |
|
12:54 am
7 Dec 2007
|
carnold
Member
| | | |
|
| posts 36 |
|
|
A while back, i was sent a diff file for SF and MUWP. SF will be installed for all users who chose to install and use it. My question is, does SF now work with MUWP without the diff file? Or do i still need to use the diff file?
|
|
|
|
|
And I really still don’t know the answer to that. The diff file, if I recall, was for 2.0 and in 2.1 I created a define (sf-includes.php) for the usermeta table so as far as I am aware you just need to set the prefix in the defines for usermeta and users.
But f that works for all sers on the MU system I really don’t know. I wish I did because the question comes up often and people use it but nobody comes back to confirm what happens!
|
|
|
3:40 am
7 Dec 2007
|
carnold
Member
| | | |
|
| posts 36 |
|
|
Well, so far so good for me. I do notice some things like, posts do not show up. The title shows but not the actual posts. Also, i don’t see a login icon or button. You can see here and click on forums. Poke around for a sec.
I backed up the DB before i went to MUWP with phpmyadmin. I restored wp_1_sfforums
wp_1_sfgroups
wp_1-sfnotice
wp_1_sfposts
wp_1_sfsettings
wp_1_sftopics
wp_1_sftrack
wp_1_sfwaiting
and you will notice that on the front page, recent forum posts show the title but not the user or date. What else do i need to restore to get that back?
|
|
|
|
|
I’m in the dark here as to what the problem could be so I can only really speculate. This may still be a problem with the users and usermeta tables. If you have moved this data from a single user WP to an MU database did you bring across the user records as well? For example, the sfposts table records which user (by ID) makes a post. If that user record, with that specific ID no longer exists then the post record is essentially orphaned.
Another problem may have been introduced by the method of bringng that data across. What tools did you use to do this? Were the record ID’s preserved? Some methods of doing this can re-order the ID’s whichb would lose all of the links and relationships. I can only really diagnose what is missing by sitting in front of the actual database and trying to piece the bits togther and that isn’t possible.
Actually another question comes down to table prefix. Is ‘wp_1′ the correct table prefix - or when you activated the forum in MU did it create some duplicate tables? I don’t know enough about MU to make valued judgements but it looks like record ID’s to me…
|
|
|
1:52 am
8 Dec 2007
|
carnold
Member
| | | |
|
| posts 36 |
|
|
I did move sf from a single user WP to MUWP. Not sure if the records can with the backup or not. I used phpmyadmin to backup and restore the sf DB. I could give you the login info to the DB, if you like. Let me know. MUWP creates wp_1_ for all the plugins i have activated.
I also see this in the apache logs:
[Fri Dec 07 20:49:27 2007] [error] [client 74.124.160.107] WordPress database error: [Table 'muwp.wp_1_users' doesn't exist]\nSELECT post_id, post_date, UNIX_TIMESTAMP(post_date) as udate, guest_name, user_id, user_login, display_name FROM wp_1_sfposts LEFT JOIN wp_1_users ON wp_1_sfposts.user_id = wp_1_users.ID WHERE topic_id = 22 ORDER BY post_id DESC LIMIT 1\n, referer: http://mytimewithgod.net/2006/12/11/bible-verses-christmas
|
|
|
4:25 am
8 Dec 2007
|
carnold
Member
| | | |
|
| posts 36 |
|
|
I read another thread that said the sfincludes file had to have some changes. I made those changes and now he posts are back. Usernames are missing.
|
|
|
|
|
This is what I said in my first reply. Your problem now is almost certainly that you didnt being the ‘users’ and ‘usermeta’ tables across from your single user system - and if you did, they didn’t restore because these two tables are named differently in MU.
Moving data from single to multi user WP is not as straightforward as backup/restore because of this. All the other tables are named with the prefix followed by your ‘blog id’ but therse two tables only have the prefix.
|
|
|
6:23 pm
8 Dec 2007
|
-Radio-
Moderator
| | Florida - USA | |
|
| posts 482 |
|
|
Both single user and MU installations of wordpress offer an EXPORT and IMPORT feature to move Blogs from one system to another using Extended RSS.
WHAT IS NOT EXPORTED:
- user info
- uploads
- themes
- plugins or thier database tables
What this means is you have to copy these items manually from PHPmyADMIN, or FTP
Using PHPmyADMIN, you can save the SF tables and restore them to an individual blog’s Forum, however the users will not be shown, because they utilize the default WP tables.
WPMU uses a different process than WP in how it handles users and blogs, see this post, so importing users would be tricky at best.
That may be a subject for questions over on http://mu.wordpress.org I have not researched it that far yet.
|
|
|
9:40 pm
8 Dec 2007
|
carnold
Member
| | | |
|
| posts 36 |
|
|
So, i have the old single WP DB still in tact. Is it possible i could "export" the wp_users table and the usermeta table then "import" those tables into MUWP? I looked at both WP and MUWP tables and they look like they have the same entries in both tables.
Sorry, i did not refresh the page before i posted and therefore did not see the post from radio.
|
|
|
12:36 am
9 Dec 2007
|
-Radio-
Moderator
| | Florida - USA | |
|
| posts 482 |
|
|
I would imagine you could try, because, yes they do look alike.
but if you have WPMU users, you may loose them, so backup the wpmu users and usermeta first.
The one thing I would be extremely cautious about is your own admin account, you may loose access to your own blog, and that would not do at all.
|
|
Forums
