Zen Cart Logo
Forums / Templates, Stylesheets, Page Layout / I can not edit my stock anymore

I can not edit my stock anymore

Locked

Views: 733

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
20 Jun 2007, 6:20 AM
#1
sylsau avatar

sylsau

New Zenner

Join Date:
Aug 2006
Location:
Australia
Posts:
15
Plugin Contributions:
0

I can not edit my stock anymore

I have now my shop running some time. Yesterday I added some stock and did some customization of the chart, as I tray to edit today I get following message:

1054 Unknown column 'p.products_height' in 'field list'
in:
[select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_virtual, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id, p.products_height,p.products_length, p.products_width, 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, p.products_discount_type, p.products_discount_type_from, p.products_price_sorter, p.master_categories_id from zen_products p, zen_products_description pd where p.products_id = '12' and p.products_id = pd.products_id and pd.language_id = '1']
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.

the same happened when I tray to insert a new Product.
The shop front seems to be Ok all product show as thy should and ordering is possible. http://www.stackcups.com.au/shop/ what did I do wrong?
Sylvia

21 Jun 2007, 11:02 AM
#2
rodg avatar

rodg

Deceased

Join Date:
Jan 2007
Location:
Australia
Posts:
6,263
Plugin Contributions:
4

Re: I can not edit my stock anymore

Did you add or update the AustPost shipping module (improved)?

If so, your database tables need updating. The easiest way to do this is to uninstall and resinstall the module (from the modules/shipping menu).

Disregard this suggestion if you haven't installed or updated this module.

Cheers
Rod

21 Jun 2007, 11:57 AM
#3
sylsau avatar

sylsau

New Zenner

Join Date:
Aug 2006
Location:
Australia
Posts:
15
Plugin Contributions:
0

Re: I can not edit my stock anymore

thanks I started to install the AustPost shipping module (improved), somehow it did not show up, I have to look in to this, thanks