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.

[fabiocesar]

an update with support xenforo 1.2?

[Booth]

Does this work with Xenforo 1.2?

[Booth]

This actually worked better than the IPB importer. Didn't bring in private messages though!

[CILGINKRAL_]

ImpEx Database error

mysql error: Invalid SQL: CREATE TABLE impexerror (
                        errorid bigint(20) unsigned NOT NULL auto_increment,
                        errortype varchar(10) NOT NULL default '',
                        classnumber varchar(3) NOT NULL default '',
                        importid bigint(20) NOT NULL default 0,
                        error varchar(250) default 'NULL',
                        remedy varchar(250) default 'NULL',
                        PRIMARY KEY (errorid)
                    ) TYPE=MyISAM

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 'TYPE=MyISAM' at line 9

mysql error number: 1064

Date: Wednesday 27th 2014f August 2014 12:40:09 PM
Database: data_vbtest
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 'TYPE=MyISAM' at line 9

I'm getting this error.

[ozzy47]

Edit the XML and change, TYPE=MyISAM; to ENGINE=MyISAM;

[CILGINKRAL_]

Which file xml?

ok
impex/index.php

Thanks ozzy47

[z3r0]

I can't see this mentioned above so I think it's best to post - I used this a few days ago and it allowed people to log in with a blank password after the conversion, to address this I used pwdreset.php from this page to reset and email new passwords to all users.

[New Joe]

Originally Posted by z3r0

I can't see this mentioned above so I think it's best to post - I used this a few days ago and it allowed people to log in with a blank password after the conversion, to address this I used pwdreset.php from this page to reset and email new passwords to all users.

Kind of a security issue really, for Admin accounts too.
I would suggest reporting this with the report button.

[denpietrau]

Originally Posted by TFGoRP

I entered the path to the /data/attachments folder, attachments worked fine though.

However when I ran attachments it looked for filenames like "blah.jpg" but xenforo stores all its attachments as 466545646546545664 and other random numbers while the actual file names are in the database under the xf_attachment_data table.

Is there anything that could be done for attachments?

Hi TFGoRP!

1. Copy Folder Attachments (internal_data/attachments from xenforo) to Vbulletin.
2. Path: /home1/myaccount/public_html/forum/internal_data/attachments

[Phillip]

Alright, I know this is for 4.1, but will it still work with 3.8 I get as far as the thread import and it ends up being...

ImpEx cannot continue and has halted due to missing needed fields in the source database :

xf_poll.multiple

Repair the source database and restart the import.

What do I need to do with this?