DISQUS

Just to let you know, in order for you to improve the script if possible that the comments where all imported but without link to the post and the post itself the sql value "comment_count" was not updated too... done the trick through phpmyadmin but not so convenient if you import alot of comments

I presume it is normal to have lost all photos I had in my Txp post...

Yes no more the same error...will examine the result precisely!! happy to find a bug in your code ;-)

seems here comes the issue, will try without the comma

In you last code, there is a comma after comments_count :

comments_count,
FROM '.$prefix.'textpattern
', ARRAY_A);
where is the truth?

What do you mean by "Make sure the last field before the WHERE has no comment next to it." ?

Though it was the same... will try it!

yes! here it is :


WordPress database error: [You have an error in your SQL syntax near 'FROM txp_textpattern ' at line 15]
SELECT ID, Posted, AuthorID, LastMod, Title, Body, Excerpt, Category1, Category2, Status, Keywords, url_title, comments_count, FROM txp_textpattern

Done! 0 posts imported.

Ok, now it is clear to me... Here is the code where I remove the 2 lines:
return $txpdb->get_results('SELECT
ID,
Posted,
AuthorID,
LastMod,
Title,
Body,
Excerpt,
Category1,
Category2,
Status,
Keywords,
url_title,
comments_count,
FROM '.$prefix.'textpattern
', ARRAY_A);

Just to mention that I tried an import from Txp 4.0.1 ... if it helps...

???? the code is just the one included in WP 2.0 RC1...supposed to be your code!?

give-me your tags...

[code]WordPress database error: [You have an error in your SQL syntax near 'FROM txp_textpattern ' at line 15]
SELECT ID, Posted, AuthorID, LastMod, Title, Body, Excerpt, Category1, Category2, Status, Keywords, url_title, comments_count, FROM txp_textpattern[/code]

mmm, now have this error again for posts import :
WordPress database error: [You have an error in your SQL syntax near 'FROM txp_textpattern ' at line 15]
SELECT ID, Posted, AuthorID, LastMod, Title, Body, Excerpt, Category1, Category2, Status, Keywords, url_title, comments_count, FROM txp_textpattern"

mmm, now have this error again for posts import :
"WordPress database error: [You have an error in your SQL syntax near 'FROM txp_textpattern ' at line 15]
SELECT ID, Posted, AuthorID, LastMod, Title, Body, Excerpt, Category1, Category2, Status, Keywords, url_title, comments_count, FROM txp_textpattern"

Ok I have installed the WP 2.0 RC1 and use the embedded script to import from Txp... I have the following error when I try to import posts :
WordPress database error: [You have an error in your SQL syntax near '"INTERVAL 1 HOURS") AS post_date_gmt, ADDDATE(LastMod, "INTERVAL 1 HOU' at line 15]
SELECT ID, Posted, AuthorID, LastMod, Title, Body, Excerpt, Category1, Category2, Status, Keywords, url_title, comments_count, ADDDATE(Posted, "INTERVAL 1 HOURS") AS post_date_gmt, ADDDATE(LastMod, "INTERVAL 1 HOURS") AS post_modified_gmt FROM txp_textpattern

any idea?

Oh, ok... is it a version for previous release? does the one included in 1.5.2 works well?

1.5.2 the latest stable one...

Hi,

I am completely new to WP and just do not find where in admin panel is the "import" function....

thanks
Pascal