Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

1054 error in categories/products backend.


Recommended Posts

Hey guys,


Im getting an error when I am in the categories tab in the admin section:

Categories / Products pixel_trans.gif Search: Go To:

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


select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_retail_price, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from products p, products_description pd, products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = '0' order by pd.products_name






What can be the cause of this? How can i fix it?

Link to comment
Share on other sites



Deleting the field in the code will fix the problem but how did it get there?


You/someone has have obviously put that field in there for a reason.


Was it for a specific contribution or were the contribution installation instructions wrong?


As the field doesn't seem to be throwing an error anywhere else it was probably wrong instructions.


I'ld want to know though.





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


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

  • Create New...