Attachment problem - Import from WBB3 to VBB4 - Please help!

[markusva]

Hi there,
I try to import the data with Impex from my old Woltlab Burning Board 3.1.2 to VBB4 - everything is working fine except import o the attachments. I always get a "Failed: Attachment not imported" message for every attachment.
Path is correct and valid, All attachments are available, All files and the folder have chmod 777.
It seems Impex looks for the filesnames like "1234.jpg" but WBB3 saves the attachments in a format like "Attachment-2" ....
Moving all attachments to the database before making the import is not working cause WBB3 doesn't support attachments in databases.
Any advise how to solve this problem?? Its urgent.
Thank you!!
Markus

[Steve Machol]

Change the attachment storage to database prior to importing.

[markusva]

This causes the error:
ImpEx Database error
mysql error: Invalid SQL:
INSERT INTO attachment
(
importattachmentid, filename, filedata,
dateline, visible, counter, filesize,
postid, filehash, userid, extension
)
VALUES
(
'1',
'DSC01977.JPG',
'',
'',
'1',
'249',
'',
'47494',
'',
'1608',
'JPG'
)

mysql error: Unknown column 'filedata' in 'field list'
mysql error number: 1054
Date: Sunday 06th 2011f February 2011 05:31:23 AM
Database: demilo_db1
MySQL error:

The structure of the attachments database of seems to be different:

`attachmentid` int(10) unsigned NOT NULL auto_increment,
`contenttypeid` int(10) unsigned NOT NULL default '0',
`contentid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`filedataid` int(10) unsigned NOT NULL default '0',
`state` enum('visible','moderation') NOT NULL default 'visible',
`counter` int(10) unsigned NOT NULL default '0',
`posthash` varchar(32) NOT NULL default '',
`filename` varchar(255) NOT NULL default '',
`caption` text,
`reportthreadid` int(10) unsigned NOT NULL default '0',
`settings` mediumtext,
`displayorder` int(10) unsigned NOT NULL default '0',
`importattachmentid` bigint(20) NOT NULL default '0',
PRIMARY KEY (`attachmentid`),
KEY `contenttypeid` (`contenttypeid`,`contentid`,`attachmentid`),
KEY `contentid` (`contentid`),
KEY `userid` (`userid`,`contenttypeid`),
KEY `posthash` (`posthash`,`userid`),
KEY `filedataid` (`filedataid`,`userid`)

Except from this the total size of all attachments if 11 GB - I am not sure if the database can take this. Please help.

[Steve Machol]

Unfortunately at this time Impex will not import attachments if they are being stored in the file system. There is no workaround for this.

Please fee free to report this in the vB4 Bug Tracker here:

http://tracker.vbulletin.com/secure/Dashboard.jspa

[markusva]

..that means that VBB4 is absoluely useless for me until Impex has been repaired. So I have to stay with WBB3 and ask for a refund?

[hoochblues]

Unfortunately at this time Impex will not import attachments if they are being stored in the file system. There is no workaround for this.
http://tracker.vbulletin.com/secure/Dashboard.jspa

I assume this statement refers to the target (vB4) system? That file attachments can only be imported when the vB4 forum stores attachments in the database?

You could be pulling the the source (ex. phpbb) attachments from the file system?

[Trevor Hannant]

No, when the source system has them in the database - Impex is a database transfer tool, not a file transfer tool

[hoochblues]

No, when the source system has them in the database - Impex is a database transfer tool, not a file transfer tool

Now I am confused. Because module 010 of impex asks "Full path to uploads/attachments folder where the source attachments are."

That implies to me it is asking for the source folder for the attachments.

[Steve Machol]

Yes, just enter the full path and proceed.