SQL error: 1054 - Unknown column 'p.products_id' in 'on clause'

[Futterama]

Hello forum,

 

I'm helping a friend with this problem in his webshop. The welcome page to the shop in www.mydomain.dk/catalog/ works fine, but when you want to see one of the product categories, this error is displayed:

 

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 = '4' and p2c.categories_id = '29'

 

[TEP STOP]

 

I logged in to his MySQL phpMyAdmin tool, and I get the same error when executing the SQL statements from there.

 

His host is unoeuro.com if this matters to you.

 

I hope someone can help us.

 

Thanks in advance.

 

Regards,

Futterama

[nst888]

Try:

 

select count(p.products_id) as total

from products_description pd,

products_to_categories p2c,

products p

left join manufacturers m on p.manufacturers_id = m.manufacturers_id

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

and p2c.categories_id = '29'

 

Nicki

[Futterama]

Try:

 

select count(p.products_id) as total

from products_description pd,

products_to_categories p2c,

products p

left join manufacturers m on p.manufacturers_id = m.manufacturers_id

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

and p2c.categories_id = '29'

 

Nicki

 

Thanks for your suggestion, but since the files have not been modified, something else must be wrong. What happened to the post saying that I needed to upgrade osCommerce because of a newer MySQL server version?

 

 

Regards,

Futterama

[shooter-boy]

It is usually a problem with MySQL5. Do you know what version you are running?

 

Rob

[Jack_mcs]

Take a look here for the fix.

 

Jack

[Futterama]

Thanks for the fast replies.

 

The MySQL server is 5.0.27-standard.

 

The last comment in Jacks suggestion: "This was fixed with the 2.2 Milestone 2 051113 Update package."

 

So if I update my osCommerce installation to the latest, the problem will go away.

 

But I'm having trouble figuring out how to upgrade. I made a topic about it here: http://www.oscommerce.com/forums/index.php?showtopic=251905

 

 

Regards,

Futterama