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.

[TFGoRP]

Originally Posted by Andreas

What is the path you did enter for attachments?

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?

[TFGoRP]

If you require any other information please do let me know!

[eva2000]

Awesome indeed Andreas

[Andreas]

Originally Posted by TFGoRP

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

Thats's the wrong path, this directory only contains thumbnails.
You must enter the part to internal_data/attachments.

However when I ran attachments it looked for filenames like "blah.jpg"

The filename is just for human readability, it does look for the real file (well, at least it should ).

[TFGoRP]

Originally Posted by Andreas

Thats's the wrong path, this directory only contains thumbnails.
You must enter the part to internal_data/attachments.


The filename is just for human readability, it does look for the real file (well, at least it should ).

the path to internal_data/attachments does not work, it still tells me source file not found for every single attachment.

If you need any other info do let me know! I would very much like to be able to do the full import as soon as possible, thank you for the support and time you have put into this

Look forward to your next response.

[Andreas]

Seems like you are SOL with this problem then as it works just fine for me.

Sorry, but I can't help you without access to your server.

You might want to check that the path is indeed correct and that the webserver has read access to read the files:
Put

PHP Code:

echo($path); 


in line 94 of 010.php to see which files are actually being accessed.

[BamaStangGuy]

Originally Posted by soniceffect

Nooooooo .... spent hours and hours converting mine through IPB to get it back!!!!

I'd have just stopped at IPB...

Maybe one day vBulletin will come up with a 3.6.12 to 4.2 upgrade script for vBulletin.org

[TFGoRP]

Originally Posted by Andreas

Seems like you are SOL with this problem then as it works just fine for me.

Sorry, but I can't help you without access to your server.

You might want to check that the path is indeed correct and that the webserver has read access to read the files:
Put

PHP Code:

echo($path); 


in line 94 of 010.php to see which files are actually being accessed.

I managed to get the attachments imported but on the very last step after importing attachments which worked perfectly I get this error on the last button. Process Inline attachments

ImpEx Database error

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


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 ' 10' at line 5

mysql error number: 1064

Date: Tuesday 22nd 2012f May 2012 05:52:31 AM
Database: mydatabase
MySQL error:+
Anyway to fix that?

Thanks for your support!

[TFGoRP]

Quick update: I can't even click on the Import button in the ACP, I also get the error above.

[pjfry]

Hi i get this Error after importing the forums:

ImpEx Database error

mysql error: Invalid SQL:
UPDATE forum
SET parentid = 2218
WHERE forumid = 2088


mysql error: Table 'dev_onlinegilde.forum' doesn't exist

mysql error number: 1146

Date: Tuesday 22nd 2012f May 2012 01:09:11 PM
Database: dev_onlinegilde
MySQL error:

First i thought this is a problem with my target DB, but the connection seems to be fine. So I have no idea what is going wrong here.

Maybe someone has an idea?

Thanks for your help!

Benny