Canada post database error

[Australian Caching]

I am setting up the new store with the latest version, so far so good, Canada post working, showing dimensions etc, BUT when I copy a product (I have many varients of similar products) to save some typing,
I double checked the install, I went to adjust the PHP for mm and grams, but it was already set.

I get the following error.

"1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '// CANADA POST changes below: 'kgs', ' at line 20
in:
[insert into products (products_type, products_quantity, products_model, products_image, products_price, products_virtual, products_date_added, products_date_available, products_weight, products_weight_type, products_dim_type, products_length, products_width, products_height, products_ready_to_ship, products_status, products_tax_class_id, manufacturers_id, products_quantity_order_min, products_quantity_order_units, products_priced_by_attribute, product_is_free, product_is_call, products_quantity_mixed, product_is_always_free_shipping, products_qty_box_status, products_quantity_order_max, products_sort_order, products_price_sorter, master_categories_id ) values ('1', '50', 'golf ball', 'golfball cache open.JPG', '4.5000', '0', now(), '0001-01-01 00:00:00', '0', // CANADA POST changes below: 'kgs', 'cm', '0.00', '0.00', '0.00', '0', '0', '0', '0', '1', '1', '0', '0', '0', '1', '0', '1', '0', '0', '4.5000', '6')]
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."

[DrByte]

In the addon's /admin/includes/modules/copy_to_confirm.php file, on line 74 you'll see this comment line starting with // which needs to be removed:

                                  '" . $products_weight . "',
 // CANADA POST changes below:
                                  '" . zen_db_input($product->fields['products_weight_type']) . "',

[Australian Caching]

Thank you oh Guru for the very fast reply and easy fix.

Guy

[kristad]

I am having this same problem / error when I go to copy a product.
" 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '// CANADA POST changes below: 'kgs', ' "

I have done what this posts says to correct the problem but it still does not work. Any suggestions please?
Using v .3.9

Thank you....

[ksookma]

It’s the second one, if you are using Dreamweaver you will see it is colored red instead of orange.

[DazAna]

Thanks you for easy fix!

[karmasherbs]

Me too. Found the answer here!
Thanks so much:)