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

[tangwaichee]

[code1054 - Unknown column 'p.products_id' in 'on clause'

select p.products_id, pd.products_name, pd.products_description, p.products_image, p.products_model, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id='80' order by pd.products_name, p.products_date_added DESC

[TEP STOP]][/code]

 

I'm having some problem in the admin area with this products

[Guest]

[code1054 - Unknown column 'p.products_id' in 'on clause'

select p.products_id, pd.products_name, pd.products_description, p.products_image, p.products_model, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id='80' order by pd.products_name, p.products_date_added DESC

[TEP STOP]][/code]

 

I'm having some problem in the admin area with this products

What osc version are you running?

[Guest]

[code1054 - Unknown column 'p.products_id' in 'on clause'

select p.products_id, pd.products_name, pd.products_description, p.products_image, p.products_model, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id='80' order by pd.products_name, p.products_date_added DESC

[TEP STOP]][/code]

 

I'm having some problem in the admin area with this products

 

I'm getting a similar message on my store. I'm running on 2.2

[Guest]

Have a look here:

http://www.oscommerce.com/forums/index.php?showtopic=208286

[tangwaichee]

Have a look here:

http://www.oscommerce.com/forums/index.php?showtopic=208286

I'm running 2.2 oso...

[Guest]

I'm running 2.2 oso...

But 2.2 what. Do read the thread I posted.

[tangwaichee]

I'm running 2.2 oso...

 

Im just need some solutions, regarding about this contribution..

[Guest]

Have a look here:

http://www.oscommerce.com/forums/index.php?showtopic=208286

 

Cheers Leslie! Thanks for pointing me in the right direction. Hope you have a great festive season! :thumbsup:

[Guest]

Cheers Leslie! Thanks for pointing me in the right direction. Hope you have a great festive season! :thumbsup:

You too Monty.

[Guest]

Im just need some solutions, regarding about this contribution..

That is why I posted the link.

[tangwaichee]

That is why I posted the link.

hey, im not well in the script that why i'm hoping that someone can show me step by step, how to go about it.....

[Guest]

That is why I posted the link.

Also have a look here

http://www.oscommerce.com/forums/index.php?showtopic=177004

[Guest]

hey, im not well in the script that why i'm hoping that someone can show me step by step, how to go about it.....

No one will ever show you step by step (that is old telephony techology - if you don't get it, don't worry).

 

The idea is that you learn to help yourself.

Have a look at the links.

 

Let us know what version of osc you have. Let us know what addon you installed that caused the problem.

[tangwaichee]

No one will ever show you step by step (that is old telephony techology - if you don't get it, don't worry).

 

The idea is that you learn to help yourself.

Have a look at the links.

 

Let us know what version of osc you have. Let us know what addon you installed that caused the problem.

 

im using the latest version of the oscommence 2.2 and im install the addon of validation email, store summary for admin...

[Guest]

im using the latest version of the oscommence 2.2 and im install the addon of validation email, store summary for admin...

You mean RC1?

 

 

Do you think the contrib may be related to the problem? I remember a few posts about that contribution.