MySQL error: 1054 - Unknown column 'products_blurb' in 'field list'

Support Center » Knowledgebase » MySQL error: 1054 - Unknown column 'products_blurb' in 'field list'

	MySQL error: 1054 - Unknown column 'products_blurb' in 'field list'

Solution Question:
I get is this
"Error reported on page /shop/index.php
MySQL error: 1054 - Unknown column 'products_blurb' in 'field list'
select products_blurb from products_description where products_id = 3 and language_id = 1

[TEP STOP]

Answer:
Got to your web server control panel and open your phpMyadmin. Find your database and when it is opened rum the mySQL command:

ALTER TABLE `products_description` ADD `products_blurb text ,
  PRIMARY KEY (products_id, language_id),
  KEY products_name (products_name)
);

Article Details

Article ID:

433

Created On:

22 Feb 2009 07:21 PM

This answer was helpful

This answer was not helpful

Back

Login

[Lost Password]

Search

Article Options

Home | Register | Submit a Ticket | Knowledgebase | Downloads