1054 - Unknown

[sunrise99]

Dears,

After I install new TM,have theo following error when click Categorie.

Would you please help ? Thanks!

 

 

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

 

[TEP STOP]

[♥geoffreywalton]

search for a contribution called

 

1054 - Unknown column 'p.products_id' in 'on clause

 

Then check out for others to cater for the changes between mysql4 and mysql5

[Guest]

Dears,

After I install new TM,have theo following error when click Categorie.

Would you please help ? Thanks!

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

 

[TEP STOP]

What do you expect when you use out of date software?

[♥geoffreywalton]

To true, but to the uninitiated it isn't obvious.

 

I might start collecting stats on the % of posts where osCommerce is not working because it is now running on a server using MySQL5.

 

ollyno1uk2 is having kittens at the moment about this too.

 

Still it is nice to be called "Dears"

[Guest]

Still it is nice to be called "Dears"

But I am cheap.