Header Tags SEO

[Jack_mcs]

Hello all.

I wonder if anyone else has experienced this issue.

When I list new products I am getting the meta tags and title of another random product on the site, it is not happening with every product but with just a random few. Here is the latest: http://www.aseawards.co.uk/endurance-series-cast-presentation-p-789.html

The product I listed is obviously a presentation cup trophy, but the tags in the source are for a random cricket trophy. The tags do not change every time the page is loaded, the cricket trophy tag is always there. This has happened a couple of times now.

Hope someone can shed some light on it. I am using version 2.2

regards Andy

The only thing I can think of that might be causing that is if you are using the Header Tags cache option. Try turning that off, if it is on, and see if that fixes it.

[Roaddoctor]

Hi Jack, his problem seem similar to my cache issue, for me it was localized to only the information pages. I have cache disabled for the time being.

 

on a different note, I've found that when configuration/headertagsseo/ Search Keywords is set to true I am getting crazy duplication of results in advanced search. With it false, all is perfect.

 

Thanks as usual!

[Jack_mcs]

on a different note, I've found that when configuration/headertagsseo/ Search Keywords is set to true I am getting crazy duplication of results in advanced search. With it false, all is perfect.

Yes, I'm aware of the problem. It is because when a searched for keyword is assigned to a product, it makes an entry for each time it is searched for so multiple results are found. I had worked on it already but haven't had time to thoroughly test it.

[greasemonkey]

I've recently installed this mod and I'm having trouble filling the products meta description with Products Description.

 

I believe my database may be to large... We have over 2,000 items - all with length descriptions.

 

I'm no coder... However, I was thinking it may be easiest to run a SELECT and INSERT INTO sql statement? Any ideas?

 

I've been trying via phpmyadmin... But I cannot get the syntax right...

[Jack_mcs]

I've recently installed this mod and I'm having trouble filling the products meta description with Products Description.

 

I believe my database may be to large... We have over 2,000 items - all with length descriptions.

 

I'm no coder... However, I was thinking it may be easiest to run a SELECT and INSERT INTO sql statement? Any ideas?

If you are talking about filling them using Fill Tags, then you may need to use the time delay option on that page. If you are talking about filling them from the products edit page, that would just be adding a small part to the database update and should not cause a failure.

[greasemonkey]

Hi Jack, thank you kindly... It would seem that I need to give my head a shake... For some reason I installed 3.2.6 NOT 3.2.9???

 

I have now upgraded and look forward to using

 

then you may need to use the time delay option on that page

 

I'll give it a try and see what happens....

[greasemonkey]

Ok, it seems to be working... 100 down... 2,000 to go...

[CotswoldEngraver]

The only thing I can think of that might be causing that is if you are using the Header Tags cache option. Try turning that off, if it is on, and see if that fixes it.

 

Thanks Jack, disabled the cache and all was fixed. Many thanks.

[blaine109]

...

Edited November 27, 2012 by blaine109

[agreene]

In a 2.3.1 shop, what would cause entering stuff into the Category Meta Tags dialog to not work at all? After filling out the title, keywords and description (all under the acceptable 70/3/140 limits) for a category, I check the page and nothing seems to take.

 

e: I have Ultimate SEO URLs installed too.

Edited December 3, 2012 by agreene

[Jack_mcs]

In a 2.3.1 shop, what would cause entering stuff into the Category Meta Tags dialog to not work at all? After filling out the title, keywords and description (all under the acceptable 70/3/140 limits) for a category, I check the page and nothing seems to take.

 

e: I have Ultimate SEO URLs installed too.

If you go back into the category edit page in admin and can't see the changes you made there, then a mistake was most likely made on the categories.php changes. If it is there and the title and tags are working correctly on the product page on the shop, then a mistake was most likely made on the index.php changes.

[agreene]

There are categories.php changes??? The documentation is a little vague. We're talking about the second phase of setup, where you add dynamic header tags, right? I only see index.php and products_info.php (I assume that's product_info.php instead).

 

edit: tpying is nto eaxy

 

e2: This is the part where I had trouble. This jerk was nowhere to be found in the index.php file. Oh god what do I do I'm not a coder

Edited December 4, 2012 by agreene

[Jack_mcs]

It seems you're confused about which contribution you are using. Those instructions are not part of Header Tags SEO.

[agreene]

Oh.

 

That explains everything.

 

It looks like you are correct. The contribution is called SEO Header Tags For Novices and is a totally different thing. Thanks for your quick reply, I'll give your contribution a shot! :)

[Roaddoctor]

Jack,

If I may ask, what is your opinion on seo practices on the mobile_ side of a shop? Primarily I dont want to damage the indexing on the classic side or run into duplicate content issues. Along that line, should Header tags SEO be placed into the mobile pages? Currently the default setup for iOSC has the meta set up like this:

 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
	 "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<meta http-equiv="Content-Type"
content="text/html; charset=utf-8" />
<meta name="viewport"
content="width=width=320; initial-scale=1.0; maximum-scale=1.0; user-scalable=no;" />
<meta name="apple-mobile-web-app-capable"
 content="yes" />
<meta name="apple-mobile-web-app-status-bar-style"
 content="default" />
<meta name="googlebot"
content="noindex, nofollow">
<meta name="robots"
content="noindex, nofollow">

 

Would you improve upon this? Your thoughts on the topic are greatly appreciated.

 

Thank you

[Jack_mcs]

Jack,

If I may ask, what is your opinion on seo practices on the mobile_ side of a shop? Primarily I dont want to damage the indexing on the classic side or run into duplicate content issues. Along that line, should Header tags SEO be placed into the mobile pages? Currently the default setup for iOSC has the meta set up like this:

 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
	 "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<meta http-equiv="Content-Type"
content="text/html; charset=utf-8" />
<meta name="viewport"
content="width=width=320; initial-scale=1.0; maximum-scale=1.0; user-scalable=no;" />
<meta name="apple-mobile-web-app-capable"
 content="yes" />
<meta name="apple-mobile-web-app-status-bar-style"
 content="default" />
<meta name="googlebot"
content="noindex, nofollow">
<meta name="robots"
content="noindex, nofollow">

 

Would you improve upon this? Your thoughts on the topic are greatly appreciated.

 

Thank you

The mobil pages should be optimized for the search engines as much as non-mobile pages. There won't be a duplicate content situation because the format of the pages are drastically different. You have to replace the title statement, which is not shown in the code you posted but is in the file. I don't see why the author of the contribution added a noindex/no follow tag but that should be removed.

[shelby72]

I've had Header Tags Controller 2.5.9 installed on my site. I've been trying to update it with Header Tags SEO. So far I've gotten it to Header Tags SEO 3.17. After all the updates, I still have never been able to get the keywords and decription overrides on the Fill Tags nor the the Page Control for the keywords where you can use text from actual page to do anything at all. They never worked from 3.0. i thought that after making all the updates that it would eventually straighten up but it hasn't. Please tell me how do I get them to work? One error I seem to be getting is: File does not exist: /var/www/vhosts/cootersautomanuals.com/httpdocs/catalog/Select

 

I am still using Oscommerce 2.2-MS2 and have PHP 4.3.9. I intend to update everything as soon as I can but for right now how far in this contribution is it safe for me to update to? Would Header Tags 3.2.9 work for me?

[Jack_mcs]

I seem to recall 3.1.7 had a mistake in the installation procedure. The best thing to do is to go through all of the update files and apply whatever mysql statements are in each. Then run the headertags_seo_install.php file in 3.2.9 with the reset option. Make sure there are not any problems on the site and then just make the file changes described in 3.2.9 and uploads its files.

 

This contribution is compatible with any running version of oscommerce.

[Guest]

Hi!

 

I had SEO headertags previously, but updated to 2.3.3. When I did that, my keywords were missing, so I decided to re-install headertags.

 

When I use the install.php, I get this error::

1060 - Duplicate column name 'categories_htc_title_tag'
ALTER TABLE categories_description ADD categories_htc_title_tag VARCHAR(80) NULL;
[TEP STOP]

 

When I use the update.php, I get this error::

1054 - Unknown column 'products_head_keywords_tag' in 'products_description'
ALTER TABLE products_description ADD products_head_listing_text LONGTEXT NULL AFTER products_head_keywords_tag
[TEP STOP]

 

When I use the uninstall.php, I get this error::

1091 - Can't DROP 'products_head_title_tag'; check that column/key exists
ALTER TABLE products_description DROP products_head_title_tag
[TEP STOP]

 

Also, when I try to access any item in my store, I get this::

1054 - Unknown column 'pd.products_head_title_tag' in 'field list'
select pd.products_head_title_tag from products p left join products_description pd on p.products_id = pd.products_id where p.products_id = '426' and pd.language_id ='1' LIMIT 1
[TEP STOP]

 

What do I do? I read somewhere on here about deleting duplicate keywords, but where do I do that?

 

Thanks!

Edited December 7, 2012 by JenniferJordan

[Jack_mcs]

You probably have a damaged database now, with regards to Header Tags. It would be possible to recover but not in a thread like this. If you don't care about losing any tags you had setup, then try running the install, uninstall and then install again. If that doesn't work, the database will need to be manually edited. You're seeing the error on the shop side because the database is damaged.

[Guest]

You probably have a damaged database now, with regards to Header Tags. It would be possible to recover but not in a thread like this. If you don't care about losing any tags you had setup, then try running the install, uninstall and then install again. If that doesn't work, the database will need to be manually edited. You're seeing the error on the shop side because the database is damaged.

 

I had a feeling it was. I've tried that so many times. I don't mind losing my tags. A few more things that I've seen:

• Inside of my admin area, under Configuration > Header Tags SEO, every option appears 7 times.
  
• Under Header Tags SEO at the bottom of the tabs on the left, I get the 1054 error as well.
  

Are there instructions for manually editing the database?

 

Thanks! :)

 

EDIT:: Here's the website, if you'd like to see first hand.

Edited December 7, 2012 by JenniferJordan

[Guest]

Database checks::

 

mgn1::

 

 

thebroo2_mgn1.featured OK

thebroo2_mgn1.mgn_admin_assert OK

thebroo2_mgn1.mgn_admin_role OK

thebroo2_mgn1.mgn_admin_rule OK

thebroo2_mgn1.mgn_admin_user OK

thebroo2_mgn1.mgn_adminnotification_inbox OK

thebroo2_mgn1.mgn_api_assert OK

thebroo2_mgn1.mgn_api_role OK

thebroo2_mgn1.mgn_api_rule OK

thebroo2_mgn1.mgn_api_session OK

thebroo2_mgn1.mgn_api_user OK

thebroo2_mgn1.mgn_catalog_category_anc_categs_index_idx OK

thebroo2_mgn1.mgn_catalog_category_anc_categs_index_tmp

note : The storage engine for the table doesn't support check

thebroo2_mgn1.mgn_catalog_category_anc_products_index_idx OK

thebroo2_mgn1.mgn_catalog_category_anc_products_index_tmp

note : The storage engine for the table doesn't support check

thebroo2_mgn1.mgn_catalog_category_entity OK

thebroo2_mgn1.mgn_catalog_category_entity_datetime OK

thebroo2_mgn1.mgn_catalog_category_entity_decimal OK

thebroo2_mgn1.mgn_catalog_category_entity_int OK

thebroo2_mgn1.mgn_catalog_category_entity_text OK

thebroo2_mgn1.mgn_catalog_category_entity_varchar OK

thebroo2_mgn1.mgn_catalog_category_flat_store_1 OK

thebroo2_mgn1.mgn_catalog_category_product OK

thebroo2_mgn1.mgn_catalog_category_product_index OK

thebroo2_mgn1.mgn_catalog_category_product_index_enbl_idx OK

thebroo2_mgn1.mgn_catalog_category_product_index_enbl_tmp

note : The storage engine for the table doesn't support check

thebroo2_mgn1.mgn_catalog_category_product_index_idx OK

thebroo2_mgn1.mgn_catalog_category_product_index_tmp

note : The storage engine for the table doesn't support check

thebroo2_mgn1.mgn_catalog_compare_item OK

thebroo2_mgn1.mgn_catalog_eav_attribute OK

thebroo2_mgn1.mgn_catalog_product_bundle_option OK

thebroo2_mgn1.mgn_catalog_product_bundle_option_value OK

thebroo2_mgn1.mgn_catalog_product_bundle_price_index OK

thebroo2_mgn1.mgn_catalog_product_bundle_selection OK

thebroo2_mgn1.mgn_catalog_product_bundle_selection_price OK

thebroo2_mgn1.mgn_catalog_product_bundle_stock_index OK

thebroo2_mgn1.mgn_catalog_product_enabled_index OK

thebroo2_mgn1.mgn_catalog_product_entity OK

thebroo2_mgn1.mgn_catalog_product_entity_datetime OK

thebroo2_mgn1.mgn_catalog_product_entity_decimal OK

thebroo2_mgn1.mgn_catalog_product_entity_gallery OK

thebroo2_mgn1.mgn_catalog_product_entity_int OK

thebroo2_mgn1.mgn_catalog_product_entity_media_gallery OK

thebroo2_mgn1.mgn_catalog_product_entity_media_gallery_value OK

thebroo2_mgn1.mgn_catalog_product_entity_text OK

thebroo2_mgn1.mgn_catalog_product_entity_tier_price OK

thebroo2_mgn1.mgn_catalog_product_entity_varchar OK

thebroo2_mgn1.mgn_catalog_product_flat_1 OK

thebroo2_mgn1.mgn_catalog_product_index_eav OK

thebroo2_mgn1.mgn_catalog_product_index_eav_decimal OK

thebroo2_mgn1.mgn_catalog_product_index_eav_decimal_idx OK

thebroo2_mgn1.mgn_catalog_product_index_eav_decimal_tmp

note : The storage engine for the table doesn't support check

thebroo2_mgn1.mgn_catalog_product_index_eav_idx OK

thebroo2_mgn1.mgn_catalog_product_index_eav_tmp

note : The storage engine for the table doesn't support check

thebroo2_mgn1.mgn_catalog_product_index_price OK

thebroo2_mgn1.mgn_catalog_product_index_price_bundle_idx OK

thebroo2_mgn1.mgn_catalog_product_index_price_bundle_opt_idx OK

thebroo2_mgn1.mgn_catalog_product_index_price_bundle_opt_tmp

note : The storage engine for the table doesn't support check

thebroo2_mgn1.mgn_catalog_product_index_price_bundle_sel_idx OK

thebroo2_mgn1.mgn_catalog_product_index_price_bundle_sel_tmp

note : The storage engine for the table doesn't support check

thebroo2_mgn1.mgn_catalog_product_index_price_bundle_tmp

note : The storage engine for the table doesn't support check

thebroo2_mgn1.mgn_catalog_product_index_price_cfg_opt_agr_idx OK

thebroo2_mgn1.mgn_catalog_product_index_price_cfg_opt_agr_tmp

note : The storage engine for the table doesn't support check

thebroo2_mgn1.mgn_catalog_product_index_price_cfg_opt_idx OK

thebroo2_mgn1.mgn_catalog_product_index_price_cfg_opt_tmp

note : The storage engine for the table doesn't support check

thebroo2_mgn1.mgn_catalog_product_index_price_downlod_idx OK

thebroo2_mgn1.mgn_catalog_product_index_price_downlod_tmp

note : The storage engine for the table doesn't support check

thebroo2_mgn1.mgn_catalog_product_index_price_final_idx OK

thebroo2_mgn1.mgn_catalog_product_index_price_final_tmp

note : The storage engine for the table doesn't support check

thebroo2_mgn1.mgn_catalog_product_index_price_idx OK

thebroo2_mgn1.mgn_catalog_product_index_price_opt_agr_idx OK

thebroo2_mgn1.mgn_catalog_product_index_price_opt_agr_tmp

note : The storage engine for the table doesn't support check

thebroo2_mgn1.mgn_catalog_product_index_price_opt_idx OK

thebroo2_mgn1.mgn_catalog_product_index_price_opt_tmp

note : The storage engine for the table doesn't support check

thebroo2_mgn1.mgn_catalog_product_index_price_tmp

note : The storage engine for the table doesn't support check

thebroo2_mgn1.mgn_catalog_product_index_tier_price OK

thebroo2_mgn1.mgn_catalog_product_index_website OK

thebroo2_mgn1.mgn_catalog_product_link OK

thebroo2_mgn1.mgn_catalog_product_link_attribute OK

thebroo2_mgn1.mgn_catalog_product_link_attribute_decimal OK

thebroo2_mgn1.mgn_catalog_product_link_attribute_int OK

thebroo2_mgn1.mgn_catalog_product_link_attribute_varchar OK

thebroo2_mgn1.mgn_catalog_product_link_type OK

thebroo2_mgn1.mgn_catalog_product_option OK

thebroo2_mgn1.mgn_catalog_product_option_price OK

thebroo2_mgn1.mgn_catalog_product_option_title OK

thebroo2_mgn1.mgn_catalog_product_option_type_price OK

thebroo2_mgn1.mgn_catalog_product_option_type_title OK

thebroo2_mgn1.mgn_catalog_product_option_type_value OK

thebroo2_mgn1.mgn_catalog_product_relation OK

thebroo2_mgn1.mgn_catalog_product_super_attribute OK

thebroo2_mgn1.mgn_catalog_product_super_attribute_label OK

thebroo2_mgn1.mgn_catalog_product_super_attribute_pricing OK

thebroo2_mgn1.mgn_catalog_product_super_link OK

thebroo2_mgn1.mgn_catalog_product_website OK

thebroo2_mgn1.mgn_catalogindex_aggregation OK

thebroo2_mgn1.mgn_catalogindex_aggregation_tag OK

thebroo2_mgn1.mgn_catalogindex_aggregation_to_tag OK

thebroo2_mgn1.mgn_catalogindex_eav OK

thebroo2_mgn1.mgn_catalogindex_minimal_price OK

thebroo2_mgn1.mgn_catalogindex_price OK

thebroo2_mgn1.mgn_cataloginventory_stock OK

thebroo2_mgn1.mgn_cataloginventory_stock_item OK

thebroo2_mgn1.mgn_cataloginventory_stock_status OK

thebroo2_mgn1.mgn_cataloginventory_stock_status_idx OK

thebroo2_mgn1.mgn_cataloginventory_stock_status_tmp

note : The storage engine for the table doesn't support check

thebroo2_mgn1.mgn_catalogrule OK

thebroo2_mgn1.mgn_catalogrule_affected_product OK

thebroo2_mgn1.mgn_catalogrule_group_website OK

thebroo2_mgn1.mgn_catalogrule_product OK

thebroo2_mgn1.mgn_catalogrule_product_price OK

thebroo2_mgn1.mgn_catalogsearch_fulltext OK

thebroo2_mgn1.mgn_catalogsearch_query OK

thebroo2_mgn1.mgn_catalogsearch_result OK

thebroo2_mgn1.mgn_checkout_agreement OK

thebroo2_mgn1.mgn_checkout_agreement_store OK

thebroo2_mgn1.mgn_cms_block OK

thebroo2_mgn1.mgn_cms_block_store OK

thebroo2_mgn1.mgn_cms_page OK

thebroo2_mgn1.mgn_cms_page_store OK

thebroo2_mgn1.mgn_core_cache OK

thebroo2_mgn1.mgn_core_cache_option OK

thebroo2_mgn1.mgn_core_cache_tag OK

thebroo2_mgn1.mgn_core_config_data OK

thebroo2_mgn1.mgn_core_email_template OK

thebroo2_mgn1.mgn_core_flag OK

thebroo2_mgn1.mgn_core_layout_link OK

thebroo2_mgn1.mgn_core_layout_update OK

thebroo2_mgn1.mgn_core_resource OK

thebroo2_mgn1.mgn_core_session OK

thebroo2_mgn1.mgn_core_store OK

thebroo2_mgn1.mgn_core_store_group OK

thebroo2_mgn1.mgn_core_translate OK

thebroo2_mgn1.mgn_core_url_rewrite OK

thebroo2_mgn1.mgn_core_variable OK

thebroo2_mgn1.mgn_core_variable_value OK

thebroo2_mgn1.mgn_core_website OK

thebroo2_mgn1.mgn_coupon_aggregated OK

thebroo2_mgn1.mgn_coupon_aggregated_order OK

thebroo2_mgn1.mgn_cron_schedule OK

thebroo2_mgn1.mgn_customer_address_entity OK

thebroo2_mgn1.mgn_customer_address_entity_datetime OK

thebroo2_mgn1.mgn_customer_address_entity_decimal OK

thebroo2_mgn1.mgn_customer_address_entity_int OK

thebroo2_mgn1.mgn_customer_address_entity_text OK

thebroo2_mgn1.mgn_customer_address_entity_varchar OK

thebroo2_mgn1.mgn_customer_eav_attribute OK

thebroo2_mgn1.mgn_customer_eav_attribute_website OK

thebroo2_mgn1.mgn_customer_entity OK

thebroo2_mgn1.mgn_customer_entity_datetime OK

thebroo2_mgn1.mgn_customer_entity_decimal OK

thebroo2_mgn1.mgn_customer_entity_int OK

thebroo2_mgn1.mgn_customer_entity_text OK

thebroo2_mgn1.mgn_customer_entity_varchar OK

thebroo2_mgn1.mgn_customer_form_attribute OK

thebroo2_mgn1.mgn_customer_group OK

thebroo2_mgn1.mgn_dataflow_batch OK

thebroo2_mgn1.mgn_dataflow_batch_export OK

thebroo2_mgn1.mgn_dataflow_batch_import OK

thebroo2_mgn1.mgn_dataflow_import_data OK

thebroo2_mgn1.mgn_dataflow_profile OK

thebroo2_mgn1.mgn_dataflow_profile_history OK

thebroo2_mgn1.mgn_dataflow_session OK

thebroo2_mgn1.mgn_design_change OK

thebroo2_mgn1.mgn_directory_country OK

thebroo2_mgn1.mgn_directory_country_format OK

thebroo2_mgn1.mgn_directory_country_region OK

thebroo2_mgn1.mgn_directory_country_region_name OK

thebroo2_mgn1.mgn_directory_currency_rate OK

thebroo2_mgn1.mgn_downloadable_link OK

thebroo2_mgn1.mgn_downloadable_link_price OK

thebroo2_mgn1.mgn_downloadable_link_purchased OK

thebroo2_mgn1.mgn_downloadable_link_purchased_item OK

thebroo2_mgn1.mgn_downloadable_link_title OK

thebroo2_mgn1.mgn_downloadable_sample OK

thebroo2_mgn1.mgn_downloadable_sample_title OK

thebroo2_mgn1.mgn_eav_attribute OK

thebroo2_mgn1.mgn_eav_attribute_group OK

thebroo2_mgn1.mgn_eav_attribute_label OK

thebroo2_mgn1.mgn_eav_attribute_option OK

thebroo2_mgn1.mgn_eav_attribute_option_value OK

thebroo2_mgn1.mgn_eav_attribute_set OK

thebroo2_mgn1.mgn_eav_entity OK

thebroo2_mgn1.mgn_eav_entity_attribute OK

thebroo2_mgn1.mgn_eav_entity_datetime OK

thebroo2_mgn1.mgn_eav_entity_decimal OK

thebroo2_mgn1.mgn_eav_entity_int OK

thebroo2_mgn1.mgn_eav_entity_store OK

thebroo2_mgn1.mgn_eav_entity_text OK

thebroo2_mgn1.mgn_eav_entity_type OK

thebroo2_mgn1.mgn_eav_entity_varchar OK

thebroo2_mgn1.mgn_eav_form_element OK

thebroo2_mgn1.mgn_eav_form_fieldset OK

thebroo2_mgn1.mgn_eav_form_fieldset_label OK

thebroo2_mgn1.mgn_eav_form_type OK

thebroo2_mgn1.mgn_eav_form_type_entity OK

thebroo2_mgn1.mgn_find_feed_import_codes OK

thebroo2_mgn1.mgn_gift_message OK

thebroo2_mgn1.mgn_googlebase_attributes OK

thebroo2_mgn1.mgn_googlebase_items OK

thebroo2_mgn1.mgn_googlebase_types OK

thebroo2_mgn1.mgn_googlecheckout_api_debug OK

thebroo2_mgn1.mgn_googlecheckout_notification OK

thebroo2_mgn1.mgn_googleoptimizer_code OK

thebroo2_mgn1.mgn_importexport_importdata OK

thebroo2_mgn1.mgn_index_event OK

thebroo2_mgn1.mgn_index_process OK

thebroo2_mgn1.mgn_index_process_event OK

thebroo2_mgn1.mgn_log_customer OK

thebroo2_mgn1.mgn_log_quote OK

thebroo2_mgn1.mgn_log_summary OK

thebroo2_mgn1.mgn_log_summary_type OK

thebroo2_mgn1.mgn_log_url OK

thebroo2_mgn1.mgn_log_url_info OK

thebroo2_mgn1.mgn_log_visitor OK

thebroo2_mgn1.mgn_log_visitor_info OK

thebroo2_mgn1.mgn_log_visitor_online OK

thebroo2_mgn1.mgn_newsletter_problem OK

thebroo2_mgn1.mgn_newsletter_queue OK

thebroo2_mgn1.mgn_newsletter_queue_link OK

thebroo2_mgn1.mgn_newsletter_queue_store_link OK

thebroo2_mgn1.mgn_newsletter_subscriber OK

thebroo2_mgn1.mgn_newsletter_template OK

thebroo2_mgn1.mgn_paygate_authorizenet_debug OK

thebroo2_mgn1.mgn_paypal_api_debug OK

thebroo2_mgn1.mgn_paypal_cert OK

thebroo2_mgn1.mgn_paypal_settlement_report OK

thebroo2_mgn1.mgn_paypal_settlement_report_row OK

thebroo2_mgn1.mgn_paypaluk_api_debug OK

thebroo2_mgn1.mgn_poll OK

thebroo2_mgn1.mgn_poll_answer OK

thebroo2_mgn1.mgn_poll_store OK

thebroo2_mgn1.mgn_poll_vote OK

thebroo2_mgn1.mgn_product_alert_price OK

thebroo2_mgn1.mgn_product_alert_stock OK

thebroo2_mgn1.mgn_rating OK

thebroo2_mgn1.mgn_rating_entity OK

thebroo2_mgn1.mgn_rating_option OK

thebroo2_mgn1.mgn_rating_option_vote OK

thebroo2_mgn1.mgn_rating_option_vote_aggregated OK

thebroo2_mgn1.mgn_rating_store OK

thebroo2_mgn1.mgn_rating_title OK

thebroo2_mgn1.mgn_report_compared_product_index OK

thebroo2_mgn1.mgn_report_event OK

thebroo2_mgn1.mgn_report_event_types OK

thebroo2_mgn1.mgn_report_viewed_product_index OK

thebroo2_mgn1.mgn_review OK

thebroo2_mgn1.mgn_review_detail OK

thebroo2_mgn1.mgn_review_entity OK

thebroo2_mgn1.mgn_review_entity_summary OK

thebroo2_mgn1.mgn_review_status OK

thebroo2_mgn1.mgn_review_store OK

thebroo2_mgn1.mgn_sales_bestsellers_aggregated_daily OK

thebroo2_mgn1.mgn_sales_bestsellers_aggregated_monthly OK

thebroo2_mgn1.mgn_sales_bestsellers_aggregated_yearly OK

thebroo2_mgn1.mgn_sales_billing_agreement OK

thebroo2_mgn1.mgn_sales_billing_agreement_order OK

thebroo2_mgn1.mgn_sales_flat_creditmemo OK

thebroo2_mgn1.mgn_sales_flat_creditmemo_comment OK

thebroo2_mgn1.mgn_sales_flat_creditmemo_grid OK

thebroo2_mgn1.mgn_sales_flat_creditmemo_item OK

thebroo2_mgn1.mgn_sales_flat_invoice OK

thebroo2_mgn1.mgn_sales_flat_invoice_comment OK

thebroo2_mgn1.mgn_sales_flat_invoice_grid OK

thebroo2_mgn1.mgn_sales_flat_invoice_item OK

thebroo2_mgn1.mgn_sales_flat_order OK

thebroo2_mgn1.mgn_sales_flat_order_address OK

thebroo2_mgn1.mgn_sales_flat_order_grid OK

thebroo2_mgn1.mgn_sales_flat_order_item OK

thebroo2_mgn1.mgn_sales_flat_order_payment OK

thebroo2_mgn1.mgn_sales_flat_order_status_history OK

thebroo2_mgn1.mgn_sales_flat_quote OK

thebroo2_mgn1.mgn_sales_flat_quote_address OK

thebroo2_mgn1.mgn_sales_flat_quote_address_item OK

thebroo2_mgn1.mgn_sales_flat_quote_item OK

thebroo2_mgn1.mgn_sales_flat_quote_item_option OK

thebroo2_mgn1.mgn_sales_flat_quote_payment OK

thebroo2_mgn1.mgn_sales_flat_quote_shipping_rate OK

thebroo2_mgn1.mgn_sales_flat_shipment OK

thebroo2_mgn1.mgn_sales_flat_shipment_comment OK

thebroo2_mgn1.mgn_sales_flat_shipment_grid OK

thebroo2_mgn1.mgn_sales_flat_shipment_item OK

thebroo2_mgn1.mgn_sales_flat_shipment_track OK

thebroo2_mgn1.mgn_sales_invoiced_aggregated OK

thebroo2_mgn1.mgn_sales_invoiced_aggregated_order OK

thebroo2_mgn1.mgn_sales_order_aggregated_created OK

thebroo2_mgn1.mgn_sales_order_status OK

thebroo2_mgn1.mgn_sales_order_status_label OK

thebroo2_mgn1.mgn_sales_order_status_state OK

thebroo2_mgn1.mgn_sales_order_tax OK

thebroo2_mgn1.mgn_sales_payment_transaction OK

thebroo2_mgn1.mgn_sales_recurring_profile OK

thebroo2_mgn1.mgn_sales_recurring_profile_order OK

thebroo2_mgn1.mgn_sales_refunded_aggregated OK

thebroo2_mgn1.mgn_sales_refunded_aggregated_order OK

thebroo2_mgn1.mgn_sales_shipping_aggregated OK

thebroo2_mgn1.mgn_sales_shipping_aggregated_order OK

thebroo2_mgn1.mgn_salesrule OK

thebroo2_mgn1.mgn_salesrule_coupon OK

thebroo2_mgn1.mgn_salesrule_coupon_usage OK

thebroo2_mgn1.mgn_salesrule_customer OK

thebroo2_mgn1.mgn_salesrule_label OK

thebroo2_mgn1.mgn_salesrule_product_attribute OK

thebroo2_mgn1.mgn_sendfriend_log OK

thebroo2_mgn1.mgn_shipping_tablerate OK

thebroo2_mgn1.mgn_sitemap OK

thebroo2_mgn1.mgn_tag OK

thebroo2_mgn1.mgn_tag_properties OK

thebroo2_mgn1.mgn_tag_relation OK

thebroo2_mgn1.mgn_tag_summary OK

thebroo2_mgn1.mgn_tax_calculation OK

thebroo2_mgn1.mgn_tax_calculation_rate OK

thebroo2_mgn1.mgn_tax_calculation_rate_title OK

thebroo2_mgn1.mgn_tax_calculation_rule OK

thebroo2_mgn1.mgn_tax_class OK

thebroo2_mgn1.mgn_tax_order_aggregated_created OK

thebroo2_mgn1.mgn_weee_discount OK

thebroo2_mgn1.mgn_weee_tax OK

thebroo2_mgn1.mgn_widget OK

thebroo2_mgn1.mgn_widget_instance OK

thebroo2_mgn1.mgn_widget_instance_page OK

thebroo2_mgn1.mgn_widget_instance_page_layout OK

thebroo2_mgn1.mgn_wishlist OK

thebroo2_mgn1.mgn_wishlist_item OK

thebroo2_mgn1.mgn_wishlist_item_option OK

thebroo2_mgn1.mgn_xmlconnect_application OK

thebroo2_mgn1.mgn_xmlconnect_history OK

thebroo2_mgn1.mgn_xmlconnect_notification_template OK

thebroo2_mgn1.mgn_xmlconnect_queue OK

 

scm1::

 

 

thebroo2_scm1.action_recorder OK

thebroo2_scm1.address_book OK

thebroo2_scm1.address_format OK

thebroo2_scm1.administrators OK

thebroo2_scm1.banners OK

thebroo2_scm1.banners_history OK

thebroo2_scm1.cache OK

thebroo2_scm1.categories OK

thebroo2_scm1.categories_description OK

thebroo2_scm1.configuration

warning : Found row where the auto_increment column has the value 0

status : OK

thebroo2_scm1.configuration_group OK

thebroo2_scm1.counter OK

thebroo2_scm1.counter_history OK

thebroo2_scm1.countries OK

thebroo2_scm1.currencies OK

thebroo2_scm1.customers OK

thebroo2_scm1.customers_basket OK

thebroo2_scm1.customers_basket_attributes OK

thebroo2_scm1.customers_info OK

thebroo2_scm1.customers_to_discount_codes OK

thebroo2_scm1.discount_codes OK

thebroo2_scm1.featured OK

thebroo2_scm1.geo_zones OK

thebroo2_scm1.headertags OK

thebroo2_scm1.headertags_cache OK

thebroo2_scm1.headertags_default OK

thebroo2_scm1.headertags_silo OK

thebroo2_scm1.languages OK

thebroo2_scm1.manufacturers OK

thebroo2_scm1.manufacturers_info OK

thebroo2_scm1.newsletters OK

thebroo2_scm1.orders OK

thebroo2_scm1.orders_products OK

thebroo2_scm1.orders_products_attributes OK

thebroo2_scm1.orders_products_download OK

thebroo2_scm1.orders_status OK

thebroo2_scm1.orders_status_history OK

thebroo2_scm1.orders_total OK

thebroo2_scm1.products OK

thebroo2_scm1.products_attributes OK

thebroo2_scm1.products_attributes_download OK

thebroo2_scm1.products_description OK

thebroo2_scm1.products_images OK

thebroo2_scm1.products_notifications OK

thebroo2_scm1.products_options OK

thebroo2_scm1.products_options_values OK

thebroo2_scm1.products_options_values_to_products_options OK

thebroo2_scm1.products_to_categories OK

thebroo2_scm1.reviews OK

thebroo2_scm1.reviews_description OK

thebroo2_scm1.sec_directory_whitelist OK

thebroo2_scm1.sessions OK

thebroo2_scm1.specials OK

thebroo2_scm1.tax_class OK

thebroo2_scm1.tax_rates OK

thebroo2_scm1.whos_online OK

thebroo2_scm1.zones OK

thebroo2_scm1.zones_to_geo_zones OK

 

scm2::

 

 

thebroo2_scm2.action_recorder OK

thebroo2_scm2.address_book OK

thebroo2_scm2.address_format OK

thebroo2_scm2.administrators OK

thebroo2_scm2.banners OK

thebroo2_scm2.banners_history OK

thebroo2_scm2.categories OK

thebroo2_scm2.categories_description OK

thebroo2_scm2.configuration OK

thebroo2_scm2.configuration_group OK

thebroo2_scm2.counter OK

thebroo2_scm2.counter_history OK

thebroo2_scm2.countries OK

thebroo2_scm2.currencies OK

thebroo2_scm2.customers OK

thebroo2_scm2.customers_basket OK

thebroo2_scm2.customers_basket_attributes OK

thebroo2_scm2.customers_info OK

thebroo2_scm2.geo_zones OK

thebroo2_scm2.languages OK

thebroo2_scm2.manufacturers OK

thebroo2_scm2.manufacturers_info OK

thebroo2_scm2.newsletters OK

thebroo2_scm2.orders OK

thebroo2_scm2.orders_products OK

thebroo2_scm2.orders_products_attributes OK

thebroo2_scm2.orders_products_download OK

thebroo2_scm2.orders_status OK

thebroo2_scm2.orders_status_history OK

thebroo2_scm2.orders_total OK

thebroo2_scm2.products OK

thebroo2_scm2.products_attributes OK

thebroo2_scm2.products_attributes_download OK

thebroo2_scm2.products_description OK

thebroo2_scm2.products_images OK

thebroo2_scm2.products_notifications OK

thebroo2_scm2.products_options OK

thebroo2_scm2.products_options_values OK

thebroo2_scm2.products_options_values_to_products_options OK

thebroo2_scm2.products_to_categories OK

thebroo2_scm2.reviews OK

thebroo2_scm2.reviews_description OK

thebroo2_scm2.sec_directory_whitelist OK

thebroo2_scm2.sessions OK

thebroo2_scm2.specials OK

thebroo2_scm2.tax_class OK

thebroo2_scm2.tax_rates OK

thebroo2_scm2.whos_online OK

thebroo2_scm2.zones OK

thebroo2_scm2.zones_to_geo_zones OK

[Guest]

Jack, I figured it out.

 

There's nothing in the install.php to add categories_htc_title_tag

 

I finally figured it out after installing and then manually dropping the fields, and each time, categories_htc_title_tag always gave an error of not existing.

 

TO FIX::

 

In your database, add the SQL command:: ALTER TABLE categories_description ADD categories_htc_title_tag LONGTEXT NULL;

 

Fixed it for me after 5 hours of playing around :]

[Guest]

I had to do the same thing for manufacturers_htc_title_tag

 

TO FIX::

 

In your database, add the SQL command:: ALTER TABLE manufacturers_info ADD manufacturers_htc_title_tag LONGTEXT NULL;

[Jack_mcs]

Those fields are in the install file. Otherwise the installation would not work for anyone. Maybe you are not using a current version?