• 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.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter zoo1023

    (@zoo1023)

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

    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.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Importing Entries from MT, SQL syntax error’ is closed to new replies.