Jump to content
Jack_mcs

Header Tags SEO

Recommended Posts

"1060 - Duplicate column name 'categories_htc_title_tag'

ALTER TABLE categories_description ADD categories_htc_title_tag VARCHAR(80) NULL;

[TEP STOP]"

That error means the database changes, or at least some of them, have already been made. If this is a new installation and you don't need to worry about existing header tags code in the database, then just run the uninstall and install database scripts and that will clear up that problem.

Share this post


Link to post
Share on other sites

Thanks a lot, Jack. It worked :thumbsup: Now I am able to carry on the remaining steps.

 

You mentioned the permission setting. Can you guide me where to change the permission setting whereas I am testing in my local machine (not on live)?? I only know where to change permission via host file manager not sure how to setup in local sever. :blush:

Thanks. organicme

Share this post


Link to post
Share on other sites

Thanks a lot, Jack. It worked :thumbsup: Now I am able to carry on the remaining steps.

 

You mentioned the permission setting. Can you guide me where to change the permission setting whereas I am testing in my local machine (not on live)?? I only know where to change permission via host file manager not sure how to setup in local sever. :blush:

Thanks. organicme

It doesn't matter on a local maching but if it is Windows, just set the files to read-only.

Share this post


Link to post
Share on other sites

Hi Jack,

I recently updated this mod as well as Ultimate urls and have a question. On certain categories I have a double title on the category page. This does not happen on each one. Any ideas what causes this? Here's a link to an example:http://www.lyonsperformance.com/test_site/valvetrain-components-c-132.html

Thanks,

Matt


If the only tool you have is a hammer, all your problems look like nails

Share this post


Link to post
Share on other sites

Hi Jack,

I recently updated this mod as well as Ultimate urls and have a question. On certain categories I have a double title on the category page. This does not happen on each one. Any ideas what causes this? Here's a link to an example:http://www.lyonsperformance.com/test_site/valvetrain-components-c-132.html

Thanks,

Matt

Header Tags doesn't control the url's so the problem is elsewhere in your code.

Share this post


Link to post
Share on other sites

A new version has been uploaded with these changes:

 

-> Added some more code to Fill Tags to show what was changed.

-> Added silo option. See admin->Header Tags SEO->Silo Control for details.

-> Fixed social bookmark code to prevent SID from being added to the url (pointed out by Carl (theintoy). Also added code to include the category name in the url for category pages.

-> Removed breadcrumb code from index.php in RC2 (found by gemcom).

Share this post


Link to post
Share on other sites

Hi, I am working on a pre-built shop with 3500 already installed products. I have the header seo tool installed and am having the following problem if anyone can help please :-)

 

I have had a good look into the SEO module attached to the website and can update products and categories at the site level with this without a problem.

 

Once this is updated with the basic information and i have a category called abc and a product called def, the title tag will now be displayed as abc - def

 

I can then go into the product and change the meta title tag to abc - what ever I want product to say

 

However, at the categoty level my title tag will only display as abc and when i update and add infromtion to this it will not update and just displays abc as the title tag

 

I can obviously populate categories with for example ITEMNAME – Buy ITEMNAME at Low Internet Prices but this in turn causes problems at the product level as this full sentence would then be placed before the actual product which then does not display in the title tag.

 

I have had a good look through all the settings and as far as I can see there should be no reason that the meta title does not update in the products and categories section the same way as products other than it just doesn’t make the requested changes.

 

If anyone can help it would be much appreciated.

Edited by davidgab

Share this post


Link to post
Share on other sites

However, at the categoty level my title tag will only display as abc and when i update and add infromtion to this it will not update and just displays abc as the title tag

If you can't edit a category, the problem is in the categories.php file. See the troubleshooting instructions for that.

Share this post


Link to post
Share on other sites

If you can't edit a category, the problem is in the categories.php file. See the troubleshooting instructions for that.

 

 

Thanks :-)

Share this post


Link to post
Share on other sites

Which boxes should be checked in the contribution header tags seo? I have Google, Language, NOODP, and NOYDR currently checked. Should revisit and robots also be checked?

 

Thank you in advance!


Flying away to get back to work.

Share this post


Link to post
Share on other sites

Which boxes should be checked in the contribution header tags seo? I have Google, Language, NOODP, and NOYDR currently checked. Should revisit and robots also be checked?

 

Thank you in advance!

Generally, all that is needed is NOODP, NOYDR and Canonical.

Share this post


Link to post
Share on other sites

5) In includes/languages/english.php (and whichever other language files you use)

 

FIND:

define('BOX_HEADER_TAGS_FILL_TAGS', 'Fill Tags');

 

ADD BENEATH:

define('BOX_HEADER_TAGS_SILO', 'Silo Control');

 

Hi Jack

Is the above correct in the upgrade instructions version 3.1.7 to

Header Tags SEO V 3.1.8 as I don't seem to have define('BOX_HEADER_TAGS_FILL_TAGS', 'Fill Tags') in includes/languages/english.php.

I do have

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

define('TEXT_SEE_MORE', 'See More');

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

includes/languages/english.php

 

Should it read admin/includes/languages/english.php

 

Thanks

 

WWW.anniedays.2ya.com

Share this post


Link to post
Share on other sites

5) In includes/languages/english.php (and whichever other language files you use)

 

FIND:

define('BOX_HEADER_TAGS_FILL_TAGS', 'Fill Tags');

 

ADD BENEATH:

define('BOX_HEADER_TAGS_SILO', 'Silo Control');

 

Should it read admin/includes/languages/english.php

Yes, it should be admin.

Share this post


Link to post
Share on other sites

Hi Jack

 

After installing HT SEO 3.1.7,I got an error message under catalog admin saying "Parse error: syntax error, unexpected T_DOUBLE_ARROW in C:\..\myadmin\categories.php on line 95

 

I then went through your suggestion in troubleshoot and threads with similar my problem I have. At the end, it seems to resolve the above issue after I replaced 2 files (categories, manufacturer)from your folder called "catalog_for_new_shop_only_MS2" Honestly,I am not sure if this is right action to take even though my shop is not new after several add-on installed. Not sure what other consequence I may deal later.

 

However, currently there are 2 remaining issues as far as I notice (as below);

1.The category description appears repeating (duplicate) in my shop

 

2.The results of 'Testing the Installation' remain the same. e.g Duplicate title found:/Duplicate meta description found:/Duplicate meta description found:/Title length warning: (Suggested range is 60 to 120 characters)

 

Somehow they seems to me the same issues but I've limited knowledge of php. It'd be really appreciated if you could advice me where or how to rectify those issues. Thanks a lot. organicme

Share this post


Link to post
Share on other sites

Hi, i've a problem with Header Tags SEO.

i got 2 languages in my osc. tags added in admin are showing only in german language in live shop. in english i got no tags at all. no title, meta, etc.

checked the install steps twice and everything is fine. any ideas guys?

Share this post


Link to post
Share on other sites

Hi Jack

 

After installing HT SEO 3.1.7,I got an error message under catalog admin saying "Parse error: syntax error, unexpected T_DOUBLE_ARROW in C:\..\myadmin\categories.php on line 95

You should install 3.1.8.

 

I then went through your suggestion in troubleshoot and threads with similar my problem I have. At the end, it seems to resolve the above issue after I replaced 2 files (categories, manufacturer)from your folder called "catalog_for_new_shop_only_MS2" Honestly,I am not sure if this is right action to take even though my shop is not new after several add-on installed. Not sure what other consequence I may deal later.

They could be significant. You can't just replace files like that unless you know it is safe. That troubleshooting procedure is to just show where the problem is at and to aid in finding it. You should replace the original files and do the manual install for them again to avoid other problems.

 

However, currently there are 2 remaining issues as far as I notice (as below);

1.The category description appears repeating (duplicate) in my shop

It means you made a mistake in the installation.

 

2.The results of 'Testing the Installation' remain the same. e.g Duplicate title found:/Duplicate meta description found:/Duplicate meta description found:/Title length warning: (Suggested range is 60 to 120 characters)

You have to look at the actual links and determine if those are actually errors. Duplicate values may be OK.

Share this post


Link to post
Share on other sites

Hi, i've a problem with Header Tags SEO.

i got 2 languages in my osc. tags added in admin are showing only in german language in live shop. in english i got no tags at all. no title, meta, etc.

checked the install steps twice and everything is fine. any ideas guys?

Do the titles show up in admin for english? If not, you probably have some error with your languages setup. if they do, then you've probably made a mistake with the installation on the shop side.

Share this post


Link to post
Share on other sites

in german test is ok. in english i got that- Database/File Mismatch Error: explain

The number of file entries in the database (26) does not match the number in the includes/header_tags.php file (32).

Files not in the database:

index.php

product_info.php

product_reviews.php

product_reviews_info.php

product_reviews_write.php

specials.php

 

but when i click add missing pages in page control there is none

Share this post


Link to post
Share on other sites

in german test is ok. in english i got that- Database/File Mismatch Error: explain

The number of file entries in the database (26) does not match the number in the includes/header_tags.php file (32).

Files not in the database:

index.php

product_info.php

product_reviews.php

product_reviews_info.php

product_reviews_write.php

specials.php

 

but when i click add missing pages in page control there is none

Without those files in the database for english, the code won't work for english. Try running the uninstall and install scripts and then run Fill Tags. That should set it up correctly. It will erase any changes you have made to Header Tags in the database though, if that matters.

Share this post


Link to post
Share on other sites

You should install 3.1.8.They could be significant. You can't just replace files like that unless you know it is safe. That troubleshooting procedure is to just show where the problem is at and to aid in finding it. You should replace the original files and do the manual install for them again to avoid other problems.

It means you made a mistake in the installation.

You have to look at the actual links and determine if those are actually errors. Duplicate values may be OK.

Hi Jack, Thanks for your advice. As suggested, I have 3.1.8 installed just now and have played around in localhost and admin panel. There are some errors where I have no idea how to fit and would appreciate if you can point me out how to fit it.

 

1.Under Admin Panel->Header Controller->Text Control: Should I worry this? After all, I'm going to use SEO instead of Header controller.

 

Fatal error: Call to undefined function GetMainArgument() in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\sand_myadmin\header_tags_english.php on line 69

 

Line69: $main_title = GetMainArgument($fp[$idx], $main['title'], $formActive);

 

2. Under my shop: Parse error: syntax error, unexpected T_DNUMBER in C:\..\catalog\includes\header_tags.php on line226

 

In fact, there is no line 226 in my header_tags.php. I then used Winmerge to compare your file and mine. I realise that some extra lines exist in my file. Those extra lines are all php files I have under Catalog such as about_us.php (script shown as below), how to order etc. I then replace my file with yours taken from category folder and the problem seem resolved but only few mins. Later, the replaced file was overwrote. Those extra lines I had appear again. Can you point me how to rectify this issue?

 

// About_Us.php

case (basename($_SERVER['PHP_SELF']) === FILENAME_ABOUT_US):

$header_tags_array = tep_header_tag_page(FILENAME_ABOUT_US);

break;

 

3. Result from Test installation shows few errors applied to diff. php files;for instance

CRE or oscMax Error: CRE or oscMax is running and the head code in the index.php file has Header Tags code installed, which is a mistake.(same to product_info.php and few others)

As far as I know, my shop is regular oscommerce site not CRE or oscMax. Can you tell me where to resolve this error? :blink: Many thanks, organicme

Share this post


Link to post
Share on other sites

1.Under Admin Panel->Header Controller->Text Control: Should I worry this? After all, I'm going to use SEO instead of Header controller.

You've made a mistake in the upgrade. It may or may not be a problem - just depends on the mistakes made. I suggest fixing it though.

 

Fatal error: Call to undefined function GetMainArgument() in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\sand_myadmin\header_tags_english.php on line 69

 

Line69: $main_title = GetMainArgument($fp[$idx], $main['title'], $formActive);

That functions isn't part of Header Tags SEO nor is there a file named header_tags_english.php in the admin directory.

 

2. Under my shop: Parse error: syntax error, unexpected T_DNUMBER in C:\..\catalog\includes\header_tags.php on line226

 

In fact, there is no line 226 in my header_tags.php. I then used Winmerge to compare your file and mine. I realise that some extra lines exist in my file. Those extra lines are all php files I have under Catalog such as about_us.php (script shown as below), how to order etc. I then replace my file with yours taken from category folder and the problem seem resolved but only few mins. Later, the replaced file was overwrote. Those extra lines I had appear again. Can you point me how to rectify this issue?

 

// About_Us.php

case (basename($_SERVER['PHP_SELF']) === FILENAME_ABOUT_US):

$header_tags_array = tep_header_tag_page(FILENAME_ABOUT_US);

break;

Header Tags SEO is tryig to build the code for the extra pages but I suspect there is still HTC code in the shop, based on the above, causing the problem.

 

3. Result from Test installation shows few errors applied to diff. php files;for instance

CRE or oscMax Error: CRE or oscMax is running and the head code in the index.php file has Header Tags code installed, which is a mistake.(same to product_info.php and few others)

As far as I know, my shop is regular oscommerce site not CRE or oscMax. Can you tell me where to resolve this error? :blink: Many thanks, organicme

Someone else mentioned this but I can't duplicate it and others aren't having the problem. Fixing the installation errors may clear it up.

Share this post


Link to post
Share on other sites

Header Tags doesn't control the url's so the problem is elsewhere in your code.

 

Can anyone bee little bit more specific how and what i should write in all those empty fields in admin such as tags, description etc etc

 

It seems taht many fields are just dublets

Share this post


Link to post
Share on other sites

Can anyone bee little bit more specific how and what i should write in all those empty fields in admin such as tags, description etc etc

 

It seems taht many fields are just dublets

There shouldn't be any empty fields once Fill Tags is ran. If there is, something is not setup correctly.

Share this post


Link to post
Share on other sites

You've made a mistake in the upgrade. It may or may not be a problem - just depends on the mistakes made. I suggest fixing it though.

 

 

That functions isn't part of Header Tags SEO nor is there a file named header_tags_english.php in the admin directory.Header Tags SEO is tryig to build the code for the extra pages but I suspect there is still HTC code in the shop, based on the above, causing the problem.

Someone else mentioned this but I can't duplicate it and others aren't having the problem. Fixing the installation errors may clear it up.

 

Hi Jack, Thanks for taking time to answer my questions. Honestly,I still couldn't figure out the root causes for those issues. I can kinda seeing the effect from having HTC and SEO in the same time. I wonder if I could eliminate the problems by removing HTC at once? if possible, then how.

 

In addition, your SEO contribution contains one folder named "Update_Docs". I have not added anything from that folder since it was not mentioned within your installation txt (unless I missed out). Also, none of txt is applicable for my shop since my shop used HTC version before upgrading. Is it right to ignore? and how about "header_tags_seo_convert.php"? where it suppose to go?

 

Many thanks. organicme

Share this post


Link to post
Share on other sites

Hi Jack, Thanks for taking time to answer my questions. Honestly,I still couldn't figure out the root causes for those issues. I can kinda seeing the effect from having HTC and SEO in the same time. I wonder if I could eliminate the problems by removing HTC at once? if possible, then how.

If properly installed, it won't matter that both sets of code are in the shop since only one will work.

 

In addition, your SEO contribution contains one folder named "Update_Docs". I have not added anything from that folder since it was not mentioned within your installation txt (unless I missed out). Also, none of txt is applicable for my shop since my shop used HTC version before upgrading. Is it right to ignore? and how about "header_tags_seo_convert.php"? where it suppose to go?

The header_tags_seo_convert.php file is only for converting from the Header Tags Controller to this contribution. It was dropped from this contribution since there is an easier way to upgrade. In short, upload all of the files from the catalog directory from this contribution. Use the update sql file to make the database changes and run through the Install_Catalog and Install_Admin files, making whatever changes are needed.

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

×