Jump to content

Shipping weight too high - Canada Post Module


carnafeagh

Recommended Posts

Using CCV5.2.16

 

I enabled my Canada Post Shipping Module and tested purchasing a product. I had not filled in any address at all, this is what came up when I clicked on "View Basket"

 

This is what I got:

 

shipping1.jpg

 

Here is how I have my Canada Post Module Set:

 

shipping2.jpg

 

 

 

I went into the debugging with my IP and this is all the info that came up. I of course have no idea how to find my issue.

 

PHP:
No Errors or Warnings

GET:

'_g' => 'settings'

SESSION:

'__client' =>
'ip_address' => '206.132.54.69'
'useragent' => 'Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.99 Safari/537.36'
'session_start' => 1421939168
'session_last' => 1421939168
'currency' => 'CAD'
'admin_id' => '1'
'language' => 'en-US'
'__system' =>
'token' => '89991f5d3e78d0fff88cb46b71ec304a'
'__admin_data' =>
'admin_id' => '1'
'customer_id' => ''
'status' => '1'
'name' => 'Jill Morgan'
'username' => 'admin'
'new_password' => '1'
'email' => '[email protected]'
'verify' => ''
'logins' => '30'
'super_user' => '1'
'notes' => ''
'failLevel' => '0'
'blockTime' => '0'
'lastTime' => '1421937275'
'browser' => 'Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.99 Safari/537.36'
'ip_address' => '206.132.54.69'
'language' => 'en-GB'
'dashboard_notes' => ''
'order_notify' => '1'
'__admin' =>
'user_language' => 'en-GB'
'__recaptcha' =>
'error' => NULL
'confirmed' => false
'__basket' =>
'contents' =>
'8f7f87eb80c1ad883662c618a9dae999' =>
'id' => 28
'quantity' => 1
'digital' => '0'
'options' =>
'7' => '-38'
'3' =>
'0' => '45'
'2' =>
'0' => '785222'
'4' => '-27'
'options_identifier' => ''
'option_line_price' => 0
'total_price_each' => '20.99'
'description' => ' The advantage of embroidered collars over tags and chips is threefold: the precious information cannot get lost, there is no wait time for scanning and last but not least, they make a great fashion statement!   How to order:  '
'name' => '5/8" Teal Polka Dot Collar'
'product_code' => '5/8NOIAU59'
'product_weight' => 0.5
'tax_each' => false
'weight' => '0.500'
'discount' => '0.00'
'subtotal' => '20.99'
'total_tax' => '0.00'
'total' => '20.99'
'delivery_address' =>
'user_defined' => false
'postcode' => 'K9V4R1'
'country' => '124'
'country_iso' => 'CA'
'country_iso3' => 'CAN'
'state_id' => '74'
'state' => 'Ontario'
'state_abbrev' => 'ON'
'billing_address' =>
'user_defined' => false
'postcode' => 'K9V4R1'
'country' => '124'
'country_iso' => 'CA'
'country_iso3' => 'CAN'
'state_id' => '74'
'state' => 'Ontario'
'state_abbrev' => 'ON'
'shipping_hash' => 'a2072c8a50f1127f73a55a6b5f574da7'
'order_taxes' => false

COOKIE:

'PHPSESSID' => 'qfi05tdfibmk49dki6i9ns1e57'

MySQLi
Queries (13):
[1] SELECT SQL_CALC_FOUND_ROWS * FROM `pbf_CubeCart_sessions` WHERE pbf_CubeCart_sessions.session_id = 'qfi05tdfibmk49dki6i9ns1e57' LIMIT 1; -- (0.00131893157959 sec)
[2] SELECT FOUND_ROWS() as Count; -- (0.000602006912231 sec)
[3] SELECT * FROM `pbf_CubeCart_lang_strings` WHERE pbf_CubeCart_lang_strings.language = 'en-GB' ; -- (0.000290155410767 sec) [CACHED]
[4] SELECT * FROM `pbf_CubeCart_hooks` WHERE pbf_CubeCart_hooks.enabled = '1' ORDER BY priority ASC ; -- (0.000717163085938 sec) [CACHED]
[5] SELECT `php_code`, `unique_id`, `description`, `hook_trigger` FROM `pbf_CubeCart_code_snippet` WHERE pbf_CubeCart_code_snippet.enabled = '1' ORDER BY `priority` ASC ; -- (0.000402927398682 sec) [CACHED]
[6] SELECT `cat_id`, `cat_name`, `cat_parent_id` FROM `pbf_CubeCart_category` ORDER BY `cat_id` DESC ; -- (0.00113797187805 sec) [CACHED]
[7] SELECT `cat_id`, `cat_name` FROM `pbf_CubeCart_category_language` WHERE pbf_CubeCart_category_language.language = 'en-US' ; -- (0.00043511390686 sec) [CACHED]
[8] SELECT * FROM `pbf_CubeCart_permissions` WHERE pbf_CubeCart_permissions.admin_id = '1' ; -- (0.000427007675171 sec) [CACHED]
[9] SELECT * FROM `pbf_CubeCart_logo` ; -- (0.00028395652771 sec) [CACHED]
[10] SELECT `numcode`, `name` FROM `pbf_CubeCart_geo_country` ; -- (0.00350117683411 sec) [CACHED]
[11] SELECT gc.numcode, gz.id, gz.name FROM `pbf_CubeCart_geo_zone` AS `gz` LEFT JOIN `pbf_CubeCart_geo_country` AS `gc` ON gc.id=gz.country_id ORDER BY gc.name, gz.name ASC -- (0.00523114204407 sec) [CACHED]
[12] SELECT `name`, `code` FROM `pbf_CubeCart_currency` WHERE pbf_CubeCart_currency.active = '1' ORDER BY `name` ASC ; -- (0.000239849090576 sec) [CACHED]
[13] SHOW FULL COLUMNS FROM pbf_CubeCart_inventory -- (0.00329899787903 sec) [CACHED]
Errors:
No Errors

Memory: Peak Usage / Max (%):
12.02MB / 128M (9.39%)

Cache (None):
Cache is disabled [Clear Cache]

Page Load Time:
0.263124 seconds

 

Appreciate any help anyone can offer.

 

To add:  I did clear out the basket and do a new purchase to recheck, and this still came up.  I also have lots of countries (including Canada and US) in my zones.

 

Jill

Link to comment
Share on other sites

I cleared my cache, and this is what came up this time on the debugging:

 

PHP:
[Warning] /home3/carnafe1/public_html/jkmorganpets/cc/includes/lib/smarty/sysplugins/smarty_resource.php:733 - filemtime() [function.filemtime.php]: stat failed for /home3/carnafe1/public_html/jkmorganpets/cc/cache/skin/da39a3ee5e6b4b0d3255bfef95601890afd80709.string.php
[Warning] /home3/carnafe1/public_html/jkmorganpets/cc/includes/lib/smarty/sysplugins/smarty_resource.php:733 - filemtime() [function.filemtime.php]: stat failed for /home3/carnafe1/public_html/jkmorganpets/cc/cache/skin/48d1856f3c4f6586fbd6b169384c6caf4ca13c19.file.box.progress.php.php
[Notice] /home3/carnafe1/public_html/jkmorganpets/cc/modules/shipping/Canada_Post/shipping.class.php:73 - Canada Post Error -3004: Parcel too heavy to be shipped with CPC. 
[Warning] /home3/carnafe1/public_html/jkmorganpets/cc/classes/cubecart.class.php:1489 - Shipping not setup or allow no shipping not enabled
[Warning] /home3/carnafe1/public_html/jkmorganpets/cc/includes/lib/smarty/sysplugins/smarty_resource.php:733 - filemtime() [function.filemtime.php]: stat failed for /home3/carnafe1/public_html/jkmorganpets/cc/cache/skin/268d75d2e090dc540c3ce38dee7db641c1bf04a9.file.content.checkout.php.php
[Warning] /home3/carnafe1/public_html/jkmorganpets/cc/includes/lib/smarty/sysplugins/smarty_resource.php:733 - filemtime() [function.filemtime.php]: stat failed for /home3/carnafe1/public_html/jkmorganpets/cc/cache/skin/23b9881e1a3ee51e6af37a7f389e8cb531194616.file.box.session.php.php
[Warning] /home3/carnafe1/public_html/jkmorganpets/cc/includes/lib/smarty/sysplugins/smarty_resource.php:733 - filemtime() [function.filemtime.php]: stat failed for /home3/carnafe1/public_html/jkmorganpets/cc/cache/skin/1919ef98362cb69f4eb147318c5139f89e3e9220.file.element.navigation_tree.php.php
[Warning] /home3/carnafe1/public_html/jkmorganpets/cc/includes/lib/smarty/sysplugins/smarty_resource.php:733 - filemtime() [function.filemtime.php]: stat failed for /home3/carnafe1/public_html/jkmorganpets/cc/cache/skin/003d4940f994bc7e3bfffc43d2e88e3d324accd2.file.box.navigation.php.php
[Warning] /home3/carnafe1/public_html/jkmorganpets/cc/includes/lib/smarty/sysplugins/smarty_resource.php:733 - filemtime() [function.filemtime.php]: stat failed for /home3/carnafe1/public_html/jkmorganpets/cc/cache/skin/1032d3e3287b3678a573cd5727bb658116f073f7.file.box.search.php.php
[Warning] /home3/carnafe1/public_html/jkmorganpets/cc/includes/lib/smarty/sysplugins/smarty_resource.php:733 - filemtime() [function.filemtime.php]: stat failed for /home3/carnafe1/public_html/jkmorganpets/cc/cache/skin/b80676e68d8808efc3dc44ed3ec27aeb46f95e0b.file.box.newsletter.php.php
[Warning] /home3/carnafe1/public_html/jkmorganpets/cc/includes/lib/smarty/sysplugins/smarty_resource.php:733 - filemtime() [function.filemtime.php]: stat failed for /home3/carnafe1/public_html/jkmorganpets/cc/cache/skin/f73c96ad9b1605ce3092768ec2f546d2ec804048.file.box.documents.php.php
[Warning] /home3/carnafe1/public_html/jkmorganpets/cc/includes/lib/smarty/sysplugins/smarty_resource.php:733 - filemtime() [function.filemtime.php]: stat failed for /home3/carnafe1/public_html/jkmorganpets/cc/cache/skin/fef6d2200999e9221ad89cf51b934bca585faf93.file.box.featured.php.php
[Warning] /home3/carnafe1/public_html/jkmorganpets/cc/includes/lib/smarty/sysplugins/smarty_resource.php:733 - filemtime() [function.filemtime.php]: stat failed for /home3/carnafe1/public_html/jkmorganpets/cc/cache/skin/7b06d479653e9292e35e304369ff92b3a65b6e5c.file.main.php.php
[Warning] /home3/carnafe1/public_html/jkmorganpets/cc/includes/lib/smarty/sysplugins/smarty_resource.php:733 - filemtime() [function.filemtime.php]: stat failed for /home3/carnafe1/public_html/jkmorganpets/cc/cache/skin/19b0b4098d59ca0072e183955a5c796ae3fd730d.file.box.errors.php.php
[Warning] /home3/carnafe1/public_html/jkmorganpets/cc/includes/lib/smarty/sysplugins/smarty_resource.php:733 - filemtime() [function.filemtime.php]: stat failed for /home3/carnafe1/public_html/jkmorganpets/cc/cache/skin/0eef6441742e03c12b2b880bf50d4984784ba164.file.common.html.php
[Warning] /home3/carnafe1/public_html/jkmorganpets/cc/includes/lib/smarty/sysplugins/smarty_resource.php:733 - filemtime() [function.filemtime.php]: stat failed for /home3/carnafe1/public_html/jkmorganpets/cc/cache/skin/0970becb89af572a1b1292b7c314359442dd2e2c.file.ccpower.php.php

GET:

'_a' => 'basket'

SESSION:

'__client' =>
'ip_address' => '206.132.54.69'
'useragent' => 'Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.99 Safari/537.36'
'session_start' => 1421940218
'session_last' => 1421940230
'currency' => 'CAD'
'admin_id' => '1'
'language' => 'en-US'
'__system' =>
'token' => '89991f5d3e78d0fff88cb46b71ec304a'
'__admin_data' =>
'admin_id' => '1'
'customer_id' => ''
'status' => '1'
'name' => 'Jill Morgan'
'username' => 'admin'
'new_password' => '1'
'email' => '[email protected]'
'verify' => ''
'logins' => '30'
'super_user' => '1'
'notes' => ''
'failLevel' => '0'
'blockTime' => '0'
'lastTime' => '1421937275'
'browser' => 'Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.99 Safari/537.36'
'ip_address' => '206.132.54.69'
'language' => 'en-GB'
'dashboard_notes' => ''
'order_notify' => '1'
'__admin' =>
'user_language' => 'en-GB'
'__recaptcha' =>
'error' => NULL
'confirmed' => false
'__basket' =>
'contents' =>
'8f7f87eb80c1ad883662c618a9dae999' =>
'id' => 28
'quantity' => 1
'digital' => '0'
'options' =>
'7' => '-38'
'3' =>
'0' => '45'
'2' =>
'0' => '785222'
'4' => '-27'
'options_identifier' => ''
'option_line_price' => 0
'total_price_each' => '20.99'
'description' => ' The advantage of embroidered collars over tags and chips is threefold: the precious information cannot get lost, there is no wait time for scanning and last but not least, they make a great fashion statement!   How to order:  '
'name' => '5/8" Teal Polka Dot Collar'
'product_code' => '5/8NOIAU59'
'product_weight' => 0.5
'tax_each' => false
'weight' => '0.500'
'discount' => '0.00'
'subtotal' => '20.99'
'total_tax' => '0.00'
'total' => '20.99'
'delivery_address' =>
'user_defined' => false
'postcode' => 'K9V4R1'
'country' => '124'
'country_iso' => 'CA'
'country_iso3' => 'CAN'
'state_id' => '74'
'state' => 'Ontario'
'state_abbrev' => 'ON'
'billing_address' =>
'user_defined' => false
'postcode' => 'K9V4R1'
'country' => '124'
'country_iso' => 'CA'
'country_iso3' => 'CAN'
'state_id' => '74'
'state' => 'Ontario'
'state_abbrev' => 'ON'
'shipping_hash' => 'a2072c8a50f1127f73a55a6b5f574da7'
'order_taxes' => false

COOKIE:

'PHPSESSID' => 'qfi05tdfibmk49dki6i9ns1e57'

MySQLi
Queries (75):
[1] SELECT SQL_CALC_FOUND_ROWS * FROM `pbf_CubeCart_sessions` WHERE pbf_CubeCart_sessions.session_id = 'qfi05tdfibmk49dki6i9ns1e57' LIMIT 1; -- (0.000463962554932 sec)
[2] SELECT FOUND_ROWS() as Count; -- (0.00171709060669 sec)
[3] SELECT * FROM `pbf_CubeCart_lang_strings` WHERE pbf_CubeCart_lang_strings.language = 'en-US' ; -- (0.000205993652344 sec) [CACHED]
[4] SELECT * FROM `pbf_CubeCart_hooks` WHERE pbf_CubeCart_hooks.enabled = '1' ORDER BY priority ASC ; -- (0.000202894210815 sec) [CACHED]
[5] SELECT `php_code`, `unique_id`, `description`, `hook_trigger` FROM `pbf_CubeCart_code_snippet` WHERE pbf_CubeCart_code_snippet.enabled = '1' ORDER BY `priority` ASC ; -- (0.000189065933228 sec) [CACHED]
[6] SELECT `cat_id`, `cat_name`, `cat_parent_id` FROM `pbf_CubeCart_category` ORDER BY `cat_id` DESC ; -- (0.0011670589447 sec) [CACHED]
[7] SELECT `cat_id`, `cat_name` FROM `pbf_CubeCart_category_language` WHERE pbf_CubeCart_category_language.language = 'en-US' ; -- (0.000178098678589 sec) [CACHED]
[8] SELECT SQL_CALC_FOUND_ROWS `array` FROM `pbf_CubeCart_config` WHERE pbf_CubeCart_config.name = 'logos' LIMIT 1; -- (0.000826120376587 sec) [CACHED]
[9] SELECT FOUND_ROWS() as Count; -- (0.00117588043213 sec)
[10] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `pbf_CubeCart_modules` WHERE pbf_CubeCart_modules.folder = 'logos' LIMIT 1; -- (0.000249862670898 sec) [CACHED]
[11] SELECT `folder` FROM `pbf_CubeCart_modules` WHERE pbf_CubeCart_modules.module = 'livehelp' AND pbf_CubeCart_modules.status = '1' ; -- (0.000200986862183 sec) [CACHED]
[12] SELECT * FROM `pbf_CubeCart_currency` WHERE pbf_CubeCart_currency.code = 'CAD' ; -- (0.000265121459961 sec) [CACHED]
[13] SELECT SQL_CALC_FOUND_ROWS `customer_id` FROM `pbf_CubeCart_sessions` WHERE pbf_CubeCart_sessions.session_id = 'qfi05tdfibmk49dki6i9ns1e57' LIMIT 1; -- (0.000743865966797 sec)
[14] SELECT FOUND_ROWS() as Count; -- (0.000164031982422 sec)
[15] SELECT SQL_CALC_FOUND_ROWS `array` FROM `pbf_CubeCart_config` WHERE pbf_CubeCart_config.name = 'Per_Category' LIMIT 1; -- (0.000662088394165 sec) [CACHED]
[16] SELECT SQL_CACHE T.tax_name AS type_name, D.display, D.name, R.id, R.type_id, R.tax_percent, R.goods, R.shipping, R.county_id FROM pbf_CubeCart_tax_rates AS R, pbf_CubeCart_tax_details AS D, pbf_CubeCart_tax_class AS T, pbf_CubeCart_geo_country AS C WHERE D.id = R.details_id AND C.numcode = R.country_id AND R.type_id = T.id AND D.status = 1 AND R.active = 1 AND R.country_id = 124 -- (0.00059700012207 sec) [CACHED]
[17] SELECT CI.* , C.status FROM `pbf_CubeCart_category_index` AS CI, `pbf_CubeCart_category` AS C WHERE CI.product_id = '28' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.000250101089478 sec) [CACHED]
[18] SELECT SQL_CALC_FOUND_ROWS * FROM `pbf_CubeCart_inventory` WHERE pbf_CubeCart_inventory.product_id = '28' AND pbf_CubeCart_inventory.status = '1' LIMIT 10 OFFSET 0; -- (0.000385999679565 sec) [CACHED]
[19] SELECT FOUND_ROWS() as Count; -- (0.000302076339722 sec)
[20] SELECT `stock_level`, `product_code`, `upc`, `jan`, `isbn`, `image` FROM `pbf_CubeCart_option_matrix` WHERE pbf_CubeCart_option_matrix.product_id = '28' AND pbf_CubeCart_option_matrix.options_identifier = '' AND pbf_CubeCart_option_matrix.status = '1' ; -- (0.000223875045776 sec) [CACHED]
[21] SELECT `quantity`, `price` FROM `pbf_CubeCart_pricing_quantity` WHERE pbf_CubeCart_pricing_quantity.product_id = '28' AND pbf_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.000205039978027 sec) [CACHED]
[22] SELECT * FROM `pbf_CubeCart_option_group` WHERE pbf_CubeCart_option_group.option_id = '7' ; -- (0.000242948532104 sec) [CACHED]
[23] SELECT * FROM `pbf_CubeCart_option_value` WHERE pbf_CubeCart_option_value.value_id = '38' ; -- (7.29560852051E-5 sec) [CACHED]
[24] SELECT * FROM `pbf_CubeCart_option_assign` WHERE pbf_CubeCart_option_assign.product = '28' AND pbf_CubeCart_option_assign.option_id = '3' ; -- (0.000137805938721 sec) [CACHED]
[25] SELECT * FROM `pbf_CubeCart_option_group` WHERE pbf_CubeCart_option_group.option_id = '3' ; -- (0.000231027603149 sec) [CACHED]
[26] SELECT * FROM `pbf_CubeCart_option_assign` WHERE pbf_CubeCart_option_assign.assign_id = '0' ; -- (0.00019097328186 sec) [CACHED]
[27] SELECT * FROM `pbf_CubeCart_option_assign` WHERE pbf_CubeCart_option_assign.product = '28' AND pbf_CubeCart_option_assign.option_id = '2' ; -- (0.000158786773682 sec) [CACHED]
[28] SELECT * FROM `pbf_CubeCart_option_group` WHERE pbf_CubeCart_option_group.option_id = '2' ; -- (0.00019097328186 sec) [CACHED]
[29] SELECT * FROM `pbf_CubeCart_option_assign` WHERE pbf_CubeCart_option_assign.assign_id = '0' ; -- (0.000155925750732 sec) [CACHED]
[30] SELECT * FROM `pbf_CubeCart_option_group` WHERE pbf_CubeCart_option_group.option_id = '4' ; -- (0.000186920166016 sec) [CACHED]
[31] SELECT * FROM `pbf_CubeCart_option_value` WHERE pbf_CubeCart_option_value.value_id = '27' ; -- (0.000271081924438 sec) [CACHED]
[32] SELECT SQL_CALC_FOUND_ROWS `array` FROM `pbf_CubeCart_config` WHERE pbf_CubeCart_config.name = 'gift_certs' LIMIT 1; -- (0.000832080841064 sec) [CACHED]
[33] SELECT FOUND_ROWS() as Count; -- (0.000256061553955 sec)
[34] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `pbf_CubeCart_modules` WHERE pbf_CubeCart_modules.folder = 'gift_certs' LIMIT 1; -- (0.000226974487305 sec) [CACHED]
[35] SELECT SQL_CALC_FOUND_ROWS * FROM `pbf_CubeCart_image_index` WHERE pbf_CubeCart_image_index.product_id = '28' ORDER BY `main_img` DESC LIMIT 1; -- (0.000219821929932 sec) [CACHED]
[36] SELECT FOUND_ROWS() as Count; -- (0.000264883041382 sec)
[37] SELECT SQL_CALC_FOUND_ROWS * FROM `pbf_CubeCart_image_index` WHERE pbf_CubeCart_image_index.product_id = '28' ORDER BY `main_img` DESC LIMIT 1; -- (0.000216960906982 sec) [CACHED]
[38] SELECT FOUND_ROWS() as Count; -- (0.000237226486206 sec)
[39] SELECT * FROM `pbf_CubeCart_filemanager` WHERE pbf_CubeCart_filemanager.file_id = '35' ; -- (0.000245094299316 sec) [CACHED]
[40] SELECT `folder`, `countries` FROM `pbf_CubeCart_modules` WHERE pbf_CubeCart_modules.module = 'shipping' AND pbf_CubeCart_modules.status = '1' ; -- (0.000232934951782 sec) [CACHED]
[41] SELECT SQL_CALC_FOUND_ROWS `array` FROM `pbf_CubeCart_config` WHERE pbf_CubeCart_config.name = 'Canada_Post' LIMIT 1; -- (0.000439167022705 sec) [CACHED]
[42] SELECT FOUND_ROWS() as Count; -- (0.000324010848999 sec)
[43] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `pbf_CubeCart_modules` WHERE pbf_CubeCart_modules.folder = 'Canada_Post' LIMIT 1; -- (0.000195980072021 sec) [CACHED]
[44] SELECT FOUND_ROWS() as Count; -- (0.000236034393311 sec)
[45] INSERT INTO `pbf_CubeCart_request_log` (`request_url`,`request`,`result`) VALUES ('http://sellonline.canadapost.ca/','<eparcel>n<language>en</language>n <ratesAndServicesRequest>n <merchantCPCID>xxxxxxxxxxxxx</merchantCPCID>n <fromPostalCode>K9V 4R1</fromPostalCode>n <itemsPrice>20.99</itemsPrice>n <lineItems>n <item>n <quantity>1</quantity>n <weight>70.5</weight>n <length>15</length>n <width>15</width>n <height>20</height>n <description>Online Order</description>n </item>n </lineItems>n <city></city>n <provOrState>Ontario</provOrState>n <country>CA</country>n <postalCode>K9V4R1</postalCode>n </ratesAndServicesRequest>n</eparcel>n','<?xml version="1.0" ?>n<!DOCTYPE eparcel [n<!ELEMENT eparcel (error)>n<!ELEMENT error (statusCode,statusMessage*, requestID)>n<!ELEMENT statusCode (#PCDATA)>n<!ELEMENT statusMessage (#PCDATA)>n<!ELEMENT requestID (#PCDATA)>n]>n<eparcel>n<error>n<statusCode>-3004</statusCode>n<statusMessage>Parcel too heavy to be shipped with CPC. </statusMessage>n<requestID>12641256</requestID>n</error>n</eparcel>n<!--END_OF_EPARCEL-->n'); -- (0.00043797492981 sec)
[46] SELECT SQL_CALC_FOUND_ROWS DISTINCT `cart_order_id` FROM `pbf_CubeCart_order_inventory` WHERE `product_id` IN (28) GROUP BY cart_order_id ORDER BY `id` DESC LIMIT 30; -- (0.000102996826172 sec) [CACHED]
[47] SELECT SQL_CALC_FOUND_ROWS `array` FROM `pbf_CubeCart_config` WHERE pbf_CubeCart_config.name = 'languages' LIMIT 1; -- (0.00230503082275 sec) [CACHED]
[48] SELECT FOUND_ROWS() as Count; -- (0.00086784362793 sec)
[49] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `pbf_CubeCart_modules` WHERE pbf_CubeCart_modules.folder = 'languages' LIMIT 1; -- (0.000810146331787 sec) [CACHED]
[50] SELECT * FROM `pbf_CubeCart_currency` WHERE pbf_CubeCart_currency.active = '1' ; -- (0.000371932983398 sec) [CACHED]
[51] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `pbf_CubeCart_category` WHERE pbf_CubeCart_category.cat_parent_id = '0' AND pbf_CubeCart_category.status = '1' AND pbf_CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.000159025192261 sec) [CACHED]
[52] SELECT `cat_id`, `cat_name` FROM `pbf_CubeCart_category_language` WHERE pbf_CubeCart_category_language.language = 'en-US' ; -- (0.00030779838562 sec) [CACHED]
[53] SELECT `id` FROM `pbf_CubeCart_category_index` AS C INNER JOIN `pbf_CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 2 AND I.status = 1 -- (0.000139951705933 sec) [CACHED]
[54] SELECT COUNT(cat_id) AS Count FROM `pbf_CubeCart_category` WHERE pbf_CubeCart_category.cat_parent_id = '2' AND pbf_CubeCart_category.status = '1'; -- (0.00096607208252 sec) [CACHED]
[55] SELECT `id` FROM `pbf_CubeCart_category_index` AS C INNER JOIN `pbf_CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 3 AND I.status = 1 -- (0 sec) [CACHED]
[56] SELECT COUNT(cat_id) AS Count FROM `pbf_CubeCart_category` WHERE pbf_CubeCart_category.cat_parent_id = '3' AND pbf_CubeCart_category.status = '1'; -- (0.000110864639282 sec) [CACHED]
[57] SELECT `id` FROM `pbf_CubeCart_category_index` AS C INNER JOIN `pbf_CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 4 AND I.status = 1 -- (8.79764556885E-5 sec) [CACHED]
[58] SELECT COUNT(cat_id) AS Count FROM `pbf_CubeCart_category` WHERE pbf_CubeCart_category.cat_parent_id = '4' AND pbf_CubeCart_category.status = '1'; -- (0.0001380443573 sec) [CACHED]
[59] SELECT `id` FROM `pbf_CubeCart_category_index` AS C INNER JOIN `pbf_CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 20 AND I.status = 1 -- (0.00203418731689 sec) [CACHED]
[60] SELECT COUNT(cat_id) AS Count FROM `pbf_CubeCart_category` WHERE pbf_CubeCart_category.cat_parent_id = '20' AND pbf_CubeCart_category.status = '1'; -- (3.38554382324E-5 sec) [CACHED]
[61] SELECT `id` FROM `pbf_CubeCart_category_index` AS C INNER JOIN `pbf_CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 5 AND I.status = 1 -- (9.20295715332E-5 sec) [CACHED]
[62] SELECT COUNT(cat_id) AS Count FROM `pbf_CubeCart_category` WHERE pbf_CubeCart_category.cat_parent_id = '5' AND pbf_CubeCart_category.status = '1'; -- (0.000109910964966 sec) [CACHED]
[63] SELECT `id` FROM `pbf_CubeCart_category_index` AS C INNER JOIN `pbf_CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 6 AND I.status = 1 -- (9.01222229004E-5 sec) [CACHED]
[64] SELECT COUNT(cat_id) AS Count FROM `pbf_CubeCart_category` WHERE pbf_CubeCart_category.cat_parent_id = '6' AND pbf_CubeCart_category.status = '1'; -- (0.00010085105896 sec) [CACHED]
[65] SELECT `id` FROM `pbf_CubeCart_category_index` AS C INNER JOIN `pbf_CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 53 AND I.status = 1 -- (9.41753387451E-5 sec) [CACHED]
[66] SELECT COUNT(cat_id) AS Count FROM `pbf_CubeCart_category` WHERE pbf_CubeCart_category.cat_parent_id = '53' AND pbf_CubeCart_category.status = '1'; -- (0.000826120376587 sec) [CACHED]
[67] SELECT `id` FROM `pbf_CubeCart_category_index` AS C INNER JOIN `pbf_CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 54 AND I.status = 1 -- (9.98973846436E-5 sec) [CACHED]
[68] SELECT COUNT(cat_id) AS Count FROM `pbf_CubeCart_category` WHERE pbf_CubeCart_category.cat_parent_id = '54' AND pbf_CubeCart_category.status = '1'; -- (0.000114917755127 sec) [CACHED]
[69] SELECT * FROM `pbf_CubeCart_documents` WHERE pbf_CubeCart_documents.doc_parent_id = '0' AND pbf_CubeCart_documents.doc_status = '1' AND pbf_CubeCart_documents.navigation_link = '1' ORDER BY `doc_order` ASC ; -- (0.000653028488159 sec) [CACHED]
[70] SELECT SQL_CALC_FOUND_ROWS `array` FROM `pbf_CubeCart_config` WHERE pbf_CubeCart_config.name = 'Contact_Form' LIMIT 1; -- (0.00434184074402 sec) [CACHED]
[71] SELECT * FROM `pbf_CubeCart_inventory` JOIN (SELECT CEIL(RAND() * (SELECT MAX(`product_id`) FROM `pbf_CubeCart_inventory`)) AS `product_id`) AS `r` USING (`product_id`) WHERE pbf_CubeCart_inventory.status = '1' -- (0.00115609169006 sec)
[72] SELECT CI.* , C.status FROM `pbf_CubeCart_category_index` AS CI, `pbf_CubeCart_category` AS C WHERE CI.product_id = '95' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.00517201423645 sec) [CACHED]
[73] SELECT SQL_CALC_FOUND_ROWS * FROM `pbf_CubeCart_image_index` WHERE pbf_CubeCart_image_index.product_id = '95' ORDER BY `main_img` DESC LIMIT 1; -- (0.00175499916077 sec) [CACHED]
[74] SELECT `quantity`, `price` FROM `pbf_CubeCart_pricing_quantity` WHERE pbf_CubeCart_pricing_quantity.product_id = '95' AND pbf_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.000380039215088 sec) [CACHED]
[75] SELECT `oi`.`product_id` AS product_id, `i`.`name`, SUM(`oi`.`quantity`) as `quantity` FROM `pbf_CubeCart_order_inventory` as `oi` JOIN `pbf_CubeCart_inventory` as `i` WHERE `oi`.`product_id` = `i`.`product_id` AND `i`.`status` = 1 GROUP BY `product_id` ORDER BY `quantity` DESC LIMIT 10; -- (0.00195097923279 sec) [CACHED]
Errors:
No Errors

Memory: Peak Usage / Max (%):

 

 

14.16MB / 128M (11.06%)

Cache (None):
Cache is disabled [Clear Cache]

Page Load Time:
 

 

 

Edited to remove my Canada Post ID

Link to comment
Share on other sites

A couple of suggestions:

 

Since you are using Canada Post, I suggest you set your store's store-wide weight unit and currency unit to match the requirements of CP. Those requirements are (probably) Metric-Kg for weight and Canadian Dollars (CAD) for currency.

 

The CP module does not make any conversions. So, if your store-wide setting is Imperial-lb for weight, the rate quotes from CP could be wildly off target.

 

I notice for Origin Postcode, you have entered a value with a space in it. I absolutely do not know if this is allowed or disallowed, but until a definitive answer is obtained, I suggest making the postcode without the space.

 

For the HxWxL of the shipping box (20x15x15), CP requires this in centimeters. Additionally, the CP module is coded to assign these dimensions to each item in the order (which I absolutely do not know if this is correct), a fact that can probably be ignored.

 

For the weight of the shipping box (70), CP does not require this in the data sent for the rate quote, but CubeCart will add it to the weight of the items being shipped. The value 70Kg is 155lbs. Even if you meant to say 70lbs, I am sure CP will balk at this. Perhaps you meant to say the shipping box weighs 70g. Since CubeCart works in Kg, make this value 0.07.

 

For the lines in the PHP: section of the Debug output, you must ignore any item that references filemtime() or unset(). These are a result of the Smarty template rendering engine doing its thing.

Link to comment
Share on other sites

I use lbs on my other site with Canada Post and don't have any problems.

 

I assumed (dangerous word) that the weight in the set up is the maximum allowed by Canada Post. Same with box.

 

I remove the box size and also no weight. Canada Post does not come up as a selection Only the flat rate. I added that to see if there were shipping issues or it was just the Canada Post Module.

 

I changed the lbs to kg, deleted the space in the postal code, but no. Here is the top code error I am getting now:

 

[Notice] /home3/carnafe1/public_html/jkmorganpets/cc/modules/shipping/Canada_Post/shipping.class.php:73 - Canada Post Error -5000: XML parsing error.

 

If I look up code errors at Canada Post, there is no error 5000

 

Jill

Link to comment
Share on other sites

"I remove the box size and also no weight."

 

Please try using the CP module with values in the HxWxL box size form fields with the typical box size you use, expressed in centimeters.

 

Using zero weight (or blank) for the box weight is fine.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...