Using one single listing template

[rooisnor]

You should use classic, by default the classic folder is used for overriding purpose.

Thanks yellow, I'm in the process of coping the template file to the classic folder. I'll override those template files and report back.

[rooisnor]

Yellow, just to make sure... I changed and move these following folders also to /classic/

includes/modules/template_default ... and rename this to includes/modules/classic/

If I did that all the pages works great except for New Products which still shows the same error... I'm getting closer!

[yellow1912]

Yellow, just to make sure... I changed and move these following folders also to /classic/

includes/modules/template_default ... and rename this to includes/modules/classic/

If I did that all the pages works great except for New Products which still shows the same error... I'm getting closer!

If new product shows the sql error, first post that page header_php.php here

[rooisnor]

<?php
/**
 * products_new header_php.php
 *
 * @package page
 * @copyright Copyright 2003-2007 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: header_php.php 6912 2007-09-02 02:23:45Z drbyte $
 */

  require(DIR_WS_MODULES . zen_get_module_directory('require_languages.php'));
  $breadcrumb->add(NAVBAR_TITLE);
// display order dropdown
  $disp_order_default = PRODUCT_NEW_LIST_SORT_DEFAULT;
  require(DIR_WS_MODULES . zen_get_module_directory(FILENAME_LISTING_DISPLAY_ORDER));
  $products_new_array = array();
// display limits
//  $display_limit = zen_get_products_new_timelimit();
  $display_limit = zen_get_new_date_range();

  $listing_sql = "SELECT p.products_id, p.products_type, pd.products_name, p.products_image, p.products_price,
                                    p.products_tax_class_id, p.products_date_added, m.manufacturers_name, p.products_model,
                                    p.products_quantity, p.products_weight, p.product_is_call,
                                    p.product_is_always_free_shipping, p.products_qty_box_status,
                                    p.master_categories_id
                             FROM " . TABLE_PRODUCTS . " p
                             LEFT JOIN " . TABLE_MANUFACTURERS . " m
                             ON (p.manufacturers_id = m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd
                             WHERE p.products_status = 1
                             AND p.products_id = pd.products_id
                             AND pd.language_id = :languageID " . $display_limit . $order_by;

  $listing_sql = $db->bindVars($listing_sql, ':languageID', $_SESSION['languages_id'], 'integer');
  $products_new_split = new splitPageResults($products_new_query_raw, MAX_DISPLAY_PRODUCTS_NEW);

//check to see if we are in normal mode ... not showcase, not maintenance, etc
  $show_submit = zen_run_normal();

$define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL,
  'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME,
  'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER,
  'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE,
  'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY,
  'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT,
  'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE);

  /*                         ,
  'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW);
  */
  asort($define_list);
  reset($define_list);
  $column_list = array();
  foreach ($define_list as $key => $value)
  {
    if ($value > 0) $column_list[] = $key;
  }
?>

[yellow1912]

Remove this line
$products_new_split = new splitPageResults($products_new_query_raw, MAX_DISPLAY_PRODUCTS_NEW);

[rooisnor]

Remove this line
$products_new_split = new splitPageResults($products_new_query_raw, MAX_DISPLAY_PRODUCTS_NEW);

Great, the error message is gone now but it doesn't read the new products listing.

Shows the following:

More new products will be added soon. Please check back later.

I checked and it seems I have all the files in the correct places though

[yellow1912]

More than likely there is something missing in the new product template, it should look the same with the rest of the template files you have just changed.

[rooisnor]

Thank you yellow... let me 're-do' the package and I'll report back!

[rooisnor]

I uploaded a fresh copy from your original package, made the changes with the same results.

The only page which is not showing the listings is the New Products Listing... the others work great!

Although I'm not too worried about the New Products listing but the other pages were crucial!

Thank you very much for your help and time yellow, you did a great job with this package which is a HUGE contribution to Zen Cart!!

I'll fiddle around and see if I can get the New Product Listing to work and I'll let you know

[LoriW.]

I am having the same error with my new product listing. I have also tried to restore my sql backups with no luck.

However, I was getting this error also for my featured listing, I did fix this by moving my stuff from mycustomtemplate to mycustomtemplate/templates this is not how it is set in the download. :)

Anyway, How would I go about fixing the new product listing?

Thanks. :)