Version: 1.0.0, by Andreas
Developer Last Online: Jan 2023
Category: Miscellaneous Hacks -
Version: 4.1.11
Rating:
Released: 05-17-2012
Last Update: Never
Installs: 33
Is in Beta Stage
No support by the author.
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.
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:
Code:
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):
Code:
// 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!
I'm having this same exact issue. it looks like changing the code "LIMIT $start_at, $per_page" but i don't know enough to know what to fix.
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:
Code:
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):
Code:
// 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
ImpEx Module: Xenforo Details »»
About Developer
Visit Web Site
Is in Beta Stage 
09-18-2012, 10:46 PM
and don't login only username 
