[Resolved] Where is the user blog data stored?
-
As you know in Buddypress you can click the user for their profile and that page is a tab for blogs to show which blogs they admin and own. Where is that information stored.
I imported a website for someone but it displays me as the blog own, if I remove myself the blog doesn’t show in the Buddypress directory at all and it doesn’t display in the users profile for owned blogs.
I’m presuming when I imported his blog and account it missed a step where it syncs something up, where should I be looking for this information in the database so that I may add it myself?
-
Scratch that, I must have overlooked it the first 20 times, lol.
Its located in the bp_user_blogs table, not sure why I kept missing it. ha ha.
And if others have this problem, then here is some MySQL:
`INSERT INTO `YOUR_DATABASE`.`PREFIX_bp_user_blogs` (
`id` ,
`user_id` ,
`blog_id`
)
VALUES (
NULL , ‘REPLACE_USER_ID’, ‘REPLACE_BLOG_ID’
);`Obviously replace the parts which say YOUR_DATABASE, PREFIX and REPLACE with the corresponding data.
I wonder why when importing though that Buddypress doesn’t take this into account?
Ah the forum striped a bit of the MySQL but I’m sure the point is clear.
- The topic ‘[Resolved] Where is the user blog data stored?’ is closed to new replies.
