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

[Guest]

I just installed a new local server so I could learn more about php and oscommerce with out messing up my store.

 

The main page works but almost all the admin section is screwy and can not view products

 

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

 

select pd.products_name, p.products_model, p.products_image, p.products_id, p.manufacturers_id, p.products_price, p.products_weight, p.products_price1,p.products_price2,p.products_price3,p.products_price4, p.products_price5,p.products_price6,p.products_price7,p.products_price8, p.products_price1_qty,p.products_price2_qty,p.products_price3_qty,p.products_pri

ce4_qty, p.products_price5_qty,p.products_price6_qty,p.products_price7_qty,p.products_pri

ce8_qty, p.products_qty_blocks, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price 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 = '365' and pd.products_id = '365' and pd.language_id = '1'

 

[TEP STOP]

 

That is what i get from the site. Some sort of DB error, But the database is in working order.

[Jack_mcs]

That means that the filed products_id is not in your database. It would have been added by some contribution so you need to find that contribution and make the database change.

 

Jack

[Guest]

That means that the filed products_id is not in your database. It would have been added by some contribution so you need to find that contribution and make the database change.

 

Jack

 

 

I've checked both databases they match 100% the local DB is a direct backup of the real time server

[Guest]

its a mysql version issue. You could get the latest upgrade of osc

http://www.oscommerce.com/solutions/downloads

 

or manually change the query to conform to the later mysql version.

[Guest]

its a mysql version issue. You could get the latest upgrade of osc

http://www.oscommerce.com/solutions/downloads

 

or manually change the query to conform to the later mysql version.

 

 

How do I manually change? My osc has about 15 mods in it, so i dont think I can upgrade very easily. I can change the mysql verson if needed.

[Guest]

there are step by step instructions with the latest download how to upgrade the original osc files.

[Guest]

there are step by step instructions with the latest download how to upgrade the original osc files.

 

 

Thanks for the help everyone. I just installed the older version of mysql since that is what my live version is running on.