1.3.9h - customers don't display on home page, and prod name/model don't show in edit

NOTE: SOLUTION POSTED HERE: http://www.zen-cart.com/forum/showpo...64&postcount=6


I had a working 1.3.9g setup.

I have just upgraded to 1.3.9h by replacing just the files listed in the changelog.

Now, if I log into admin and attempt to edit a product, I find that its Product Name, Product Description and Products Model fields are blank.

The same applies if I create a new product and then edit it.

The Product Name and Product Model are correctly shown in the list of products for any category and all information is correctly shown within the normal customer view of products.

Regards

Nick Greaves

OK, I have replaced the following 1.3.9h file:

/admin/includes/modules/product/collect_info.php

with the previous version from 1.3.9g.

This has restored normal operation.

So it looks as though there is some issue around that particular file.

Regards

Nick

I've since noticed that when you go from creating or editing a product to the preview screen, the Product Name is missing from that screen.

I've tried replacing:

/admin/includes/modules/product/preview_info.php

with the 1.3.9g version, but that just results in both the Product Name and Product Description not appearing.

Regards

Nick Greaves

None of those things happen here with a fresh installation of 1.3.9h or with an installation of 1.3.9g upgraded to 1.3.9h (both stock with no mods installed).

Quote:

---

Originally Posted by stevesh

None of those things happen here with a fresh installation of 1.3.9h or with an installation of 1.3.9g upgraded to 1.3.9h (both stock with no mods installed).

---

Hmm. I wonder what's different about our setups?

I have:

Renamed /admin
Edited english.php to use UK date formats and "kg" instead of "lbs"

Apart from creating custom templates in the usual way, I haven't done much else.

Addons in use are:

Ceon Manual Card
Easy Populate
Contact reCAPTCHA

As far as I can see, none of those should have any relevance or involvement in this area of operation.

All of the above mods/addons were done a few versions ago so have worked fine up to and including version g.

Regards

Nick

Quote:

---

if I log into admin and attempt to edit a product, I find that its Product Name, Product Description and Products Model fields are blank.

---

As this is in the admin - - - I suspect that you missed something in the upgrade????

I've just upgraded to 139h on windows and linux servers, and have a lot of mods. Its working ok for me.

Quote:

---

Originally Posted by kobra

As this is in the admin - - - I suspect that you missed something in the upgrade????

---

Well I've been through all of the changed files in the /admin tree again and checked that they were all replaced.

Regards

Nick

No problems with my upgrade from g to h either :cool:

Quote:

---

Well I've been through all of the changed files in the /admin tree again and checked that they were all replaced.

---

Unless you have altered an admin core file....
Try deleting all the files in the admin directory and reloading a new set from the 1.3.9h distribution

Quote:

---

Originally Posted by kobra

Try deleting all the files in the admin directory and reloading a new set from the 1.3.9h distribution

---

I'll do that as a last resort if I have to, but I wonder if whoever carried out the mods to:

/admin/includes/modules/product/collect_info.php

might be able to give me a clue as to what has changed between versions g and h (I could do a file compare but, to be honest, my PHP knowledge is very limited so if anyone can point me in the right direction I could try a few individual file replacements first).

Regards

Nick

Quote:

---

so if anyone can point me in the right direction I could try a few individual file replacements first

---

replacing/crossing version files is playing with dynamite

As many have posted they are not seeing what you are
So a full reload of the admin side is a better solution

Quote:

---

Originally Posted by nickgreaves

I'll do that as a last resort if I have to, but I wonder if whoever carried out the mods to:

/admin/includes/modules/product/collect_info.php

might be able to give me a clue as to what has changed between versions g and h (I could do a file compare but, to be honest, my PHP knowledge is very limited so if anyone can point me in the right direction I could try a few individual file replacements first).

Regards

Nick

---

Lines 299, 412, 433 were changed.
Granted, those line numbers refer to an UNMODIFIED version of the file.
Quickly comparing those files in WinMerge will show you what has changed.

Quote:

---

Originally Posted by kobra

replacing/crossing version files is playing with dynamite

---

Perhaps I'm not explaining very well.

As of this morning, I had a fully patched up-to-date version of 1.3.9g.

I then replaced all of the files listed in the changelog so I had a fully patched up-to-date version of 1.3.9h. At that stage I experienced the problems described.

As an experiment, I rolled back one single file to the 1.3.9g version and this partially resolved the problem, providing me with a temporary workaround.

If I can identify what has changed between versions of that file - particularly in terms of its dependency on the contents of other files, that might point me to where the problem lies.

Quote:

---

Originally Posted by nickgreaves

If I can identify what has changed between versions of that file - particularly in terms of its dependency on the contents of other files, that might point me to where the problem lies.

---

Quote:

---

Originally Posted by stevesh

None of those things happen here with a fresh installation of 1.3.9h or with an installation of 1.3.9g upgraded to 1.3.9h

---

Quote:

---

Originally Posted by frank18

No problems with my upgrade from g to h either

---

With all of the time you have invested so far, you could have reloaded all the admin files

I am upgrading 9g to 9h right now and before overwriting includes/version.php I notice the new file in 9H is older than 9g by about 5 hours....is this right?

Quote:

---

Originally Posted by polygone

I am upgrading 9g to 9h right now and before overwriting includes/version.php I notice the new file in 9H is older than 9g by about 5 hours....is this right?

---

a) no, it doesn't matter.
b) that's completely different than the subject matter of the rest of the discussion in this thread -- please try not to hijack other peoples' discussions, since it just adds confusion to the existing dialog. :wink:

Quote:

---

Originally Posted by DrByte

a) no, it doesn't matter.
b) that's completely different than the subject matter of the rest of the discussion in this thread

---

So I should have posted a new thread with the same title? Sorry..next time I'll know better.

Quote:

---

Originally Posted by kobra

With all of the time you have invested so far, you could have reloaded all the admin files

---

OK, I have now reloaded ALL of the files in the shop root directory and the (renamed) /admin directory tree.

The problem remains the same.

I even replaced /admin/includes/languages/english.php with the original unedited version to be absolutely sure.

So the only modified file in the whole directory tree was admin/includes/configure.php (which obviously has to be modified with the correct directory/database settings).

Regards

Nick

nickgreaves,
PHP version?

Quote:

---

Originally Posted by DrByte

nickgreaves,
PHP version?

---

PHP Version: 5.2.1 (Zend: 2.2.0)

In case it's useful/relevant:

MySQL 5.0.22-Debian_0ubuntu6.06.3
Server OS: Linux server33.interdns.co.uk 2.6.15-55-server
Database Patch Level: 1.3.9a

Regards

Nick

OK, some additional information:

As replacing all of the files within the /admin directory tree with those from the 1.3.9h installation set didn't work, I replaced ALL files in all directories. That means that apart from a few additional files for custom templates (created as custom includes in the usual way) plus the files for the three addons already meantioned, everything was exactly as per the distribution set.

Symptoms were still as described initially. I've since found a couple of extra problems:

1. On the admin home page, under "New Customers" only the dates are shown. The customer names are missing.

2. On orders, all of the address information is missing.

For the time being I've rolled back to a working 1.3.9g installation and all of the information which was missing in 1.3.9h is show correctly in 1.3.9g (including a couple of new customer accounts and a couple of new orders from today - since the upgrade). So the information is obviously still being recorded in the database OK it's just failing to appear on several pages for some reason.

I have retained the 1.3.9h installation in a separate folder on the server so that by renaming two directories I can easily swap between the working 1.3.9g and problematic 1.3.9h installations. So if there's any further investigation I can do, please let me know.

Regards

Nick

Quote:

---

So if there's any further investigation I can do, please let me know.

---

As I and others have not experienced your issue and can not replicate it, there is little advice we can offer....

Quote:

---

Originally Posted by kobra

As I and others have not experienced your issue and can not replicate it, there is little advice we can offer....

---

Since the problems are all to do with the rendering of (or, rather, failure to render) information that we know is present in the SQL table, it seems likely that there is a common cause.

I realise no-one else has reproduced it so far, though there have been a couple of similar reports today such as:

http://www.zen-cart.com/forum/showthread.php?t=166962

http://www.zen-cart.com/forum/showthread.php?t=166972
(oddly, this is with an upgrade to 1.3.9g rather than h)


Regards

Nick

Quote:

---

Now, if I log into admin and attempt to edit a product, I find that its Product Name, Product Description and Products Model fields are blank.

I realise no-one else has reproduced it so far, though there have been a couple of similar reports today such as:

---

One is a partially blank screen, the other fully different than yours
So I suspect not similar at all

Quote:

---

Originally Posted by kobra

One is a partially blank screen, the other fully different than yours
So I suspect not similar at all

---

The missing names under "New Customers" on the main admin screen and the missing addresses from orders are part of the problem I am seeing (as I reported a few messages back).

The point, though, is this:

I upgraded from a fully patched 1.3.9g (with minimal mods) to 1.3.9h, adding and replacing updated files as per the changelog. It didn't work correctly.

Now you'll just have to take my word that I'm not imagining that or making it up. So clearly there is a problem.

The initial suggestion was that perhaps I'd missed a file so at the suggestion of folks here I've replaced ALL of the files from the installation archive, just to be sure. The problems are the same.

So the likely explanations are:

1. A compatibility issue with the server which was not there in 1.3.9g (PHP version, OS, etc).

2. A compatibility issue with the underlying SQL database which was not there in 1.3.9g.

3. A file permissions problem (though I've been through most of the directories and most are 644 except the config ones).

4. Aliens.

Whilst I appreciate that I may currently be the only person with this problem it is, nonetheless, a problem and it therefore has a cause. That is what I am trying to diagnose.

Regards

Nick

I upgraded today from 1.3.9g to 1.3.9h, and I am experiencing the exact same problems as Nick Greaves.

If you display that admin page in your browser, where those customer or product details apparently don't "show", and then choose View Source in your browser, do those details show up in the raw HTML?

Also what CHARSET are you using in your english.php file?
What Character Set and/or collation is your database using?

I have the same issue as the OP. Product name, description are blank . Also , my New Customers section, the name is blank but I do see the date.

PHP version is 4.4.9

Can you answer all the questions I just asked above?

Quote:

---

Originally Posted by DrByte

If you display that admin page in your browser, where those customer or product details apparently don't "show", and then choose View Source in your browser, do those details show up in the raw HTML?

Also what CHARSET are you using in your english.php file?
What Character Set and/or collation is your database using?

---

I've already gone back to 1.3.9g (and the problems are solved), so I can't tell you whether customer & product details show up in View Source.

In my english.php files, CHARSET is iso-8859-1.

MySQL charset: UTF-8 Unicode (utf8)
MySQL connection collation: utf8_unicode_ci

Quote:

---

Originally Posted by DrByte

If you display that admin page in your browser, where those customer or product details apparently don't "show", and then choose View Source in your browser, do those details show up in the raw HTML?

Also what CHARSET are you using in your english.php file?
What Character Set and/or collation is your database using?

---

Responses:
View Source --> I only see the dates in raw HTML, no names

Char set in english.php --> iso-8859-1 (only thing I see that mentioned char set)

Char set for db --> utf-8

Quote:

---

Originally Posted by DrByte

If you display that admin page in your browser, where those customer or product details apparently don't "show", and then choose View Source in your browser, do those details show up in the raw HTML?

---

This is the source for the "New Customers" section:

<div class="header">New customers: </div>
<div class="row"><span class="left"><a href="http://www.donallnagealai.ie/shop/admin/customers.php?search=&origin=index" class="contentlink"> </a></span><span class="rigth">
28/10/2010 </span></div>
<div class="row"><span class="left"><a href="http://www.donallnagealai.ie/shop/admin/customers.php?search=&origin=index" class="contentlink"> </a></span><span class="rigth">
28/10/2010 </span></div>
<div class="row"><span class="left"><a href="http://www.donallnagealai.ie/shop/admin/customers.php?search=&origin=index" class="contentlink"> </a></span><span class="rigth">
26/10/2010 </span></div>
<div class="row"><span class="left"><a href="http://www.donallnagealai.ie/shop/admin/customers.php?search=&origin=index" class="contentlink"> </a></span><span class="rigth">
26/10/2010 </span></div>
<div class="row"><span class="left"><a href="http://www.donallnagealai.ie/shop/admin/customers.php?search=&origin=index" class="contentlink"> </a></span><span class="rigth">
23/10/2010 </span></div>
</div>

(I have actually renamed the "admin" directory but have edited the urls here for clarity)

So, no, the customer details don't appear in the source.

Here's a short extract from the corresponding source for the same page in version 1.3.9g:

<div class="row"><span class="left"><a href="http://www.donallnagealai.ie/shop/admin/customers.php?search=Deane&origin=index" class="contentlink">Michael Deane</a></span><span class="rigth">
28/10/2010 </span></div>

Quote:

---

Also what CHARSET are you using in your english.php file?
What Character Set and/or collation is your database using?

---

For english.php I have:

// charset for web pages and emails
define('CHARSET', 'iso-8859-1');

On the "Version" info page I have:

HTTP_ACCEPT_CHARSET ISO-8859-1,utf-8;q=0.7,*;q=0.7

Is that what you're looking for?

In both cases it's unchanged from the default and is the same as I used in all the previous versions of Zen Cart up to 1.3.9g.

Regards

Nick

Curious to know whether your database tables are UTF8 or latin1

Is there something else you'd like for me to check?

Quote:

---

Originally Posted by DrByte

Curious to know whether your database tables are UTF8 or latin1

---

Mine are UTF-8.

Regards

Nick

In post #21 nickgreaves posted "Database Patch Level: 1.3.9a".
Could that have anything to do with his problem, as his database isn't 1.3.9g, while he's trying to upgrade from 'g' to 'h'?
I mean, if he had a "working 1.3.9g", shouldn't the database reflect that?
Just a question..................

I too have upgraded from 1.3.9g to 1.3.9h and am experiencing the same problem. Original installation was 1.3.9b but I have upgraded religiously since then.

I have added new products and their descriptions as normal, but the description field disappears if I go back and have to edit something.

I have retraced my steps twice now but still the same problem. I noticed the problem occured before I added any of the new files, so assume it was one of the pages that was overwritten.

Server details are as follows:

PHP 5
Charset from english.php: iso-8859-1
SQL Charset: utf8 utf8_general_ci UTF-8 Unicode 3
SQL 5

Hope this helps. If anything isn't clear please ask and I shall clarify.

Thanks

Quote:

---

Originally Posted by Get Em Fast

In post #21 nickgreaves posted "Database Patch Level: 1.3.9a".
Could that have anything to do with his problem, as his database isn't 1.3.9g, while he's trying to upgrade from 'g' to 'h'?
I mean, if he had a "working 1.3.9g", shouldn't the database reflect that?
Just a question..................

---

I don't think there have been any changes to the database structure since 1.3.9a. Certainly it was working fine with 1.3.9g so unless there has been a change between g and h (which isn't mentioned in the release notes), I doubt if this is the issue.

Regards

Nick

Quote:

---

Originally Posted by nickgreaves

I don't think there have been any changes to the database structure since 1.3.9a. Certainly it was working fine with 1.3.9g so unless there has been a change between g and h (which isn't mentioned in the release notes), I doubt if this is the issue.

Regards

Nick

---

Yea, I know the docs say that there has been no database changes since "a", but I was thinking maybe something in the files just disagreed with "a". But, I know you're right.......I'm thinking that too, but I've seen stranger things happen, ya know?

Like I say though, it was just a question.......I already knew the answer before I posted, but curiosity made me post it anyway........haha.....that killed the cat, didn't it?

Anyone find a solution other than reverting back to 1.3.9g?

Quote:

---

Originally Posted by Get Em Fast

In post #21 nickgreaves posted "Database Patch Level: 1.3.9a".
Could that have anything to do with his problem, as his database isn't 1.3.9g, while he's trying to upgrade from 'g' to 'h'?
I mean, if he had a "working 1.3.9g", shouldn't the database reflect that?
Just a question..................

---

Quote:

---

Originally Posted by nickgreaves

I don't think there have been any changes to the database structure since 1.3.9a. Certainly it was working fine with 1.3.9g so unless there has been a change between g and h (which isn't mentioned in the release notes), I doubt if this is the issue.

Regards

Nick

---

Quote:

---

Originally Posted by Get Em Fast

Yea, I know the docs say that there has been no database changes since "a", but I was thinking maybe something in the files just disagreed with "a". But, I know you're right.......I'm thinking that too, but I've seen stranger things happen, ya know?

Like I say though, it was just a question.......I already knew the answer before I posted, but curiosity made me post it anyway........haha.....that killed the cat, didn't it?

---

There is no change to the database revision level between 1.3.9 releases. As far as database revision goes, the letter simply indicates which version was used when first upgrading to 1.3.9xx.

As such, as suggested, it's *not* a related factor.

Yea.......didn't really think so, but wanted to clarify. Thanks, Doc.

Got the same problem as the OP, can't see my new customers

This is an odd issue. Did anyone try to compare the files between the 2 versions that are related to the links affected???

Maybe turning on the error logging might record log an error.

I incurred this problem as well:

Quote:

---

Now, if I log into admin and attempt to edit a product, I find that its Product Name, Product Description and Products Model fields are blank.

---

I first incurred it when I tested out a download with 1.3.9g using Easy Populate Advanced 3.0.3, for the Music Product Type. I assumed it was related to the Music Product Type, as I believe I had success downloading the General Product Type, as far as continuing to see the product name and description in the Admin-editable product screen.

But after upgrading to 1.3.9h, I now do not see my products in the Admin-editable product screen for the general product type, either.

I was beginning to think I had just not noticed before that the general type product was blank, but since viewing this message, I believe I had indeed checked that and it was working for the general product type.

I hope this information is a clue for solving this problem, if someone knowledgeable can make some sense of it. I will be forced to return to 1.2.5.4 Easy Populate to avoid this, but I can see that Easy Populate Advanced 3.0.3 is a really strong program that could be a great assist, as helpful for 2nd language sites as 1.2.5.4, if 3.0.3 didn't have this glitch; and since this problem has not come up in any of the 3.0.3 discussions, maybe it was new for the music product type in as of one of the 1.3.9 updates. I didn't start using 3.0.3 until version g.

Notageek

Related posts:

See my post: http://www.zen-cart.com/forum/showth...otageek&page=2.

A version of this problem seems occurring as described in my Post #73, here, http://www.zen-cart.com/forum/showth...otageek&page=8. See Paragraph 3 of Post #73 where it describes that I had blank descriptions in the Admin-editable product screen, but the descriptions show in the cart.

I hope this information sheds some light on this blank Admin product screen problem.

Notageek

Quote:

---

Originally Posted by nickgreaves

Now, if I log into admin and attempt to edit a product, I find that its Product Name, Product Description and Products Model fields are blank.

The same applies if I create a new product and then edit it.

The Product Name and Product Model are correctly shown in the list of products for any category and all information is correctly shown within the normal customer view of products.

---

Quote:

---

Originally Posted by nickgreaves

OK, some additional information:

1. On the admin home page, under "New Customers" only the dates are shown. The customer names are missing.

2. On orders, all of the address information is missing.

---

Okay, this appears to be a PHP version conflict. Older versions of PHP are croaking on the use of a parameter added only in newer versions.
Stay tuned for a patch ...

Update:
NOTE: SOLUTION POSTED HERE: http://www.zen-cart.com/forum/showpo...64&postcount=6

Quote:

---

Originally Posted by notageek

I first incurred it when I tested out a download with 1.3.9g using Easy Populate Advanced 3.0.3, for the Music Product Type. I assumed it was related to the Music Product Type, as I believe I had success downloading the General Product Type, as far as continuing to see the product name and description in the Admin-editable product screen.

---

I don't see how this thread's main issue has anything to do with EasyPopulate.

Reply accepted as "same symptom, different circumstances - module involved."

In case it eventually would appear relevant, my host's php version is 5.1.6 although 5.2.13 is offered on another server, FYI.

Quote:

---

Originally Posted by DrByte

Okay, this appears to be a PHP version conflict. Older versions of PHP are croaking on the use of a parameter added only in newer versions.
Stay tuned for a patch ...

---

What PHP version(s) will 1.3.9h work with as is? Looks like the latest in general use are 5.2.14 and 5.3.3.

Should I be asking my ISP to upgrade the version on their server?

Regards

Nick

I have no problems with anything in v1.3.9h when using PHP 5.2.12 or newer versions.
That includes ALL the symptoms discussed in the previous 50 posts of this thread. ie: more specifically, I DO NOT HAVE any of those symptoms when using PHP 5.2.12 or newer (including up to 5.3.3).

However, I've confirmed that PHP 4.4 does indeed dislike these changes made in 1.3.9h.
We're working on an update that will fix that incompatibility.

Quote:

---

Originally Posted by DrByte

I have no problems with anything in v1.3.9h when using PHP 5.2.12 or newer versions.

---

The server I'm using is currently running 5.2.1.

I've asked my ISP if they can upgrade the version though if you're working on a patch anyway I guess that's not urgent.

Regards

Nick

Not to be irrelevant, but in case it helps, this discussion prompted me to check to see whether my cart was showing the correction to the category name and description after a re-upload. The actual customer view of the cart shows the correction.

However, my Admin-editable product screen still shows the prior errors in the Spanish name and description, which shows me that at one time I was able to upload with EP 3.0.3 in the general product type, and see the upload in the Admin-editable product screen. Since upgrading to 1.3.9h, that Admin-editable product screen is actually being bypassed.

So, I would suppose that php ver. 5.1.6 is not operating in this respect with 1.3.9h, because the upgrade is the difference in the two uploads bringing about this occurrence.

It would be interesting to see if the patch will also affect the operation of Easy Populate 3.0.3 in this respect.

The display problem in the admin is just that: a display problem. The display problem doesn't care how the data was put there initially, whether EP or typed by hand. It's just not displaying it because it's running into a PHP error.

If you're having problems with EP, they should be discussed in the EP support threads.

Quote:

---

Originally Posted by DrByte

Quote:

---

Originally Posted by nickgreaves

Now, if I log into admin and attempt to edit a product, I find that its Product Name, Product Description and Products Model fields are blank.

The same applies if I create a new product and then edit it.

The Product Name and Product Model are correctly shown in the list of products for any category and all information is correctly shown within the normal customer view of products.

---

Quote:

---

Originally Posted by nickgreaves

OK, some additional information:

1. On the admin home page, under "New Customers" only the dates are shown. The customer names are missing.

2. On orders, all of the address information is missing.

---

Okay, this appears to be a PHP version conflict. Older versions of PHP are croaking on the use of a parameter added only in newer versions.
Stay tuned for a patch ...

---

Solution posted here: http://www.zen-cart.com/forum/showpo...64&postcount=6

Quote:

---

Originally Posted by DrByte

Solution posted here: http://www.zen-cart.com/forum/showpo...64&postcount=6

---

First file patched, second replaced with 1.3.9g version.

Working fine (PHP 5.2.1).

Have also asked ISP to install latest PHP version so will revert the two files to the standard 1.3.9h versions then and test again.

Regards

Nick

PS: Thanks very much.