Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Product Price and Stock Update


mbnaman

Recommended Posts

Posted

Help, After installing the Multi product update, I am getting the following error message on the catalog cpanel screen:

 

 

Product Price and Stock Update

 

1054 - Unknown column 'products_length' in 'field list'

 

select p.products_id, p.manufacturers_id, p.products_quantity, p.products_weight, products_length, products_width, products_height, products_ready_to_ship, p.products_price, p.products_model, pd.products_name, m.manufacturers_id, m.manufacturers_name from products p, products_description pd, manufacturers m where p.products_id = pd.products_id and p.manufacturers_id = m.manufacturers_id and pd.language_id = 1 group by pd.products_name order by p.products_model ASC limit 0, 10

 

[TEP STOP]

 

 

Can anyone help

Posted

products_length probably does not exist in the DB table you're trying to read.

 

Try commenting it out of the code and run the script again.

Just between us, remember there are only 10 kinds of people in the world; those who understand binary and those who don't!!

 

Remember, learning is a "do-it-yourself" experience; although, not necessarily a "do-it-BY-yourself" experience.

 

The quickest way to learn is to forget to BACKUP!

Posted
In what file do I commnet it out?

 

You need to know the program that's running. If there is no information on the screen, check your browser address bar to find out what's running, ei: index.php, create_account.php, product_info.php

Just between us, remember there are only 10 kinds of people in the world; those who understand binary and those who don't!!

 

Remember, learning is a "do-it-yourself" experience; although, not necessarily a "do-it-BY-yourself" experience.

 

The quickest way to learn is to forget to BACKUP!

Archived

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

×
×
  • Create New...