![]() |
phpBB2 attachment support for ImpEx
Hi,
This "mod" will import attachments from your phpBB2 board to your vB3 board, and comes in the form of another ImpEx module for the phpBB2 system. You must patch your impex before you start the import process. You cannot use this to import attachments from a phpBB2 board to an existing vBulletin board already imported, as crucial data is missing (namely, mapping the old phpBB2 postid to the new vB postid). It also requires a small modification to one of the core ImpEx files to fix a small bug (missing addslashes on a variable passed to the DB), and several other phpBB2 module files. I wrote this for personal use, in order to import my own board. Later tested it on another board and fixed a few bugs, but I'm certain there may be some left. It's based on the IPB attachment importer, but I believe I'm allowed to post it here, as only registered owners should be able to grab the code. Two small comments - during the import stage, it will ask you what's the largest attachment you want to import. This is limited by several factors - the setting of the MySQL variable "max_allowed_packet" (as attachments are imported into the DB), and the type of the filedata field in the attachment table. vB uses "mediumtext", which will limit you to 16MB attachments. If you want to import larger attachments, be sure to change these two. If using the slow queries log, you may also want to consider either disabling it temporarily, or raising the long_query_time value - otherwise the MySQL will choke itself just trying to write out almost every single large attachment to the logfile... which will slow things down even more. Finally - in order for the import process to finish quickly and efficiently, an INDEX is required on the importpostid column in the "post" table. I did not add this automatically, as I'm not sure where all those added fields that the importer adds to tables are cleared up. Before running the attachments module (but after running the posts module), execute this query: Code:
ALTER TABLE `post` ADD INDEX `importpostidx` ( `importpostid` ) be much, much slower - try to avoid doing that). I dunno if I'm allowed to post the modified ImpEx files themselves, so I'll post a patch file from ImpEx 1.21 (much easier than listing by hand :) ). If the files can be posted, please let me know, and I'll attach those as well. To use the patch file put it one level above the "impex" directory, then run: patch -p1 -d impex < phpBB2_attachments_import.patch EDIT: forgot to include the importattachmentid column here. Look 2 posts down for instructions. Hope this helps someone. |
This is awsome. Been wanting to move my phpBB attachments. Now I finally can. Will surely give this a try.
Thanks for sharing. *install* |
In the patch file included here I neglected to add one required line
which is required in order to create a temporary column in the attachment table during the upgrade process. In impex/systems/phpBB2/001.php, around line 89, and AFTER you use the patch file, find this: Code:
'13' => array('post' => 'importpostid') Code:
'13' => array('post' => 'importpostid'), named 'importattachmentid' to the attachment table. |
Can you clarify on what you mean by adding a BIGINT column to the attachment table? I have a phpBB import already underway and successful. I've patched my impex with both sets of changes but the attachment option does not show up in ImpEx.
Thanks in advance. -Pat |
I'll forward this over to Jerry to confirm this is allowed :) Also he may have some use for it.
|
Cool. To recap - I've already done an import of my users/messages and that worked OK. I ran patch, and replaced the missing line. When I fire up ImpEx from the ACP, no option shows up to import phpBB attachments. I'm wondering if I have to bump a file to tell it to restart the import.. or whether I need to extend the SQL schema with a new column as indicated above.
Your help is appreciated. Have a nice weekend. -Pat |
Hello,
Ive currently installed a fresh vB3 and imported all my data from my old phpbb forums. My problems is now to import the attachments as its the only thing left for me to do. Ive downloaded the "Attachment Fix" script but im a little miffed on where or what todo with this. Could somebody point me in the right direction as i would dearly like to import all my attachments and everything upto now has gone really well. From a Board already up with only attachments waiting todo, what will i have todo in order to execute this script and import my phpbb attachments. Any help greatly appreciated folks, ill be eyes open Thx. |
i'll help ya out...where are you stuck? After you did the mod there should be a module that says Import Attachments in ImpEx UNLESS you added this mod AFTER you started the inital import.
|
Thx Audigy mate,
Well im not sure ive added the module, above in instructions it says To use the patch file put it one level above the "impex" directory, then run: patch -p1 -d impex < phpBB2_attachments_import.patch Ive placed that file in the correct location but then what ? its say run the patch -p1 -d impex < phpBB2_attachments_import.patch but im presuming this is from sever side ? as im not sure on how to execute this script at all. Many thx aud, appreciate your reply/time. Cecil |
As someone mentioned, the module will not show up if you only
added it after starting an import session, due to the datastore ImpExSession (or whatever it's called,I forget) storing a serialized version of the current import state (one would hope that sometime in the future it would actually store errors as well, kind of useless right now). Regardless, the attachment import requires that the posts import module adds another field to the table, so even if it did show you'd need to import everything all over again. As to how to use this: since I did not want to give step by step instructions on how to patch the ImpEx files, I included a patch file. If you do not have command line access to the machine your vB3 is running on, you'll have to unpack impex locally, patch it, then transfer things over to the server. If using Windows, grab the patch utility here: http://prdownloads.sourceforge.net/g...n.exe?download Or simply install Cygwin. Hope this helps. |
All times are GMT. The time now is 03:19 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|