Attachment table missing columns
 

Hello,
I'm attempting to import smf 1.9 -> vb 4 latest.

When I get to the attachments it fails with the following error.
Quote:
ImpEx Database errormysql error: Invalid SQL:
INSERT INTO attachment
(
importattachmentid, filename, filedata,
dateline, visible, counter, filesize,
postid, filehash, userid, extension
)
VALUES
(
'335',
'IrishFloodPanic.jpg',
'',
'1274798091',
'1',
'3',
'',
'36568',
'6a61944d8b2eeb70b97041f920ba1f4b',
'421',
'jpg'
)


mysql error: Unknown column 'filedata' in 'field list'

mysql error number: 1054

Date: Wednesday 26th 2010f May 2010 12:34:51 AM
Database: xxx
MySQL error:

Looking at my attachment table, the following fields are present
Quote:
attachmentid contenttypeid contentid userid dateline filedataid state counter posthash filename caption reportthreadid settings importattachmentid

so, it would seem that these fields are missing:
Quote:
filedata, filesize, postid, filehash, extension


Can I recreate the attachment table before my import? There is only the 1 test attachment in there regardless, so no issues dropping / creating.

Thanks,
Moses.