1054 Unknown column 'p.product_price_w' in 'field list'
i received this error:
Quote:
1054 Unknown column 'p.product_price_w' in 'field list'
in:
[select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_price, p.product_price_w, p.products_virtual, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id, 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_qty_box_status, p.products_quantity_order_max, p.products_sort_order from products p, products_description pd where p.products_id = pd.products_id and p.products_id = '932']
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.
It only seems to affect the product preview in the admin section of the cart and - my guess - it is related to the wholesale mod.
I asked before but haven't got any reply
Re: 1054 Unknown column 'p.product_price_w' in 'field list'
Yes, it's part of an addon.
You've evidently got the PHP part of the addon on your site, but you don't have the SQL changes applied to your site.
Re: 1054 Unknown column 'p.product_price_w' in 'field list'
Please refer to DrByte's post
Re: 1054 Unknown column 'p.product_price_w' in 'field list'
i ran the sql again and it says statements ignored tables already exist
zencart version 1.3.9h
Re: 1054 Unknown column 'p.product_price_w' in 'field list'
Are you sure it's talking about the correct tables?
Re: 1054 Unknown column 'p.product_price_w' in 'field list'
Quote:
i ran the sql again and it says statements ignored tables already exist
Most add on SQL is configured for a standard table - \
One with NO prefix
Do your other ZenCart tables have a prefix?
Re: 1054 Unknown column 'p.product_price_w' in 'field list'
judging from the error message content, I was guessing they don't :blush:
Re: 1054 Unknown column 'p.product_price_w' in 'field list'