Jump to content
Jack_mcs

Header Tags SEO

Recommended Posts

Try these changes. I haven't tested them but I think they are OK. In includes/functions/header_tags.php, find

  if (($type == 'man' || $type == 'top') && ($pageTags['append_manufacturer'] || $defaultTags['default_logo_append_group'] || $defaultTags['default_logo_append_manufacturer']))
 {
   $the_manufacturer_query= tep_db_query($manStr);
   $the_manufacturer = tep_db_fetch_array($the_manufacturer_query);
   $header_tags_array['manufacturer'] = $the_manufacturer['htc_title_tag'];  //save for use on the logo

Replace with

  if ($type == 'man' && ($pageTags['append_manufacturer'] || $defaultTags['default_logo_append_group'] || $defaultTags['default_logo_append_manufacturer']))
 {
   $the_manufacturer_query= tep_db_query($manStr);
   $the_manufacturer = tep_db_fetch_array($the_manufacturer_query);
   $header_tags_array['manufacturer'] = $the_manufacturer['htc_title_tag'];  //save for use on the logo

   $sortOrder['title'][$pageTags['sortorder_manufacturer']] = '';
   $sortOrder['logo'][$pageTags['sortorder_manufacturer']] = '';
   $sortOrder['description'][$pageTags['sortorder_manufacturer']] = '';
   $sortOrder['keywords'][$pageTags['sortorder_manufacturer']] = '';

Find

function StripSID($url)
{
 $sidName = tep_session_name(); 
 if (($sid = strpos($url, $_GET[ $sidName ])) !== FALSE)
 {
    $SidLength = strlen($_GET[ $sidName ]) + strlen( $sidName ) + 2; // to account for the "?" and "="
    return substr($url , 0, - $SidLength );
 } 
 return $url;
}

Replace with

function StripSID($url)
{
 $sidName = tep_session_name(); 
 if (isset($_GET[ $sidName ]))
 {
   if (($sid = strpos($url, $_GET[ $sidName ])) !== FALSE)
   {
      $SidLength = strlen($_GET[ $sidName ]) + strlen( $sidName ) + 2; // to account for the "?" and "="
      return substr($url , 0, - $SidLength );
   }
 } 
 return $url;
}

In includes/header_tags.php, find

    if (isset($_GET['manufacturers_id']) || $category_depth == 'top')

Replace with

    if (isset($_GET['manufacturers_id']) && $category_depth == 'top')

 

Hi Jack,

 

I made the changes above and added an echo for the manufacturers_id and category_depth (echo ' in includes/header tags line 42 manufacturers id = ' . $manufacturer_id . ' and category_depth = ' . $category_depth;

)

 

received this message on an otherwise blank page:

 

in includes/header tags line 42 manufacturers id = and category_depth = top

 

1065 - Query was empty

 

[TEP STOP]

 

the problem seems to be that isset($_GET['manufacturers_id'] evaluates to true even when it is empty/blank

also tried

if ((isset($_GET['manufacturers_id'])) && tep_not_null($_GET['manufacturers_id']) && $category_depth == 'top')

 

same message

 

it's like manufacturers_id is (or being) set to nothing

 

any thoughts appreciated

 

jk

 

ps - also looked back four pages for info as per your reply to my previous post:

 

Error: Undefined index: logo_text2

 

Already went over this in the last page or two.

 

guess I may have went too fast will doublecheck

 

Thanks for your patience.

Share this post


Link to post
Share on other sites

oh, sorry I forgot to mention that I assigned a variable for $_GET['manufacturers_id']

$manufacturer_id = $_GET['manufacturers_id'];

(used in the echo statement)

by the way, is assigning a variable preferable to repeatedly using $GET (or $POST)

as far as speed is concerned?

 

Thanks,

 

jk

Share this post


Link to post
Share on other sites

oh, sorry I forgot to mention that I assigned a variable for $_GET['manufacturers_id']

$manufacturer_id = $_GET['manufacturers_id'];

(used in the echo statement)

by the way, is assigning a variable preferable to repeatedly using $GET (or $POST)

as far as speed is concerned?

 

Thanks,

 

jk

Share this post


Link to post
Share on other sites

the problem seems to be that isset($_GET['manufacturers_id'] evaluates to true even when it is empty/blank

You can try

isset($_GET['manufacturers_id']) && $_GET['manufacturers_id'] > 0

oh, sorry I forgot to mention that I assigned a variable for $_GET['manufacturers_id']

$manufacturer_id = $_GET['manufacturers_id'];

(used in the echo statement)

by the way, is assigning a variable preferable to repeatedly using $GET (or $POST)

as far as speed is concerned?

No, there's no difference. $_GET and $_POST are already variables.

Share this post


Link to post
Share on other sites

Hi Jack,

 

I bought this template from MonsterTemplate.com somehow the code in the Index.php and product_info different what was been told. Below is my code, if someone help me out I am willing to donate some money or other method. I really need this HeaderTags_SEO for my shop. Please help. Thanks.

 

Index.php

 

<?php

/*

$Id: index.php,v 1.1 2003/06/11 17:37:59 hpdl Exp $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2003 osCommerce

 

Released under the GNU General Public License

*/

 

require('includes/application_top.php');

 

// the following cPath references come from application_top.php

$category_depth = 'top';

if (isset($cPath) && tep_not_null($cPath)) {

$categories_products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'");

$cateqories_products = tep_db_fetch_array($categories_products_query);

if ($cateqories_products['total'] > 0) {

$category_depth = 'products'; // display products

} else {

$category_parent_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$current_category_id . "'");

$category_parent = tep_db_fetch_array($category_parent_query);

if ($category_parent['total'] > 0) {

$category_depth = 'nested'; // navigate through the categories

} else {

$category_depth = 'products'; // category has no products, but display the 'no products' message

}

}

}

 

require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_DEFAULT);

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<html <?php echo HTML_PARAMS; ?>>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">

<title><?php echo TITLE; ?></title>

<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">

<link rel="stylesheet" type="text/css" href="stylesheet.css">

</head>

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">

<!-- header //-->

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

<!-- header_eof //-->

 

<!-- body //-->

<table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td valign="top" class="col_left">

<!-- left_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

<!-- left_navigation_eof //-->

</td>

<!-- body_text //-->

<?php

if ($category_depth == 'nested') {

$category_query = tep_db_query("select cd.categories_name, c.categories_image from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . (int)$current_category_id . "' and cd.categories_id = '" . (int)$current_category_id . "' and cd.language_id = '" . (int)$languages_id . "'");

$category = tep_db_fetch_array($category_query);

?>

<td width="100%" class="col_center">

 

 

<?php tep_draw_heading_top();?>

 

<?php new contentBoxHeading_ProdNew($info_box_contents);?>

 

<?php tep_draw_heading_top_1();?>

 

 

<table cellpadding="0" cellspacing="0" border="0"><tr><td height="3"></td></tr></table>

<table border="0" cellspacing="0" cellpadding="0" align="center" class="box_width_cont product">

<tr>

<?php

if (isset($cPath) && strpos('_', $cPath)) {

// check to see if there are deeper categories within the current category

$category_links = array_reverse($cPath_array);

for($i=0, $n=sizeof($category_links); $i<$n; $i++) {

$categories_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$category_links[$i] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "'");

$categories = tep_db_fetch_array($categories_query);

if ($categories['total'] < 1) {

// do nothing, go through the loop

} else {

$categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$category_links[$i] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name");

break; // we've found the deepest category the customer is in

}

}

} else {

$categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$current_category_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name");

}

 

$number_of_categories = tep_db_num_rows($categories_query);

$rows = 0;

while ($categories = tep_db_fetch_array($categories_query)) {

 

$rows++;

$cPath_new = tep_get_path($categories['categories_id']);

 

$p_pic_sub = '<a href="' . tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">' . tep_image(DIR_WS_IMAGES . $categories['categories_image'], $categories['categories_name'], SUBCATEGORY_IMAGE_WIDTH, SUBCATEGORY_IMAGE_HEIGHT) . '</a>';

 

$p_name_sub = '<a href="' . tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">' . $categories['categories_name'] . '</a>';

 

$width = (int)(100 / MAX_DISPLAY_CATEGORIES_PER_ROW) . '%';

echo '

 

<td align="center" width="' . $width . '">

'.tep_draw_prod_pic_top().''.$p_pic_sub.''.tep_draw_prod_pic_bottom().'

<table cellpadding="0" cellspacing="0" border="0">

<tr>

<td class="vam" style="vertical-align:middle;height:0px;padding:10px 0px 2px 0px;" align="center"><span>'.$p_name_sub.'</span></td>

</tr>

</table>

 

 

</td>

' . "\n";

if ($col!=(MAX_DISPLAY_CATEGORIES_PER_ROW-1)){

echo '

<td>'.tep_draw_separator('spacer.gif', '1', '1').'</td>

';

}

else{

 

if ((($rows / MAX_DISPLAY_CATEGORIES_PER_ROW) == floor($rows / MAX_DISPLAY_CATEGORIES_PER_ROW)) && ($rows != $number_of_categories)) {

echo '

</tr><tr><td class="bg_line_x" colspan="'.(MAX_DISPLAY_CATEGORIES_PER_ROW + MAX_DISPLAY_CATEGORIES_PER_ROW -1).'">'.tep_draw_separator('spacer.gif', '1', '15').'</td></tr>' . "\n";

echo ' <tr>' . "\n";

}

}

if ($col==MAX_DISPLAY_CATEGORIES_PER_ROW-1){

$col=0;

}else{

$col++;

}

}

 

// needed for the new products module shown below

$new_products_category_id = $current_category_id;

?>

 

</table>

 

<?php tep_draw_heading_bottom_1();?>

 

<?php tep_draw_heading_bottom(); ?>

 

<?php tep_draw_separate(); ?> <!-- ///////// -->

 

<?php /* tep_draw_heading_top(); */ ?>

 

<?php new contentBoxHeading_WHATS_NEW($info_box_contents, true, false);?>

 

<?php tep_draw_heading_top_3();?>

 

<?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?>

 

<?php tep_draw_heading_bottom_3();?>

 

<?php /* tep_draw_heading_bottom(); */?>

 

</td>

<?php

} elseif ($category_depth == 'products' || isset($HTTP_GET_VARS['manufacturers_id'])) {

// create column list

$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);

 

$column_list = array();

reset($define_list);

while (list($key, $value) = each($define_list)) {

if ($value > 0) $column_list[] = $key;

}

 

$select_column_list = '';

 

for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {

switch ($column_list[$i]) {

case 'PRODUCT_LIST_MODEL':

$select_column_list .= 'p.products_model, ';

break;

case 'PRODUCT_LIST_NAME':

$select_column_list .= 'pd.products_name, ';

break;

case 'PRODUCT_LIST_MANUFACTURER':

$select_column_list .= 'm.manufacturers_name, ';

break;

case 'PRODUCT_LIST_QUANTITY':

$select_column_list .= 'p.products_quantity, ';

break;

case 'PRODUCT_LIST_IMAGE':

$select_column_list .= 'p.products_image, ';

break;

case 'PRODUCT_LIST_WEIGHT':

$select_column_list .= 'p.products_weight, ';

break;

}

}

 

// show the products of a specified manufacturer

if (isset($HTTP_GET_VARS['manufacturers_id'])) {

if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {

// We are asked to show only a specific category

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'";

} else {

// We show them all

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'";

}

} else {

// show the products in a given categorie

if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {

// We are asked to show only specific catgeory

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";

} else {

// We show them all

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";

}

}

 

if ( (!isset($HTTP_GET_VARS['sort'])) || (!ereg('^[1-8][ad]$', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) {

for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {

if ($column_list[$i] == 'PRODUCT_LIST_NAME') {

$HTTP_GET_VARS['sort'] = $i+1 . 'a';

$listing_sql .= " order by pd.products_name";

break;

}

}

} else {

$sort_col = substr($HTTP_GET_VARS['sort'], 0 , 1);

$sort_order = substr($HTTP_GET_VARS['sort'], 1);

 

switch ($column_list[$sort_col-1]) {

case 'PRODUCT_LIST_MODEL':

$listing_sql .= " order by p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

break;

case 'PRODUCT_LIST_NAME':

$listing_sql .= " order by pd.products_name " . ($sort_order == 'd' ? 'desc' : '');

break;

case 'PRODUCT_LIST_MANUFACTURER':

$listing_sql .= " order by m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

break;

case 'PRODUCT_LIST_QUANTITY':

$listing_sql .= " order by p.products_quantity " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

break;

case 'PRODUCT_LIST_IMAGE':

$listing_sql .= " order by pd.products_name";

break;

case 'PRODUCT_LIST_WEIGHT':

$listing_sql .= " order by p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

break;

case 'PRODUCT_LIST_PRICE':

$listing_sql .= " order by final_price " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

break;

}

}

?>

<td width="100%" class="col_center">

 

<?php /* tep_draw_heading_top(); */?>

 

 

 

<?php tep_draw_heading_top_1();?>

 

<?php

// optional Product List Filter

if (PRODUCT_LIST_FILTER > 0) {

if (isset($HTTP_GET_VARS['manufacturers_id'])) {

$filterlist_sql = "select distinct c.categories_id as id, cd.categories_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' order by cd.categories_name";

} else {

$filterlist_sql= "select distinct m.manufacturers_id as id, m.manufacturers_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by m.manufacturers_name";

}

$filterlist_query = tep_db_query($filterlist_sql);

if (tep_db_num_rows($filterlist_query) > 1) {

echo ' <div align="right" class="main" style="padding:10px 0px 10px 0px;">' . tep_draw_form('filter', FILENAME_DEFAULT, 'get') . TEXT_SHOW . ' ';

if (isset($HTTP_GET_VARS['manufacturers_id'])) {

echo tep_draw_hidden_field('manufacturers_id', $HTTP_GET_VARS['manufacturers_id']);

$options = array(array('id' => '', 'text' => TEXT_ALL_CATEGORIES));

} else {

echo tep_draw_hidden_field('cPath', $cPath);

$options = array(array('id' => '', 'text' => TEXT_ALL_MANUFACTURERS));

}

echo tep_draw_hidden_field('sort', $HTTP_GET_VARS['sort']);

while ($filterlist = tep_db_fetch_array($filterlist_query)) {

$options[] = array('id' => $filterlist['id'], 'text' => $filterlist['name']);

}

echo tep_draw_pull_down_menu('filter_id', $options, (isset($HTTP_GET_VARS['filter_id']) ? $HTTP_GET_VARS['filter_id'] : ''), 'onchange="this.form.submit()"');

echo tep_hide_session_id() . '</form></div>' . "\n";

}

}

 

// Get the right image for the top-right

$image = DIR_WS_IMAGES . 'table_background_list.gif';

if (isset($HTTP_GET_VARS['manufacturers_id'])) {

$image = tep_db_query("select manufacturers_image from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'");

$image = tep_db_fetch_array($image);

$image = $image['manufacturers_image'];

} elseif ($current_category_id) {

$image = tep_db_query("select categories_image from " . TABLE_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'");

$image = tep_db_fetch_array($image);

$image = $image['categories_image'];

}

?>

<?php tep_draw_heading_bottom_1();?>

 

<?php include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); ?>

 

<?php tep_draw_heading_bottom_3();?>

 

<?php /* tep_draw_heading_bottom(); */?>

 

</td>

<?php

} else { // default page

?>

<td width="100%" class="col_center">

 

 

 

<?php /* require(DIR_WS_BOXES . 'panel_top.php'); */ ?>

 

<?php /* tep_draw_heading_top(); */?>

 

<!-- Welcome box start -->

<?php /* tep_draw_heading_top(); */?>

<?php /* tep_draw_heading_top_3(); */?>

<?php /* echo tep_draw_prod_top(); */ ?>

<!-- <table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td class="main"><?php /* echo tep_customer_greeting(); */ ?></td>

</tr>

<tr>

<td><?php /* echo tep_draw_separator('pixel_trans.gif', '100%', '10'); */ ?></td>

</tr>

<tr>

<td class="main"><?php /* echo TEXT_MAIN; */ ?></td>

</tr>

</table> -->

 

<?php /* echo tep_draw_prod_bottom(); */ ?>

<?php /* tep_draw_heading_bottom_3(); */?>

<?php /* echo tep_draw_separate(); */ ?>

 

<!-- Welcome box end -->

 

<?php //new contentBoxHeading_ProdNew($info_box_contents); ?>

 

<?php tep_draw_heading_top_3();?>

 

<?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?>

 

<?php tep_draw_heading_bottom_3();?>

 

<?php include(DIR_WS_MODULES . FILENAME_UPCOMING_PRODUCTS); ?>

 

 

<?php /* tep_draw_heading_bottom(); */?>

 

</td>

<?php

}

?>

<!-- body_text_eof //-->

<td class="col_right">

<!-- right_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>

<!-- right_navigation_eof //-->

</td>

</tr>

</table>

<!-- body_eof //-->

 

<!-- footer //-->

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

<!-- footer_eof //--></body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

 

=====================================================================================================

product_info.php

 

<?php

/*

$Id: product_info.php,v 1.97 2003/07/01 14:34:54 hpdl Exp $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2003 osCommerce

 

Released under the GNU General Public License

*/

 

require('includes/application_top.php');

 

require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCT_INFO);

 

$product_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");

$product_check = tep_db_fetch_array($product_check_query);

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<html <?php echo HTML_PARAMS; ?>>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">

<title><?php echo TITLE; ?></title>

<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">

<link rel="stylesheet" type="text/css" href="stylesheet.css">

<script language="javascript"><!--

function popupWindow(url) {

window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,left=150')

}

//--></script>

</head>

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">

<!-- header //-->

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

<!-- header_eof //-->

 

<!-- body //-->

<table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td class="col_left">

<!-- left_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

<!-- left_navigation_eof //-->

</td>

<!-- body_text //-->

<td width="100%" class="col_center"><?php echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product')); ?><table border="0" width="100%" cellspacing="0" cellpadding="0">

<?php

if ($product_check['total'] < 1) {

?>

<tr><td>

<?php tep_draw_heading_top(); ?>

 

<?php echo tep_draw_title_top();?>

 

<?php echo TEXT_PRODUCT_NOT_FOUND;?>

 

<?php echo tep_draw_title_bottom();?>

 

<?php tep_draw_heading_top_1(); ?>

 

 

 

<!--

<table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">

<tr class="infoBoxContents">

<td>

-->

<br style="line-height:1px;"><br style="line-height:12px;">

 

<table border="0" width="100%" cellspacing="0" cellpadding="2">

<tr>

<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

<td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td>

<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

</tr>

</table>

 

<!--

</td>

</tr>

</table>

-->

 

 

<?php tep_draw_heading_bottom_1(); ?>

 

<?php tep_draw_heading_bottom(); ?>

 

<?php

} else {

$product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");

$product_info = tep_db_fetch_array($product_info_query);

 

tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . (int)$languages_id . "'");

 

if ($new_price = tep_get_products_special_price($product_info['products_id'])) {

$products_price = '<span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span> <s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s>';

} else {

$products_price = '<span class="productSpecialPrice">' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])).'</span>';

}

 

if (tep_not_null($product_info['products_model'])) {

$products_name = $product_info['products_name'] . '<br><span class="smallText">[' . $product_info['products_model'] . ']</span>';

} else {

$products_name = $product_info['products_name'];

}

?>

<tr>

<td>

 

<?php tep_draw_heading_top(); ?>

 

<?php echo tep_draw_title_top();?>

 

<?php echo $breadcrumb->trail(' » ')?>

 

<?php echo tep_draw_title_bottom();?>

 

 

<?php tep_draw_heading_top_1(); ?>

<?php /* tep_draw_heading_top_2(); */ ?>

 

 

<table cellspacing="0" cellpadding="0" border="0" class="product">

<tr><td>

<table cellspacing="0" cellpadding="0" border="0">

<tr><td height="100%">

 

<table cellpadding="0" cellspacing="0" border="0" class="title_info">

<tr><td class="name"><em><?php echo $products_name; ?></em></td></tr>

</table>

 

<?php

if (tep_not_null($product_info['products_image'])) {

?>

 

<table cellpadding="0" cellspacing="0" border="0" align="left" class="prod_info">

<tr><td align="center">

 

 

 

<?php echo tep_draw_prod_pic_top();?>

 

<script language="javascript"><!--

document.write('<?php echo '<a href="javascript:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id']) . '\\\')">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], addslashes($product_info['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, ' style="margin:0px 0px 0px 0px;"') . ''; ?>');

//--></script>

<noscript>

<?php echo '<a href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) . '" target="_blank">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, ' style="margin:0px 0px 0px 0px;"') . ''; ?>

</noscript>

 

<?php echo tep_draw_prod_pic_bottom();?>

 

</td></tr>

<tr><td align="center">

<script language="javascript"><!--

document.write('<?php echo '<div class="enlarge"><a href="javascript:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id']) . '\\\')">' . TEXT_CLICK_TO_ENLARGE . '</a></div>'; ?>');

//--></script>

<noscript>

<?php echo '<div class="enlarge"><a href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) . '" target="_blank"><br style="line-height:7px">' . TEXT_CLICK_TO_ENLARGE . '</a></div>'; ?>

</noscript>

</td></tr>

</table>

<?php

}

?>

 

<div class="padd3"><?php echo stripslashes($product_info['products_description']); ?>

<br><br style="line-height:11px"><span class="productSpecialPrice"><?php echo $products_price?></span></div>

 

</td></tr>

 

</table>

</td>

</tr>

</table>

 

<?php /* tep_draw_heading_bottom_2(); */ ?>

<table cellspacing="0" cellpadding="0" border="0" align="center" style="margin:15px 0px 15px 0px; height:1px;">

<tr><td class="bg_line_x"><?php echo tep_draw_separator('spacer.gif', '1', '1');?></td></tr>

</table>

<?php tep_draw_heading_top_2();?>

 

<?php

$products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "'");

$products_attributes = tep_db_fetch_array($products_attributes_query);

if ($products_attributes['total'] > 0) {

?>

<table cellpadding="0" cellspacing="0" class="box_width_cont product">

<tr><td height="25" colspan="2"><strong><?php echo TEXT_PRODUCT_OPTIONS; ?></strong></td></tr>

<?php

$products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' order by popt.products_options_name");

while ($products_options_name = tep_db_fetch_array($products_options_name_query)) {

$products_options_array = array();

$products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'");

while ($products_options = tep_db_fetch_array($products_options_query)) {

$products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']);

if ($products_options['options_values_price'] != '0') {

$products_options_array[sizeof($products_options_array)-1]['text'] .= ' (' . $products_options['price_prefix'] . $currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) .') ';

}

}

 

if (isset($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']])) {

$selected_attribute = $cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']];

} else {

$selected_attribute = false;

}

?>

<tr>

<td class="main"><?php echo $products_options_name['products_options_name'] . ':'; ?></td>

<td class="main"><?php echo tep_draw_pull_down_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute); ?></td>

</tr>

<tr><td height="10" colspan="2"></td></tr>

<?php

}

?>

</table>

<?php

}

?>

 

<?php

$reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'");

$reviews = tep_db_fetch_array($reviews_query);

if ($reviews['count'] > 0) {

?>

<table cellpadding="0" cellspacing="0" class="product box_width_cont">

<tr><td class="line_h"><?php echo TEXT_CURRENT_REVIEWS . ' ' . $reviews['count']; ?></td></tr>

<tr><td height="17"></td></tr>

</table>

<?php

}

 

if (tep_not_null($product_info['products_url'])) {

?>

<table cellpadding="0" cellspacing="0" class="product box_width_cont">

<tr><td class="line_h"><?php echo sprintf(TEXT_MORE_INFORMATION, tep_href_link(FILENAME_REDIRECT, 'action=url&goto=' . urlencode($product_info['products_url']), 'NONSSL', true, false)); ?></td></tr>

<tr><td height="17"></td></tr>

</table>

<?php

}

 

if ($product_info['products_date_available'] > date('Y-m-d H:i:s')) {

?>

<table cellpadding="0" cellspacing="0" class="product box_width_cont">

<tr><td class="line_h"><?php echo sprintf(TEXT_DATE_AVAILABLE, tep_date_long($product_info['products_date_available'])); ?></td></tr>

<tr><td height="17"></td></tr>

</table>

<?php

} else {

?>

<table cellpadding="0" cellspacing="0" class="product box_width_cont">

<tr><td class="line_h"><?php echo sprintf(TEXT_DATE_ADDED, tep_date_long($product_info['products_date_added'])); ?></td></tr>

<tr><td height="17"></td></tr>

</table>

<?php

}

?>

<!--

<table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">

<tr class="infoBoxContents"><td>

-->

<table border="0" width="100%" cellspacing="0" cellpadding="0" class="product box_width_cont">

<tr>

<td class="main bg_input"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params()) . '">' . tep_image_button('button_reviews.gif', IMAGE_BUTTON_REVIEWS) . '</a>'; ?><?php echo tep_draw_separator('spacer.gif', '15', '1'); ?><?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_add_to_cart1.gif', IMAGE_BUTTON_IN_CART); ?></td>

</tr>

</table><br style="line-height:1px;"><br style="line-height:10px;">

<!--

</td></tr>

</table>

-->

<?php tep_draw_heading_bottom_2();?>

 

<?php tep_draw_heading_bottom_1(); ?>

 

<?php tep_draw_heading_bottom();?>

 

<?php

if ((USE_CACHE == 'true') && empty($SID)) {

echo tep_cache_also_purchased(3600);

} else {

include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS);

}

}

?>

</td>

</tr>

</table></form></td>

<!-- body_text_eof //-->

<td class="col_right">

<!-- right_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>

<!-- right_navigation_eof //-->

</td>

</tr>

</table>

<!-- body_eof //-->

 

<!-- footer //-->

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

<!-- footer_eof //--></body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Share this post


Link to post
Share on other sites

Sorry to bother - This add-on looks interesting, I have 1 question though - will it help me rewrite page titles like: http://dktool.dk/oscommerce_st/catalog/product_info.php?cPath=47&products_id=139 to something more meaningful? Like for example http://dktool.dk/oscommerce_st/catalog/philipsdrillingmachines

No, that is not the purpose of this contribution. You need one of the url rewriter contributions for that. I recommend Ultimate SEO 2.2d (see the link in my signature).

Share this post


Link to post
Share on other sites

I am running the latest ver of Header Tags SEO. Am still playing with settings the meta tags. When viewing the source code at home page, the meta tags displays as following:

 

 <meta name="Description" content="Wholesale home decor accents and unique gifts. We offer many home decor items to accent your personal style." >
<meta name="Keywords" content="Replace me in Page Control under index.php" >
<meta name="googlebot" content="all" >
<meta http-equiv="Content-Language" content="en-us" >
<meta name="robots" content="noodp" >
<meta name="slurp" content="noydir" >
<meta name="revisit-after" content="1 days" >
<meta name="robots" content="index, follow" >

 

But when I try to validate web site, I get to many errors. So how do I get or where do i need to change/add code to that it will insert / just before the closing tag. One example below of what I am in question of:

 

<meta name="Description" content="Wholesale .......... personal style." />

 

 

Because this is what validator.w3.org/ is showing for errors that refer to the meta tags.

 

Thanks.

 

Bennett

Share this post


Link to post
Share on other sites

But when I try to validate web site, I get to many errors. So how do I get or where do i need to change/add code to that it will insert / just before the closing tag. One example below of what I am in question of:

That can be changed in includes/header_tags.php at the bottom of the file.

Share this post


Link to post
Share on other sites

That can be changed in includes/header_tags.php at the bottom of the file.

 

Thanks Jack, I guess did not go far enough, I was searching in the top have.

 

Bennett

Share this post


Link to post
Share on other sites

Hey Jack,

 

Hopefully this time I have a question which isn't so stupid (i.e. has already been solved on this page :P)

 

There's 3 things I am having trouble with when running the Header Tags Test:

 

1. In order to remove the Permissions Error, I have to set the permission for the includes/header_tags.php file to 777 <---- (since 755 still gives me the error, I have commented out the chmod script like it says in the troubleshoot) is setting the permision to 777 a security problem of any sort?

 

2. I get the STS error saying the head code in the index.php and products_info.php file has Header Tags code installed, which is a mistake. (I should be able to sort this by myself I guess but any help pointing me in the right direction would be grately appreeciated.

 

3. I have the Database Error where my file count is significantly higher than my database file entries (21 to 6 repectively). The troubleshoot tells me how to deal with this, however, it says I have to log into the page control to resolve this issue. Unfortunately, when I try to do this I get the error...

 

1054 - Unknown column 'sortorder_root_1' in 'field list'

 

insert into headertags (page_name, page_title, page_description, page_keywords, page_logo, page_logo_1, page_logo_2, page_logo_3, page_logo_4, append_default_title, append_default_description, append_default_keywords, append_default_logo, append_category, append_manufacturer, append_product, append_root, sortorder_title, sortorder_description, sortorder_keywords, sortorder_logo, sortorder_category, sortorder_manufacturer, sortorder_product, sortorder_root, sortorder_root_1, sortorder_root_2, sortorder_root_3, sortorder_root_4, language_id) values ('tell_a_friend.php', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '10', '1', '1', '1', '1', '1', '1')

 

[TEP STOP]

.

 

I am using

Header Tags SEO 3.2.1

STS 4.5.8

 

Thanks for all your hard work and great contribution

 

Chris

Edited by Greeny

Share this post


Link to post
Share on other sites

Hello Jack,

 

I apologize for asking a question that might have been asked - but I can't find a suitable answer anywhere on this thread.

 

After installing Header Tags SEO - my admin section is blank. I saw another response where you told a person to re-upload the files, which I did. No success. I've re-gone over the install and just can seem to see whats wrong. Please any help would be appreciated.

 

Thanks,

Chris

Share this post


Link to post
Share on other sites

Hello Jack,

 

I apologize for asking a question that might have been asked - but I can't find a suitable answer anywhere on this thread.

 

After installing Header Tags SEO - my admin section is blank. I saw another response where you told a person to re-upload the files, which I did. No success. I've re-gone over the install and just can seem to see whats wrong. Please any help would be appreciated.

 

Thanks,

Chris

 

Ok- Solved - i added an extra comment to the html_output file.

Share this post


Link to post
Share on other sites

1. In order to remove the Permissions Error, I have to set the permission for the includes/header_tags.php file to 777 <---- (since 755 still gives me the error, I have commented out the chmod script like it says in the troubleshoot) is setting the permision to 777 a security problem of any sort?

 

2. I get the STS error saying the head code in the index.php and products_info.php file has Header Tags code installed, which is a mistake. (I should be able to sort this by myself I guess but any help pointing me in the right direction would be grately appreeciated.

 

3. I have the Database Error where my file count is significantly higher than my database file entries (21 to 6 repectively). The troubleshoot tells me how to deal with this, however, it says I have to log into the page control to resolve this issue. Unfortunately, when I try to do this I get the error...

1 - As long as your includes difrectory is protected, which it is by default, that is fine.

 

2 - There shouldn't be header tags code in the head section of any file when using STS.

 

3 - There is a mistake in the sql files of the contribution - a different mistake in each. Run these sql commands to fix the one you are having.

ALTER TABLE `headertags` ADD `sortorder_root_1` tinyint( 2 ) NOT NULL DEFAULT 1 AFTER `sortorder_root`;
ALTER TABLE `headertags` ADD `sortorder_root_2` tinyint( 2 ) NOT NULL DEFAULT 1 AFTER `sortorder_root_1`;
ALTER TABLE `headertags` ADD `sortorder_root_3` tinyint( 2 ) NOT NULL DEFAULT 1 AFTER `sortorder_root_2`;
ALTER TABLE `headertags` ADD `sortorder_root_4` tinyint( 2 ) NOT NULL DEFAULT 1 AFTER `sortorder_root_3`;

Share this post


Link to post
Share on other sites

2 - There shouldn't be header tags code in the head section of any file when using STS.

 

 

Thanks Jack Its all working fine now, except when you say header tags code I'm not sure what you mean :S

 

In my product_info.php.html file in my STS template folder the code in between my <head></head> tags reads:

 

<!--$headcontent-->

<link rel="stylesheet" type="text/css" href="$templatedir/stylesheet.css">

<title>Elite Shafts UK - Cutom Golf Shafts, Diamana Golf Shafts, Mitsubishi Golf Shafts, VooDoo Golf Shafts, Custom Snake Eyes Clubs</title>

<script type="text/javascript" src="../../../js/jquery-1.3.2.min.js"></script>

<script type="text/javascript" src="../../../js/jquery.cycle.all.min.js"></script>

 

<script type="text/javascript">

$(document).ready(function() {

$('.slideshow').cycle({

fx: 'fade', // choose your transition type, ex: fade, scrollUp, shuffle, etc...

timeout: 5000

});

});

</script>

 

<script language="javascript" type="text/javascript">

//<![CDATA[

var cot_loc0=(window.location.protocol == "https:")? "https://secure.comodo.net/trustlogo/javascript/cot.js" :

"http://www.trustlogo.com/trustlogo/javascript/cot.js";

document.writeln('<scr' + 'ipt language="JavaScript" src="'+cot_loc0+'" type="text\/javascript">' + '<\/scr' + 'ipt>');

//]]>

</script>

 

Out of this is the <title></title> the header tags? or is it the <!--headcontent--> ? I have tried removing both, but it doesn't clear up the error and I can't figure out what else would be the header tags code.

 

Cheers

Share this post


Link to post
Share on other sites

hi all, and 10x to Jack,

 

i have installed Header Tags SEO V 3.2.1 and datebase sql files + update sql. Now i recived this error:

 

 

1146 - Table 'holzmann_osc4.TABLE_HEADERTAGS_DEFAULT' doesn't exist

 

select * from TABLE_HEADERTAGS_DEFAULT where language_id = '1'

 

 

all datebase felds are in my sql datebase

 

 

can you help me?

Share this post


Link to post
Share on other sites

In my product_info.php.html file in my STS template folder the code in between my <head></head> tags reads:

I was referring to root files, as the instructions state. If you follow them, then it will be correct. The file you mentioned is fine.

Share this post


Link to post
Share on other sites

1146 - Table 'holzmann_osc4.TABLE_HEADERTAGS_DEFAULT' doesn't exist

It means you missed a step in the installation. Search the installation files for changes to the database_tables.php file in regards to TABLE_HEADERTAGS_DEFAULT.

Share this post


Link to post
Share on other sites

It means you missed a step in the installation. Search the installation files for changes to the database_tables.php file in regards to TABLE_HEADERTAGS_DEFAULT.

 

 

YESSSSSSSSSSSSS YOU ARE RIGHT+++++++++++++++++++++++++

 

:)

 

the problem was in database_tables. it was not in right dir

 

 

many thx

Share this post


Link to post
Share on other sites

I was referring to root files, as the instructions state. If you follow them, then it will be correct. The file you mentioned is fine.

 

 

Lol sorry, I don't know why, but i thought you had to make that change to index.php and products_info.php. My bad again :P

 

Thanks for your help :D

Share this post


Link to post
Share on other sites

Hi Jack, I must say that after all these years I am amazed that you are still available for questions.

 

Anyway I have had my store for a while now but have finally decided to get my header tags contribution to work correctly.

 

I have looked through a lot of your answers to people who have had the same problem as me but I have not yet found an answer.

 

Firstly I have run the test and no errors are showing.

 

In the section page control I have loaded the index.php file. I am trying to use the option of "Use keywords from text on the actual page" by clicking the circle option but I do not get the chance to update because the page reloads and says the message "Failed to load page from shop: http://topclassfurniture.co.uk/mystore/index.php?language=en".

 

I have searched the Failed to load page from shop etc in this forum but can not find a positive answer to the problem.

 

Also in the Fill Tags section I have tried to check both the Description Override and Keywords Override by saying "yes" and at the bottom of the page I have checked fill all tags in the Categories and Products section, (not using Manufacturers), but as soon as I update this I also get the message "Failed to load page from shop: http://topclassfurniture.co.uk/mystore/product_info.php?products_id=29&language=en".

 

Should I also check the Generic Override and also check the Title:, Description:, Keywords: and Description: in Categories and Products section?

 

I am so sorry if you have been asked these questions lots of times and it is not as though I have not bothered looking through the threads as I have but finding an answer which I can follow to my specific problem is not always apparent.

 

Thank you so much for taking the trouble to read this and hopefully help solve my problem.

 

Offie

Share this post


Link to post
Share on other sites

Hi,

 

I have my SEO header tag installed successfully in my local server. When I moved everything to production server (lived), I cannot login to my admin control panel anymore. I get a total blank screen and no HTML codes when login.

 

I did troubleshooting by uploading the updated files one by one, and finally found that once admin/include/filenames.php is uploaded, the failure begins.

 

Comparing the new and old filenames.php with diffMerge shows that only:

 

/*** Begin Header Tags SEO ***/

define('FILENAME_HEADER_TAGS_SEO', 'header_tags_seo.php');

define('FILENAME_HEADER_TAGS_SILO', 'header_tags_seo_silo.php');

define('FILENAME_HEADER_TAGS_FILL_TAGS', 'header_tags_fill_tags.php');

define('FILENAME_HEADER_TAGS_TEST', 'header_tags_test.php');

/*** End Header Tags SEO ***/

 

has been added.

 

Can someone please tell me what is probably wrong?

 

Those changes wouldn't cause the problem you are having. But they are required for the code to link properly and once you try to do that, one of the other files is getting loaded, which is causing the problem. I suggest you upload all of the files from the contributions catalog/admin/ directory. The problem you describe is typically because a file is in the wrong place so replacing them all from the contribution is the quickest way to resolve that.

 

Thanks Jack for the reply and I was able to find the cause and solution for this problem.

 

It was caused by white spaces after the last ?> tag in some modified PHP file.

 

It may not be new to some people and details can be found here: http://www.oscommerce.info/kb/osCommerce/General_Information/Common_Problems/15

Share this post


Link to post
Share on other sites

The above is an invalid url. You need to fix your shop before the Header Tags code will work.

 

Hi Jack and thanks for your reply.

 

I am not sure why you say that it is an invalid url because when I type it in and load the page I am taken to my products page. I currently dont have any products in this store yet as I am just building it but I have also tried it in another store I am building which does have some products and I am getting the same error message which is:

 

Failed to load page from shop: http://classgifts.co.uk/mystore/product_info.php?products_id=29&language=en

 

Do I need to have the store fully loaded for the addon to work because I would have thought it would have worked with only 1 item in the store?

 

Thanks again

 

Michael

Share this post


Link to post
Share on other sites

Hi Everyone.. I just installed HeaderTags_SEO_V_3.2.1 two days ago. Everything seemed to be fine until I went into my Admin account and was editing som eof my products. I clicked on a product, I selected Edit, made my change and Clicked Preview. The Products Title will not show in Preview, nor will it show on my actual webstore! I have no idea what the problem is or how to fix it. Has anyone ever had this happen?

 

Whats weird is i can select Edit a product, not do or make any changes, Click preview and then it wont display that products title either!!

 

Is there something wrong with the install I can fix? Is there a problem with this contribution? I didnt see anyone having the problem Im having, but I cant run an online store and not have the name of the product listed..

 

 

What should I do?? I really need some ides on this.

 

Thanks

 

 

My STORE

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×