xciso Posted January 23, 2011 Share Posted January 23, 2011 I cant find direct what the problem is. How can i get more info about where the problem is? Quote Link to comment Share on other sites More sharing options...
johnnybebad Posted January 23, 2011 Share Posted January 23, 2011 Hi Jack, My link I now have the headertags working except the headertags box is sometimes empty even when the product description is plentiful so not sure whats happening there. This is the same inside and outside of sts, so dont understand what code it is I am missing. as you can see I have a column problem with headertags infoboxes in sts trying to find out why and have posted for support on the sts thread Quote Getting better with mods but no programmer am I. Link to comment Share on other sites More sharing options...
blaine109 Posted January 23, 2011 Share Posted January 23, 2011 1064 Error when trying to duplicate a product. 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from products_description where products_id = '182'' at line 1 select language_id, products_name, products_description, products_head_title_tag, products_head_desc_tag, products_head_keywords_tag, products_url, from products_description where products_id = '182' [TEP STOP] I am running Header Tags SEO V 3.2.5 Around line 348 you will find the following code: /*** Begin Header Tags SEO ***/ $description_query = tep_db_query("select language_id, products_name, products_description, products_head_title_tag, products_head_desc_tag, products_head_keywords_tag, products_url, from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$products_id . "'"); while ($description = tep_db_fetch_array($description_query)) { tep_db_query("insert into " . TABLE_PRODUCTS_DESCRIPTION . " (products_id, language_id, products_name, products_description, products_head_title_tag, products_head_desc_tag, products_head_keywords_tag, products_url, products_viewed) values ('" . (int)$dup_products_id . "', '" . (int)$description['language_id'] . "', '" . tep_db_input($description['products_name']) . "', '" . tep_db_input($description['products_description']) . "', '" . tep_db_input($description['products_head_title_tag']) . "', '" . tep_db_input($description['products_head_desc_tag']) . "', '" . tep_db_input($description['products_head_keywords_tag']) . "', '" . tep_db_input($description['products_url']) . "', '0')"); } /*** End Header Tags SEO ***/ There is an extra comma in the $description_query after products_url that shouldn't be there. Winmerge is a wonderful program! Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted January 24, 2011 Author Share Posted January 24, 2011 I now have the headertags working except the headertags box is sometimes empty even when the product description is plentiful so not sure whats happening there. This is the same inside and outside of sts, so dont understand what code it is I am missing. as you can see I have a column problem with headertags infoboxes in sts trying to find out why and have posted for support on the sts thread The header tags box should only display on a product page so there is a mistake in your installation since the link you provided is to a category. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
johnnybebad Posted January 24, 2011 Share Posted January 24, 2011 The header tags box should only display on a product page so there is a mistake in your installation since the link you provided is to a category. the silo box is displaying on the category, and the hedaer tags box (see more) is displaying on the products page ??? Thanks Quote Getting better with mods but no programmer am I. Link to comment Share on other sites More sharing options...
johnnybebad Posted January 24, 2011 Share Posted January 24, 2011 the silo box is displaying on the category, and the hedaer tags box (see more) is displaying on the products page ??? Thanks go it working now correctly I think but will be checking back later. 1. needed to add code to column_left.php so it reads as shown in code below (this is so it works outside sts) <?php /* $Id: column_left.php 1739 2007-12-20 00:52:16Z hpdl $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ // START STS 4.1 if ($sts->display_template_output) { include DIR_WS_MODULES.'sts_inc/sts_column_left.php'; } else { //END STS 4.1 if ((USE_CACHE == 'true') && empty($SID)) { echo tep_cache_categories_box(); } else { include(DIR_WS_BOXES . 'categories.php'); } if ((USE_CACHE == 'true') && empty($SID)) { echo tep_cache_manufacturers_box(); } else { include(DIR_WS_BOXES . 'manufacturers.php'); } require(DIR_WS_BOXES . 'affiliate.php'); require(DIR_WS_BOXES . 'whats_new.php'); require(DIR_WS_BOXES . 'search.php'); require(DIR_WS_BOXES . 'information.php'); require(DIR_WS_BOXES . 'links.php'); require(DIR_WS_BOXES . 'featured.php'); require(DIR_WS_BOXES . 'paypalLogo.php'); require(DIR_WS_BOXES . 'googlead.php'); /*** Begin Header Tags SEO ***/ if (HEADER_TAGS_DISPLAY_SILO_BOX == 'true') if (isset($category_depth) && $category_depth !== 'top') include(DIR_WS_BOXES . 'headertags_seo_silo.php'); /*** End Header Tags SEO ***/ /*** Begin Header Tags SEO ***/ if (HEADER_TAGS_DISPLAY_COLUMN_BOX == 'true' && basename($_SERVER['PHP_SELF']) == FILENAME_PRODUCT_INFO) include(DIR_WS_BOXES . 'header_tags.php'); /*** End Header Tags SEO ***/ // START STS 4.1 } // END STS 4.1 ?> 2. sts_inc/sts_column_left.php like:- <?php /* $Id: sts_column_left.php,v 4.3.3 2006/03/12 22:06:41 rigadin Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2005 osCommerce Released under the GNU General Public License STS v4.3.3 by Rigadin (rigadin@osc-help.net) Based on: Simple Template System (STS) - Copyright (c) 2004 Brian Gallagher - brian@diamondsea.com */ $sts->restart_capture(); // Clear buffer but do not save it nowhere, no interesting information in buffer. // Get categories box from db or cache if ((USE_CACHE == 'true') && empty($SID)) { echo tep_cache_categories_box(); } else { include(DIR_WS_BOXES . 'categories.php'); } $sts->restart_capture ('categorybox', 'box'); // Get manufacturer box from db or cache if ((USE_CACHE == 'true') && empty($SID)) { echo tep_cache_manufacturers_box(); } else { include(DIR_WS_BOXES . 'manufacturers.php'); } $sts->restart_capture ('manufacturerbox', 'box'); require(DIR_WS_BOXES . 'competition.php'); $sts->restart_capture ('competitionbox', 'box'); /*** Begin Header Tags SEO ***/ if (HEADER_TAGS_DISPLAY_COLUMN_BOX == 'true' && basename($_SERVER['PHP_SELF']) == FILENAME_PRODUCT_INFO) require(DIR_WS_BOXES . 'header_tags.php'); $sts->restart_capture ('headertagsbox', 'box'); require(DIR_WS_BOXES . 'whos_online.php'); $sts->restart_capture ('whosonlinebox', 'box'); // Get Whos online new box require(DIR_WS_BOXES . 'paypalLogo.php'); $sts->restart_capture ('paypallogobox', 'box'); // Get Whos online new box require(DIR_WS_BOXES . 'whats_new.php'); $sts->restart_capture ('whatsnewbox', 'box'); // Get What's new box require(DIR_WS_BOXES . 'search.php'); $sts->restart_capture ('searchbox', 'box'); // Get search box require(DIR_WS_BOXES . 'newsdesk_latest.php'); $sts->restart_capture ('newsdeskbox', 'box'); // Get shopping cart box require(DIR_WS_BOXES . 'newsdesk.php'); $sts->restart_capture ('catnewsdeskbox', 'box'); // Get shopping cart box require(DIR_WS_BOXES . 'faqdesk.php'); $sts->restart_capture ('catfaqdeskbox', 'box'); // Get shopping cart box require(DIR_WS_BOXES . 'faqdesk_latest.php'); $sts->restart_capture ('faqdeskbox', 'box'); // Get shopping cart box require(DIR_WS_BOXES . 'information.php'); $sts->restart_capture ('informationbox', 'box'); // Get information box require(DIR_WS_BOXES . 'shopping_cart.php'); $sts->restart_capture ('cartbox', 'box'); // Get shopping cart box if (isset($HTTP_GET_VARS['products_id'])) include(DIR_WS_BOXES . 'manufacturer_info.php'); $sts->restart_capture ('maninfobox', 'box'); // Get manufacturer info box (empty if no product selected) if (tep_session_is_registered('customer_id')) include(DIR_WS_BOXES . 'order_history.php'); $sts->restart_capture ('orderhistorybox', 'box'); // Get customer's order history box (empty if visitor not logged) include(DIR_WS_BOXES . 'best_sellers.php'); $sts->restart_capture ('bestsellersbox_only', 'box'); // Get bestseller box only, new since v4.0.5 require(DIR_WS_BOXES . 'googlead.php'); $sts->restart_capture ('googleadbox', 'box'); // Get information box require(DIR_WS_BOXES . 'affiliate.php'); $sts->restart_capture ('affiliatebox', 'box'); // Get information box require(DIR_WS_BOXES . 'featured.php'); $sts->restart_capture ('$featuredbox', 'box'); // Get information box // Get bestseller or product notification box. If you use this, do not use these boxes separately! if (isset($HTTP_GET_VARS['products_id'])) { include(DIR_WS_BOXES . 'product_notifications.php'); $sts->restart_capture ('notificationbox', 'box'); // Get product notification box // Get bestseller or product notification box. If you use this, do not use these boxes separately! if (tep_session_is_registered('customer_id')) { $check_query = tep_db_query("select count(*) as count from " . TABLE_CUSTOMERS_INFO . " where customers_info_id = '" . (int)$customer_id . "' and global_product_notifications = '1'"); $check = tep_db_fetch_array($check_query); if ($check['count'] > 0) { $sts->template['bestsellersbox']=$sts->template['bestsellersbox_only']; // Show bestseller box if customer asked for general notifications } else { $sts->template['bestsellersbox']=$sts->template['notificationbox']; // Otherwise select notification box } } else { $sts->template['bestsellersbox']=$sts->template['notificationbox']; // } } else { $sts->template['bestsellersbox']=$sts->template['bestsellersbox_only']; $sts->template['notificationbox']=''; } include(DIR_WS_BOXES . 'specials.php'); $sts->restart_capture ('specialbox', 'box'); // Get special box $sts->template['specialfriendbox']=$sts->template['specialbox']; // Shows specials or tell a friend include(DIR_WS_BOXES . 'featured.php'); $sts->restart_capture ('featuredbox', 'box'); // Get featured box $sts->template['featuredbox']=$sts->template['featuredbox']; // Show featured products if (isset($HTTP_GET_VARS['products_id']) && basename($PHP_SELF) != FILENAME_TELL_A_FRIEND) { include(DIR_WS_BOXES . 'tell_a_friend.php'); $sts->restart_capture ('tellafriendbox', 'box'); // Get tell a friend box $sts->template['specialfriendbox']=$sts->template['tellafriendbox']; // Shows specials or tell a friend } else $sts->template['tellafriendbox']=''; // Get languages and currencies boxes, empty if in checkout procedure if (substr(basename($PHP_SELF), 0, 8) != 'checkout') { include(DIR_WS_BOXES . 'languages.php'); $sts->restart_capture ('languagebox', 'box'); include(DIR_WS_BOXES . 'currencies.php'); $sts->restart_capture ('currenciesbox', 'box'); } else { $sts->template['languagebox']=''; $sts->template['currenciesbox']=''; } if (basename($PHP_SELF) != FILENAME_PRODUCT_REVIEWS_INFO) { require(DIR_WS_BOXES . 'reviews.php'); $sts->restart_capture ('reviewsbox', 'box'); // Get the reviews box } else { $sts->template['reviewsbox']=''; } /*** Begin Header Tags SEO ***/ if (HEADER_TAGS_DISPLAY_SILO_BOX == 'true') if (isset($category_depth) && $category_depth !== 'top') require(DIR_WS_BOXES . 'headertags_seo_silo.php'); $sts->restart_capture ('headertagssilobox', 'box'); /*** End Header Tags SEO *** ?> This means I can move the boxes by using placeholders as I would normally to anywhere in my sts_template.html I havent got any errors and it looks okay, but will be checking it again later so i know if I have any problems. Quote Getting better with mods but no programmer am I. Link to comment Share on other sites More sharing options...
jhande Posted January 24, 2011 Share Posted January 24, 2011 Hi Jack, Your pain in the butt is back again... :P My site is using either version 3.0.1 or 3.1.4. Should I really update to version 3.2.5? Quote - :: Jim :: - - My Toolbox ~ Adobe Web Bundle, XAMPP & WinMerge | Install ~ osC v2.3.3.4 - Link to comment Share on other sites More sharing options...
Jack_mcs Posted January 24, 2011 Author Share Posted January 24, 2011 My site is using either version 3.0.1 or 3.1.4. Should I really update to version 3.2.5? You can look at the history file in the latest version to see the changes made since yours. Some are important so, yes, you should upgrade. jhande 1 Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
jhande Posted January 25, 2011 Share Posted January 25, 2011 You can look at the history file in the latest version to see the changes made since yours. Some are important so, yes, you should upgrade. Thank you Jack! :thumbsup: Quote - :: Jim :: - - My Toolbox ~ Adobe Web Bundle, XAMPP & WinMerge | Install ~ osC v2.3.3.4 - Link to comment Share on other sites More sharing options...
gomikeyp Posted January 27, 2011 Share Posted January 27, 2011 (edited) I have completed the install but in the admin -> Header Tags SEO -> Page Control... In the drop down, I only see Select a file, Show All Files and Add missing pages. How can I get it to show all the pages available to edit? Thanks in advance. --- NVM. Found the problem. I skipped step 1 because I have sts installed but I'm not actually using it... so I guess I have to still change them. Thanks. Edited January 27, 2011 by gomikeyp Quote Link to comment Share on other sites More sharing options...
sahilsaid Posted January 30, 2011 Share Posted January 30, 2011 (edited) I am having problem setting what I want. The title of my product comes up as "product title -- Category name" I don't want the category name to appear after the product name as it makes my title long without any good keywords. I tried several setting in "Page control" page but it either shows up or it completely goes away. When it is gone away then all the titles on all the category i.e product_listing page has same title resulting in duplicate contents. So I want to keep the category name before the title but only for product_listing page and not before or after my product_info.php title tags. how do I achieve that? My current setting on "Page control" is as screen shot below,, Which boxes needs to be checked and unchecked to achieve what I want? to summarize: I want my product titles to be : <title>my great product whatever</title> The category titles to be : <title>New - my website default title</title> but that "New (the category name)" should not appear after or before my product title tags. Current titles produced with setting below is: <title>>my great product whatever - New (or whatever category the product is in). I don't want this category name to appear after my product titles. Thanks for help... Edited January 30, 2011 by sahilsaid Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted January 31, 2011 Author Share Posted January 31, 2011 to summarize: I want my product titles to be : <title>my great product whatever</title> The category titles to be : <title>New - my website default title</title> Uncheck the default category checkbox. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
sahilsaid Posted January 31, 2011 Share Posted January 31, 2011 Uncheck the default category checkbox. Hi Jack, Thanks for your quick reply. I unchecked the default category check box but then the category title did disappear from the back of the product title but it also gets disappeared from the category pages (product_listing pages) and gives all the category/subcategory a default title and description resulting in many duplicate contents. Does this look like a installation fault?, but it was working fine few months ago. Quote Link to comment Share on other sites More sharing options...
♥14steve14 Posted January 31, 2011 Share Posted January 31, 2011 I have just installed this on 2.3.1. Everything seems to work ok. No problem with that. The problem i have is that when looking at the page control page, all the boxes to enter text for title, description,keywords and logo text are aligned to the right, not the left. My install of 2.3.1 only has ultimate url 2.2 added. This may be something i have done, but i have rechecked all the files associated with this great contribution, and all seem to be correct. Any help appreciated Quote REMEMBER BACKUP, BACKUP AND BACKUP Link to comment Share on other sites More sharing options...
Jack_mcs Posted January 31, 2011 Author Share Posted January 31, 2011 Hi Jack, Thanks for your quick reply. I unchecked the default category check box but then the category title did disappear from the back of the product title but it also gets disappeared from the category pages (product_listing pages) and gives all the category/subcategory a default title and description resulting in many duplicate contents. Does this look like a installation fault?, but it was working fine few months ago. Check the category box for index.php in page control. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Jack_mcs Posted January 31, 2011 Author Share Posted January 31, 2011 I have just installed this on 2.3.1. Everything seems to work ok. No problem with that. The problem i have is that when looking at the page control page, all the boxes to enter text for title, description,keywords and logo text are aligned to the right, not the left. My install of 2.3.1 only has ultimate url 2.2 added. This may be something i have done, but i have rechecked all the files associated with this great contribution, and all seem to be correct. Any help appreciated Hmm, no, I can't think of what that might be. Assuming you are using the Header Tags files from the 2.3 directory, there's nothing else I can think of that would cause that. What screen resolution are you using? Does it do the same in other browsers (IE, FF, Chrome)? Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
♥14steve14 Posted January 31, 2011 Share Posted January 31, 2011 Jack Thanks for the quick response. The problem only seems to be there in ie8. Its as it should be in firefox. ie8 screenshot Firefox image Quote REMEMBER BACKUP, BACKUP AND BACKUP Link to comment Share on other sites More sharing options...
Jack_mcs Posted January 31, 2011 Author Share Posted January 31, 2011 Jack Thanks for the quick response. The problem only seems to be there in ie8. Its as it should be in firefox. Yes, I see that here too. There seems to be something overriding the default align left attribute. I tried making some basic changes, even edited the css class for admin, but it didn't help so I don't have an answer right now. I'll put this in the list of things to look at for the next version. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
sahilsaid Posted January 31, 2011 Share Posted January 31, 2011 Check the category box for index.php in page control. Thanks jack, all seems to be sorted. thanks so much for your help. Quote Link to comment Share on other sites More sharing options...
♥14steve14 Posted January 31, 2011 Share Posted January 31, 2011 Jack Thanks for having a look. It all seems to be working fine, so its no great problem. Quote REMEMBER BACKUP, BACKUP AND BACKUP Link to comment Share on other sites More sharing options...
Follkes Posted February 4, 2011 Share Posted February 4, 2011 Hi Jack!! I was checking for new versions and saw about this "-> Changed canonical code so duplicate slashes are removed for the home page". And it happend to me !!! you rememer this? http://www.oscommerce.com/forums/topic/298099-header-tags-seo/page__view__findpost__p__1518873 With an update would be solved? Thank you!!!! Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted February 5, 2011 Author Share Posted February 5, 2011 I was checking for new versions and saw about this "-> Changed canonical code so duplicate slashes are removed for the home page". And it happend to me !!! you rememer this? http://www.oscommerce.com/forums/topic/298099-header-tags-seo/page__view__findpost__p__1518873 With an update would be solved? That was fixed several releases ago, as I recall, and no one has mentioned the problem since so, as far as I know, it has been fixed. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
DorianJ Posted February 6, 2011 Share Posted February 6, 2011 I migrated from HTC to Header Tags SEO v3.2.5 and have come across a strange problem. Some of the category pages will display the value of the categories_description.categories_htc_title_tag field for the page's HEADING_TITLE and other category pages will display the word "Categories" in this location. Been working about 15 hours today to make this work so I'm probably overlooking something easy, but I need help. In case you're wondering what text I'm referring to, it is the <H1> text in the upper-left corner of the main content area. Quote -Dorian Link to comment Share on other sites More sharing options...
Jack_mcs Posted February 6, 2011 Author Share Posted February 6, 2011 I migrated from HTC to Header Tags SEO v3.2.5 and have come across a strange problem. Some of the category pages will display the value of the categories_description.categories_htc_title_tag field for the page's HEADING_TITLE and other category pages will display the word "Categories" in this location. Been working about 15 hours today to make this work so I'm probably overlooking something easy, but I need help. In case you're wondering what text I'm referring to, it is the <H1> text in the upper-left corner of the main content area. Depending upon your version of HTC, it may not have had all of the category fields filled in. Try running fill tags->Fill Empty and see if that helpd. Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Follkes Posted February 6, 2011 Share Posted February 6, 2011 Yes, I see that here too. There seems to be something overriding the default align left attribute. I tried making some basic changes, even edited the css class for admin, but it didn't help so I don't have an answer right now. I'll put this in the list of things to look at for the next version. Yep, upgraded to 5.2.5 and now I see canonical tag in main correctly. GREAT CONTRIBUTION! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.