Canada Post Shipping Module - SQL failed to run

[sjmills93]

ZenCart Version: 1.3.8b

Downloaded & extracted the shipping module (http://www.zen-cart.com/index.php?ma...products_id=78). Opened the Install_CP.txt document to follow directions to install.

1. Install_CP.txt - says its for v1.3.7 - so is it or has the version number in this install how to document just been overlooked?

2. Followed instruction #2 that says to go to Admin>Tools>Install SQLPatch by browse, select mysql_canpost_dimensional_3x.sql and clicking "send".

Problems:
Zencart has area for entry of sql commands with a "send" button AND where the browse button located has an "upload" button. So cannot follow directions as posted.

Tried to copy/paste the SQL commands from the mysql_canpost_dimension_13x file and received failures on all 6 commands!!

What should I be doing? Please help. Have attache screenprint of error messages.

[sjmills93]

OK - here's an update.

Using FTP - I uploaded the module's files into the appropriate folders as indicated in the Canada Post Shipping Module for Zen Cart instructions:
admin\includes\extra_configures\shipping_units.php
admin\includes\modules\copy_to_confirm.php
admin\includes\modules\update_product.php
admin\includes\modules\product\collect_info.php
admin\includes\modules\product\preview_info.php
admin\includes\languages\english\extra_definitions\canada_post_defines.php
includes\classes\shopping_cart.php
includes\extra_configures\shipping_units.php
includes\languages\english\modules\shipping\canadapost.php
includes\modules\shipping\canadapost.php
images\shipping_canadapost.gif

Then in looking for where to change the sytem units to kgs I realized I should click on Modules>Shipping and there was notice and button on right side to Install, so I clicked the Install button and filled in the text fields asking for lettermail postal rates and my client's Canada Post retailer ID.

However, there was an error at the top of the page saying that a file was missing, namely /public_html/includes/languages/english/modules/shipping/canadapost.php.

Double checked and FTP'd the file to the folder ZenCart seemed to want it.

Back to Modules>Shipping. Now I have an error that reads:

Fatal error: Cannot redeclare class canadapost in /home/judy9328/public_html/includes/modules/shipping/canadapost.php on line 496

???
Help would be great, anyone?

[Blackthorne]

You are either missing that file or it's locked and can't be read.

You need to triple check that it's actually in the correct folder. It can get confusing as there are duplicate folder structures in several places in Zen Cart.

Walk through it slowly, for each file.

The error you are getting is Zen Cart saying it has been told to look for that line in that file and it's not finding it.

[Vitalyk]

I was not able to run SQL file also. Im getting same errors
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.
Note: 6 statements ignored. See "upgrade_exceptions" table for additional details.

Please let me know what should I do step by step since I'm new to ZC