Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1054 - Unknown column 'mi.manufacturers_htc_title_tag' in 'field list' after header tags install


stanleymog

Recommended Posts

Posted

Hi there,

 

I have installed the header tags installation which Jackmc kindly contributed but have had a couple of problems, one I have overcome this evening but after nearly 3 hours of looking today and many hours before xmas I cannot find the answer to it!

 

The problem is in admin/manufacturers.php and I get the following error:

 

1054 - Unknown column 'mi.manufacturers_htc_title_tag' in 'field list'

 

select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.date_added, m.last_modified, mi.manufacturers_htc_title_tag from manufacturers m LEFT JOIN manufacturers_info mi on m.manufacturers_id = mi.manufacturers_id where mi.languages_id = '1' order by m.manufacturers_name limit 0, 20

 

[TEP STOP]

 

 

After having a similer problem with my admin/categories.php I thought the problem would be in this bit of code:

 

//BOC HTC

$manufacturers_query_raw = "select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.date_added, m.last_modified, mi.manufacturers_htc_title_tag from " . TABLE_MANUFACTURERS . " m LEFT JOIN " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id where mi.languages_id = '".$languages_id ."' order by m.manufacturers_name";

//EOC HTC

 

 

But what do i alter, i do try to solve problems myself but this has got me stumped so any advice would be appreciated and i am sorry if there are any spelling mistakes, I have square eyyes!

Posted

The error is saying that the code can't find the entry it needs in the database. If you haven't ran installed the database changes, that is the problem. If this is an upgrade from an earlier version of Header Tags, then you need to run the manufacturers update sql file.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

All of My Addons

Get the latest versions of my addons

Recommended SEO Addons

Posted
The error is saying that the code can't find the entry it needs in the database. If you haven't ran installed the database changes, that is the problem. If this is an upgrade from an earlier version of Header Tags, then you need to run the manufacturers update sql file.

 

Jack

 

Thanks Jack, I missed one file out, now its all working fine.

 

Thank you very much :D :thumbsup:

  • 2 years later...
Posted

Manufacturers

1054 - Unknown column 'mi.manufacturers_htc_title_tag' in 'field list'

 

select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.date_added, m.last_modified, mi.manufacturers_htc_title_tag from manufacturers m LEFT JOIN manufacturers_info mi on m.manufacturers_id = mi.manufacturers_id where mi.languages_id = '1' order by m.manufacturers_name limit 0, 2000

 

 

Please help me................

Posted

again either you have not installed the mod correctly like missed out the SQL file that needs running or you are using PHP5 and require a fix on the LEFT JOIN statement

I dont help with templates (thats what the seller is for)

 

th search function will often help, when it dont try this in google.

 

site:http://www.oscommerce.com/forums then your search word

  • 7 months later...
Posted

I have just installed everything to spec but have the same type issues:

 

1. 1054 - Unknown column 'title_tag' in 'field list'

 

select products_name, products_description, title_tag, desc_tag, keywords_tag from products_description where products_id = '167' and language_id = '1'

 

[TEP STOP]

 

2. In the admin I have a similar message:

 

1054 - Unknown column 'pd.title_tag' in 'field list'

 

select p.products_id, p.manufacturers_id, pd.products_name, pd.title_tag, pd.desc_tag, pd.keywords_tag, p.manufacturers_id from products p, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' limit 0, 9

 

[TEP STOP]

 

I saw something about uploading a sql file, but I dont see anything like that in the package. Any help would be great, thanks!

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...