Forums / Upgrading to 1.5.x / Upgrade missing product descriptions on Admin, not site - Fonts a bit odd

Upgrade missing product descriptions on Admin, not site - Fonts a bit odd

Started by bwtharp on 11 Apr 2012, 11:04 PM · Views: 6,350

Results 21 to 24 of 24
2 Jun 2012, 2:35 AM
#21
smcelligott avatar

smcelligott

New Zenner

Join Date:
Nov 2009
Location:
Sydney Australia
Posts:
84
Plugin Contributions:
0

Upgrade missing product descriptions on Admin, not site - Fonts a bit odd

OK one more test that may be of interest. Admittedly I have a lot of messy html in my product descriptions, so I decided to edit one of the items with a missing product description from phpMyAdmin (LOL, yes, I do realise this is not a typical editor).

I stripped of all html and started over with plain text. The only thing that remained at the php level was basically something that looked like:
text<p>text<p>text. Figured with garbage stripped, this should definitely pull up in admin . . . yet, it STILL didn't find the product description.

So it looks like missing product descriptions are the symptom, but the 'disease' is lurking elsewhere.

The ONLY way I seem able to clean this up is one product at a time. I paste in text only and then re-format using simple html code (I'm not using an html editor in this account, at the moment). After I have saved it cleanly, it pulls up consistently thereafter. Still I wish I could figure out what is causing this silliness . . .

The wayward product, not cleaned up is: http://talismanjewellery.com.au/TJOnline/necklaces/coordinates-of-the-heart if that helps . . .

Cheers, Seán

Sean M - Sydney, Australia

2 Jun 2012, 2:52 AM
#22
smcelligott avatar

smcelligott

New Zenner

Join Date:
Nov 2009
Location:
Sydney Australia
Posts:
84
Plugin Contributions:
0

Re: Upgrade missing product descriptions on Admin, not site - Fonts a bit odd

smcelligott:

. . . The wayward product, *not *cleaned up

Should read, the wayward product ***NOW ***cleaned up

Sorry for the confusion.

Sean M - Sydney, Australia

2 Jun 2012, 5:31 AM
#23
smcelligott avatar

smcelligott

New Zenner

Join Date:
Nov 2009
Location:
Sydney Australia
Posts:
84
Plugin Contributions:
0

Re: Upgrade missing product descriptions on Admin, not site - Fonts a bit odd

Figured out a solution, but the biggest issue is that the problem is hard to "see."

I looked at a product description in phpMyAdmin, and other than some excessive html all appeared fine.

Then I discovered that the preview icon (next to left of the product name in an admin product listing) still shows data even when you see none in edit mode.

There I discovered some hidden characters. I think it may have to do with single quotes which I apparently use too often in product descriptions (You know how there are smart quotes vs. standard uniform ones? Not important but most word processors make a start quote different than an end quote - exactly the same keystroke but the stored characters are not the same). In any event, EVERY record that I found that had problems with display turns out to have some now-unrecognised character.

The fix fortunately doesn't involve data base edits (as I had experimented with). First, I go in to preview and copy the text, and then I paste it in the (empty) product description box in edit mode, being careful to backspace over the hidden characters, and then re-entering new spaces. It is tedious, but can't figure out another work-around.

If you have any other solutions . . .

Sean M - Sydney, Australia

2 Jun 2012, 3:37 PM
#24
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,511
Plugin Contributions:
176

Re: Upgrade missing product descriptions on Admin, not site - Fonts a bit odd

Right. Your "smart quotes" are extended characters. They are not normal characters in the usual character set. And that is preventing the from being displayed properly in your Admin area when going into edit mode. If you save the empty description from that screen you will of course save the empty description.

NOTE: It is ALWAYS A BAD IDEA to use word processing programs like MS Word (or anything by Microsoft) when editing web pages or when preparing content to put onto web pages.

You can try cleaning up the data by using "Paste Special" from your editor's menu and choosing something like Plain Text instead.
Or maybe even in CKEditor use the "Paste From Word" option in hopes that it will strip out some of the plethora of crap that Word injects into your content.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.