Import from Textpattern into WordPress

  • flashpunk

    (@flashpunk)


    18 years, 4 months ago

    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

    (@adb)

    18 years ago

    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

    (@adb)

    18 years ago

    Suggestions anyone? Or is this a lost cause?

    adb

    (@adb)

    18 years ago

    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

    (@adb)

    18 years ago

    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

    (@adb)

    18 years ago

    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.