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

:no:Since uploading products with easy populate i am unable to edit any of the products descriptions. This is what i am presented with below once i click the edit icon:

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 direct00products p, direct00products_description pd where p.products_id = '1120' 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.

This doesn't look like an Easy Populate problem. It looks as though you have added a mod that's expecting to find additional product fields: products_height, products_length and products_width in your database's products table, but that this table hasn't been extended to include. Apart from uploading data with Easy Populate, what else have you done to your site?

Thats all i had done. If i enter categories and products manually this does not occur. It has ONLY happened since uploading products via: easy populate.

:clap: I guess you may have been correct, as i have just installed another zencart on my database and done a test without any other modules added. NO PROBLEMS what so ever. Thanks for your assistance. I would not no what module could have been causing this problem.

Slash74:

:clap: I guess you may have been correct, as i have just installed another zencart on my database and done a test without any other modules added. NO PROBLEMS what so ever. Thanks for your assistance. I would not no what module could have been causing this problem.

I received a similar error when I decided to uninstal "Candadian Post", never did figure out how to completely get rid of it, so I re-installed it and just disabled it.

DWells:

I received a similar error when I decided to uninstal "Candadian Post", never did figure out how to completely get rid of it, so I re-installed it and just disabled it.This could be a good clue. There are some shipping modules that require a packages dimensions and may add them to the database. If only their code was implemented without the extra database fields, or as in your case the database fields were removed by maybe some code trying to access them somehow got left in, then that would explain the error.

Hhad the same problem after i had created a new database with modified Zencart files. And it was tracked back to the OZ Post module. Have to reinstall the module properly (Modules > Shipping > OzPost , Remove and Install again) to fix this error.