Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Problem with loading product information


oscNewbie75

Recommended Posts

Hi all! Would appreciate anyone's help on this.

 

Have recently installed OSC for my online shop. I've started changing the categories and sub-categories. the structure is fairly simple:

 

Top Category > Sub-category > item

 

However, when I select Sub-category, the following error occurs:

 

"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 = '32' "

 

I checked my database file to check if products_id is missing. However, it seems like products_id is defined under section CREATE TABLE `products` as follows:

 

CREATE TABLE `products` (

`products_id` int(11) NOT NULL auto_increment,

`products_quantity` int(4) NOT NULL,

`products_model` varchar(12) default NULL,

`products_image` varchar(64) default NULL,

`products_price` decimal(15,4) NOT NULL,

`products_date_added` datetime NOT NULL,

`products_last_modified` datetime default NULL,

`products_date_available` datetime default NULL,

`products_weight` decimal(5,2) NOT NULL,

`products_status` tinyint(1) NOT NULL,

`products_tax_class_id` int(11) NOT NULL,

`manufacturers_id` int(11) default NULL,

`products_ordered` int(11) NOT NULL default '0',

PRIMARY KEY (`products_id`),

KEY `idx_products_date_added` (`products_date_added`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=29 ;

 

 

What can be the problem?

thank you in advance!

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...