importing attachments, keep getting database error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • pitrow
    Member
    • Jan 2010
    • 66
    • 4.0.0

    importing attachments, keep getting database error

    Hello, I'm trying to import from phpbb 3.0.3 into vb4.0.2 PL 1 and I keep running into an error when I try to import the attachements.

    Every time I run it I get this
    Code:
    ImpEx Database errormysql error: Invalid SQL: 
                        INSERT INTO attachment
                        (
                            importattachmentid, filename, filedata,
                            dateline, visible, counter, filesize,
                            postid, filehash, userid, extension
                        )
                        VALUES
                        (
                            '938',
                            '10034.jpg',
                            '',
                            '1150242556',
                            '1',
                            '449',
                            '',
                            '32873',
                            'de8df3dfda56bfd676eadbe7fbed7878',
                            '1108',
                            'jpg'
                        )
                    
    
    mysql error: Unknown column 'filedata' in 'field list'
    
    mysql error number: 1054
    
    Date: Saturday 06th 2010f March 2010 04:46:21 PM
    Database: vb4_forum
    MySQL error:
    any ideas what could be causing this?
  • pitrow
    Member
    • Jan 2010
    • 66
    • 4.0.0

    #2
    Anyone?

    Comment

    • doggiebs
      Senior Member
      • Sep 2008
      • 355

      #3
      i would recommend you import into vb3 first and then upgrade to vb4 afterwards, as impex doesn't import attachments correctly into vb4 on some systems including phpBB3, impex is being works on to sort this problem.

      Comment

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