Jump to content

carnafeagh

Member
  • Posts

    11
  • Joined

  • Last visited

Posts posted by carnafeagh

  1. 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

  2. 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

  3. 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

  4. "make descriptions for very similar items different"

     

    I would like to call your attention to Chuggy's "Additional Product Fields" (google for it). It provides a huge opportunity for a myriad of things that can be done. The number of solutions it provides is far greater than is initially envisioned.

     

     

    Thanks. That looks to be exactly what I am looking for.

     

    Jill

  5. Thanks. I just updated from .14 -.16 this morning and didn't notice that all the previous things that were "upgrade only" are now there for me to use.

     

    Now I am trying to figure out how to make descriptions for very similar items different so google search doesn't ignore them.

     

    Jill

  6. I have searched everywhere but can't seem to find an answer to this issue (if there is one).

     

    Most of my products have options with price upsells.

     

    Is there a way to price the attribute (or the option) before it is added to the product? Currently I have to add the option to the product, then go in and add the price for the particular attribute.

     

    I am using the free version (and so far very impressed). Is this available in the paid version, or just not feasible at this time.

     

    I am using 5.2.16.

     

    Jill

    jkmorganpets.com/cc

×
×
  • Create New...