If this is your first visit, check our documentation. To post, register or login.
Forums / General Questions / 1054 Unknown column 'p.products_price_w' in 'field list'

1054 Unknown column 'p.products_price_w' in 'field list'

Locked

Started by bigbens on 21 Sep 2008, 11:50 PM · Views: 1,268

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
21 Sep 2008, 11:50 PM
#1
bigbens avatar

bigbens

New Zenner

Join Date:
Sep 2008
Location:
Nebraska
Posts:
11
Plugin Contributions:
0

1054 Unknown column 'p.products_price_w' in 'field list'

Now, I have another error that popped up in my Admin>Catalog>Categories/Products. I get error

1054 Unknown column 'p.products_price_w' in 'field list'
in:
[select p.products_type, p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_price_w, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.products_model, p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute, p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping, p.products_quantity_order_max, p.products_sort_order from zen_products p, zen_products_description pd, zen_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 = '10' order by p.products_sort_order, pd.products_name limit 0, 10]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

BUT GUESS WHAT? :censored: dead end

Someone please help.....

23 Sep 2008, 3:26 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: 1054 Unknown column 'p.products_price_w' in 'field list'

Sounds like an add-on that was not installed correctly ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!