Announcement

Collapse
No announcement yet.

importing attachments, keep getting database error

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

  • 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?

  • #2
    Anyone?

    Comment


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