1054 error in categories/products backend.

[vashichino7]

Hey guys,

 

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

Categories / Products 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

 

[TEP STOP]

 

 

 

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

[MrPhil]

I don't think that's a standard field. Did you recently add an add-on (mod) to osC? If so, you neglected to run the SQL query to add field(s) to table(s) in the database.

[vashichino7]

This error was fixed in categories.php in admin folder. The database was reading a products_retail_price and my database was did not have that table. So, I went ahead and deleted it and it works well.

[vashichino7]

Thank you Phil, problem solved.

[♥geoffreywalton]

Hi

 

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.

 

Cheers

 

G