Specials Sidebox showing on home page only

[Ajeh]

Sounds like an issue with your template files ...

You may want to compare them to the original files to see if anything stands out ...

Beyond Compare from scootersoftware.com is a handy tool for this ...

[kburner]

Sounds like an issue with your template files ...

You may want to compare them to the original files to see if anything stands out ...

Beyond Compare from scootersoftware.com is a handy tool for this ...

I compared with original files and did not see anything...

Here are two files unless there are others I do not know about.

include/modules/sidebox/temp/specials.php

// test if box should display
  $show_specials= true;

  if (isset($_GET['products_id'])) {
    $show_specials= true;
  } else {
    $show_specials= true;
  }

  if ($show_specials == true) {
    $random_specials_sidebox_product_query = "select p.products_id, pd.products_name, p.products_price,
                                    p.products_tax_class_id, p.products_image,
                                    s.specials_new_products_price,
                                    p.master_categories_id
                             from " . TABLE_PRODUCTS . " p, " .
                                      TABLE_PRODUCTS_DESCRIPTION . " pd, " .
                                      TABLE_SPECIALS . " s
                             where p.products_status = 1
                             and p.products_id = s.products_id
                             and pd.products_id = s.products_id
                             and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                             and s.status = 1";

//    $random_specials_sidebox_product = zen_random_select($random_specials_sidebox_product_query);
    $random_specials_sidebox_product = $db->ExecuteRandomMulti($random_specials_sidebox_product_query, MAX_RANDOM_SELECT_SPECIALS);

    if ($random_specials_sidebox_product->RecordCount() > 0)  {
      require($template->get_template_dir('tpl_specials.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes'). '/tpl_specials.php');
      $title =  BOX_HEADING_SPECIALS;
      $title_link = FILENAME_SPECIALS;
      require($template->get_template_dir($column_box_default, DIR_WS_TEMPLATE, $current_page_base,'common') . '/' . $column_box_default);
    }
  }
?>

includes/templates/temp/sideboxes/tpl_specials.php

$content = "";
  $specials_box_counter = 0;
  while (!$random_specials_sidebox_product->EOF) {
    $specials_box_counter++;
    $specials_box_price = zen_get_products_display_price($random_specials_sidebox_product->fields['products_id']);
    $content .= '<div class="sideBoxContent centeredContent">';
    $content .= '<a href="' . zen_href_link(zen_get_info_page($random_specials_sidebox_product->fields["products_id"]), 'cPath=' . zen_get_generated_category_path_rev($random_specials_sidebox_product->fields["master_categories_id"]) . '&products_id=' . $random_specials_sidebox_product->fields["products_id"]) . '">' . zen_image(DIR_WS_IMAGES . $random_specials_sidebox_product->fields['products_image'], $random_specials_sidebox_product->fields['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT); 
    $content .= '<br />' . $random_specials_sidebox_product->fields['products_name'] . '</a>';
    $content .= '<div>' . $specials_box_price . '</div>';
    $content .= '</div>';
    $random_specials_sidebox_product->MoveNextRandom();
  }
?>

Do you see anything?

[Ajeh]

Does the Specials page show when you use the link to specials from the Categories sidebox?

[kburner]

Does the Specials page show when you use the link to specials from the Categories sidebox?

No, it does not work from the categories sidebox either.

[Ajeh]

This makes me think you are looking in the wrong place for the problem ...

Check the files:
/includes/templates/template_default/templates/tpl_specials_default.php
/includes/languages/english/specials.php

against your template files:
/includes/templates/temp/templates/tpl_specials_default.php
/includes/languages/english/temp/specials.php

[kburner]

This makes me think you are looking in the wrong place for the problem ...

Check the files:
/includes/templates/template_default/templates/tpl_specials_default.php
/includes/languages/english/specials.php

against your template files:
/includes/templates/temp/templates/tpl_specials_default.php
/includes/languages/english/temp/specials.php

Checked the files and they match....

[Ajeh]

Is this on the site in your signature?

If so, your URL is being built wrong and with that is the SEO stuff you are using or your configure.php file ...

View Source and you will see there are things built for the page ...

Turn off the SEO stuff, does this correct the problem?