Jump to content
Jack_mcs

Header Tags SEO

Recommended Posts

I wondered if anyone had come across this error when trying to add a pseudo page

 

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

That means there is a missing database entry. I'm assuming you upgraded from a previous version since the entry is in the last version. Search the update files for it to find the database changes you need to make.

Share this post


Link to post
Share on other sites

Hi

 

This is a basic SQL problem but it's related to Header Tags 3.2.5 and it's also baffling. Everything has been installed and working for a few months but now I need to add some custom text to the products_head_keywords_tag field.

 

I need to append the same 5 keywords to 1400 products so rather than do each individually, I went into PHPmyadmin and exported the products_description table to excel.

 

So... my excel sheet is finished and I have a txt file with the SQL statements. It runs in PHPmyadmin with no errors, I look at the table and my new keywords are there.

 

The problem is that my product pages don't pick up the new info. The info is there in PHPmyadmin and also in my Admin section. I've tried

 

update products_description set products_head_keywords_tag=concat(products_head_keywords_tag,' keyword, keyword') where product_id=;etc etc

 

and

 

update products_description set products_head_keywords_tag=existing values for products_head_keywords_tag, keyword, keyword';

 

Both these work on my local test site with XAMPP but NOT on my LIVE site. The baffling thing is that if I edit and update the products in my Admin panel, without changing anything, they are then shown in the source of my product pages.

 

Obviously, i've cleared the cache, rebooted, tried with Firefox but they are still not shown.Even more baffling is that I backed up my LIVE database, restored it locally, ran my SQL with no errors, tried a few product pages and Yippee my new keywords are there. Restored back to my LIVE site and... Nope, they're not shown. Again, they are shown in my Admin panel and in PHPmyadmin and again if I edit and update the products in my Admin panel, without changing anything, they are then shown in the source of my product pages.

 

As a test I tried

update products_description set products_description='liwurfdhwwoafhgrfdv oliergjo t543563aerdf' where product_id=;etc etc

 

That WORKS first time, locally and live. Why is it just the header tags?

 

Hope someone can put me out of my misery

 

Ian

Share this post


Link to post
Share on other sites

That WORKS first time, locally and live. Why is it just the header tags?

If, after the change to the database, you go to the products edit page for one of those products and the keywords are there, in proper format, then something must be wrong with your installation. Otherwise, something is wrong with the database changes. The recommended way for making such a change is with Easy Populate, which has a setting for this contribution. It is easier, in my opinion, and less likely to cause problems. For 1,400 products the upload may fail, depending upon your server but you can use the split option to accomplish it.

Share this post


Link to post
Share on other sites

If, after the change to the database, you go to the products edit page for one of those products and the keywords are there, in proper format, then something must be wrong with your installation. Otherwise, something is wrong with the database changes. The recommended way for making such a change is with Easy Populate, which has a setting for this contribution. It is easier, in my opinion, and less likely to cause problems. For 1,400 products the upload may fail, depending upon your server but you can use the split option to accomplish it.

 

Doh!! it was me. My local test site and live site got out of sync. Wasn't really ready to add the new features to live store but did update live admin section. Thats what the problem was. Both sites are now sync'd

 

Thanks

 

Ian

Share this post


Link to post
Share on other sites

Anyone have a minute to help me out with something?

It seems that all of my French and German URLS (see underlined below) are getting redirected to the English equivalent URL. This means that the French and German are no longer getting picked up in Google. Big problem for me!

Is there a setting I can change in Header Tags SEO?

Thanks :)

Carolyn

 

----------------------------

This is how Googlebot fetched the page.

 

URL: http://www.jubilane.ch/schwangerschaft-c-52.html

Date: Mon Nov 08 03:47:00 PST 2010

 

Googlebot Type: Web

 

HTTP/1.0 301 Moved Permanently

Date: Mon, 08 Nov 2010 11:47:01 GMT

Server: Apache/2.2.17

Set-Cookie: cookie_test=please_accept_for_session; expires=Wed, 08-Dec-2010 11:47:01 GMT; path=/; domain=www.jubilane.ch

Location: http://www.jubilane.ch/preconception-pregnancy-c-52.htmlConnection: close

Content-Type: text/html


Carolyn

Share this post


Link to post
Share on other sites

Anyone have a minute to help me out with something?

It seems that all of my French and German URLS (see underlined below) are getting redirected to the English equivalent URL. This means that the French and German are no longer getting picked up in Google. Big problem for me!

Is there a setting I can change in Header Tags SEO?

This contribution doesn't have any thing to do with urls and redirection.

Share this post


Link to post
Share on other sites

Hi gents,

 

I need some help.

I am on HTS 3.5, I had the same problem in 3.4.

 

When I run a test on any of my pages I get the following:

 

Test Results

languages in the Header Tags table are: 1 ( English ).

Title and Meta Tag results for index.php explain

English

From Site:

Title ->

Meta Description ->

Meta Keywords ->

From Settings:

Title -> OrganiCulture - Organic Italian Product in the UK

Meta Description -> Organic Italian Products delivery in the UK guaranteed by International Certifications. Buy online today. Free Shipping for orders over 50£

Meta Keywords -> Organic Italian Product, Eco friendly, Natural organic cosmetics, Organic Beauty Products, Organic baby products, Organic Skin Care, Organic food, italian food online, food delivery, delicatessen, extra virgin olive oil, marmalade, pesto, uk

 

Results of scan:

index.php is missing Header Tags code or it is not installed correctly. Verify that Fill Tags has been ran and that the root checkbox or the default checkboxes have been checked in Page Control.

 

From Site is all highlighted in red while from settings is in yellow.

Is that normal? Any ideas on what can I have done wrong? I saw in this thread someone with a similar problem but not answer.

 

Just to let you know Google indexes my page using the correct tags.

 

I am not sure if this is a real problem or a red herrings.

 

Any help is really appreciated.

Cheers

JK

Share this post


Link to post
Share on other sites

From Site is all highlighted in red while from settings is in yellow.

Is that normal? Any ideas on what can I have done wrong? I saw in this thread someone with a similar problem but not answer.

 

Just to let you know Google indexes my page using the correct tags.

 

I am not sure if this is a real problem or a red herrings.

Perhaps there is something wrong with your installation or the provided code doesn't work with your php version or your host has some setting set so that it is preventing the code from working but if the title and tags show up on the actual page, then it a non-issue.

Share this post


Link to post
Share on other sites

Hi Jack_mcs!

 

In the beginning of the included instructions it says "The Search Engine Frienly option in admin->Configuration must be off to use this conribution". I use the Ultimate SEO v2.2d contribution, should i set "Enable SEO URL's" to off or does it mean something else?

 

In Admin-->Configuration-->My Store, the "Use Search-Engine Safe URLs (still in development)" option is already set to false.

 

Thanks in advance ¨-)

Share this post


Link to post
Share on other sites

Hi Jack_mcs!

 

In the beginning of the included instructions it says "The Search Engine Frienly option in admin->Configuration must be off to use this conribution". I use the Ultimate SEO v2.2d contribution, should i set "Enable SEO URL's" to off or does it mean something else?

 

In Admin-->Configuration-->My Store, the "Use Search-Engine Safe URLs (still in development)" option is already set to false.

It is referring to Admin-->Configuration-->My Store, the "Use Search-Engine Safe URLs. Your version of Ultimate SEO will turn that option off automatically so you don't have to do anything.

Share this post


Link to post
Share on other sites

It is referring to Admin-->Configuration-->My Store, the "Use Search-Engine Safe URLs. Your version of Ultimate SEO will turn that option off automatically so you don't have to do anything.

Good, thanx, i will go on with the Header Tags SEO v3.2.5 installation then :-)

Share this post


Link to post
Share on other sites

Hi Jack

 

I have osc 2.2 MS2 & Header Tags Controller v2.6.3 at the moment.

 

Do I need to upgrade to merchant v2.3.1 before I tackle updating my Header tags?

 

Do I just need to use this contribution without doing anything else i.e. I don't have to undo anything from the header tags controller I already have installed? I says it isn't compatible?

 

http://addons.oscommerce.com/info/5851

 

Thanks

Share this post


Link to post
Share on other sites

Hi Jack

 

I have osc 2.2 MS2 & Header Tags Controller v2.6.3 at the moment.

 

Do I need to upgrade to merchant v2.3.1 before I tackle updating my Header tags?

 

Do I just need to use this contribution without doing anything else i.e. I don't have to undo anything from the header tags controller I already have installed? I says it isn't compatible?

 

http://addons.oscommerce.com/info/5851

 

Thanks

If you are going to upgrade your shop to 2.3.1, it won't work with HTC and there aren't any instructions for upgrading HTC to the 2.3 version so you'll need to do a new install. Although for the database changes, you'll need to apply all of the database patches in the update files in order to not lose any of the Header Tags data. If you are not going to update to 2.3.1, then you can do the same thing but use the MS2 set of instructions.

Share this post


Link to post
Share on other sites

Hi Jack,

i have noticed a problem that i had not before. My product description is not filled probably.

When i fill products meta description with products description then i get in german language only the product title filled into the meta desription insteed of my product description. For english language everything is fine. What could be the issue? Any Idea?


getshoes.de your Streetwear Store

Share this post


Link to post
Share on other sites

Hi Jack,

i have noticed a problem that i had not before. My product description is not filled probably.

When i fill products meta description with products description then i get in german language only the product title filled into the meta desription insteed of my product description. For english language everything is fine. What could be the issue? Any Idea?

It was my fault, i have to set english to get the german tags filled.


getshoes.de your Streetwear Store

Share this post


Link to post
Share on other sites

Hi Jack!

 

I have osc 2.2 MS2 (standard, no templates), i have uploaded the sql file & completed the installation of the catalog part. I see no "Replace me in Page Control under index.php" message (in fact i see no changes at all for now), but i guess that this is because my default language doesn't have id 1 (it has id 4). Before i go on to the admin part, i have one question:

 

In the product_info.php, if i add

 

<?php /*** Begin Header Tags SEO ***/ ?>

<tr>

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

</tr>

<tr>

<td class="smallText" align="center"><?php echo TEXT_VIEWING; ?> 

<?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>

</tr>

<?php /*** End Header Tags SEO ***/ ?>

 

above

 

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

<!-- body_text_eof //-->

 

then on the product page the right column of my site is shown to the bottom of the page (centered).

What am i doing wrong?

Thanx!

Edited by Vassilis

Share this post


Link to post
Share on other sites

Hi Jack_mcs,

 

Thanks for your quick reply.

I could not see anything wrong in the install itself: I have review the code multiple time and again if all the metatag are filled I suspect that the code is fine. Is there any particular settings that need to be enable on the server?

My PHP version is 5.2.14.

 

Another problem that I have noticed in the test is the following:

 

Title length warning: (Suggested range is 60 to 120 characters) explain

 

for English

The Title for Argan Oil LIP BALM - 5.7 ml - I Provenzali Bio may be too short. It is 46 characters long.

 

for English

The Title for Pure Argan OIL - 50 ml - I Provenzali Bio may be too short. It is 41 characters long.

The Title for Organic EXTRA VIRGIN OLIVE OIL "Zahir" - 0.5 l - San Comaio may be too short. It is 59 characters long.

The Title for Organic BODY OIL -125 ml - NATURAL SENSE' for your Bebe' may be too short. It is 56 characters long.

The Title for Delicate LAUNDRY - 1000 ml - NATURAL SENSE' for your Bebe' may be too short. It is 58 characters long.

The Title for Organic BATH FOAM - 200ml - NATURAL SENSE' for your Bebe' may be too short. It is 57 characters long.

The Title for Organic SHAMPOO - 200 ml - NATURAL SENSE' for your Bebe' may be too short. It is 56 characters long.

The Title for DISHES & TABLEWARE Detergent - 1000 ml - Folia may be too short. It is 46 characters long.

The Title for DISHWASHER Detergent - 1000 ml - Folia may be too short. It is 38 characters long.

The Title for FLOORS & HARD SURFACES Detergent - 1000 ml - Folia may be too short. It is 50 characters long.

The Title for HANDWASH & WASHING MACHINE Detergent - 2000 ml - Folia may be too short. It is 54 characters long.

The Title for Multiuse with Active Oxygen may be too short. It is 27 characters long.

The Title for "Fiori d'Arancia" MARMALADE - 240 gr - BioAgricola Ferraro may be too short. It is 58 characters long.

The Title for Argan Oil BEAUTY SOAP - 250 gr - I Provenzali Bio may be too short. It is 49 characters long.

The Title for Argan Oil BODY GEL - 125 ml - I Provenzali Bio may be too short. It is 46 characters long.

The Title for Pure Argan BUTTER - 75 ml - I Provenzali Bio may be too short. It is 44 characters long.

 

 

 

Meta Description length warning: (Suggested range is 15 to 300 characters) explain

 

for English

The Meta Description for Pure Argan OIL - 50 ml - I Provenzali Bio may be too long. It is 351 characters long.

 

for English

The Meta Description for Organic EXTRA VIRGIN OLIVE OIL "Zahir" - Special Edition - 0.5 l - San Comaio may be too long. It is 304 characters long.

The Meta Description for Organic RED PESTO in Extra Virgin Olive Oil - 180 gr - Artigiana Genovese may be too long. It is 305 characters long.

The Meta Description for Organic SHAMPOO - 200 ml - NATURAL SENSE' for your Bebe' may be too long. It is 383 characters long.

The Meta Description for Organic GENOESE PESTO in Extra Virgin Olive Oil - 180 gr - Artigiana Genovese may be too long. It is 349 characters long.

The Meta Description for Argan Oil BEAUTY SOAP - 250 gr - I Provenzali Bio may be too long. It is 324 characters long.

 

If you actually count the number of char, it does not match the number of char shown by the test.

Is this a known issue?

 

Any ideas on where to check?

Thanks again in advance for all your help.

 

Cheers

JK

 

Perhaps there is something wrong with your installation or the provided code doesn't work with your php version or your host has some setting set so that it is preventing the code from working but if the title and tags show up on the actual page, then it a non-issue.

Share this post


Link to post
Share on other sites

I have osc 2.2 MS2 (standard, no templates), i have uploaded the sql file & completed the installation of the catalog part. I see no "Replace me in Page Control under index.php" message (in fact i see no changes at all for now), but i guess that this is because my default language doesn't have id 1 (it has id 4). Before i go on to the admin part, i have one question:

 

then on the product page the right column of my site is shown to the bottom of the page (centered).

What am i doing wrong?

For the language problem, when you finish the admin login run the test function and there will be a way to fix it. You can do so beforehand by altering the database file but that's extra work and not necessary.

 

If you are using a standard shop (means no STS too), then you must have made a mistake with where the code was placed. There is an included file that you can use to compare against with a program like WinMerge.

Share this post


Link to post
Share on other sites

For the language problem, when you finish the admin login run the test function and there will be a way to fix it. You can do so beforehand by altering the database file but that's extra work and not necessary.

 

If you are using a standard shop (means no STS too), then you must have made a mistake with where the code was placed. There is an included file that you can use to compare against with a program like WinMerge.

I corrected the above right column problem concerning product_info.php by using the code from the 'new shop' file which is slightly different than the code in the instructions:

 

New Shop code (ms2, less than 2.3):

<?php /*** Begin Header Tags SEO ***/ ?>

<tr>

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

</tr>

<tr>

<td class="smallText" align="center"><?php echo TEXT_VIEWING; ?> 

<?php if (! tep_not_null($header_tags_array['title'])) $header_tags_array['title'] = $product_info['products_name'];

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>

</tr>

<?php /*** End Header Tags SEO ***/ ?>

 

Instructions code (ms2, less than 2.3):

<?php /*** Begin Header Tags SEO ***/ ?>

<tr>

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

</tr>

<tr>

<td class="smallText" align="center"><?php echo TEXT_VIEWING; ?> 

<?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>

</tr>

<?php /*** End Header Tags SEO ***/ ?>

 

:-)

Edited by Vassilis

Share this post


Link to post
Share on other sites

Hi Jack

 

I think I am going to have to start again with a fresh install of 2.3.1 :(

I will then do a fresh install for this new version instead of HTC. Hope it goes as well as it did before!

I also have Ultimate SEO URLSs v2.1c as suggested by you to work with HTC. Is this the same version to go with your HTS on a 2.3.1?

 

Thanks

Julie

Share this post


Link to post
Share on other sites

Hi Jack

 

I think I am going to have to start again with a fresh install of 2.3.1 :(

I will then do a fresh install for this new version instead of HTC. Hope it goes as well as it did before!

I also have Ultimate SEO URLSs v2.1c as suggested by you to work with HTC. Is this the same version to go with your HTS on a 2.3.1?

No, that version has problems and should be replaced no matter what else you do. I recommend using Ultimate SEO V 2.2d (be sure not to grab the Polish version though).

Share this post


Link to post
Share on other sites

I installed carefully everything and the contribution seems to work perfectly fine!!! I just need to check the 'How to operate" instructions in order to take the best out of it. In my humble opinion, this contribution is professional's work, detailed and established in the most convenient and efficient way for all users.

 

Jack, thank you, u have my full respect :-)

Share this post


Link to post
Share on other sites

Jack_mcs - Thanks so much for your help so far!!!

 

Couple more questions

 

vnjrqe.jpg

 

 

The stuff in the red boxes = problems...

 

Any Recommendations??

 

And also on the front page it also now says

 

" What's New Here? " and a picture beside it which it never ust to say..

 

Any suggestions??

 

Thanks so much for your help,

 

Jono

Share this post


Link to post
Share on other sites

I installed carefully everything and the contribution seems to work perfectly fine!!! I just need to check the 'How to operate" instructions in order to take the best out of it. In my humble opinion, this contribution is professional's work, detailed and established in the most convenient and efficient way for all users.

 

Jack, thank you, u have my full respect :-)

Thank you for the kind words. They are appreciated.

Share this post


Link to post
Share on other sites

The stuff in the red boxes = problems...

 

Any Recommendations??

 

And also on the front page it also now says

 

" What's New Here? " and a picture beside it which it never ust to say..

The < and $text viewing in the boxes are coding mistakes. You need to check the changes you made on that page. I don't see anything regarding a What's New statement but that isn't something the contribution adds.

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

×