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

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

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

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

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

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?

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

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

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>

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?

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

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

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?