Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Help! Googlefeeder v 2.8, : SQL error Unknown column


ChrisRedfern

Recommended Posts

Can anyone help ? im only a rookie!

 

I am getting an error code when trying to prouce a data feed from within admin,

 

: SQL error Unknown column 'products.products_brand' in 'field list'| sql = SELECT concat( 'http://reefbathrooms.co.uk/product_info.php?products_id=' ,products.products_id) AS product_url, products_model AS prodModel, manufacturers.manufacturers_name AS mfgName, manufacturers.manufacturers_id, products.products_id AS id, products_description.products_name AS name, products_description.products_description AS description, products.products_quantity AS quantity, products.products_status AS prodStatus, products.products_weight AS prodWeight, products.products_brand as brand, FORMAT( IFNULL(specials.specials_new_products_price, products.products_price) * 1.19,2) AS price, CONCAT( 'http://reefbathrooms.co.uk/images/' ,products.products_image) AS image_url, products_to_categories.categories_id AS prodCatID, categories.parent_id AS catParentID, categories_description.categories_name AS catName FROM (categories, categories_description, products, products_description, products_to_categories) left join manufacturers on ( manufacturers.manufacturers_id = products.manufacturers_id ) left join specials on ( specials.products_id = products.products_id AND ( ( (specials.expires_date > CURRENT_DATE) OR (specials.expires_date is NULL) OR (specials.expires_date = 0) ) AND ( specials.status = 1 ) ) ) WHERE products.products_id=products_description.products_id AND products.products_id=products_to_categories.products_id AND products_to_categories.categories_id=categories.categories_id AND categories.categories_id=categories_description.categories_id AND categories_description.language_id = 1 AND products_description.language_id = 1 ORDER BY products.products_id ASC

 

i understand this is some problem with my database, although im unsure what i need to change or add,

 

can anyone show my some light! =)

 

thanks!

Link to comment
Share on other sites

  • 2 months later...

You do not have a field in your db called brand.

 

products.products_brand as brand,

 

 

You could create a field in your products table called brand and a blank field will be passed to google. You really need to update admin/categories.php to update this field.

 

You could try changing

 

 

products.products_brand as brand

 

to

 

manufacturers.manufacturers_name AS brand

 

If the manufacturer's name is the brand.

 

HTH

 

G

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...