Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Administration Area SQL Issue?


Ramsay

Recommended Posts

Everything seems to work fine in my administration area. Apart from:

 

'Categories / Products' which displays this error:

 

1054 - Unknown column 'cd.categories_htc_title_tag' in 'field list'

 

select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, cd.categories_htc_title_tag, cd.categories_htc_desc_tag, cd.categories_htc_keywords_tag, cd.categories_htc_description from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '1' order by c.sort_order, cd.categories_name

 

[TEP STOP]

 

& 'Manufacturers' which displays this error:

 

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, 20

 

[TEP STOP]

 

 

 

 

Help would be greatly appreciated

Contributions Installed: STSv43 (Simple Template System), Protx Direct v3.0a, Secure Admin Login - Logout 1.5, UK Royal Mail & Overseas Shipping v 1.2 (FULL), Order Editor v2.8.2 With some Bug Fix - New, Ultimate SEO URLs v2.2.1, Easy Populate 2.76d-MS2 (with attributes)

Link to comment
Share on other sites

Everything seems to work fine in my administration area. Apart from:

 

'Categories / Products' which displays this error:

 

1054 - Unknown column 'cd.categories_htc_title_tag' in 'field list'

 

select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, cd.categories_htc_title_tag, cd.categories_htc_desc_tag, cd.categories_htc_keywords_tag, cd.categories_htc_description from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '1' order by c.sort_order, cd.categories_name

 

[TEP STOP]

 

& 'Manufacturers' which displays this error:

 

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, 20

 

[TEP STOP]

Help would be greatly appreciated

 

 

It is looking for the tables for the Header Tags Contribution... did you install Header Tags and do the sql update?

Link to comment
Share on other sites

It is looking for the tables for the Header Tags Contribution... did you install Header Tags and do the sql update?

 

No the only contributions i have installed are:

 

Protx Direct v3.0a

STSv43 (simple template system)

Secure Admin Login - Logout 1.5

 

-cheers for the fast reply

Contributions Installed: STSv43 (Simple Template System), Protx Direct v3.0a, Secure Admin Login - Logout 1.5, UK Royal Mail & Overseas Shipping v 1.2 (FULL), Order Editor v2.8.2 With some Bug Fix - New, Ultimate SEO URLs v2.2.1, Easy Populate 2.76d-MS2 (with attributes)

Link to comment
Share on other sites

Just realised that the headers tag contribution is integrated with STS.. :blush:

 

Thankyou

 

I will do the SQL update and see what happens

Contributions Installed: STSv43 (Simple Template System), Protx Direct v3.0a, Secure Admin Login - Logout 1.5, UK Royal Mail & Overseas Shipping v 1.2 (FULL), Order Editor v2.8.2 With some Bug Fix - New, Ultimate SEO URLs v2.2.1, Easy Populate 2.76d-MS2 (with attributes)

Link to comment
Share on other sites

success :D

Contributions Installed: STSv43 (Simple Template System), Protx Direct v3.0a, Secure Admin Login - Logout 1.5, UK Royal Mail & Overseas Shipping v 1.2 (FULL), Order Editor v2.8.2 With some Bug Fix - New, Ultimate SEO URLs v2.2.1, Easy Populate 2.76d-MS2 (with attributes)

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...