impex mysql error while importing attachments

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • BOWZONE
    New Member
    • Feb 2005
    • 24

    impex mysql error while importing attachments

    i am running import from vb3.8 to vb4.2, first of all i got this error while running import attachment module.

    ImpEx Database error

    Code:
    mysql error: Invalid SQL: 
                INSERT INTO vbjake_attachment
                (
                    importattachmentid,
                    filename,
                    userid,
                    dateline,
                    counter,
                    reportthreadid,
                    caption,
                    state,
                    contentid,
                    filedataid,
                    contenttypeid,
                    settings,
                    displayorder
                )
                VALUES
                (
                    '229',
                    'rca record label logo & rangy mountain\'s rmc logo.JPG',
                    '3811',
                    '1230052922',
                    '15',
                    0,
                    'rca record label logo & rangy mountain's rmc logo.JPG',
                    'visible',
                    14265,
                    2335,
                    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 rmc logo.JPG',
                    'visible',
                    14265,
                    2335,
                    1,
                    '',
                    0
                )' at line 25
    
    mysql error number: 1064
    
    Date: Thursday 08th 2012f November 2012 07:54:50 AM
    Database: dbname
    MySQL error:
    And secondly i can't see the thread content of many imported threads, when i open the threads the threads are empty and the urls look like this

    Small business web hosting offering additional business services such as: domain name registrations, email accounts, web services, online community resources and various small business solutions.


    as you can see page = 0 and #post0

    and the last i also noticed that many of the imported users are not showing their profiles, as i hover on any username it shows the url as
    Small business web hosting offering additional business services such as: domain name registrations, email accounts, web services, online community resources and various small business solutions.


    please help me in fixing this, i already tried to run all general update tools.

    Thanks in advance

    - - - Updated - - -

    i figure out the mysql error, and successfully imported the attachments, need help with the rest.
  • Hartmut
    Senior Member
    • Nov 2007
    • 2870
    • 4.2.x

    #2
    Originally posted by BOWZONE
    i am running import from vb3.8 to vb4.2
    Uhm... why do you import from vB 3.8 to vB 4.2 instead of just running the upgrade script? Are you positive you meant importing from vB 3.8?
    No private support, only PM me when I ask for it. Support in the forums only.

    Comment

    • BOWZONE
      New Member
      • Feb 2005
      • 24

      #3
      Originally posted by Hartmut
      Uhm... why do you import from vB 3.8 to vB 4.2 instead of just running the upgrade script? Are you positive you meant importing from vB 3.8?
      i am merging two different forums,

      Comment

      • Hartmut
        Senior Member
        • Nov 2007
        • 2870
        • 4.2.x

        #4
        I see. Could I get the URL together with an example link to look myself?
        No private support, only PM me when I ask for it. Support in the forums only.

        Comment

        • BOWZONE
          New Member
          • Feb 2005
          • 24

          #5
          here is the url

          here is the category where all data is imported

          Comment

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