Home Community Forum Plugins

Documentation

For Developers For Storeowners

Services Donate Get Started

Forums / Addon Shipping Modules / Canada Post Sql

Canada Post Sql

Locked

Results 1 to 10 of 10

This thread is locked. New replies are disabled.

07 Feb 2007, 14:08

fmmap

New Zenner

Join Date:: Jan 2007
Posts:: 13
Plugin Contributions:: 0

Canada Post Sql

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: http://70.98.54.163:2082/3rdparty/phpMyAdmin/themes/original/img/b_help.png
#1060 - Duplicate column name 'products_weight_type'

Plus, I can't do this from Admin.

07 Feb 2007, 14:11

fmmap

New Zenner

Join Date:: Jan 2007
Posts:: 13
Plugin Contributions:: 0

Re: Canada Post Sql

I I try to install from ADMIN, this erro array comes up:
http://www.masteraminopattern.com/master/Fran1Mac0/images/icons/error.gif Failed: 6http://www.masteraminopattern.com/master/Fran1Mac0/images/icons/error.gif ERROR: Cannot ADD column products_weight_type because it already exists.http://www.masteraminopattern.com/master/Fran1Mac0/images/icons/error.gif ERROR: Cannot ADD column products_dim_type because it already exists.http://www.masteraminopattern.com/master/Fran1Mac0/images/icons/error.gif ERROR: Cannot ADD column products_length because it already exists.http://www.masteraminopattern.com/master/Fran1Mac0/images/icons/error.gif ERROR: Cannot ADD column products_width because it already exists.http://www.masteraminopattern.com/master/Fran1Mac0/images/icons/error.gif ERROR: Cannot ADD column products_height because it already exists.http://www.masteraminopattern.com/master/Fran1Mac0/images/icons/error.gif ERROR: Cannot ADD column products_ready_to_ship because it already exists.

07 Feb 2007, 14:12

ajeh

Oba-san

Join Date:: Sep 2003
Posts:: 62,757
Plugin Contributions:: 1

Re: Canada Post Sql

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?

07 Feb 2007, 14:31

fmmap

New Zenner

Join Date:: Jan 2007
Posts:: 13
Plugin Contributions:: 0

Re: Canada Post Sql

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

07 Feb 2007, 14:37

fmmap

New Zenner

Join Date:: Jan 2007
Posts:: 13
Plugin Contributions:: 0

Re: Canada Post Sql

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

07 Feb 2007, 14:46

fmmap

New Zenner

Join Date:: Jan 2007
Posts:: 13
Plugin Contributions:: 0

Re: Canada Post Sql

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.

07 Feb 2007, 15:09

fmmap

New Zenner

Join Date:: Jan 2007
Posts:: 13
Plugin Contributions:: 0

Re: Canada Post Sql

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

07 Feb 2007, 17:28

ajeh

Oba-san

Join Date:: Sep 2003
Posts:: 62,757
Plugin Contributions:: 1

Re: Canada Post Sql

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

01 Mar 2007, 23:05

lenkart

New Zenner

Join Date:: Mar 2007
Posts:: 9
Plugin Contributions:: 0

Re: Canada Post Sql

Hi, Linda

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

Thanks, Elena

02 Mar 2007, 03:27

#10

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: Canada Post Sql

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