Importing Entries from MT, SQL syntax error
-
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.
- The topic ‘Importing Entries from MT, SQL syntax error’ is closed to new replies.