Announcement

Collapse
No announcement yet.

Import SMF -> vBulletinCMS

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

  • Leon_ofcra
    replied
    Same error here

    Can you please help us ?

    Leave a comment:


  • erosolmi
    started a topic Import SMF -> vBulletinCMS

    Import SMF -> vBulletinCMS

    I'm importing attachments from SMF (1.1.10) to vBulletin CMS 4.0.0 Patch Level 1
    I'm using Impex 1.94

    All went fine except for the 2 following problems:
    1) user avatar: none imported. I've read in another post that Avatars are not supposed to be imported. I will be manually
    2) attachmenets: immediatelly import stops due to the following MySql error:
    ImpEx Database errormysql error: Invalid SQL:
    INSERT INTO attachment
    (
    importattachmentid, filename, filedata,
    dateline, visible, counter, filesize,
    postid, filehash, userid, extension
    )
    VALUES
    (
    '1',
    'clip0018.JPG',
    '',
    '1262704399',
    '1',
    '147',
    '',
    '23324',
    '840c026ec9122370245c1f0129083459',
    '411',
    'jpg'
    )


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

    mysql error number: 1054

    Date: Tuesday 05th 2010f January 2010 04:13:19 PM
    Database: vbulletincms
    MySQL error:
    It seems some fields are missing from attachment table.
    Configuration stores attached files on file system.

    Any help?
    Thanks a lot
    Eros
    Last edited by erosolmi; Tue 5th Jan '10, 6:43am.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X