Announcement

Collapse
No announcement yet.

impex mysql error while importing attachments

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

  • BOWZONE
    replied
    here is the url
    http://forum.kitmeout.com/rmc-latest...html?p=0#post0
    here is the category where all data is imported
    http://forum.kitmeout.com/rmc-yoropiko-mkws/

    Leave a comment:


  • Hartmut
    replied
    I see. Could I get the URL together with an example link to look myself?

    Leave a comment:


  • BOWZONE
    replied
    Originally posted by Hartmut View Post
    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,

    Leave a comment:


  • Hartmut
    replied
    Originally posted by BOWZONE View Post
    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?

    Leave a comment:


  • BOWZONE
    started a topic impex mysql error while importing attachments

    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

    http://www.mydomain.com/showthread.p...5427&p=0#post0

    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
    www.mydomain.com/member.php

    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.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X