sql upload error – “duplicate line” on line 55
-
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), etcUNTIL 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 INTOwp_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
) VALUEScould 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
) VALUESand make sure the ; that preceded all the other instances become commas?
- The topic ‘sql upload error – “duplicate line” on line 55’ is closed to new replies.