sean seah Posted August 25, 2016 Share Posted August 25, 2016 Hai, I'm using Cubecart V6 with the paypal pro gateway as my payment method. And I'm using Foundation as my skin of template. My scenario is : Non-member (Without Login) Customer can purchases and add item into their basket, and view it by click on "view basket". (the button will navigate them to xxxx.com/index.php?_a=basket) Member (Login) Customer can purchases the item, but the "view basket" button is failure. It navigate customer to (xxxx.com/index.php?_a=confirm). Previously it doesn't have "View Basket", I enable it via box.basket.php in skin, template. It is not only that, but it will shows the same url to customer when they press on login button during login process. (In order to confirm member had login, they need to press "back" button in browser and refresh the browser). Thanks Quote Link to comment Share on other sites More sharing options...
sean seah Posted August 28, 2016 Author Share Posted August 28, 2016 Anyone can assist me on this? Or Am I making you guys not clear on the problem? Quote Link to comment Share on other sites More sharing options...
bsmither Posted August 28, 2016 Share Posted August 28, 2016 I will be happy to assist. But you are not clear. CubeCart does take a customer to ?_a=confirm if CubeCart has a valid Billing and Delivery address. How is this a problem for you? Quote Link to comment Share on other sites More sharing options...
sean seah Posted August 28, 2016 Author Share Posted August 28, 2016 Sorry, my bad. I'll explain it with screen shot. For non login-user, it can successfully "VIEW BASKET". (Referring to image 1 & 2) My problem is, when members login, the process doesn't go smooth as non-member's. (Referring to image 3 & 4) Maybe you can try, via ebn-kowalit.com/shopping Thanks Quote Link to comment Share on other sites More sharing options...
bsmither Posted August 28, 2016 Share Posted August 28, 2016 Ok. The page ?_a=confirm is crashing. We need to find out why. Please create a file named ini-custom.inc.php by following the instructions here:https://forums.cubecart.com/topic/51550-how-to-create-the-error-log/ When you next get the 500 Internal Server Error, look at the contents of a new file created called error_log. When we find the cause of the error, you can remove the ini-custom.inc.php file. Quote Link to comment Share on other sites More sharing options...
sean seah Posted October 25, 2016 Author Share Posted October 25, 2016 Finally was able to get back. Here is the error_log which was mentioned. Could you take a look at it please? error_log.txt Quote Link to comment Share on other sites More sharing options...
bsmither Posted October 26, 2016 Share Posted October 26, 2016 Please confirm that you have a Shipper's (Merchant) Account with FedEx. If not (and FedEx is available in your country), please contact FedEx to obtain your account credentials. If yes, please verify that the account credentials are correct. NOTE: do not cut/paste account numbers from the email you received from FedEx confirming your account. Doing so into CubeCart's FedEx control panel. Doing so will almost always add invisible line ending characters and will corrupt the form entry. To verify the account numbers are correct, delete them, then type them back in manually. If you do not want to use FedEx, in admin, Manage Plugins, disable the FedEx module and choose a different shipping method. Quote Link to comment Share on other sites More sharing options...
sean seah Posted December 21, 2016 Author Share Posted December 21, 2016 Thanks bsmither. So I've just obtained my account credentials and and have inserted accordingly. The checkout button is now available though when clicked, it shows HTTP Error 500. Is there something I missed? Quote Link to comment Share on other sites More sharing options...
bsmither Posted December 21, 2016 Share Posted December 21, 2016 Let's have a look at a recent error_log. Quote Link to comment Share on other sites More sharing options...
sean seah Posted December 21, 2016 Author Share Posted December 21, 2016 error_log (1) Quote Link to comment Share on other sites More sharing options...
bsmither Posted December 21, 2016 Share Posted December 21, 2016 Assuming there is no more issues with a failing authentication, FedEx is returning a response that CubeCart can't handle. (Specifically, the response is not in an array format.) Not being useable, CubeCart throws a fatal error. (I disagree with CubeCart's programmers doing that.) We need to discover what the actual response FedEx is sending back. I'll have instructions shortly. Quote Link to comment Share on other sites More sharing options...
bsmither Posted December 21, 2016 Share Posted December 21, 2016 Please try this: In /modules/shipping/FedEx/shipping.class.php, starting near line 216: Find all occurances of: E_USER_ERROR Change to: E_USER_WARNING There should be three instances. Then, starting near line 211, find: 'next_day' => "", ); } } } else { Change to: 'next_day' => "", ); } } } else { findReasons($this->_client); Next, near line 123, find: public function calculate() { On a blank line after, add the following: function findReasons($soapClient) { if(!is_object($soapClient)) return false; $GLOBALS['debug']->debugMessage("Request :<br>", htmlentities($soapClient->__getLastRequest()), "<br>"); $GLOBALS['debug']->debugMessage("Response :<br>", htmlentities($soapClient->__getLastResponse()), "<br>"); } In CubeCart's admin, Store Settings, Advanced tab, Enable Debugging and enter your IP address (www.whatismyip.com) in the adjacent field. Now, you shouldn't get a crash, but a warning shown in the Debug section at the bottom of the page. Quote Link to comment Share on other sites More sharing options...
sean seah Posted December 23, 2016 Author Share Posted December 23, 2016 My pages is displaying now and this is the result. I tried to change locations and weights as was shown by the warning displayed but the warning still pops up. Could this be due to any discrepancy with my FedEx application? Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted December 23, 2016 Share Posted December 23, 2016 "Now, you shouldn't get a crash, but a warning shown in the Debug section at the bottom of the page." What is in the top part of the Debug section in gray at the bottom of the page when you get the screen shown above? Quote Link to comment Share on other sites More sharing options...
bsmither Posted December 23, 2016 Share Posted December 23, 2016 If, having enabled Debug mode in the CubeCart admin, you should be seeing a grey section at the bottom of the page. In that that grey section will be a header Debug Messages, where we should see the FedEx response. Quote Link to comment Share on other sites More sharing options...
sean seah Posted December 23, 2016 Author Share Posted December 23, 2016 It doesn't show much. Just as shown in picture even though I've already enabled debugging. Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted December 23, 2016 Share Posted December 23, 2016 You must not have your IP address listed as the exception to show the Debug section. There would be a huge slate gray section below eCommerce by CubeCart that only you can see IF it has the correct IP in it. Quote Link to comment Share on other sites More sharing options...
bsmither Posted December 23, 2016 Share Posted December 23, 2016 Please visit this site, www.whatismyip.com, and manually enter the IP address shown to you in the appropriate text field of CubeCart's admin, Store Settings, Advanced tab. Do not Copy/Paste as this will copy in more characters than allowed and will confuse CubeCart. Quote Link to comment Share on other sites More sharing options...
sean seah Posted December 23, 2016 Author Share Posted December 23, 2016 PHP:[Notice] /home/ebnkowal/public_html/shopping/classes/user.class.php:455 - Use of undefined constant CC_ADMIN - assumed 'CC_ADMIN'[Notice] /home/ebnkowal/public_html/shopping/classes/user.class.php:455 - Use of undefined constant CC_ADMIN - assumed 'CC_ADMIN'[Notice] /home/ebnkowal/public_html/shopping/classes/cubecart.class.php:1568 - Undefined index: coupons[Notice] /home/ebnkowal/public_html/shopping/modules/shipping/FedEx/shipping.class.php:162 - Undefined variable: delivery_state[Warning] /home/ebnkowal/public_html/shopping/modules/shipping/FedEx/shipping.class.php:227 - FedEx Error: Authentication Failed[Warning] /home/ebnkowal/public_html/shopping/classes/cubecart.class.php:1668 - Shipping not setup or allow no shipping not enabled[Notice] /home/ebnkowal/public_html/shopping/classes/cubecart.class.php:1702 - Undefined index: gateway[Notice] /home/ebnkowal/public_html/shopping/classes/cubecart.class.php:2100 - Undefined index: scope[Notice] /home/ebnkowal/public_html/shopping/modules/plugins/PayPal_Pro/hooks/class.cubecart.display_basket.alternate.php:74 - Undefined index: billmelater GET: 'Before Sanitise:' => '_a' => checkout 'After Sanitise:' => '_a' => checkout SESSION: '__client' => 'ip_address' => 60.52.27.99 'useragent' => Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36 'session_start' => 1482508470 'session_last' => 1482508473 'language' => en-GB 'user_language' => en-GB 'currency' => MYR 'admin_id' => 1 '__system' => 'token' => cbca4a2b41093733eb1502b63cccdf71 'login_push' => 1 'recent_extensions' => '0' => 'name' => Havenswift Hosting Skin Configuration 'url' => https://www.cubecart.com/extensions/skins/havenswift-hosting-skin-configuration 'image' => https://www.cubecart.com//img/sellers/8/354/master.jpg 'price' => Free '1' => 'name' => Oxipay 'url' => https://www.cubecart.com/extensions/payment-gateways/oxipay 'image' => https://www.cubecart.com//img/sellers/1/353/master.png 'price' => Free '2' => 'name' => Facebook Feed 'url' => https://www.cubecart.com/extensions/plugins/facebook-feed 'image' => https://www.cubecart.com//img/sellers/62/350/master.png 'price' => $30.00 '3' => 'name' => Google Plus Feed 'url' => https://www.cubecart.com/extensions/plugins/google-plus-feed 'image' => https://www.cubecart.com//img/sellers/62/349/master.png 'price' => $30.00 '4' => 'name' => Twitter Feed 'url' => https://www.cubecart.com/extensions/plugins/twitter-feed 'image' => https://www.cubecart.com//img/sellers/62/348/master.png 'price' => $30.00 '5' => 'name' => Minimum Order Value 'url' => https://www.cubecart.com/extensions/code-snippets/minimum-order-value 'image' => https://www.cubecart.com//img/noimage.png 'price' => Free '6' => 'name' => Contact Form File Upload 'url' => https://www.cubecart.com/extensions/plugins/contact-form-file-upload 'image' => https://www.cubecart.com//img/sellers/62/346/master.png 'price' => $30.00 '7' => 'name' => Additional Global Product Tabs 'url' => https://www.cubecart.com/extensions/plugins/additional-global-product-tabs 'image' => https://www.cubecart.com//img/sellers/62/345/master.png 'price' => $30.00 '8' => 'name' => Bulk Product Editor 'url' => https://www.cubecart.com/extensions/plugins/bulk-product-editor 'image' => https://www.cubecart.com//img/sellers/62/344/master.png 'price' => $30.00 '9' => 'name' => Bulk Product Cloner 'url' => https://www.cubecart.com/extensions/plugins/bulk-product-cloner 'image' => https://www.cubecart.com//img/sellers/62/343/master.png 'price' => $30.00 '10' => 'name' => Sisow 'url' => https://www.cubecart.com/extensions/payment-gateways/sisow 'image' => https://www.cubecart.com//img/sellers/208/342/master.png 'price' => Free '11' => 'name' => Japanese Language Pack (Storefront) 日本語 'url' => https://www.cubecart.com/extensions/languages/japanese-language-pack-storefront 'image' => https://www.cubecart.com//img/sellers/205/341/master.png 'price' => $25.00 '__recaptcha' => 'error' => 'confirmed' => '__admin_data' => 'admin_id' => 1 'customer_id' => 'status' => 1 'name' => Admin 'username' => ebnkowal 'new_password' => 1 'email' => [email protected] 'verify' => 'logins' => 31 'super_user' => 1 'notes' => 'failLevel' => 0 'blockTime' => 0 'lastTime' => 1482210322 'browser' => Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36 'ip_address' => 60.52.27.99 'language' => en-GB 'dashboard_notes' => HFCHFCH 'order_notify' => 1 'tour_shown' => 1 '__admin' => 'user_language' => en-GB '__basket' => 'confirm_addresses' => 1 'billing_address' => 'address_id' => 25 'customer_id' => 9 'billing' => 1 'default' => 1 'description' => Billing/Delivery Address 'title' => 'first_name' => Jeffrey 'last_name' => Mark 'company_name' => 'line1' => 15A, KHEE MOI GARDEN, JALAN SUNGAI MAONG TGH, 'line2' => 'town' => KUCHING 'state' => SARAWAK 'postcode' => 93150 'country' => Malaysia 'hash' => a1fd91fae9056b1941e890413e9b8d8e 'state_id' => SARAWAK 'country_id' => 458 'state_abbrev' => SARAWAK 'country_iso' => MY 'country_iso3' => MYS 'user_defined' => 1 'estimate' => 'delivery_address' => 'address_id' => 25 'customer_id' => 9 'billing' => 1 'default' => 1 'description' => Billing/Delivery Address 'title' => 'first_name' => Jeffrey 'last_name' => Mark 'company_name' => 'line1' => 15A, KHEE MOI GARDEN, JALAN SUNGAI MAONG TGH, 'line2' => 'town' => KUCHING 'state' => SARAWAK 'postcode' => 93150 'country' => Malaysia 'hash' => a1fd91fae9056b1941e890413e9b8d8e 'state_id' => SARAWAK 'country_id' => 458 'state_abbrev' => SARAWAK 'country_iso' => MY 'country_iso3' => MYS 'user_defined' => 1 'estimate' => 'contents' => '074bd900db6252876a1c0e8a32af983a' => 'id' => 7 'quantity' => 1 'digital' => 0 'option_line_price' => 0 'total_price_each' => 1102.00 'description' => 'name' => Deluxe Series C 'product_code' => CHRAKATM69 'product_weight' => 0.450 'tax_each' => 'weight' => 0.450 'discount' => 0.00 'subtotal' => 1102.00 'total_tax' => 0.00 'total' => 1102.00 'shipping_hash' => a2072c8a50f1127f73a55a6b5f574da7 'order_taxes' => 'cart_order_id' => 161223-213909-1577 'order_status' => 1 '__PayPal_Pro' => 'stage' => SetExpressCheckout COOKIE: 'username' => [email protected] 'PHPSESSID' => lcgda996a78076ddig05pjj615 'timezone' => Asia/Shanghai 'cpsession' => ebnkowal:UipLvnhfHF3ZOumu,15d7eb093995074e6661b2dcbb839fdb 'CCS_68028DA3C9' => elhjfrd8a3c5ukj84g78m2oin7 MySQLiQueries (157):[1] SELECT SQL_CALC_FOUND_ROWS * FROM `ccr5_CubeCart_sessions` WHERE ccr5_CubeCart_sessions.session_id = 'elhjfrd8a3c5ukj84g78m2oin7' LIMIT 1; -- (0.0001220703125 sec) [NOT CACHED][2] SELECT FOUND_ROWS() as Count; -- (4.6014785766602E-5 sec) [NOT CACHED][3] SELECT * FROM `ccr5_CubeCart_lang_strings` WHERE ccr5_CubeCart_lang_strings.language = 'en-GB' ; -- (0.00064396858215332 sec) [CACHE WRITE][4] SELECT * FROM `ccr5_CubeCart_hooks` WHERE ccr5_CubeCart_hooks.enabled = '1' ORDER BY priority ASC ; -- (0.00027680397033691 sec) [CACHE WRITE][5] SELECT `php_code`, `unique_id`, `description`, `hook_trigger` FROM `ccr5_CubeCart_code_snippet` WHERE ccr5_CubeCart_code_snippet.enabled = '1' ORDER BY `priority` ASC ; -- (8.2969665527344E-5 sec) [CACHE WRITE][6] SELECT `cat_id`, `cat_name`, `cat_parent_id` FROM `ccr5_CubeCart_category` ORDER BY `cat_id` DESC ; -- (0.00010108947753906 sec) [CACHE WRITE][7] SELECT `cat_id`, `cat_name` FROM `ccr5_CubeCart_category_language` WHERE ccr5_CubeCart_category_language.language = 'en-GB' ; -- (7.1048736572266E-5 sec) [CACHE WRITE][8] SELECT SQL_CALC_FOUND_ROWS `array` FROM `ccr5_CubeCart_config` WHERE ccr5_CubeCart_config.name = 'logos' LIMIT 1; -- (9.2983245849609E-5 sec) [CACHE WRITE][9] SELECT FOUND_ROWS() as Count; -- (4.5061111450195E-5 sec) [NOT CACHED][10] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `ccr5_CubeCart_modules` WHERE ccr5_CubeCart_modules.folder = 'logos' LIMIT 1; -- (7.2956085205078E-5 sec) [CACHE WRITE][11] SELECT `folder` FROM `ccr5_CubeCart_modules` WHERE ccr5_CubeCart_modules.module = 'livehelp' AND ccr5_CubeCart_modules.status = '1' ; -- (8.2969665527344E-5 sec) [CACHE WRITE][12] SELECT * FROM `ccr5_CubeCart_currency` WHERE ccr5_CubeCart_currency.code = 'MYR' ; -- (0.00012612342834473 sec) [CACHE WRITE][13] SELECT SQL_CALC_FOUND_ROWS * FROM `ccr5_CubeCart_customer` WHERE ccr5_CubeCart_customer.customer_id = '9' LIMIT 1; -- (0.00017690658569336 sec) [CACHE WRITE][14] SELECT FOUND_ROWS() as Count; -- (5.3167343139648E-5 sec) [NOT CACHED][15] SELECT `path` FROM `ccr5_CubeCart_seo_urls` WHERE ccr5_CubeCart_seo_urls.type = 'login' ; -- (0.0001518726348877 sec) [CACHE WRITE][16] SELECT * FROM `ccr5_CubeCart_addressbook` WHERE ccr5_CubeCart_addressbook.customer_id = '9' ORDER BY billing DESC ; -- (0.0015652179718018 sec) [NOT CACHED][17] SELECT `id` FROM `ccr5_CubeCart_geo_country` WHERE ccr5_CubeCart_geo_country.numcode = '458' ; -- (0.00019598007202148 sec) [CACHE WRITE][18] SELECT * FROM `ccr5_CubeCart_geo_zone` WHERE ccr5_CubeCart_geo_zone.name = 'SARAWAK' ; -- (0.00026488304138184 sec) [CACHE WRITE][19] SELECT `name` FROM `ccr5_CubeCart_geo_country` WHERE ccr5_CubeCart_geo_country.numcode = '458' ; -- (0.00020408630371094 sec) [CACHE WRITE][20] SELECT * FROM `ccr5_CubeCart_geo_zone` WHERE ccr5_CubeCart_geo_zone.name = 'SARAWAK' ; -- (0.00025105476379395 sec) [CACHE WRITE][21] SELECT `iso` FROM `ccr5_CubeCart_geo_country` WHERE ccr5_CubeCart_geo_country.numcode = '458' ; -- (0.00018692016601562 sec) [CACHE WRITE][22] SELECT `iso3` FROM `ccr5_CubeCart_geo_country` WHERE ccr5_CubeCart_geo_country.numcode = '458' ; -- (0.00019216537475586 sec) [CACHE WRITE][23] SELECT `id` FROM `ccr5_CubeCart_geo_country` WHERE ccr5_CubeCart_geo_country.numcode = '458' ; -- (0.00018692016601562 sec) [CACHE WRITE][24] SELECT * FROM `ccr5_CubeCart_geo_zone` WHERE ccr5_CubeCart_geo_zone.name = 'JOHOR' ; -- (0.00024700164794922 sec) [CACHE WRITE][25] SELECT `name` FROM `ccr5_CubeCart_geo_country` WHERE ccr5_CubeCart_geo_country.numcode = '458' ; -- (0.00020003318786621 sec) [CACHE WRITE][26] SELECT * FROM `ccr5_CubeCart_geo_zone` WHERE ccr5_CubeCart_geo_zone.name = 'JOHOR' ; -- (0.00025296211242676 sec) [CACHE WRITE][27] SELECT `iso` FROM `ccr5_CubeCart_geo_country` WHERE ccr5_CubeCart_geo_country.numcode = '458' ; -- (0.00018692016601562 sec) [CACHE WRITE][28] SELECT `iso3` FROM `ccr5_CubeCart_geo_country` WHERE ccr5_CubeCart_geo_country.numcode = '458' ; -- (0.00018906593322754 sec) [CACHE WRITE][29] SELECT `basket` FROM `ccr5_CubeCart_saved_cart` WHERE ccr5_CubeCart_saved_cart.customer_id = '9' ; -- (0.00010299682617188 sec) [NOT CACHED][30] UPDATE `ccr5_CubeCart_saved_cart` SET `basket` = 'a:1:{s:32:\"074bd900db6252876a1c0e8a32af983a\";a:10:{s:2:\"id\";i:7;s:8:\"quantity\";i:1;s:7:\"digital\";s:1:\"0\";s:17:\"option_line_price\";i:0;s:16:\"total_price_each\";s:7:\"1102.00\";s:11:\"description\";b:0;s:4:\"name\";s:15:\"Deluxe Series C\";s:12:\"product_code\";s:10:\"CHRAKATM69\";s:14:\"product_weight\";s:5:\"0.450\";s:8:\"tax_each\";b:0;}}' WHERE ccr5_CubeCart_saved_cart.customer_id = '9'; -- (0.027350902557373 sec) [NOT CACHED][31] SELECT subscriber_id FROM `ccr5_CubeCart_newsletter_subscriber` WHERE ccr5_CubeCart_newsletter_subscriber.status = '1' AND ccr5_CubeCart_newsletter_subscriber.email = '[email protected]' ; -- (0.00012707710266113 sec) [NOT CACHED][32] SELECT SQL_CALC_FOUND_ROWS `array` FROM `ccr5_CubeCart_config` WHERE ccr5_CubeCart_config.name = 'Per_Category' LIMIT 1; -- (0.00018095970153809 sec) [CACHE WRITE][33] 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 ccr5_CubeCart_tax_rates AS R, ccr5_CubeCart_tax_details AS D, ccr5_CubeCart_tax_class AS T, ccr5_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 = 458 -- (0.0051429271697998 sec) [CACHE WRITE][34] SELECT CI.* , C.status FROM `ccr5_CubeCart_category_index` AS CI, `ccr5_CubeCart_category` AS C WHERE CI.product_id = '7' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.0002138614654541 sec) [CACHE WRITE][35] SELECT SQL_CALC_FOUND_ROWS * FROM `ccr5_CubeCart_inventory` WHERE ccr5_CubeCart_inventory.product_id = '7' AND ccr5_CubeCart_inventory.status = '1' LIMIT 10 OFFSET 0; -- (0.00025296211242676 sec) [CACHE WRITE][36] SELECT FOUND_ROWS() as Count; -- (5.8174133300781E-5 sec) [NOT CACHED][37] SELECT `stock_level`, `product_code`, `upc`, `jan`, `isbn`, `image` FROM `ccr5_CubeCart_option_matrix` WHERE ccr5_CubeCart_option_matrix.product_id = '7' AND ccr5_CubeCart_option_matrix.options_identifier = '' AND ccr5_CubeCart_option_matrix.status = '1' ; -- (0.00014090538024902 sec) [CACHE WRITE][38] SELECT * FROM `ccr5_CubeCart_customer_membership` WHERE ccr5_CubeCart_customer_membership.customer_id = '9' ; -- (0.00010514259338379 sec) [CACHE WRITE][39] SELECT `quantity`, `price` FROM `ccr5_CubeCart_pricing_quantity` WHERE ccr5_CubeCart_pricing_quantity.product_id = '7' AND ccr5_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00012993812561035 sec) [CACHE WRITE][40] SELECT * FROM `ccr5_CubeCart_geo_zone` WHERE ccr5_CubeCart_geo_zone.name = 'SARAWAK' ; -- (0.00027799606323242 sec) [CACHE WRITE][41] SELECT SQL_CALC_FOUND_ROWS `array` FROM `ccr5_CubeCart_config` WHERE ccr5_CubeCart_config.name = 'gift_certs' LIMIT 1; -- (0.00010490417480469 sec) [CACHE WRITE][42] SELECT FOUND_ROWS() as Count; -- (4.887580871582E-5 sec) [NOT CACHED][43] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `ccr5_CubeCart_modules` WHERE ccr5_CubeCart_modules.folder = 'gift_certs' LIMIT 1; -- (9.5129013061523E-5 sec) [CACHE WRITE][44] SELECT SQL_CALC_FOUND_ROWS * FROM `ccr5_CubeCart_image_index` WHERE ccr5_CubeCart_image_index.product_id = '7' ORDER BY `main_img` DESC LIMIT 1; -- (0.00015401840209961 sec) [CACHE WRITE][45] SELECT FOUND_ROWS() as Count; -- (5.0067901611328E-5 sec) [NOT CACHED][46] SELECT SQL_CALC_FOUND_ROWS * FROM `ccr5_CubeCart_image_index` WHERE ccr5_CubeCart_image_index.product_id = '7' ORDER BY `main_img` DESC LIMIT 1; -- (0.00014400482177734 sec) [CACHE WRITE][47] SELECT FOUND_ROWS() as Count; -- (4.7922134399414E-5 sec) [NOT CACHED][48] SELECT * FROM `ccr5_CubeCart_filemanager` WHERE ccr5_CubeCart_filemanager.file_id = '9' ; -- (0.00012993812561035 sec) [CACHE WRITE][49] SELECT `path` FROM `ccr5_CubeCart_seo_urls` WHERE ccr5_CubeCart_seo_urls.type = 'prod' AND ccr5_CubeCart_seo_urls.item_id = '7' ; -- (0.00014901161193848 sec) [CACHE WRITE][50] SELECT `folder`, `countries` FROM `ccr5_CubeCart_modules` WHERE ccr5_CubeCart_modules.module = 'shipping' AND ccr5_CubeCart_modules.status = '1' ; -- (0.00012111663818359 sec) [CACHE WRITE][51] SELECT SQL_CALC_FOUND_ROWS `array` FROM `ccr5_CubeCart_config` WHERE ccr5_CubeCart_config.name = 'FedEx' LIMIT 1; -- (0.00010800361633301 sec) [CACHE WRITE][52] SELECT FOUND_ROWS() as Count; -- (6.2942504882812E-5 sec) [NOT CACHED][53] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `ccr5_CubeCart_modules` WHERE ccr5_CubeCart_modules.folder = 'FedEx' LIMIT 1; -- (9.7990036010742E-5 sec) [CACHE WRITE][54] SELECT FOUND_ROWS() as Count; -- (5.0067901611328E-5 sec) [NOT CACHED][55] SELECT * FROM `ccr5_CubeCart_modules` WHERE ccr5_CubeCart_modules.module = 'gateway' AND ccr5_CubeCart_modules.status = '1' ORDER BY `position` ASC ; -- (0.00022697448730469 sec) [CACHE WRITE][56] SELECT SQL_CALC_FOUND_ROWS `array` FROM `ccr5_CubeCart_config` WHERE ccr5_CubeCart_config.name = 'PayPal_Pro' LIMIT 1; -- (0.00012087821960449 sec) [CACHE WRITE][57] SELECT FOUND_ROWS() as Count; -- (5.8174133300781E-5 sec) [NOT CACHED][58] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `ccr5_CubeCart_modules` WHERE ccr5_CubeCart_modules.folder = 'PayPal_Pro' LIMIT 1; -- (0.00010418891906738 sec) [CACHE WRITE][59] SELECT FOUND_ROWS() as Count; -- (5.3167343139648E-5 sec) [NOT CACHED][60] SELECT COUNT(*) AS Count FROM `ccr5_CubeCart_modules` WHERE ccr5_CubeCart_modules.status = '1' AND ccr5_CubeCart_modules.module = 'gateway'; -- (0.00010895729064941 sec) [CACHE WRITE][61] SELECT SQL_CALC_FOUND_ROWS DISTINCT `cart_order_id` FROM `ccr5_CubeCart_order_inventory` WHERE `product_id` IN (7) GROUP BY cart_order_id ORDER BY `id` DESC LIMIT 30; -- (0.00076484680175781 sec) [CACHE WRITE][62] SELECT SQL_CALC_FOUND_ROWS `array` FROM `ccr5_CubeCart_config` WHERE ccr5_CubeCart_config.name = 'languages' LIMIT 1; -- (0.00010514259338379 sec) [CACHE WRITE][63] SELECT FOUND_ROWS() as Count; -- (5.4121017456055E-5 sec) [NOT CACHED][64] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `ccr5_CubeCart_modules` WHERE ccr5_CubeCart_modules.folder = 'languages' LIMIT 1; -- (8.6069107055664E-5 sec) [CACHE WRITE][65] SELECT * FROM `ccr5_CubeCart_currency` WHERE ccr5_CubeCart_currency.active = '1' ; -- (0.00020694732666016 sec) [CACHE WRITE][66] SELECT `path` FROM `ccr5_CubeCart_seo_urls` WHERE ccr5_CubeCart_seo_urls.type = 'login' ; -- (0.00011801719665527 sec) [CACHE WRITE][67] SELECT `path` FROM `ccr5_CubeCart_seo_urls` WHERE ccr5_CubeCart_seo_urls.type = 'register' ; -- (0.00010800361633301 sec) [CACHE WRITE][68] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `ccr5_CubeCart_category` WHERE ccr5_CubeCart_category.cat_parent_id = '0' AND ccr5_CubeCart_category.status = '1' AND ccr5_CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.00016021728515625 sec) [CACHE WRITE][69] SELECT `cat_id`, `cat_name` FROM `ccr5_CubeCart_category_language` WHERE ccr5_CubeCart_category_language.language = 'en-GB' ; -- (8.2969665527344E-5 sec) [CACHE WRITE][70] SELECT C.`product_id`, I.`use_stock_level` FROM `ccr5_CubeCart_category_index` AS C INNER JOIN `ccr5_CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 3 AND I.status = 1 -- (0.0001990795135498 sec) [CACHE WRITE][71] SELECT COUNT(cat_id) AS Count FROM `ccr5_CubeCart_category` WHERE ccr5_CubeCart_category.cat_parent_id = '3' AND ccr5_CubeCart_category.status = '1'; -- (0.00010991096496582 sec) [CACHE WRITE][72] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `ccr5_CubeCart_category` WHERE ccr5_CubeCart_category.cat_parent_id = '3' AND ccr5_CubeCart_category.status = '1' AND ccr5_CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.00011706352233887 sec) [CACHE WRITE][73] SELECT C.`product_id`, I.`use_stock_level` FROM `ccr5_CubeCart_category_index` AS C INNER JOIN `ccr5_CubeCart_inventory` AS I ON I.`product_id` = C.`product_id` WHERE C.cat_id = 2 AND I.status = 1 -- (0.00011801719665527 sec) [CACHE WRITE][74] SELECT COUNT(cat_id) AS Count FROM `ccr5_CubeCart_category` WHERE ccr5_CubeCart_category.cat_parent_id = '2' AND ccr5_CubeCart_category.status = '1'; -- (0.00010490417480469 sec) [CACHE WRITE][75] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `ccr5_CubeCart_category` WHERE ccr5_CubeCart_category.cat_parent_id = '2' AND ccr5_CubeCart_category.status = '1' AND ccr5_CubeCart_category.hide = '0' ORDER BY priority, cat_name ASC ; -- (0.00011515617370605 sec) [CACHE WRITE][76] SELECT `path` FROM `ccr5_CubeCart_seo_urls` WHERE ccr5_CubeCart_seo_urls.type = 'cat' AND ccr5_CubeCart_seo_urls.item_id = '3' ; -- (0.00015091896057129 sec) [CACHE WRITE][77] SELECT `path` FROM `ccr5_CubeCart_seo_urls` WHERE ccr5_CubeCart_seo_urls.type = 'cat' AND ccr5_CubeCart_seo_urls.item_id = '2' ; -- (0.00014400482177734 sec) [CACHE WRITE][78] SELECT `path` FROM `ccr5_CubeCart_seo_urls` WHERE ccr5_CubeCart_seo_urls.type = 'saleitems' ; -- (0.00010895729064941 sec) [CACHE WRITE][79] SELECT `path` FROM `ccr5_CubeCart_seo_urls` WHERE ccr5_CubeCart_seo_urls.type = 'certificates' ; -- (0.00010418891906738 sec) [CACHE WRITE][80] SELECT `path` FROM `ccr5_CubeCart_seo_urls` WHERE ccr5_CubeCart_seo_urls.type = 'search' ; -- (0.00010895729064941 sec) [CACHE WRITE][81] SELECT * FROM `ccr5_CubeCart_customer_membership` WHERE ccr5_CubeCart_customer_membership.customer_id = '9' ; -- (9.7036361694336E-5 sec) [CACHE WRITE][82] SELECT `price`, `sale_price`, `product_id`,`description`,`name`, `price`-`sale_price` AS `saving` FROM `ccr5_CubeCart_inventory` WHERE `price` > `sale_price` AND `sale_price` > 0 AND `status` = '1' LIMIT 10 -- (0.00020003318786621 sec) [CACHE WRITE][83] SELECT `path` FROM `ccr5_CubeCart_seo_urls` WHERE ccr5_CubeCart_seo_urls.type = 'prod' AND ccr5_CubeCart_seo_urls.item_id = '7' ; -- (0.0001218318939209 sec) [CACHE WRITE][84] SELECT * FROM `ccr5_CubeCart_customer_membership` WHERE ccr5_CubeCart_customer_membership.customer_id = '9' ; -- (8.7976455688477E-5 sec) [CACHE WRITE][85] SELECT `quantity`, `price` FROM `ccr5_CubeCart_pricing_quantity` WHERE ccr5_CubeCart_pricing_quantity.product_id = '7' AND ccr5_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00011086463928223 sec) [CACHE WRITE][86] SELECT `path` FROM `ccr5_CubeCart_seo_urls` WHERE ccr5_CubeCart_seo_urls.type = 'prod' AND ccr5_CubeCart_seo_urls.item_id = '4' ; -- (0.00012803077697754 sec) [CACHE WRITE][87] SELECT * FROM `ccr5_CubeCart_customer_membership` WHERE ccr5_CubeCart_customer_membership.customer_id = '9' ; -- (8.702278137207E-5 sec) [CACHE WRITE][88] SELECT `quantity`, `price` FROM `ccr5_CubeCart_pricing_quantity` WHERE ccr5_CubeCart_pricing_quantity.product_id = '4' AND ccr5_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00010418891906738 sec) [CACHE WRITE][89] SELECT `path` FROM `ccr5_CubeCart_seo_urls` WHERE ccr5_CubeCart_seo_urls.type = 'prod' AND ccr5_CubeCart_seo_urls.item_id = '6' ; -- (0.00011801719665527 sec) [CACHE WRITE][90] SELECT * FROM `ccr5_CubeCart_customer_membership` WHERE ccr5_CubeCart_customer_membership.customer_id = '9' ; -- (8.9168548583984E-5 sec) [CACHE WRITE][91] SELECT `quantity`, `price` FROM `ccr5_CubeCart_pricing_quantity` WHERE ccr5_CubeCart_pricing_quantity.product_id = '6' AND ccr5_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00010418891906738 sec) [CACHE WRITE][92] SELECT `path` FROM `ccr5_CubeCart_seo_urls` WHERE ccr5_CubeCart_seo_urls.type = 'prod' AND ccr5_CubeCart_seo_urls.item_id = '5' ; -- (0.00012302398681641 sec) [CACHE WRITE][93] SELECT * FROM `ccr5_CubeCart_customer_membership` WHERE ccr5_CubeCart_customer_membership.customer_id = '9' ; -- (8.6784362792969E-5 sec) [CACHE WRITE][94] SELECT `quantity`, `price` FROM `ccr5_CubeCart_pricing_quantity` WHERE ccr5_CubeCart_pricing_quantity.product_id = '5' AND ccr5_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00010299682617188 sec) [CACHE WRITE][95] SELECT `path` FROM `ccr5_CubeCart_seo_urls` WHERE ccr5_CubeCart_seo_urls.type = 'prod' AND ccr5_CubeCart_seo_urls.item_id = '3' ; -- (0.00012397766113281 sec) [CACHE WRITE][96] SELECT * FROM `ccr5_CubeCart_customer_membership` WHERE ccr5_CubeCart_customer_membership.customer_id = '9' ; -- (8.6069107055664E-5 sec) [CACHE WRITE][97] SELECT `quantity`, `price` FROM `ccr5_CubeCart_pricing_quantity` WHERE ccr5_CubeCart_pricing_quantity.product_id = '3' AND ccr5_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00010299682617188 sec) [CACHE WRITE][98] SELECT `path` FROM `ccr5_CubeCart_seo_urls` WHERE ccr5_CubeCart_seo_urls.type = 'saleitems' ; -- (0.00010395050048828 sec) [CACHE WRITE][99] SELECT SQL_CALC_FOUND_ROWS * FROM `ccr5_CubeCart_newsletter_subscriber` WHERE ccr5_CubeCart_newsletter_subscriber.email = '[email protected]' LIMIT 1; -- (9.2983245849609E-5 sec) [CACHE WRITE][100] SELECT * FROM `ccr5_CubeCart_documents` WHERE ccr5_CubeCart_documents.doc_parent_id = '0' AND ccr5_CubeCart_documents.doc_status = '1' AND ccr5_CubeCart_documents.navigation_link = '1' ORDER BY `doc_order` ASC ; -- (0.00030803680419922 sec) [CACHE WRITE][101] SELECT `path` FROM `ccr5_CubeCart_seo_urls` WHERE ccr5_CubeCart_seo_urls.type = 'doc' AND ccr5_CubeCart_seo_urls.item_id = '2' ; -- (0.00012683868408203 sec) [CACHE WRITE][102] SELECT `path` FROM `ccr5_CubeCart_seo_urls` WHERE ccr5_CubeCart_seo_urls.type = 'doc' AND ccr5_CubeCart_seo_urls.item_id = '3' ; -- (0.00012493133544922 sec) [CACHE WRITE][103] SELECT `path` FROM `ccr5_CubeCart_seo_urls` WHERE ccr5_CubeCart_seo_urls.type = 'doc' AND ccr5_CubeCart_seo_urls.item_id = '4' ; -- (0.00012111663818359 sec) [CACHE WRITE][104] SELECT `path` FROM `ccr5_CubeCart_seo_urls` WHERE ccr5_CubeCart_seo_urls.type = 'doc' AND ccr5_CubeCart_seo_urls.item_id = '5' ; -- (0.00013899803161621 sec) [CACHE WRITE][105] SELECT SQL_CALC_FOUND_ROWS `array` FROM `ccr5_CubeCart_config` WHERE ccr5_CubeCart_config.name = 'Contact_Form' LIMIT 1; -- (9.2983245849609E-5 sec) [CACHE WRITE][106] SELECT FOUND_ROWS() as Count; -- (5.1021575927734E-5 sec) [NOT CACHED][107] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `ccr5_CubeCart_modules` WHERE ccr5_CubeCart_modules.folder = 'Contact_Form' LIMIT 1; -- (8.2015991210938E-5 sec) [CACHE WRITE][108] SELECT `path` FROM `ccr5_CubeCart_seo_urls` WHERE ccr5_CubeCart_seo_urls.type = 'contact' ; -- (0.00010204315185547 sec) [CACHE WRITE][109] SELECT `product_id` FROM `ccr5_CubeCart_inventory` WHERE ccr5_CubeCart_inventory.status = '1' AND ccr5_CubeCart_inventory.featured = '1' -- (0.00013995170593262 sec) [NOT CACHED][110] SELECT CI.* , C.status FROM `ccr5_CubeCart_category_index` AS CI, `ccr5_CubeCart_category` AS C WHERE CI.product_id = '4' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.0001530647277832 sec) [CACHE WRITE][111] SELECT SQL_CALC_FOUND_ROWS * FROM `ccr5_CubeCart_inventory` WHERE ccr5_CubeCart_inventory.product_id = '4' LIMIT 1; -- (0.00020694732666016 sec) [CACHE WRITE][112] SELECT FOUND_ROWS() as Count; -- (5.1975250244141E-5 sec) [NOT CACHED][113] SELECT SQL_CALC_FOUND_ROWS * FROM `ccr5_CubeCart_image_index` WHERE ccr5_CubeCart_image_index.product_id = '4' ORDER BY `main_img` DESC LIMIT 1; -- (0.00012993812561035 sec) [CACHE WRITE][114] SELECT FOUND_ROWS() as Count; -- (4.9829483032227E-5 sec) [NOT CACHED][115] SELECT * FROM `ccr5_CubeCart_filemanager` WHERE ccr5_CubeCart_filemanager.file_id = '6' ; -- (0.00011801719665527 sec) [CACHE WRITE][116] SELECT * FROM `ccr5_CubeCart_customer_membership` WHERE ccr5_CubeCart_customer_membership.customer_id = '9' ; -- (8.8930130004883E-5 sec) [CACHE WRITE][117] SELECT `quantity`, `price` FROM `ccr5_CubeCart_pricing_quantity` WHERE ccr5_CubeCart_pricing_quantity.product_id = '4' AND ccr5_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00010514259338379 sec) [CACHE WRITE][118] SELECT `path` FROM `ccr5_CubeCart_seo_urls` WHERE ccr5_CubeCart_seo_urls.type = 'prod' AND ccr5_CubeCart_seo_urls.item_id = '4' ; -- (0.00012302398681641 sec) [CACHE WRITE][119] SELECT SQL_CALC_FOUND_ROWS `name`, `product_id`, `quantity`, `price`, `sale_price`, `tax_type`, `tax_inclusive` FROM `ccr5_CubeCart_inventory` WHERE ccr5_CubeCart_inventory.status = '1' ORDER BY popularity DESC LIMIT 10; -- (0.00021910667419434 sec) [CACHE WRITE][120] SELECT FOUND_ROWS() as Count; -- (5.1021575927734E-5 sec) [NOT CACHED][121] SELECT CI.* , C.status FROM `ccr5_CubeCart_category_index` AS CI, `ccr5_CubeCart_category` AS C WHERE CI.product_id = '2' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.00014996528625488 sec) [CACHE WRITE][122] SELECT `path` FROM `ccr5_CubeCart_seo_urls` WHERE ccr5_CubeCart_seo_urls.type = 'prod' AND ccr5_CubeCart_seo_urls.item_id = '2' ; -- (0.00012683868408203 sec) [CACHE WRITE][123] SELECT * FROM `ccr5_CubeCart_customer_membership` WHERE ccr5_CubeCart_customer_membership.customer_id = '9' ; -- (9.2029571533203E-5 sec) [CACHE WRITE][124] SELECT `quantity`, `price` FROM `ccr5_CubeCart_pricing_quantity` WHERE ccr5_CubeCart_pricing_quantity.product_id = '2' AND ccr5_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00010514259338379 sec) [CACHE WRITE][125] SELECT SQL_CALC_FOUND_ROWS * FROM `ccr5_CubeCart_image_index` WHERE ccr5_CubeCart_image_index.product_id = '2' ORDER BY `main_img` DESC LIMIT 1; -- (0.00012302398681641 sec) [CACHE WRITE][126] SELECT FOUND_ROWS() as Count; -- (5.1021575927734E-5 sec) [NOT CACHED][127] SELECT * FROM `ccr5_CubeCart_filemanager` WHERE ccr5_CubeCart_filemanager.file_id = '2' ; -- (0.00011301040649414 sec) [CACHE WRITE][128] SELECT CI.* , C.status FROM `ccr5_CubeCart_category_index` AS CI, `ccr5_CubeCart_category` AS C WHERE CI.product_id = '3' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.00014615058898926 sec) [CACHE WRITE][129] SELECT `path` FROM `ccr5_CubeCart_seo_urls` WHERE ccr5_CubeCart_seo_urls.type = 'prod' AND ccr5_CubeCart_seo_urls.item_id = '3' ; -- (0.00012803077697754 sec) [CACHE WRITE][130] SELECT * FROM `ccr5_CubeCart_customer_membership` WHERE ccr5_CubeCart_customer_membership.customer_id = '9' ; -- (8.7976455688477E-5 sec) [CACHE WRITE][131] SELECT `quantity`, `price` FROM `ccr5_CubeCart_pricing_quantity` WHERE ccr5_CubeCart_pricing_quantity.product_id = '3' AND ccr5_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.0001060962677002 sec) [CACHE WRITE][132] SELECT SQL_CALC_FOUND_ROWS * FROM `ccr5_CubeCart_image_index` WHERE ccr5_CubeCart_image_index.product_id = '3' ORDER BY `main_img` DESC LIMIT 1; -- (0.0001220703125 sec) [CACHE WRITE][133] SELECT FOUND_ROWS() as Count; -- (5.2928924560547E-5 sec) [NOT CACHED][134] SELECT * FROM `ccr5_CubeCart_filemanager` WHERE ccr5_CubeCart_filemanager.file_id = '5' ; -- (0.00011301040649414 sec) [CACHE WRITE][135] SELECT `path` FROM `ccr5_CubeCart_seo_urls` WHERE ccr5_CubeCart_seo_urls.type = 'prod' AND ccr5_CubeCart_seo_urls.item_id = '4' ; -- (0.00012087821960449 sec) [CACHE WRITE][136] SELECT * FROM `ccr5_CubeCart_customer_membership` WHERE ccr5_CubeCart_customer_membership.customer_id = '9' ; -- (8.702278137207E-5 sec) [CACHE WRITE][137] SELECT `quantity`, `price` FROM `ccr5_CubeCart_pricing_quantity` WHERE ccr5_CubeCart_pricing_quantity.product_id = '4' AND ccr5_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00010299682617188 sec) [CACHE WRITE][138] SELECT * FROM `ccr5_CubeCart_filemanager` WHERE ccr5_CubeCart_filemanager.file_id = '6' ; -- (0.00011396408081055 sec) [CACHE WRITE][139] SELECT CI.* , C.status FROM `ccr5_CubeCart_category_index` AS CI, `ccr5_CubeCart_category` AS C WHERE CI.product_id = '5' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.00014686584472656 sec) [CACHE WRITE][140] SELECT `path` FROM `ccr5_CubeCart_seo_urls` WHERE ccr5_CubeCart_seo_urls.type = 'prod' AND ccr5_CubeCart_seo_urls.item_id = '5' ; -- (0.0001218318939209 sec) [CACHE WRITE][141] SELECT * FROM `ccr5_CubeCart_customer_membership` WHERE ccr5_CubeCart_customer_membership.customer_id = '9' ; -- (8.702278137207E-5 sec) [CACHE WRITE][142] SELECT `quantity`, `price` FROM `ccr5_CubeCart_pricing_quantity` WHERE ccr5_CubeCart_pricing_quantity.product_id = '5' AND ccr5_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00010204315185547 sec) [CACHE WRITE][143] SELECT SQL_CALC_FOUND_ROWS * FROM `ccr5_CubeCart_image_index` WHERE ccr5_CubeCart_image_index.product_id = '5' ORDER BY `main_img` DESC LIMIT 1; -- (0.0001220703125 sec) [CACHE WRITE][144] SELECT FOUND_ROWS() as Count; -- (5.5074691772461E-5 sec) [NOT CACHED][145] SELECT * FROM `ccr5_CubeCart_filemanager` WHERE ccr5_CubeCart_filemanager.file_id = '7' ; -- (0.00011110305786133 sec) [CACHE WRITE][146] SELECT CI.* , C.status FROM `ccr5_CubeCart_category_index` AS CI, `ccr5_CubeCart_category` AS C WHERE CI.product_id = '6' AND CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.00014901161193848 sec) [CACHE WRITE][147] SELECT `path` FROM `ccr5_CubeCart_seo_urls` WHERE ccr5_CubeCart_seo_urls.type = 'prod' AND ccr5_CubeCart_seo_urls.item_id = '6' ; -- (0.00011682510375977 sec) [CACHE WRITE][148] SELECT * FROM `ccr5_CubeCart_customer_membership` WHERE ccr5_CubeCart_customer_membership.customer_id = '9' ; -- (8.6069107055664E-5 sec) [CACHE WRITE][149] SELECT `quantity`, `price` FROM `ccr5_CubeCart_pricing_quantity` WHERE ccr5_CubeCart_pricing_quantity.product_id = '6' AND ccr5_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00010204315185547 sec) [CACHE WRITE][150] SELECT SQL_CALC_FOUND_ROWS * FROM `ccr5_CubeCart_image_index` WHERE ccr5_CubeCart_image_index.product_id = '6' ORDER BY `main_img` DESC LIMIT 1; -- (0.00012087821960449 sec) [CACHE WRITE][151] SELECT FOUND_ROWS() as Count; -- (5.2928924560547E-5 sec) [NOT CACHED][152] SELECT * FROM `ccr5_CubeCart_filemanager` WHERE ccr5_CubeCart_filemanager.file_id = '8' ; -- (0.00011110305786133 sec) [CACHE WRITE][153] SELECT `path` FROM `ccr5_CubeCart_seo_urls` WHERE ccr5_CubeCart_seo_urls.type = 'prod' AND ccr5_CubeCart_seo_urls.item_id = '7' ; -- (0.00011491775512695 sec) [CACHE WRITE][154] SELECT * FROM `ccr5_CubeCart_customer_membership` WHERE ccr5_CubeCart_customer_membership.customer_id = '9' ; -- (8.6069107055664E-5 sec) [CACHE WRITE][155] SELECT `quantity`, `price` FROM `ccr5_CubeCart_pricing_quantity` WHERE ccr5_CubeCart_pricing_quantity.product_id = '7' AND ccr5_CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00010108947753906 sec) [CACHE WRITE][156] SELECT * FROM `ccr5_CubeCart_filemanager` WHERE ccr5_CubeCart_filemanager.file_id = '9' ; -- (0.00011205673217773 sec) [CACHE WRITE][157] SELECT * FROM `ccr5_CubeCart_permissions` WHERE ccr5_CubeCart_permissions.admin_id = '1' ; -- (9.7036361694336E-5 sec) [CACHE WRITE] Memory: Peak Usage / Max (%):1.77MB / 256M (0.69%) Cache (File): DisabledCache Used: 0.00 KB of 69.27 KB (0.00%) [Clear Cache] Page Load Time:0.348423 seconds Quote Link to comment Share on other sites More sharing options...
bsmither Posted December 23, 2016 Share Posted December 23, 2016 Ok, we have a response from FedEx: FedEx Error: Authentication Failed We think that there is still an issue with the codes entered in the FedEx module's settings screen, or that FedEx hasn't actually authorized you to use their Rate Request API. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.