canada post checkout error

[MB1]

just added the module and installed it

and this is what displays on my main page where the checkout sidebox would be

1054 Unknown column 'p.products_dim_type' in 'field list'
in:
[select p.products_id, p.products_status, pd.products_name, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_dim_type, p.products_weight_type, p.products_length, p.products_width, p.products_height, p.products_ready_to_ship, p.products_tax_class_id, p.products_quantity_order_min, p.products_quantity_order_units, p.product_is_free, p.products_priced_by_attribute, p.products_discount_type, p.products_discount_type_from from storeproducts p, storeproducts_description pd where p.products_id = '41' and pd.products_id = p.products_id and pd.language_id = '1']

any ideas what this is all about?

[MB1]

no one has ever run into this problem?

[verdon]

was there an sql patch to run? did you do that?

[MB1]

an sql patch i don't know, i didn't run one

[verdon]

There are 2 CP modules floating around. One supports dimensional multi-box packaging and the other doesn't. The one that does requires modifications to the products table (so you can enter packaging info). It comes with some SQL statements that need to be run, to modify your database.

If you look at the error you are getting...

p.products_dim_type, p.products_weight_type, p.products_length, p.products_width, p.products_height

... these are not standard fields, which indicates to me you are using the CP module with dimensional support, and did not make the required changes to the database.

Best luck,

[MB1]

i did the patch thing and reinstalled it now everything is fine other then i have to put in the deminsions on all these products