Announcement

Collapse
No announcement yet.

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

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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

  • #2
    Change the attachment storage to database prior to importing.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      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.

      Comment


      • #4
        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
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          ..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?

          Comment


          • #6
            Originally posted by Steve Machol View Post
            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?

            Comment


            • #7
              No, when the source system has them in the database - Impex is a database transfer tool, not a file transfer tool
              Vote for:

              - *Admin Settable Paid Subscription Reminder Timeframe*
              -
              *PM - Add ability to reply to originator only*
              - Add Admin ability to auto-subscribe users to specific channel(s)
              - "Quick Route" Interface...

              Comment


              • #8
                Originally posted by Trevor Hannant View Post
                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.

                Comment


                • #9
                  Yes, just enter the full path and proceed.
                  Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                  Change CKEditor Colors to Match Style (for 4.1.4 and above)

                  Steve Machol Photography


                  Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                  Comment

                  widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                  Working...
                  X