Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Header Tags SEO


Jack_mcs

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

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

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

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

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

Link to comment
Share on other sites

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 920

Cannot 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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

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

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

Link to comment
Share on other sites

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.

I have built an online store solely with the help of this forum.

Link to comment
Share on other sites

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.

I have built an online store solely with the help of this forum.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

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

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.

I have built an online store solely with the help of this forum.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

It means you made a mistake in the installation. The test results are not recognizing STS so that is where I would start.

 

Jack

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

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...