Administration Area SQL Issue?

[Ramsay]

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

[Barbie]

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?

[Ramsay]

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

[Ramsay]

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

 

Thankyou

 

I will do the SQL update and see what happens

[Ramsay]

success :D