Imported MT Entries Wacky

Thanks. How do I execute this script?

Okay, got it to run. Got an error though:
Invalid query: insert command denied to user: ‘jimlynch_jim@localhost’ for table ‘wp_users’
SQL : INSERT INTO wp_users (user_login,user_pass,user_firstname,user_lastname,user_nickname,user_icq,user_email,user_url,user_ip,user_domain,user_browser,dateYMDhour,user_level,user_aim,user_msn,user_yim,user_idmode) VALUES (‘Jim’,’1a1dc91c907325c69271ddf0c944bc72′,’Jim’,”,’Jim’,”,’[email protected]’,’www.jimlynch.com’,”,”,”,”,’1′,”,”,”,”);

Okay, I blew away the database and reinstalled. That took care of the error above.
But I got this one when it started importing:
Invalid query: 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 ’[email protected]’,”,’140.146.234.149′,’2004-05-03 01:24:0
SQL : INSERT INTO wp_comments (comment_post_ID,comment_author,comment_author_email,comment_author_url,comment_author_IP,comment_date,comment_content,comment_karma) VALUES (’20’,’rockin\’88tbirdgirl’,’rockin’[email protected]’,”,’140.146.234.149′,’2004-05-03 01:24:07′,’I think this site is spectacular, and it brings into focus, once again, something a lot of people have forgotten about: September the 11th, 2001. I will never forget where I was or what I was doing whan I found out the World Trade Center had been hit by terrorists. People have a tendency to forget; out of sight, out of mind. Every month on the 11th on the large dry-erase board where I work, I write, \”REMEMBER!\” in the hopes that it will wake people out of their little daydream that they are safe in the world. Most people get it, and some people just think I am odd. Apparently, September the 11th, was not very important to them as it was to me. I feel sometimes that I am the only person that still thinks of September the 11th with horror and deep, desparaging sadness. I cannot be the only one, obviously, by the number of posts I have read here, although it FEELS like it. I feel physically ill, when I think about all of the people that had to make the gruesome choice of being either burnt to death or to jump out of the buildings and commit suicide.The 911 calls that were made and were not responded to because rescuers could not get to their location, is equally sickening to me. Is there anyone from the mid-west that feels as I do? Just curious…Well, I just wanted to say that I have not forgotten this horrible act of terrorism against the United States or how many people died nor will I ever. I am thinking of all the people around the world that lost a loved one in the terrorist attacks! God Bless You All!’,’0′);

Well this is interesting. Some of the entries did get imported but still with the line breaks! So it’s not MT’s export that’s the problem. I see the exact same thing.
I doubt it’s WP’s problem either. Could it be the way Mozilla’s Composer handles links and HTML? That’s what I used for the most part for all of these entries. Does it have some kind of formatting problem or something?

At this point, I’ve decided to use a Word macro to just clean up the important entries. That should make it fairly quick.

Jim, it seems the entries are screwed up the way they are stored in the MT database, for whatever reason.
What amazes me is how your MT installation managed to remove those breaks while displaying those entries. (In other words, if the entries had breaks in them, MT should have displayed those)
Hope you find that the latest solution works.

Thank you both very much, I appreciate the help.
But it’s too late. I killed the MT database earlier this evening. I fixed the most important entries with the Word macro and will either prune out the nonimportant ones by deleting them or will fix the rest slowly over time.
But thank you both very much. I really did appreciate the effort to help out with this.
Despite the minor line break burp, I’m really digging WP. It’s got quite a lot of what I wanted from MT. And boy do I love the little smilie hack. ??

replace
<?php the_content(); ?>
with
<?php
$postdata = $wpdb->get_row(“SELECT * FROM $tableposts WHERE ID = ‘$id'”);
echo $postdata->post_content;
?>

Hey thanks for writing this import tool. I have been havign trouble with my athors coming out in the wrong places. I removed all my (many) failed imported posts and ran your script. I got the following error:
Importing User records ...
Invalid query: Table 'opwp.wp_users' doesn't exist
SQL : INSERT INTO wp_users (user_login,user_pass,user_firstname,user_lastname,user_nickname,user_icq,user_email,user_url,user_ip,user_domain,user_browser,dateYMDhour,user_level,user_aim,user_msn,user_yim,user_idmode) VALUES ('rubyji','1a1dc91c907325c69271ddf0c944bc72','rubyji','','rubyji','','[email protected]','https://lotusmedia.org/blog/','','','','','1','','','','');'
What does this mean?