Announcement

Collapse
No announcement yet.

Almost got it, only one item left for success.

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

  • #16
    My host has agreed to increase the allowed memory size but when I ran the import for attachments, I received this error.

    ImpEx Database error


    mysql error: Invalid SQL:
    INSERT INTO attachment
    (
    importattachmentid,
    filename,
    userid,
    dateline,
    counter,
    reportthreadid,
    caption,
    state,
    contentid,
    filedataid,
    contenttypeid,
    settings,
    displayorder
    )
    VALUES
    (
    '1846',
    'My pic\'s 170.jpg',
    '22',
    '',
    '53',
    0,
    'My pic's 170.jpg',
    'visible',
    2601,
    523,
    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 's 170.jpg',
    'visible',
    2601,
    523,
    1,
    '',
    0
    )' at line 25


    mysql error number: 1064


    Date: Saturday 12th 2012f May 2012 03:00:05 PM
    Database: micompan_vbforum
    MySQL error:

    Comment


    • #17
      I must be editting the ImpexDatabaseCore file wrong. I have tried several times and keep getting this error. Ugh, my head hurts!

      Thanks to everyone who has helped so far, it is much appreciated!

      Comment


      • #18
        That error is saying it doesn't like the single quote in here:

        My pic\'s 170.jpg'

        Perhaps edit the database directly and remove it and then trying running the script again.

        Please don't PM or VM me for support - I only help out in the threads.
        vBulletin Manual & vBulletin 4.0 Code Documentation (API)
        Want help modifying your vbulletin forum? Head on over to vbulletin.org
        If I post CSS and you don't know where it goes, throw it into the additional.css template.

        W3Schools <- awesome site for html/css help

        Comment


        • #19
          Originally posted by Lynne View Post
          That error is saying it doesn't like the single quote in here:

          My pic\'s 170.jpg'

          Perhaps edit the database directly and remove it and then trying running the script again.
          Exactly what I ended up doing. I deleted approx 40 pics which had extra ' in them. was able to save about 99% of the pics. Thank You for all the help!

          Comment

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