Textpattern CMS

#1 2006-05-14 13:31:38

kahlo

Member

From: Dartmouth, Nova Scotia

Registered: 2006-05-14

Posts: 25

Triple spacing where there should be single.

Hi, I just started with TXP today actually and everything has been great thus far except when I imported my blog from my old WP installation, everything is triple spaced where in WP it is only single. I have no clue how to fix this as thus far I have not experienced this problem with my articles that originated in TXP. Any help that could be provided would be greatly appreciated. You can see the problem here —> http://alessandrapalmer.org/blog

— Ally

#2 2006-05-14 14:20:30

Mary

Sock Enthusiast

Registered: 2004-06-27

Posts: 6,236

Re: Triple spacing where there should be single.

It looks like you were using WordPress’ TinyMCE toolbar, is that right? What’s happened is that your posts already had HTML formatting applied, but you’ve got Textile turned on as well, so it’s being marked up a second time.

Do you intend to continue using the TinyMCE toolbar (there’s at least 1 Textpattern plugin)?

#3 2006-05-14 19:07:16

kahlo

Member

From: Dartmouth, Nova Scotia

Registered: 2006-05-14

Posts: 25

Re: Triple spacing where there should be single.

No I don’t intend to continue using the toolbar. Any ideas as to what I should do?

#4 2006-05-14 20:14:54

Mary

Sock Enthusiast

Registered: 2004-06-27

Posts: 6,236

Re: Triple spacing where there should be single.

Okay, for some reason the WordPress importer runs Textile on imported articles.

What you want to do is run an sql query. You can use something like phpMyAdmin or whatever database manager your host provides you with, or you can use this plugin.

If you can fill me in on two things, I can whip up the query for you to copy and paste:

1. Are you using a database prefix? if so, what?
2. I assume you imported all your WordPress posts first? Basically, what I’d like to know is what are the article id#s of the first (1?) and last of these older posts?

:)

Last edited by Mary (2006-05-14 20:15:31)

#5 2006-05-15 09:36:50

kahlo

Member

From: Dartmouth, Nova Scotia

Registered: 2006-05-14

Posts: 25

Re: Triple spacing where there should be single.

1. No, I am not using a database prefix.

2. The numbers are;
First one: 75
Last one: 110

Thanks so much!

#6 2006-05-15 18:21:33

Mary

Sock Enthusiast

Registered: 2004-06-27

Posts: 6,236

Re: Triple spacing where there should be single.

Okay, this should do it for you:

UPDATE textpattern SET `textile_body` = 0, `textile_excerpt` = 0, `Body_html` = `Body` WHERE ID BETWEEN 75 AND 110;

:)

#7 2006-05-15 20:56:36

kahlo

Member

From: Dartmouth, Nova Scotia

Registered: 2006-05-14

Posts: 25

Re: Triple spacing where there should be single.

Thanks. It worked. :)

Last edited by kahlo (2006-05-15 22:45:18)