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 1 to 20 of 24
11 Apr 2012, 11:04 PM
#1
bwtharp avatar

bwtharp

New Zenner

Join Date:
Nov 2009
Location:
Mountain Maryland
Posts:
10
Plugin Contributions:
0

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

I up graded a site from 1.38h to 1.50 using the approved instructions provided by Zen Cart. I thought all went well. The customer is discovering problems. I've included examples as I can. (we'll skip his irriation about the login timeout <G>) Worst case - I do have a backup!

ISSUE #1)
the site is http://cart.valleyrailroadmodeltrains.com

If you look at some pages you will notice odd fonts appearing.
(See this page: http://cart.valleyrailroadmodeltrains.com//index.php?main_page=product_info&cPath=170&products_id=2213


Those codes were not there prior to the upgrade.

ISSUE #2)
You can see the description on line in the about mentioned item. Now if you pull up that item in the admin pages this is what you see:

Notice the description in blank.

Any help would be appreciated.

12 Apr 2012, 10:27 AM
#2
stevesh avatar

stevesh

Black Belt

Join Date:
Feb 2005
Location:
Lansing, Michigan USA
Posts:
19,793
Plugin Contributions:
2

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

#1 is the result of pasting the copy in question into Zencart from a WYSIWYG editor, along with all the styling that editor adds, including this: <font size="4">.

Better to use the CKE editor mod or (my choice) insert the copy as text and style it in the stylesheet.

12 Apr 2012, 12:23 PM
#3
bwtharp avatar

bwtharp

New Zenner

Join Date:
Nov 2009
Location:
Mountain Maryland
Posts:
10
Plugin Contributions:
0

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

#1 I found the answer to. It involved changing the language type in the \admin\language\english.php file to "latin1".

#2 is still an issue. I'm using the new CKeditor v3.6x and still have the problem.

12 Apr 2012, 2:36 PM
#4
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,139
Plugin Contributions:
56

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

bwtharp:

#2 is still an issue. I'm using the new CKeditor v3.6x and still have the problem.

Look in your /cache directory. I'm betting that you have a bunch of admin log files that indicate PHP failures due to the change from utf8 to latin1, possibly from the htmlentities function.

12 Apr 2012, 10:44 PM
#5
bwtharp avatar

bwtharp

New Zenner

Join Date:
Nov 2009
Location:
Mountain Maryland
Posts:
10
Plugin Contributions:
0

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

Yes, but it's absolutely useless to me; (Translated => I'm not sure how to fix it!) Obviously I've got something set wrong somewhere but I'm not understanding the fix.

[12-Apr-2012 05:38:38] PHP Warning: htmlspecialchars() [<a href='function.htmlspecialchars'>function.htmlspecialchars</a>]: Invalid multibyte sequence in argument in /xxxxx/xxxxx/includes/modules/product/collect_info.php on line 401

[12-Apr-2012 05:37:45] PHP Warning: htmlspecialchars() [<a href='function.htmlspecialchars'>function.htmlspecialchars</a>]: Invalid multibyte sequence in argument in /xxxx/xxxxx/includes/modules/product/collect_info.php on line 401

13 Apr 2012, 3:57 PM
#6
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,139
Plugin Contributions:
56

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

It looks like you got it sorted out ... how did you do it?

13 Apr 2012, 6:09 PM
#7
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

Almost certainly the problem is caused by changing characters sets incorrectly.
https://www.zen-cart.com/tutorials/index.php?article=414

.
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.

14 Apr 2012, 4:12 AM
#8
bwtharp avatar

bwtharp

New Zenner

Join Date:
Nov 2009
Location:
Mountain Maryland
Posts:
10
Plugin Contributions:
0

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

It's not at all fixed. Still working on it.

14 Apr 2012, 4:15 AM
#9
bwtharp avatar

bwtharp

New Zenner

Join Date:
Nov 2009
Location:
Mountain Maryland
Posts:
10
Plugin Contributions:
0

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

I did a authorized install from a new download of 1.5 per the instructions including choosing "upgrade" when converting the database. I have no reference to "DB_CHARSET in my configure.php file, just the language.php file.

14 Apr 2012, 4:23 AM
#10
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

I'm not going to sit and argue with you, but I will state emphatically that a clean NEW installation will indeed set DB_CHARSET in the configure.php files.
If you copy another file overtop of it, then of course the rest of the content will be replaced with whatever you overwrite it with.
Doing an upgrade will NOT replace the configure.php files: it only reads them. So if you're doing an upgrade and not a new install, then the files will NOT include the DB_CHARSET line.

Either way, if the DB_CHARSET is missing from your configure.php files, then if you want to use a different character set than the default, you'll need to put it there yourself.

.
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.

10 May 2012, 12:44 PM
#11
delia avatar

delia

Totally Zenned

Join Date:
May 2006
Location:
Gardiner, Maine
Posts:
2,383
Plugin Contributions:
7

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

Don't forget to change both admin and catalog configure files and both admin and catalog english.php files. May sound dumb to have to remind folks of that but I finally realized that I had an admin english file to edit too. Maybe I'm just slow this morning......

Thanks Dr. Byte, again!

The full-time Zen Cart Guru. WizTech4ZC.com
New template for 2.0 viewable here: 2.0 Demo

10 May 2012, 7:49 PM
#12
delia avatar

delia

Totally Zenned

Join Date:
May 2006
Location:
Gardiner, Maine
Posts:
2,383
Plugin Contributions:
7

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

after I made the changes, I check the site and everything was okay. Now it's down for maintenance and changing the setting in admin does not affect that. Any ideas?

The database setting does say false.

The full-time Zen Cart Guru. WizTech4ZC.com
New template for 2.0 viewable here: 2.0 Demo

11 May 2012, 1:35 AM
#13
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

That sounds like it's pointing to the wrong database. ie: your DB_XXXXX settings in your admin configure.php have different settings than your non-admin configure.php

.
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.

15 May 2012, 1:19 PM
#14
delia avatar

delia

Totally Zenned

Join Date:
May 2006
Location:
Gardiner, Maine
Posts:
2,383
Plugin Contributions:
7

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

I was actually on the road when I posted the other day and have finally gotten time to report back.. I have to praise you and shamefacedly admit that the problem was exactly that, though I had figured it out by the time you posted. Thanks once again!

The full-time Zen Cart Guru. WizTech4ZC.com
New template for 2.0 viewable here: 2.0 Demo

1 Jun 2012, 7:56 AM
#15
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

I too am having the problem with disappearing product descriptions. Perhaps I have a few more clues. When I copy the html product description from the current product (source code is easiest), I can then paste that into the source code view of CK Editor, and save any changes. Once text is "manually" restored and saved, I can go back in to THIS record and the description is there. I can edit and save without problem. If I go in to a product where there is no product description displaying, and change something unrelated to the description - e.g. sort order - it saves this blank description and my description is lost.

It is as if the catalog display "sees" the description but the admin edit can't find it . . . let me check something that might have triggered some a revelation . . . .

Back soon! Cheers, Seán

Sean M - Sydney, Australia

1 Jun 2012, 8:33 AM
#16
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. Those are the same symptoms these other folks are talking about.
And it's caused by mismatched character sets, as described earlier. And/or the use of an older PHP version not compatible with the version of Zen Cart being used.

.
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.

1 Jun 2012, 8:52 AM
#17
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

OK, a bit of sleuthing, and this might help pointing someone in the right direction.

I just fixed another issue where my products couldn't be activated or de-activated in Admin. The fix for which ( had something to do with products that were linked to more than one category. So super sleuth that I am (and that is a joke) I looked at some different products that had links to more than one category. NONE of those multi-category products that I looked at, had product descriptions showing up in the edit product mode.

On the other hand, several of the single category products, did have product descriptions intact - unfortunately not ALL single category products had descriptions, because that would make this far too easy ;)

STRIKE THAT . . . ARRRRGH! Some multi-category products do actually have product descriptions, but I still think this MIGHT somehow be part of the issue. I looked at a bunch of multi-category products in our category "necklaces" and they had no product descriptions. However I went to the multi-category products in "pearls" and almost all had descriptions. While I then went back to necklaces and was able to find a pearl necklace that had product description (an exception in that category?), the disappearing product descriptions SEEM to be more likely in some categories than in others.

Is this making any sense at all?

I did try to look at categories in their primary categories versus their linked categories, but couldn't find a consistent rule there either.

I feel strangely drawn to "admin/includes/modules" but not sure where to go once I get there. LOL. Does anyone have a Ouija board?

Many thanks for those of you than managed to read this and have it makes sense . . . Cheers, Seán

Sean M - Sydney, Australia

1 Jun 2012, 5:41 PM
#18
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

Got any examples of specific products we can view on your storefront which exhibit these problems during your admin viewing?
And, please click Reply below and answer all the questions in the Posting Tips section.

.
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.

2 Jun 2012, 1:14 AM
#19
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

Dr B,

OK I no longer see ANY patterns . . . when I really sought out items with descriptions and items without descriptions, I found that they were scattered, and perhaps there is actually no correlation between single/multi-category and missing descriptions. Nevertheless, since I collected this information I've included examples of each with/without descrition and with single vs. multi-category items.

Perhaps you can see something that I am missing?

Single Category, WITH description
http://talismanjewellery.com.au/TJOnline/necklaces/braveheart
http://talismanjewellery.com.au/TJOnline/necklaces/fleur-de-lis-necklace

Single Category, missing description
http://talismanjewellery.com.au/TJOnline/necklaces/glacier-necklace
http://talismanjewellery.com.au/TJOnline/necklaces/amazonite-boho-necklace

Multi-Category, WITH description
http://talismanjewellery.com.au/TJOnline/necklaces/chunky-pearl-necklace
http://talismanjewellery.com.au/TJOnline/necklaces/organic-pendant-rings

Multi-Category, missing description
http://talismanjewellery.com.au/TJOnline/necklaces/peace-baby
http://talismanjewellery.com.au/TJOnline/necklaces/whisper-pearls

Hope this helps others, as this is a real brain cell killer for me. I look forward to your insights Dr B!

Cheers, Seán

Sean M - Sydney, Australia

2 Jun 2012, 1:59 AM
#20
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

I'm seeing this same issue appear on multiple threads, and just came across one suggesting that this could be a browser rather than a ZC issue, so attempted to look at these product description in Firefox and then IE9. This made no difference. The items that had missing descriptions in Chrome also had missing descriptions in Firefox and IE9 - same for those WITH product descriptions - consistent across browsers. I'll keep working on this . . .

Sean M - Sydney, Australia