Oscommerce error message, possibly SQl related, please help!

[bobbybrown]

Hey guys,

I've installed OScommerce to my site and got it all up and running, then found an error message.

 

This is the 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 = '58'

 

[TEP STOP]

 

I get it when trying to search for something or when clicking on the categories for my products, meaning that noone can access my products!

 

I've tried running querys in phpmyadmin but nothing works, I just get errors saying the fields don't exist.

I don't have a field in the products table called products_d.

 

I'm really confused why its happening, its a totally new fresh install of oscommerce.

 

If someone can help me get this sorted it would be really appreciated, I've tried everything I can think of.

 

Thanks for reading guys.

 

Dan

[playcraft]

Hey guys,

I've installed OScommerce to my site and got it all up and running, then found an error message.

 

This is the 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 = '58'

 

[TEP STOP]

 

I get it when trying to search for something or when clicking on the categories for my products, meaning that noone can access my products!

 

I've tried running querys in phpmyadmin but nothing works, I just get errors saying the fields don't exist.

I don't have a field in the products table called products_d.

 

I'm really confused why its happening, its a totally new fresh install of oscommerce.

 

If someone can help me get this sorted it would be really appreciated, I've tried everything I can think of.

 

Thanks for reading guys.

 

Dan

Try this

[bobbybrown]

Try this

 

Thanks for that, unfortunately my index.php is much shorter than that says it should be and doesn't have the lines it asks for.

 

Any ideas?

[bobbybrown]

This might help, I'm using a template so my index.php doesn't have those lines.

 

I'm really stuck on this.

[♥geoffreywalton]

There is a contribution that explains how to fix the "left join"/mysql5 problem or there a couple of useful links in my signature block below.

[bobbybrown]

I've sorted it now.