sql upload error – “duplicate line” on line 55

  • Resolved heroesnhunks

    (@heroesnhunks)


    15 years, 7 months ago

    I started a thread yesterday which put me on the right track to export my wordpress blog’s database as a sql file – but I’m having difficulty with applying it to my new host’s wordpress installation. They’ve been very helpful to a point but cannot help me figure out EXACTLY what the error is. They were able to determine that it happened at “line 55” because there was a duplicate line – line 55 appears to be the following …

    INSERT INTO wp_comments (comment_ID, comment_post_ID, comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_date_gmt, comment_content, comment_karma, comment_approved, comment_agent, comment_type, comment_parent, user_id)
    `
    this code is followed by VALUES (values for comment), (values for next comment), etc

    UNTIL one of the comments values is followed by a ; instead of a , and then the INSERT INFO code is repeated again…

    …(value for comment),(value for comment);
    INSERT INTO wp_comments (comment_ID, comment_post_ID, comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_date_gmt, comment_content, comment_karma, comment_approved, comment_agent, comment_type, comment_parent, user_id) VALUES

    could this be the problem that is stopping the sql database restore>

    this code IS repeated a few timed within the data for table wp_comments. Should I go in and remove all but the first instance of

    INSERT INTO wp_comments (comment_ID, comment_post_ID, comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_date_gmt, comment_content, comment_karma, comment_approved, comment_agent, comment_type, comment_parent, user_id) VALUES

    and make sure the ; that preceded all the other instances become commas?

Viewing 9 replies - 1 through 9 (of 9 total)
  • Thread Starter heroesnhunks

    (@heroesnhunks)

    the same thing is occurring with most of the other table structures… there is a string of code starting with INSERT INFO ‘wp_whatever’ that is repeated multiple time within each table structure – is that normal or could it cause a duplicate line error?

    If there is a better place for this thread please move it there.

    Thread Starter heroesnhunks

    (@heroesnhunks)

    anyone? I don’t know enough about wordpress code SHOULD look like to tell what’s causing the problem. Is there any OFFICIAL wordpress tech support?

    Thread Starter heroesnhunks

    (@heroesnhunks)

    I’ve compared my .sql file with the .sql file I dowloaded from the new installation to compare syntax and DID find a discrepency – just not sure what it means…

    in the new sql file (exported from a fresh wordpress install) every single entry into a table structure has the following structure

    INSERT INTO ‘wp_comment’ VALUE (values for comment);
    INSERT INTO ‘wp_comment’ VALUE (values for comment);
    INSERT INTO ‘wp_comment’ VALUE (values for comment);
    INSERT INTO ‘wp_comment’ VALUE (values for comment);

    instead of the way it is arranged in MY .sql file…(as exported – wp_comments as example)

    INSERT INTO wp_comments (comment_ID, comment_post_ID, comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_date_gmt, comment_content, comment_karma, comment_approved, comment_agent, comment_type, comment_parent, user_id) VALUES (values for comment),(values for comment),(values for comment),(values for comment),(values for comment),(values for comment);
    INSERT INTO wp_comments (comment_ID, comment_post_ID, comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_date_gmt, comment_content, comment_karma, comment_approved, comment_agent, comment_type, comment_parent, user_id) VALUES (values for comment),(values for comment),(values for comment),(values for comment),(values for comment),(values for comment);

    above discrepancy between the files continues for all other table structure too… my version lists a (series of data types within parentheses) inbetween the INSERT INTO wp_whatever and the VALUE, but the one exported by the fresh wp install doesn’t… do I have to make my syntax match the newer file in order for it to work? It is alot of owrk and I don’t want to do that unless I have to.

    Thread Starter heroesnhunks

    (@heroesnhunks)

    PLEASE HELP DESPERATE

    Thread Starter heroesnhunks

    (@heroesnhunks)

    no one knows the correct syntax?

    Thread Starter heroesnhunks

    (@heroesnhunks)

    PLEASE!

    What version of WordPress is the exported WordPress and what version is the new WordPress install?

    See: https://www.tamba2.org.uk/wordpress/restore/

    Thread Starter heroesnhunks

    (@heroesnhunks)

    problem was the settings I used when I exported the .sql file. I used defalt settings when there were boxes I needed to check – I FINALLY found the settings on my own.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘sql upload error – “duplicate line” on line 55’ is closed to new replies.