Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1054 - Unknown column 'p.products_price5' in 'field list'


Guest

Recommended Posts

Folks,

 

I have gone trough most of my files, which is kind of a pain since I have been going with oscommerce since 2002, have a lot of contributions installed, which gives me additional head aches.

 

I have implemented all forum advise and bug fix on the '1054 - Unknown column' issue, replaced p.products_id = s.products_id with p2c.products_id = s.products_id

 

Still I am having this error when I go to individual products:

 

 

1054 - Unknown column 'p.products_price5' in 'field list'

 

select pd.products_name, p.products_model, p.products_image, p.products_id, p.manufacturers_id, p.products_price, p.products_weight, p.products_quantity, 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_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_qty, p.products_qty_blocks, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price from products p left join specials s on p.products_id = s.products_id, products_description pd where p.products_status = '1' and pd.products_id = p.products_id and p.products_id = '586' and pd.language_id = '1'

 

[TEP STOP]

 

I know you all have gone over this already before, but I floored. 15 hours of search and going......

 

Thanks so much.

 

Wolfgang

Link to comment
Share on other sites

Rhea,

 

Thanks soooo much, that will get me going, I probably missed importing that table in a recent contribution.

 

Thanks again.

 

Wolfgang

Link to comment
Share on other sites

The database field 'products_price5' does not exist in the 'product table in the database.

 

Vger

 

 

One more time, thanks, the fix was laughable easy, I am up and running. Test transaction worked and I have a new contribution in the process 'Quantity Price Breaks Per Product'.

 

Take care,

 

Wolfgang

Link to comment
Share on other sites

One more time, thanks, the fix was laughable easy, I am up and running. Test transaction worked and I have a new contribution in the process 'Quantity Price Breaks Per Product'.

 

Take care,

 

Wolfgang

 

 

hey how did u fix this? i'm currently testing a template and it gives me that error. just delete 'products_price5' from database?

Link to comment
Share on other sites

No the exact opposite in fact.

 

You have installed a contribution which requires this field, unfortunately you have not run the sql included with the contribution to create the field.

 

My advice is start checking all the contribution installation, probably in reverse order

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...