Title: Importing Entries from MT, SQL syntax error
Last modified: August 18, 2016

---

# Importing Entries from MT, SQL syntax error

 *  [zoo1023](https://wordpress.org/support/users/zoo1023/)
 * (@zoo1023)
 * [19 years, 5 months ago](https://wordpress.org/support/topic/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.

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Thread Starter [zoo1023](https://wordpress.org/support/users/zoo1023/)
 * (@zoo1023)
 * [19 years, 4 months ago](https://wordpress.org/support/topic/importing-entries-from-mt-sql-syntax-error/#post-500007)
 * No thoughts?? I STILL can’t get this blog working, I’m so frustrated!
 *  [Pravin Paratey](https://wordpress.org/support/users/pravin/)
 * (@pravin)
 * [19 years, 4 months ago](https://wordpress.org/support/topic/importing-entries-from-mt-sql-syntax-error/#post-500027)
 * 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.

## Tags

 * [Import](https://wordpress.org/support/topic-tag/import/)
 * [mt](https://wordpress.org/support/topic-tag/mt/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [Pravin Paratey](https://wordpress.org/support/users/pravin/)
 * Last activity: [19 years, 4 months ago](https://wordpress.org/support/topic/importing-entries-from-mt-sql-syntax-error/#post-500027)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics