Title: Import from Textpattern into WordPress
Last modified: August 18, 2016

---

# Import from Textpattern into WordPress

 *  [flashpunk](https://wordpress.org/support/users/flashpunk/)
 * (@flashpunk)
 * [20 years, 5 months ago](https://wordpress.org/support/topic/import-from-textpattern-into-wordpress/)
 * I’m trying to import a textpattern blog into a wordpress install. I’m getting
   these SQL Errors. (keep in mind i’ve never really worked with a SQL database 
   before, so excuse my lack of knowledge)
    -  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 ‘”INTERVAL -7 HOURS”) AS post_date_gmt, ADDDATE(LastMo]
       SELECT
      ID, Posted, AuthorID, LastMod, Title, Body, Excerpt, Category1, Category2,
      Status, Keywords, url_title, comments_count, ADDDATE(Posted, “INTERVAL -7 
      HOURS”) AS post_date_gmt, ADDDATE(LastMod, “INTERVAL -7 HOURS”) AS post_modified_gmt
      FROM textpattern
    - 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 ‘”INTERVAL -7 HOURS”) AS post_date_gmt, ADDDATE(LastMo]
       SELECT
      option_value FROM wp_options WHERE option_name = ‘txpposts2wpposts’ LIMIT 
      1
    - 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 ‘”INTERVAL -7 HOURS”) AS post_date_gmt, ADDDATE(LastMo]
       INSERT
      INTO wp_options (option_name, option_value, option_description, autoload) 
      VALUES (‘txpposts2wpposts’, ‘a:0:{}’, ”, ‘yes’)
    - 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 ‘”INTERVAL -7 HOURS”) AS post_date_gmt, ADDDATE(LastMo]
       SELECT
      ID FROM wp_posts WHERE TRIM(to_ping) != ” LIMIT 1
    - 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 ‘”INTERVAL -7 HOURS”) AS post_date_gmt, ADDDATE(LastMo]
       SELECT
      post_id FROM wp_postmeta WHERE meta_key = ‘_pingme’ OR meta_key = ‘_encloseme’
      LIMIT 1
 * Does anyone have any idea

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

 *  [adb](https://wordpress.org/support/users/adb/)
 * (@adb)
 * [20 years, 1 month ago](https://wordpress.org/support/topic/import-from-textpattern-into-wordpress/#post-292699)
 * When attempting to import textpattern posts to wordpress I get the following 
   error:
 * 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‘/
   txp_category WHERE type = “article”‘ at line 5]
    SELECT id, name, title FROM /
   txp_category WHERE type = “article” No Categories to Import!
 * How do I correct this? Thanks in advance.
 *  [adb](https://wordpress.org/support/users/adb/)
 * (@adb)
 * [20 years, 1 month ago](https://wordpress.org/support/topic/import-from-textpattern-into-wordpress/#post-292700)
 * Suggestions anyone? Or is this a lost cause?
 *  [adb](https://wordpress.org/support/users/adb/)
 * (@adb)
 * [20 years, 1 month ago](https://wordpress.org/support/topic/import-from-textpattern-into-wordpress/#post-292701)
 * I decided to try a fresh wp install in a new database and then use the textpattern
   import feature from the admin page. I got the following errors:
 * WordPress database error: [Table ‘database_tp.txp_txp_category’ doesn’t exist]
   
   SELECT id, name, title FROM txp_txp_category WHERE type = “article”
 * No Categories to Import!
    WordPress database error: [Table ‘database_tp.wp_options’
   doesn’t exist] SELECT option_value FROM wp_options WHERE option_name = ‘txp_cats’
   LIMIT 1
 * WordPress database error: [Table ‘database_tp.wp_options’ doesn’t exist]
    INSERT
   INTO wp_options (option_name, option_value, option_description, autoload) VALUES(‘
   txp_cats’, ”, ”, ‘yes’)
 * WordPress database error: [Table ‘database_tp.txp_txp_users’ doesn’t exist]
    
   SELECT user_id, name, RealName, email, privs FROM txp_txp_users
 * No Users to Import!
    WordPress database error: [Table ‘database_tp.txp_textpattern’
   doesn’t exist] SELECT ID, Posted, AuthorID, LastMod, Title, Body, Excerpt, Category1,
   Category2, Status, Keywords, url_title, comments_count FROM txp_textpattern
 * WordPress database error: [Table ‘database_tp.wp_options’ doesn’t exist]
    SELECT
   option_value FROM wp_options WHERE option_name = ‘txpposts2wpposts’ LIMIT 1
 * WordPress database error: [Table ‘database_tp.wp_options’ doesn’t exist]
    INSERT
   INTO wp_options (option_name, option_value, option_description, autoload) VALUES(‘
   txpposts2wpposts’, ‘a:0:{}’, ”, ‘yes’)
 * Done! 0 posts imported.
 * WordPress database error: [Table ‘database_tp.txp_txp_discuss’ doesn’t exist]
   
   SELECT * FROM txp_txp_discuss
 * WordPress database error: [Table ‘database_tp.wp_options’ doesn’t exist]
    SELECT
   option_value FROM wp_options WHERE option_name = ‘txpposts2wpposts’ LIMIT 1
 * No Comments to Import!
 * WordPress database error: [Table ‘database_tp.txp_txp_link’ doesn’t exist]
    SELECT
   id, date, category, url, linkname, description FROM txp_txp_link
 * No Links to Import!
    WordPress database error: [Table ‘database_tp.wp_options’
   doesn’t exist] SELECT option_value FROM wp_options WHERE option_name = ‘txp_links’
   LIMIT 1
 * WordPress database error: [Table ‘database_tp.wp_options’ doesn’t exist]
    INSERT
   INTO wp_options (option_name, option_value, option_description, autoload) VALUES(‘
   txp_links’, ”, ”, ‘yes’)
 * Clearly, the import process is not as simple as just clicking the “import”. I’d
   very much like to continue using wordpress, but this import ordeal is making 
   it difficult. Please help! 🙁 Thanks!
 *  [adb](https://wordpress.org/support/users/adb/)
 * (@adb)
 * [20 years, 1 month ago](https://wordpress.org/support/topic/import-from-textpattern-into-wordpress/#post-292702)
 * I tried the import again. I got a bunch of errors, but at the end of each import
   step it told me how many posts, comments, etc had been imported. When the import
   finished, still no posts, comments, etc. Suggestions?
 *  [adb](https://wordpress.org/support/users/adb/)
 * (@adb)
 * [20 years, 1 month ago](https://wordpress.org/support/topic/import-from-textpattern-into-wordpress/#post-292703)
 * I solved the problem. Moved wordpress to the same database as Textpattern. No
   problem with the import that way.

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

The topic ‘Import from Textpattern into WordPress’ is closed to new replies.

## Tags

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

 * In: [Alpha/Beta/RC](https://wordpress.org/support/forum/alphabeta/)
 * 5 replies
 * 2 participants
 * Last reply from: [adb](https://wordpress.org/support/users/adb/)
 * Last activity: [20 years, 1 month ago](https://wordpress.org/support/topic/import-from-textpattern-into-wordpress/#post-292703)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics