[Zylantex]

Thanks TLS I've being doing this over the last few days and the old system is still live so the situation is not critical.

That's very good advice to go the 3.8 route, I'll give it a go and report back later.

--------------- Added 04 Oct 2016 at 15:14 ---------------

I installed 3.8.9 and did the import. Strangely all forums were imported as categories but I manually changed them before proceeding.

I then installed and upgraded to 4.2.2 without any failures during the process.
Embedded images and attachments seem fine.
All the video links are weird, the text after the video: seems to vary for every item.

[video:346bwfqo]https://www.youtube.com/watch?v=5Njp-NeuZ6M&spfre[/video:346bwfqo]
[video:1ts98nqh]https://www.youtube.com/watch?v=yYcCbR1q5UY[/video:1ts98nqh]
[video:2v94fly3]https://youtu.be/7soLnMj4VjM[/video:2v94fly3]

I only see the text not the video.

When viewing a thread the dates in the postbits are showing correctly but at a forum level all dates are 31/12/1960 11:00pm so no posts show as active.

The posts per page parameter is still being ignored.

Would it help if I use a higher PHP Rev after the upgrade say PHP 5.6?

--------------- Added 04 Oct 2016 at 15:38 ---------------

I've looked at some of the tables in MySQL and I note the following:

Table: post
Field: postid - looks correct
Field: threadid - looks correct
Field: userid -looks correct

Table: thread
Field: firstpostid - all zeroes
Field: lastpostid - all zeroes
Field: lastpost - all zeroes
Field: forumid - looks correct

Table: forum
Field: lastpost - all zeroes
Field: lastpostid - all zeroes
Field: lastthreadid - looks normal
Field: lastposter - all zeroes

I think the missing links are the issue but my php/MySQL isn't up to correcting it.