[Morrus]

Originally Posted by Ted S

Alright, that makes it way more painful to fix, sorry!

How are you with database queries? Good you say, fantastic!

Let's see how one of your review with line breaks looks in mySQL:

SELECT comments FROM pf_reviews WHERE postid = XXX (pick the post, will show all the reviews on it).

We're looking to see if we either get line breaks in the raw data or break tags added (which are getting removed).

We're slipping outside my comfort zone here - I'm not too sure what I'm doing.

So I went to PHYMYADMIN and entered that query. There's no table pf_reviews, but there is pf_review. I'm hoping that's just a typo and not an actual missing table.

Looking at pf_review I can't see anywhere there where the review is actually stored. It just has reviewid productid threadid postid userid rating comments headline fullname location ipaddress createddate approved.

I'm going to make a guess that postid is what I want in the post table? In that case, looking at the post, there's the wall of text, but no line breaks. The custom fields, at the bottom, though, are formatted with bold titles and line breaks, so that little bit works. The main body of the text is just the wall though.

Phew. That was a long way to say -- if I understand you right, no, there is no formatting in the actual database entry.

I'm pretty sure this has to be the same thing missing WYSIWYG toolbar. If we fix the toolbar, I'm willing to bet the formatting issue will fix itself too.

Also, as a data point - posting in HTML (when it's switched on) works just fine, and the formatting gets saved correctly.