Running into an error when importing attachments

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Savy83
    New Member
    • Aug 2009
    • 5

    Running into an error when importing attachments

    ImpEx Database error

    mysql error: Invalid SQL:
    INSERT INTO attachment
    (
    importattachmentid,
    filename,
    userid,
    dateline,
    counter,
    reportthreadid,
    caption,
    state,
    contentid,
    filedataid,
    contenttypeid,
    settings,
    displayorder
    )
    VALUES
    (
    '193',
    'kill \'em all.jpg',
    '41',
    '1145019815',
    '22',
    0,
    'kill 'em all.jpg',
    'visible',
    2856,
    97,
    1,
    '',
    0
    )


    mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'em all.jpg',
    'visible',
    2856,
    97,
    1,
    '',
    0
    )' at line 25

    mysql error number: 1064

    Date: Sunday 05th 2014f January 2014 03:48:15 PM
    Database: janx_forums
    MySQL error:
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...