Guest Posted December 3, 2008 Share Posted December 3, 2008 Hi Jack: Actually, that was my bad. I skipped renaming 'header tags controller' to 'header tags seo' or something like that. That's fixed. But, I've gone thru the steps again and I have one big issue remaining. When I click on Header Tags SEO in Admin, I get hit with this: 1054 - Unknown column 'manufacturers_htc_title_tag' in 'where clause' select mi.manufacturers_id, mi.languages_id, m.manufacturers_name from manufacturers_info mi left join manufacturers m on (mi.manufacturers_id = m.manufacturers_id) where (manufacturers_htc_title_tag = '' or manufacturers_htc_desc_tag = '' or manufacturers_htc_keywords_tag = '' ) It's almost like I need another SQL to update the manufacturers table in my database. Or...something. LOL. - Andrea Quote Link to comment Share on other sites More sharing options...
Guest Posted December 3, 2008 Share Posted December 3, 2008 I can see when I look at the original SQL file that comes with it, that my update SQL is missing this: ALTER TABLE products_description ADD products_head_title_tag VARCHAR(80) NULL; ALTER TABLE products_description ADD products_head_desc_tag LONGTEXT NULL; ALTER TABLE products_description ADD products_head_keywords_tag LONGTEXT NULL; ALTER TABLE categories_description ADD categories_htc_title_tag VARCHAR(80) NULL; ALTER TABLE categories_description ADD categories_htc_desc_tag LONGTEXT NULL; ALTER TABLE categories_description ADD categories_htc_keywords_tag LONGTEXT NULL; ALTER TABLE categories_description ADD categories_htc_description LONGTEXT NULL; ALTER TABLE manufacturers_info ADD manufacturers_htc_title_tag VARCHAR(80) NULL; ALTER TABLE manufacturers_info ADD manufacturers_htc_desc_tag LONGTEXT NULL; ALTER TABLE manufacturers_info ADD manufacturers_htc_keywords_tag LONGTEXT NULL; ALTER TABLE manufacturers_info ADD manufacturers_htc_description LONGTEXT NULL; Should I just try running that? - Andrea Quote Link to comment Share on other sites More sharing options...
Guest Posted December 3, 2008 Share Posted December 3, 2008 Me again. I saw when looking at the database that I had all the entries in the categories description and products description tables, but none of the entries were in the manufacturers info table, so I ran this part: ALTER TABLE manufacturers_info ADD manufacturers_htc_title_tag VARCHAR(80) NULL; ALTER TABLE manufacturers_info ADD manufacturers_htc_desc_tag LONGTEXT NULL; ALTER TABLE manufacturers_info ADD manufacturers_htc_keywords_tag LONGTEXT NULL; ALTER TABLE manufacturers_info ADD manufacturers_htc_description LONGTEXT NULL; And now I'm in. I have yet to do the final step, the one where I use the header_tags_seo_convert.php file so...here goes! - Andrea Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted December 3, 2008 Author Share Posted December 3, 2008 Yes, you need those if you are updating from an old version. But to clarigy something, you said, "I skipped renaming 'header tags controller' to 'header tags seo' ...." The files are completely different and shouldn't be renamed. It is good that you skipped that. Just be sure you don't go back and do it. Jack 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...
Guest Posted December 3, 2008 Share Posted December 3, 2008 I'm running into all kinds of things now. LOL. For example, my Latest News contrib at news.html and eBay Auctions at current_auctions.html will not load onscreen. I get this: Fatal error: Call to undefined function: tep_header_tag_page() in /home/xxxxx/xxxxx/xxxxx/includes/header_tags.php on line 353 Everything appears to have transferred fine, all of the previous header tags. I don't know why these other pages are throwing this error. They're appearing just fine in the Header Tags section in Admin. ??? - Andrea Quote Link to comment Share on other sites More sharing options...
Guest Posted December 3, 2008 Share Posted December 3, 2008 I'm sorry...please ignore my last post. I'm an idiot. I neglected to replace my old includes>header_tags.php file with the new one. Geez. All is well...except one teeny tiny thing. There are some instructions in the upgrade text regarding catalog>product_info.php that read like this: 15) Find the following line in catalog/product_info.php <a name="<?php echo $tags_array['title']; ?>"></a> Replace with <?php /*** Begin Header Tags SEO ***/ ?> <a name="<?php echo $header_tags_array['title']; ?>"></a> <?php /*** End Header Tags SEO ***/ ?> 16) Find the following line in catalog/product_info.php <?php echo '<a title="' . $tags_array['title'] . '" href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $product_info['products_id'], 'NONSSL') . '"/# ' . $tags_array['title'] . '">' . $tags_array['title']; ?></a></td> Replace with <?php echo '<a title="' . $header_tags_array['title'] . '" href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $product_info['products_id'], 'NONSSL') . '"/# ' . $header_tags_array['title'] . '">' . $header_tags_array['title']; ?></a></td> Problem is...I don't have any of that existing code. I did take the first one in step 15 and slap it into a place near the top of my file that originally read as: <?php // BOF: WebMakers.com Changed: Header Tag Controller v2.5.2 // Replaced by header_tags.php if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) { require(DIR_WS_INCLUDES . 'header_tags.php'); } else { ?> <title><?php echo TITLE; ?></title> <?php } // EOF: WebMakers.com Changed: Header Tag Controller v2.5.2 ?> That seems fine, but I don't know what to do with step 16. I don't have that line anywhere in the file. The only code I can find...with any mention of FILENAME_PRODUCT_INFO reads as this: <td width="100%" valign="top"><?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"> Doesn't seem to be hurting without that code from step 16. The header tags from the items are appearing just fine at the top of the screen. What does it do and do I really need it? - Andrea Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted December 3, 2008 Author Share Posted December 3, 2008 It adds a link to the page. it is not required but useful for SEO purposes. If you want to install it, just use the instructions in the Install_Catalog.txt file since those are for a new installation which, in the case of that code, it is. Jack 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...
Guest Posted December 3, 2008 Share Posted December 3, 2008 The only strange...or I should probably say different...thing I'm noticing with my product listings is that instead of having: My Store - Name Of Product at the top of the screen when viewing a listing, I now have: http://www.mystore.com/name-of-product.html It's not so bad, really...especially because I have SEO-G urls installed, so...keywords in the urls are useful there. It's just odd how instead of what I posted above, the header tag onscreen is a URL. And I haven't changed anything since I last posted. All I did was enter step 15 in place of what I had. Step 16 still remains undone. When I go into Admin and actually edit a product, everything looks just as it did before. I will have inserted Name of Product in the Product Title Tag field but, the header tags is not picking up what I typed in. It's picking up the full-on URL of the product in the website. Is that supposed to be happening? I'm sorry if I'm driving you nuts. I promise to stop soon. :) - Andrea Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted December 3, 2008 Author Share Posted December 3, 2008 It shouldn't have the url. Did you run fill tags (use fill empty so your previous ones are not overwritten). Jack 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...
Guest Posted December 3, 2008 Share Posted December 3, 2008 I went to Header Tags SEO > Fill Tags and then I selected the circle at the bottom of the screen for Fill Only Empty Tags under the Products heading. Nothing happened. Just reloaded the same page. I can see when I choose to select and edit any product that all of the tags are there. It's just not picking them up onscreen. It's showing a URL instead. Would it have anything to do with my permission error, this is appearing at the top of Admin when I'm in Header Tags: Warning: chmod() [function.chmod]: Operation not permitted in /home/xxx/xxx/xxx/admin/includes/functions/header_tags.php on line 920Cannot change the permission on /home/xxx/xxx/xxx/includes/header_tags.php I've noticed when clicking around that my individual pages, like Conditions and Privacy are not picking up their pre-filled tags, either. It's all defaulting to the tags written for the homepage of the site. I looked at the upgrade instructions again and there is something there about troubleshooting and fixing it. Problem is...the code in my admin/includes/functions/header_tags.php file is nothing like the one being referenced in the fix-it text. It says to do this: Around line 201 you find this code: if (!is_writable($filename)) { if (!chmod($filename, 0666)) { echo "Cannot change the mode of file ($filename)"; exit; } } Replace that with the following code: if (!is_writable($filename)) { echo "The file isn't writable"; exit; /* if (!chmod($filename, 0666)) { echo "Cannot change the mode of file ($filename)"; exit; } */ } The file is one of the new files I uploaded. Mine says: if (!is_writable($filename)) { if (!chmod($filename, 0666)) { echo sprintf(ERROR_CANT_CHMOD, $filename); return false; } } I wonder if that's why I'm unable to apply any changes. I used FTP to change the file permission on includes/header_tags.php but I'm still getting this at the top of the screen, along with the other one I posted: Permissions settings for the /home/xxx/xxx/xxx/includes/header_tags.php file appear to be incorrect. Change to 777 It didn't change. It's sitting with permissions of 644. - Andrea Quote Link to comment Share on other sites More sharing options...
Guest Posted December 3, 2008 Share Posted December 3, 2008 I ran the Test thingy in Header Tags SEO and it came back with this: Permissions Error: Permissions settings for the /home/xxx/xxx/xxx/includes/header_tags.php file appear to be incorrect. Change to 777. NOTE: Disregard if on Windows server. Missing Code in File The Header Tags head code for the product_info.php file cannot be found. Database/File Mismatch Error: The number of file entries in the database (33) does not match the number in the includes/header_tags.php file (6). Files not in the includes/header_tags.php file: 0 1 advanced_search.php articles.php conditions.php contact_us.php cookie_usage.php current_auctions.php email.php faq.php guidelines.php info_shopping_cart.php links.php linkshare.php military.php news.php order_info.php popup_shipping.php privacy.php products_new.php reviews.php revisions.php search_tips.php shipping.php shopping_cart.php site_search.php stock.php This is messy, huh? - Andrea Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted December 3, 2008 Author Share Posted December 3, 2008 The files will mismatch if the includes/header_tags.php file is not writeable and it won't be writeable if the permissions are wrong. Fix the obvious first and go from there. Jack 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...
Guest Posted December 3, 2008 Share Posted December 3, 2008 I swear that I changed the file permissions via FTP from 644 to 755 and what appeared to 'take' did not. I don't know why. I tried again, via FTP, and they suddenly 'took'. ??? I fear my product_info.php file may be a mess (nothing like the ones in either install folder), but the errors when running the Test in Header Tags SEO have diminished considerably. I only have two lousy files being listed as not included in header_tags.php, and I really don't care about either of them. I can add them later. The individual products are now showing their proper header tags, as well. But, I am surprised. I reverted back to what I had originally with Header Tags version 2.5.2 in order for it to work. Go figure. I am THRILLED to see that I can add individual Latest News tidbits and have header tags appear showing the titles of those mini-articles. So...Thank You for writing this! I'm sorry I drove you up the wall... - Andrea Quote Link to comment Share on other sites More sharing options...
BarrySmith Posted December 3, 2008 Share Posted December 3, 2008 Hi Jack, I think I was not too good at explaining what I meant earlier! In the title on the web browser I would like to add some words that suit the actual product. For example, if I am selling red glof balls, I would like to add red gold balls from Nike, Adidas etc. Is this possible? And if so would really appreciate some guidance. Kind regards. Barry. Quote I have built an online store solely with the help of this forum. Link to comment Share on other sites More sharing options...
BarrySmith Posted December 3, 2008 Share Posted December 3, 2008 Hi Jack, I think I was not too good at explaining what I meant earlier! In the title on the web browser I would like to add some words that suit the actual product. For example, if I am selling red golf balls, I would like to add red gold balls from Nike, Adidas etc. Also I have a good idea of what meta tages to use for the different products. Can this also be added? Is this possible? And if so would really appreciate some guidance. Kind regards. Barry. Quote I have built an online store solely with the help of this forum. Link to comment Share on other sites More sharing options...
www.in.no Posted December 3, 2008 Share Posted December 3, 2008 Hi Arild,Sorry I'm very new to all this could you tell me what "The only thing is that i have to check "root" to get information to show. If i uncheck "root" it goes blank." means. If yopu go to page controle and select the file from the drop down menu, you get the form for how to handle the different options for SEO one is named root in the lower right corner. I have to check this to get it working correctly on the pseudo page - information page unlimited. Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted December 3, 2008 Author Share Posted December 3, 2008 Hi Jack, I think I was not too good at explaining what I meant earlier! In the title on the web browser I would like to add some words that suit the actual product. For example, if I am selling red glof balls, I would like to add red gold balls from Nike, Adidas etc. Is this possible? And if so would really appreciate some guidance. Kind regards. Barry. You would need to edit the title in theproducts edit page or use the Generic Override in Fill Tags. Jack 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...
BarrySmith Posted December 4, 2008 Share Posted December 4, 2008 You would need to edit the title in theproducts edit page or use the Generic Override in Fill Tags. Jack Thanks Jack, I shall try not to trouble you again. Regarding amending the product page are you referring to oscommerce or the headertage seo contribution? Regards. Barry. Quote I have built an online store solely with the help of this forum. Link to comment Share on other sites More sharing options...
Jack_mcs Posted December 4, 2008 Author Share Posted December 4, 2008 The products edit page is in admin->Catalog. The Fill Tags page is in admin->Header Tags SEO. Jack 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...
dtblkg35 Posted December 4, 2008 Share Posted December 4, 2008 I need a little help. i have quickly looked over the fourm post and did not see my error right away, so I am sorry if this has been answered. IF has been answered then please just point me to what page the fix is on. I have installed a new shop, added STS, Ultimate URLS, and SID killer in short. I have made 3 attempts to add the Header Tags SEO and every time i get the same error. The error only happens when i go to the products detail page. Below is there error, please anyone with an idea how to fix this? Parse error: syntax error, unexpected T_CLASS in /home/xxxx/xxxxxx/includes/header_tags.php on line 233 When i run the "Test" i get the following info, but i know that i have made the changes to the index.php and product_info.php. Missing Code in File The Header Tags head code for the index.php file cannot be found. The Header Tags head code for the product_info.php file cannot be found. The Header Tags head code for the product_reviews.php file cannot be found. The Header Tags head code for the product_reviews_info.php file cannot be found. The Header Tags head code for the product_reviews_write.php file cannot be found. The Header Tags head code for the specials.php file cannot be found. Thank you for your help Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted December 4, 2008 Author Share Posted December 4, 2008 It means you made a mistake in the installation. The test results are not recognizing STS so that is where I would start. Jack 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...
Guest Posted December 5, 2008 Share Posted December 5, 2008 I have a question about the Social Bookmarks feature. When I run my mouse over the bookmark images on the product_info page, the mouseover text is running together at the beginning. The code for the first bookmark reads: <img src="images/socialbookmark/delicious.png" alt="<?php echo 'Add' . $NAME . ' to del.icio'; ?> " title="<?php echo 'Add' . $NAME. ' to del.icio'; ?> " border="0"></a></td> So, when I run my mouse over it, it reads: AddName Of Product to del.icio How can I insert a space between the word Add and Name of Product? So it reads: Add Name of Product to del.icio I've tried using and adding some spaces between the punctuation, but nothing seems to work. Also, there's a minor typo in the bookmarks module at the bottom of the file where the last two bookmarks are both being called the same name in the mouseover. They're both being called Redditt when the last one should be Ekstreme. - Andrea Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted December 5, 2008 Author Share Posted December 5, 2008 To fix those, change all instances of 'Add' to 'Add ' and change the last Redditt to Ekstreme. Jack 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...
Guest Posted December 5, 2008 Share Posted December 5, 2008 Thanks very much! I really love the pseudo-pages addition to this contrib, too; glad I installed it! - Andrea Quote Link to comment Share on other sites More sharing options...
xj-220 Posted December 5, 2008 Share Posted December 5, 2008 Hi Forum I’ve just installed Header Tags SEO V 3.0.7 and have a little problem. If I specify a category in the Header Tags under ‘Admin’, ‘Categories/Article’, I'm not able to delete it afterwards. Even deleting the information from the text field doesn’t work. Following tags can’t be deleted: Header Tags Category Title Header Tags Category Description Header Tags Category Keywords Header Tags Categories Description Can anybody help me with this? Best regards from germany 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.