by prettyscripts on 2010-02-17 14:26:21
this refers to moving a post or page from one blog to another, within the same b2evolution installation.
i can't seem to find any interface in the back office to do this. the database needs to be updated directly, but it's not as easy as updating the blog id to the post because that's not how the schema works. the relationship is between post and categories, not post and blog.
this is high level instruction for advance users and must be done carefully! i recommend using phpmyadmin to access mysql database. it also assumes the default table prefix 'b2_'.
decide which category in the destinated blog to move to. look up category id in b2_categories table. if there are 2 categories with the same name, choose the one with the correct destintated blog id (which can be found via b2_blogs table).
note the category_ID.
identify the post id. in backoffice post tab (or any tabs, depending on type of post), mouse over the title to show url in status bar. note the number at the end of url '...&p=[number]'. this is the post id.
there are 2 tabled that needs to be updated.
edit b2_items__item table where post_ID is the number found above. edit column post_main_cat_ID to the destinated category id found above.
edit b2_postcats table. be very careful with this table because it's storing just the ids. locate the correct post in postcat_post_ID column and update postcat_cat_ID to the destinated category id found above.