ERROR 1054 appear

[jennki]

Hi, I've installed the oscommerce successfully, but the following ERROR CODE APPEAR whenever I clicked on the items or the images in the sub-catalogue (eg. Action under Catalog>>Hardware>>Action) and the items under the "Manufacturers" dropdown menu.

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '8'

 

[TEP STOP]

 

I can see the product details by clicking on the product directly under the "New Products" section or "What's New" box.

 

Pls. advise why is that happen, and how can I correct this? Thanks in advance.

[jennki]

Problem is solved. I've updated my oscommerce with info provided in update-20051113.html, and mainly because of updating the MySQL 5.

[jennki]

Problem is solved. I've updated my oscommerce with info provided in update-20051113.html, and mainly because of updating the MySQL 5.

 

Although problem of the error disappeared, however, inside the update guide under "MySQL 5.0 Compatibility", it said I need to perform the following SQL queries:

 

ALTER TABLE whos_online MODIFY COLUMN last_page_url VARCHAR(255) NOT NULL;

 

ALTER TABLE customers MODIFY COLUMN customers_default_address_id INTEGER;

 

ALTER TABLE customers_basket MODIFY COLUMN final_price DECIMAL(15,4);

 

Could anyone tell me what is mean by perform SQL queries, and how in more details? Thanks in advance.

 

On the other hand, although I can see the product listing now, but I could not add any item into the cart? WHY? Is it related to above performance? Pls. advise.