I want to move from another blog software to b2evolution. Since there is no import plugin for the other software and no general import api for b2evo (as far as I can tell), I have to insert the posts and comments directly into the mysql database. However, the inserted posts do not show up either on the blog itself or on the admin page.
The fields I set in db_items__item are the following:
post_ID, post_creator_user_ID, post_lastedit_user_ID, post_datestart, post_datecreated, post_datemodified, post_last_touched_ts, post_content, post_excerpt, post_excerpt_autogenerated, post_title, post_urltitle, post_main_cat_ID, post_status, post_renderers.
I've checked that post_main_cat_ID is the right id for the blog. What is missing? Do I have to set post_canonical_slug_ID (what is that?)? Do I have to add a relation in another table?