'There are no products to list in this category' showing, but there are!

[jacdesigner]

One of my older Zen clients is experiencing this same issue. They have an older version store (1.2.7) which had started breaking after they moved hosting a couple of times. In their case I am starting by backing up the database and running repairs, to see if there are any instances of data issues there that might be remedied.

If anyone has additional advice on what files to look at, I would appreciate it. In this site's case, all of the categories seem to be displaying the "no products to list" message, although there are products in the database for these categories. The featured and special products still display and you can arrive at those products pages in that way only.

If I have any progress I will post info here. We have been hired to try and help them fix their current site but if I cannot do so soon I may just recommend a rebuild in 1.3...

[kuroi]

We have been hired to try and help them fix their current site but if I cannot do so soon I may just recommend a rebuild in 1.3...

I would suggest that this should be your first recommendation rather than your fallback.

It's a bit of a wild punt, but i suspect that your client has caught up with a hosting company running PHP5 (as all good hosts should be, given that the last PHP release with 17 months ago and all support for it was withdrawn at the end of 2008).

Zen Cart 1.2.7 is even older (July 2007) as is not compatible with PHP5. So even if you manage to fix the specific problems, you're on a very slippery downward slope with problems likely to manifest themselves in very difficult to predict ways.

[jacdesigner]

Thank you, Kuroi,

That is a good point. Their server does have both PHP5 and mysql5.

I am definitely recommending a rebuild of this site in the new version in my report, but for now I just have to do my best to repair what I can. So far I have successfully restored their Admin features and cleaned up their database. I am also running some patches which might help some.

[kuroi]

You may find this a helpful source of specific things to look out for >> http://uk3.php.net/manual/en/migrati...compatible.php.

If they're using PHP5.3 then you have a bigger problem still, and will need to take a look at the Zen Cart patch for dealing with that.

Best of luck.