Miscellaneous Hacks - ImpEx Module: Xenforo

This is a Xenforo module for ImpEx, the vBulletin Import System,
it does allow you to import a Xenforo Database into a vBulletin 4 installation.

Currently, the following data will be imported:

• Usergroups
• Users including Avatars
• Forums
• Threads including Polls
• Posts
• Smilies
• Attachments
• Conversations
  As vBulletin does not have an equivalent to the Conversations feature in Xenforo, conversations will be converted to Private Messages in vBulletin.
  Please note that any attachments used in conversations will get lost as vBulletin does not (yet) support attachments in PMs.

This module has been developed for Xenforo 1.0.4, but it should also work with Xenforo 1.1.X.
Please not that Xenforo 1.1.X features (Profile Fields, Thread Prefixes, etc.) are not yet supported.

If there is enough interest I might add those features in a later release.

Warning
This module is BETA and has not been tested extensively - use it at your own risk.
If you find bugs, please report them!

Important - See Post #87 about an important potential security issue and fix if you use this.

[Brandon Sheley]

Originally Posted by iBaker

3. The Attachments path I just could not get right. I tried echoing the path and it showed the correct web address for the internal_data/attachments of the source web site but it failed on all attachments. I copied the source attachments folder to a folder in the target domain (i.e. vb site) and used the path /home/xxx/public_html/source_att/attachments/ and that worked for about 500 attachments out of 14,500

Ouch...
What did you do about the attachments, where you just testing things out?

[iBaker]

Yes I was just testing things out and couldn't get them imported so had to give up...very funny that you have just posted as about 2hrs ago I reinstalled vb and are going to make a concentrated effort to try and get things right so if anyone can help with the attachments then please, let us know what you did...also the other biggest worry is passwords, I will pay to be able for my users to keep their passwords

[RedFlamePro]

who can convert this mod to vbb 3.8x , please

[iBaker]

Ok, I have been working on this a fair bit and are overcoming many of the problems that it has, both within Impex and this mod.

I have been doing this on my local PC using xampps and once it is all going properly will try on a web server and then if all goes well I will post here the little things that I have had to do to make it work...for example Attachments should use database not file system as that will cause an error etc.

The final error that I have come up with is in the very last process of changing the in-line attachments (step 11).

The error I get is:

ImpEx Database error

mysql error: Invalid SQL: 
            SELECT attachmentid
            FROM attachment
            WHERE importattachmentid != 0
            ORDER BY attachmentid ASC
            LIMIT , 1000
        

mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1000' at line 5

mysql error number: 1064

Date: Saturday 01st 2012f September 2012 12:24:14 PM
Database: recflynew_forum
MySQL error:

This is the code in the php file that causes the error (011.php):

        // Get an array data
        $attachments = $Db_target->query("
            SELECT attachmentid
            FROM {$t_tb_prefix}attachment
            WHERE importattachmentid != 0
            ORDER BY attachmentid ASC
            LIMIT $start_at, $per_page
        ");

MySQL Error 1064 seems to fire up if the delimiter is incorrect...it also interesting that there seems to be no value inserted for $start_at

Can anyone help with this final error...thanks!

[iBaker]

I give up on this...after 2 days of solid work I can't get it to work...maybe some of you can that only have very small sites but for example if you have any more than 1,000 attachments it will fail...you don't get passwords or even the videos that XF allows you in posts and more.

The only option for me now, and others that are not happy with XF is to go to IPB...a real pity for vb

[big dan]

Ian,

For what it's worth I imported 400,000+ posts with something like 20k attachments with this module. The only thing I had to change was Ragtek's edit here: https://vborg.vbsupport.ru/showpost....4&postcount=55

Inline attachments stalled for me with no error given so I skipped it. It isn't a major step it just places the attachment code in posts.

[iBaker]

Originally Posted by big dan

Ian,

For what it's worth I imported 400,000+ posts with something like 20k attachments with this module. The only thing I had to change was Ragtek's edit here: https://vborg.vbsupport.ru/showpost....4&postcount=55

Inline attachments stalled for me with no error given so I skipped it. It isn't a major step it just places the attachment code in posts.

So are you saying that any post that has an inline attachment will still show the attach code in the post and no image but the attached image will show as a standard attachment?

This would result in messy posts wouldn't it?

Also what did you do about Avatars as my attempts show the user's avatar ok when viewing the user in the ACP however their avatar doesn't display in any postbits?

Also XF has the ability to display YouTube, Vimeo etc videos inline in posts. How did you handle their display instead of just leaving the bbcode text of them again making posts look messy?

Also what process do you do after step 10 given that you didn't run step 11?

[iBaker]

Just completed another import in my test xampp environment on my PC and are resolving 3many of the little issues...eg, Avatars are now working etc.

A couple of big issues that I have found is that the importer doesn't seem to do is:
Poll information...it only imports the first option of a poll and not all the other options so all polls just have one entry
Profile Messages don't seem to import either
IP addresses of posts don't get imported

[big dan]

Originally Posted by iBaker

Just completed another import in my test xampp environment on my PC and are resolving 3many of the little issues...eg, Avatars are now working etc.

A couple of big issues that I have found is that the importer doesn't seem to do is:
Poll information...it only imports the first option of a poll and not all the other options so all polls just have one entry
Profile Messages don't seem to import either
IP addresses of posts don't get imported

I noticed the lack of IP address and Profile messages after the import. Visitor messages are rarely used on my board and the IP address I can live without.

Originally Posted by iBaker

So are you saying that any post that has an inline attachment will still show the attach code in the post and no image but the attached image will show as a standard attachment?

This would result in messy posts wouldn't it?

Also what did you do about Avatars as my attempts show the user's avatar ok when viewing the user in the ACP however their avatar doesn't display in any postbits?

Also XF has the ability to display YouTube, Vimeo etc videos inline in posts. How did you handle their display instead of just leaving the bbcode text of them again making posts look messy?

Also what process do you do after step 10 given that you didn't run step 11?

Yeah, I left the posts messy. I'll edit them as they come up but I'm not very worried about it.

After step 10 I clicked the database cleanup and restart link to delete the session then dumped the IMPEX files and ran all the counter updates.

[Alien]

I hope to see this updated for profile messages and thread prefixes.

Thanks, Andreas!