Forums

Importing Entries from MT, SQL syntax error (3 posts)

  1. zoo1023
    Member
    Posted 5 years ago #

    I'm incredibly frustrated...I can't find the answer to this in the forums (the one person who posted something similar never got a response), and the Docs section has what appears to be out-of-date information on importing entries? The file mentioned in the Docs doesn't even exist in this version of WP, as far as I can tell.

    Anyway. I've tried to break up my import.txt file into small chunks, but even importing a single entry gives me this error:

    Importing post ZAN IS ONLINE\...
    WordPress database 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 'closed', 'closed', '', 'zan-is-online', '', '', '1969-12-31 18:59:59', '1969-12-' at line 4]
    INSERT IGNORE INTO wp_posts (post_author, post_date, post_date_gmt, post_content, post_content_filtered, post_title, post_excerpt, post_status, comment_status, ping_status, post_password, post_name, to_ping, pinged, post_modified, post_modified_gmt, post_parent, menu_order, post_mime_type) VALUES ('2', '1969-12-31 18:59:59', '1969-12-31 23:59:59', '', '', 'ZAN IS ONLINE\\', '', 'Publish\', 'closed', 'closed', '', 'zan-is-online', '', '', '1969-12-31 18:59:59', '1969-12-31 23:59:59', '0', '0', '')

    WordPress database 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 '' at line 3]
    SELECT category_id FROM wp_post2cat WHERE post_id =

    WordPress database 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 ' 1)' at line 2]
    INSERT INTO wp_post2cat (post_id, category_id) VALUES (, 1)

    Any ideas?? I really want to like WordPress, but this is making it difficult! I can add the actual file text, if it would help anyone.

  2. zoo1023
    Member
    Posted 5 years ago #

    No thoughts?? I STILL can't get this blog working, I'm so frustrated!

  3. pravin
    Member
    Posted 5 years ago #

    Notice your 'Publish\' ends with a \'

    Remove the \ and it should work. Do the same for other lines too.

    For 'ZAN IS ONLINE\\', you can change it to 'ZAN IS ONLINE' or leave it as it is.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags