JForum Posts Missing

[StuBramley]

Type of import - Clean Import
Source - JForum - 2.1.8
Target - vBulletin 3.8.2
Module - 007 - Import Post

The module is not importing several thousand posts.

If I run the query in the get_jForum_post_details function manually :-


SELECT posts.post_id, posts.topic_id, posts.forum_id, posts.user_id, posts.post_time, posts.poster_ip, posts.enable_bbcode, posts.enable_html,
posts.enable_smilies, posts.enable_sig,
posts_text.post_id, posts_text.post_text, posts_text.post_subject
FROM jforum_posts AS posts
LEFT JOIN jforum_posts_text AS posts_text ON (posts.post_id = posts_text.post_id)
ORDER BY posts.post_id

It returns 16147 records

However the ImpEx import only processes 13596 records - all successful and with no errors. The result is that the last 2+ months of posts are excluded.

[StuBramley]

I think that a JForum hack is the cause of this - there are posts that have no post text in the database. The import stops when the first null post text is encountered. If I delete these orphaned records the import works Ok.