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

PDF Catalog(s) Generation

1054 - 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]

 

I presume your referring to oscommerce?

If you are, i kept getting that error and when i finally fixed it, it stopped the products working in the categories.
I recommend you use Zen Cart, a script based off OSCommerce but 10x better

 

Actually you need to upgrade your oscommerce this will solve your problem.

Thanks,
Subikar

 

what column are there on your "products" table?

 

I could solve this.
Here is the solution.


1. Open "index.php" in an html editor and do this:

2. If you are getting 1054 - Unknown column 'p.products_id' in 'on clause' then replace p.products_id = s.products_id with p2c.products_id = s.products_id EXCEPT on the line specified in #1 above.


Then open "advanced_search_results.php" in an html editor and do this:

This problem should solved.

 

yes his host has upgraded his mysql from 4 to 5 thats where this problem come and it should be solved what asif2bd has suggested but before doing all this you should backup at least those files which you are going to change

Regards

Alex

 

mine is on the oscommence 2.2 admin section which i generate the catalog, it show me the error of 1054 - 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='1' order by pd.products_name, p.products_date_added DESC

 

There is a typo in your SQL command. it should read:

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 pd.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

(Note the ONE CHARACTER difference!) You will need to find out which PHP module it is in, but that should be in your web browser address bar and you should be able to see it in your Apache error log.

 

can you help mew with it...pls???/

 

SSH into your machine and cd to your /oscommerce/install/dir

Just do a

grep -Ri yoursearchstring .

Code (markup):

Should be able to find the module and then vi and correct it.

Who modified this code though? oSCommerce works out of the box....

 

im dont use SSH.... and as im install the contribution of pdf catalog in oscommence of http://www.oscommerce.com/community/contributions,908/category,12/search,pdf+catalog. then im having error at the admin section when im (generate catalog)of it:-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='1' order by pd.products_name, p.products_date_added DESC
Jan 5th 2008 7:32 am

 

How did you install OSC on the computer? Did you use FTP?

 

thanks... i was getting this error all night and finally i have it fixed thanks to your input

International SEO Company

 

Thankx that i could help u ppl.