Purple Lily template problem with adding product

[grans_attic]

Today I have installed zencart and also the purple lily template. after a few hours of getting most of the store looking the way I would like I decided to set up a test product and its not working

this is what i am getting:- 1054 Unknown column 'products_height' in 'field list'
in:
[insert into zen_products (products_quantity, products_type, products_model, products_price, products_date_available, products_weight, products_height, products_length, products_width, products_status, products_virtual, products_tax_class_id, manufacturers_id, products_quantity_order_min, products_quantity_order_units, products_priced_by_attribute, product_is_free, product_is_call, products_quantity_mixed, product_is_always_free_shipping, products_qty_box_status, products_quantity_order_max, products_sort_order, products_discount_type, products_discount_type_from, products_price_sorter, products_image, products_date_added, master_categories_id) values ('1', '1', 'VOT-NSENT', '2.00', null, '0', '0', '0', '0', '1', '0', '0', '0', '1', '1', '0', '0', '0', '1', '0', '1', '0', '0', '0', '0', '0', '', now(), '15')]


I am running Zen Cart 1.3.8a

I am not sure where I went wrong any and all help is greatly appreciated.

[afo]

It's unlikely the template is the problem. Switch to the classic template and see if the problem persists.

[grans_attic]

Thanks Afo I did that and yes the same thing happened. So now I am not sure where the problem is at all.

[stevesh]

Since there is no 'product_height' field in a stock Zencart database, I'm guessing you installed a mod (probably the Canada Post mod) and neglected to run the SQL patch included in the mod.

[integrity_designs]

I have this same issue but Using the Zen Cart Classic template and OZpost Shipping module. I have nothing to do with the Canada Post module... what would I need to do please?

I am at a loss....

The only thing different I have done was the following to make my banner's display the way i wanted.
here (#8 here). I am sure that would not have had any affect on it working. Right?

Please help.....

Kind Regards Casey

EDIT: using latest version and I am trying to add my first product.

[integrity_designs]

please anyone able to help with this?

[integrity_designs]

Fixed it myself. My ozpost module was uninstalled after the zen cart upgrade of changelog yesterday.

At least I can get listing now