Canada Post Sql

[FMMap]

I get this error when trying to add the sql for this module:
Error

SQL query:
#Canada Post Shipping Module -- Adds dimensional support to products
ALTER TABLE products ADD products_weight_type ENUM( 'lbs', 'kgs' ) NOT NULL default 'kgs' AFTER products_weight;


MySQL said:
#1060 - Duplicate column name 'products_weight_type'

Plus, I can't do this from Admin.

[FMMap]

I I try to install from ADMIN, this erro array comes up:
Failed: 6 ERROR: Cannot ADD column products_weight_type because it already exists. ERROR: Cannot ADD column products_dim_type because it already exists. ERROR: Cannot ADD column products_length because it already exists. ERROR: Cannot ADD column products_width because it already exists. ERROR: Cannot ADD column products_height because it already exists. ERROR: Cannot ADD column products_ready_to_ship because it already exists.

[Ajeh]

Sounds like the fields are there and you are trying to add them again ...

Look at your database table via phpMyAdmin ... do you already see the fields in the products table?

[FMMap]

I wouldn't know where to look! AND the CanadaPost option isn't listed in Admin / Modules /shipping

[FMMap]

OK, sorry for being dumb; in admin/config/product listing, these values are there but not all; there's no lbbs/kgs etc

[FMMap]

I wouldn't know where to look! AND the CanadaPost option isn't listed in Admin / Modules /shipping

OK, found them in the dB, all values are there, BUT no Canada Post option comes up in admin.

[FMMap]

I think I've solved the problem. The CP module now shows up (misssed some uploads).

[Ajeh]

Thanks for the updates on what was missing on your site for this ... always a help to others with similar issues ...

[LenkArt]

Hi, Linda

I am in Canada and I need to install Canada Post to my ZENcart/LenkArt.
What should I do?

Thanks, Elena

[DrByte]

reply posted to your other thread about installation (since this thread is about a SQL challenge instead of how to install).
http://www.zen-cart.com/forum/showthread.php?t=59717