Error when item is viewed

[trisha33]

Hi,

I need some asisstance..asap..whenever someone selects a product to look at, they get the following error:

 

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

 

select pd.language_id, p.products_id, pd.products_name, pd.products_description, pd.products_head_title_tag, pd.products_head_keywords_tag, pd.products_head_desc_tag, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from products p, products_description pd where p.products_id = '374' and pd.products_id = '374' and pd.language_id ='1'

 

[TEP STOP]

 

 

How can i fix it?

 

Thanks.

[♥Vger]

Someone has only partly installed a meta tag contribution - without adding the extra tables to the database using the .sql file that came with the contribution.

 

You need to access your database via phpMyAdmin, click on the SQL tab, use the Browse function to locate the contributions .sql file on your computer, then click 'Go'. This will install the missing tables and the errors will disappear.

 

Vger

[trisha33]

Thanks so much for your quick response. I got if fixed. :)

 

 

Someone has only partly installed a meta tag contribution - without adding the extra tables to the database using the .sql file that came with the contribution.

 

You need to access your database via phpMyAdmin, click on the SQL tab, use the Browse function to locate the contributions .sql file on your computer, then click 'Go'.  This will install the missing tables and the errors will disappear.

 

Vger

<{POST_SNAPBACK}>

[satish]

Hi,

check in your contribution there should be some insert/alter/update statements for the stated table.The field needs to be added to the table which was not done.

Probably when moving from one version to another you didnt go thru the install procedure.

 

Satish Mantri

 

Hi,

I need some asisstance..asap..whenever someone selects a product to look at, they get the following error:

 

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

 

select pd.language_id, p.products_id, pd.products_name, pd.products_description, pd.products_head_title_tag, pd.products_head_keywords_tag, pd.products_head_desc_tag, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from products p, products_description pd where p.products_id = '374' and pd.products_id = '374' and pd.language_id ='1'

 

[TEP STOP]

How can i fix it?

 

Thanks.

<{POST_SNAPBACK}>