Thanks! I appreciate your help, I’m desperate to update these sites on old versions of Zikula. I can’t even update the PHP on the server past 5.3 because because Zikula 1.2x won’t work on anything later.
The issues you noted.
Categories
aren’t used much, so yes, they can be ignored, it doesn’t seem like it’s difficult to assign forums to categories in bbPress if needed.
Subscriptions
The table prefix is causing me confusion as I switch between databases. Some of my forums have databases using nuke_ for prefix and some have zk_ , this is an artifact from many years of using Postnuke/Zikula and based on when the original database was created.
in the dizkus schema the (prefix)_dizkus_subscription table contains which forums a user is subscribed to.
The (prefix)_dizkus_topic_subscription table contains which topics a user is subscribed to.
Topic Author IP
This isn’t necessary to move to bbPress as far as I’m concerned. Only used when I’m investigating a possible spam post. Someone else might need to have it though, so put it on the “nice to have” list.
Topic Content
None of the conversion attempts have been successful enough to see yet. So far have always errored out because of failed sql statements.
I attempted to do a join because the title of a new topic is stored in (prefix)_dizkus_topics along with the topic post time, views, num. replies, last post ID, forum ID, and sticky status (0 or 1). But the content of the first post in a topic is stored in the (prefix)_dizkus_posts table.
There is no “first post in topic” post ID in either table, as it looks like phpBB had so I tried to adapt this.
// Topic content.
// Note: We join the 'posts' table because 'topics' does not include topic content.
$this->field_map[] = array(
'from_tablename' => 'posts',
'from_fieldname' => 'post_text',
'join_tablename' => 'topics',
'join_type' => 'INNER',
'join_expression' => 'USING (topic_id) WHERE posts.post_id = topics.topic_first_post_id',
'to_type' => 'topic',
'to_fieldname' => 'post_content',
'callback_method' => 'callback_html'
);
Topic Favorites
Dizkus doesn’t have topic favorites, only forum.
Passwords
Since Dizkus doesn’t store passwords, they would have to taken from (prefix)_users table, but thinking about it I’m not sure that this script needs to deal with passwords at all. I will still need to migrate ALL the users from the Zikula installs, not just the ones that have posted in the forums. I’m planning on using WP All Import Pro for that job and migrating other data like converting news items to news and bringing over static pages.
Worst case, if the passwords get screwed up everyone would have to use the “lost password” system to set a new one.
Just tried the version of dizkusZK in Github after merging your changes and got this error.
Repair any missing information: Continue
WordPress database error: [Unknown column 'zk_users.pn_uname' in 'field list']
SELECT convert(zk_dizkus_users.user_id USING "utf8mb4") AS user_id,convert(zk_users.pn_uname USING "utf8mb4") AS pn_uname,convert(zk_users.pn_email USING "utf8mb4") AS pn_email,convert(zk_users.pn_url USING "utf8mb4") AS pn_url,convert(zk_users.pn_user_regdate USING "utf8mb4") AS pn_user_regdate,convert(zk_users.pn_user_avatar USING "utf8mb4") AS pn_user_avatar FROM zk_dizkus_users AS zk_dizkus_users LIMIT 0, 100
No users to convertNo data to cleanStarting Conversion
