Sub-Categories Gone and page blank!

[jonwil99]

Our site has been running OK now for over 12 months. But now when I click on one category the page nearly goes blank execpt for the header section. I have checked the tables "categories", "categories_description" and "products_to_categories" and they look OK and consistent. When I look in the admin section the category has sub-categories etc. However, the html returned after clicking on the category looks incomplete (it stops on a <table> tag). If anyone has a few clues I would REALLY appreciate it, details of site are:

www.milsims.com.au
broken category is "Roleplaying Games"
Zencart V1.2.3

Thanks heaps

[lennyg]

Hi All,

We're still having the same problem with this site. We worked around it before by splitting up the size of the category into smaller chunks.
Now the "Collectable Cards and Miniatures" section of www.milsims.com.au won't show properly.
In addition, "Miniatures & Rules -> Warhammer 40,000" doesn't show a page at all! The only difference between these 2 categories is the the Warhammer 40,000 category has a product in it. If I add a test blank product into the "Collectable cards and miniatures" category, I get the same problem as with the Warhammer category. Take the test product out, and suddenly I get the header back, but no content under it.

Any clues?

Lenny

[Ajeh]

How is your site setup?

I go to the link you give ... then it changes links on your site ...

What version Zen Cart?

Clean install or an upgrade?

If an upgrade from what version and how did you upgrade?

What happens if you switch to Classic?

What are your Session Settings?

Could you post your /includes/configure.php from your server without your username and password?

[lennyg]

The setup of Zen Cart is "as is" from the hosting provider.

I also have a test site that looks at exactly the same data (images out of date though). It can be found at www.milsims.com.au/test.

ZenCart version is 1.2.3, database patch level 1.2.2.
The install was clean - no upgrades (client is afraid to change anything! )

The test site has the classic template - and exactly the same result.

Session setup:
Session Directory /xxx/milsims.com.au/cache
Cookie Domain True
Force Cookie Use False
Check SSL Session ID False
Check User Agent False
Check IP Address False
Prevent Spider Sessions True
Recreate Session False

Configure script (from the test site, but prod site is similar)

<?php
//
//  ---------------------------------------------------------------------- 
// |Zen Cart Open Source E-commerce                                       |
//  ---------------------------------------------------------------------- 
// | Copyright (c) 2004 The Zen Cart developers                           |
// |                                                                      |
// | http://www.zen-cart.com/index.php                                    |
// |                                                                      |
// | Portions Copyright (c) 2003 osCommerce                               |
//  ---------------------------------------------------------------------- 
// | This source file is subject to version 2.0 of the GPL license,       |
// | that is bundled with this package in the file LICENSE, and is        |
// | available through the world-wide-web at the following url:           |
// | http://www.zen-cart.com/license/2_0.txt.                             |
// | If you did not receive a copy of the Zen Cart license and are unable |
// | to obtain it through the world-wide-web, please send a note to       |
// | [email protected] so we can mail you a copy immediately.          |
//  ---------------------------------------------------------------------- 
//

// Define the webserver and path parameters
  // Main webserver: eg, http://localhost - should not be empty for productive servers
  define('HTTP_SERVER', 'http://www.milsims.com.au');
  // Secure webserver: eg, https://localhost - should not be empty for productive servers
  define('HTTPS_SERVER', 'https://www.milsims.com.au');
  // secure webserver for checkout procedure?
  define('ENABLE_SSL', 'true');

// NOTE: be sure to leave the trailing '/' at the end of these lines if you make changes!
// * DIR_WS_* = Webserver directories (virtual/URL)
  // these paths are relative to top of your webspace ... (ie: under the public_html or httpdocs folder)
  define('DIR_WS_CATALOG', '/test/');
  define('DIR_WS_HTTPS_CATALOG', '/test/');

  define('DIR_WS_IMAGES', 'images/');
  define('DIR_WS_INCLUDES', 'includes/');
  define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');
  define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
  define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
  define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
  define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');
  define('DIR_WS_DOWNLOAD_PUBLIC', DIR_WS_CATALOG . 'pub/');
  define('DIR_WS_BLOCKS', DIR_WS_INCLUDES . 'blocks/');
  define('DIR_WS_TEMPLATES', DIR_WS_INCLUDES . 'templates/');

  define('DIR_WS_PHPBB', '/');

// * DIR_FS_* = Filesystem directories (local/physical)
  //the following path is a COMPLETE path to your Zen Cart files. eg: /var/www/vhost/accountname/public_html/store/
  define('DIR_FS_CATALOG', '/xxx/milsims.com.au/test/');

  define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
  define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');
  define('DIR_WS_UPLOADS', DIR_WS_IMAGES . 'uploads/');
  define('DIR_FS_UPLOADS', DIR_FS_CATALOG . DIR_WS_UPLOADS);
  define('DIR_FS_EMAIL_TEMPLATES', DIR_FS_CATALOG . 'email/');

// define our database connection
  define('DB_TYPE', 'mysql');
  define('DB_PREFIX', 'test_');
  define('DB_SERVER', 'xxxx.com.au'); // eg, localhost - should not be empty
  define('DB_SERVER_USERNAME', 'xxx');
  define('DB_SERVER_PASSWORD', 'xxx');
  define('DB_DATABASE', 'xxx');
  define('USE_PCONNECT', 'false'); // use persistent connections?
  define('STORE_SESSIONS', 'db'); // leave empty '' for default handler or set to 'db'

  // The next 2 "defines" are for SQL cache support.
  // For SQL_CACHE_METHOD, you can select from:  none, database, or file
  // If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache 
  // or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder
  // ie: /path/to/your/webspace/public_html/zen/cache   -- leave no trailing slash  
  define('SQL_CACHE_METHOD', 'file'); 
  define('DIR_FS_SQL_CACHE', '/xxx/milsims.com.au/test/cache');

?>

The strange thing is that this only started happening today. When we did the original update earlier this week, everything looked fine and dandy. No products were added in the last few days, either.

Lenny