Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

SQL Error after installing


DataMouse

Recommended Posts

Hi guys and girls

 

I'm having a problem after installing a template.

 

On http://www.bodybuildingsupplementshop.com/products.php, you can see that this should show product categories (and it does).

When you click a category, you should get a list of prodcts (there's ony one in there at the mo).

 

However, I get this error:

 

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 = '64'

[TEP STOP]

 

I'e been through the template files to look for a SQL update statement - no such look.

Can anyone help me to figure out how to add the column to the database? (as it's this that I'm assuming is the issue).

 

Thanks guys

 

 

Danny

Link to comment
Share on other sites

I fixed it. It's a mySQL5 issue.

For those reading along at home:

 

Change

p.products_id

 

to

p2c.products_id

 

In the index.php (or products.php in my case).

Link to comment
Share on other sites

I fixed it. It's a mySQL5 issue.

For those reading along at home:

 

Change

p.products_id

 

to

p2c.products_id

 

In the index.php (or products.php in my case).

Hi

 

Thanks. This is working now.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...