Jump to content

sean seah

Member
  • Posts

    10
  • Joined

  • Last visited

sean seah's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. Hi, Wish to make the sales report with the product details, which sql should I edit on? "product_code" is a new attributes that I add in, since it is not inside the table "CubeCart_order_summary". Actually, it is from table "CubeCart_order_inventory". And, How to sum the product_code? As the product code is in integer, digit form. The below code is from admin_LsSCSi/sources/reports.index.inc.php $fields = array( 'title', 'cart_order_id', 'product_code', 'order_date', 'status', 'subtotal', 'discount', 'shipping', 'total_tax', 'total', 'customer_id', 'first_name', 'last_name', 'company_name', 'line1', 'line2', 'town', 'state', 'country', 'postcode', 'title_d', 'first_name_d', 'last_name_d', 'company_name_d', 'line1_d', 'line2_d', 'town_d', 'state_d', 'country_d', 'postcode_d', 'phone', 'email', 'gateway' ); foreach ($GLOBALS['hooks']->load('admin.reports.order.pre') as $hook) include $hook; $orders = $GLOBALS['db']->select('CubeCart_order_summary', $fields, $where); foreach ($GLOBALS['hooks']->load('admin.reports.order.post') as $hook) include $hook; if ($orders) { ## If we are wanting an external report start new External class if (isset($_POST['external_report']) && is_array($_POST['external_report'])) { $module_name = array_keys($_POST['external_report']); $external_class_path = 'modules/external/'.$module_name[0].'/external.class.php'; if (file_exists($external_class_path)) { include $external_class_path; $external_report = new External($GLOBALS['config']->get($module_name[0])); } } ## Tally up totals $tally = array(); $i = 0; foreach ($orders as $order_summary) { $order_summary['status'] = $lang['order_state']['name_'.(int)$order_summary['status']]; foreach ($order_summary as $field => $value) { if (in_array($field, array('subtotal', 'discount', 'shipping', 'total_tax', 'total'))) { if (!isset($tally[$field])) $tally[$field] = 0; $tally[$field] += $value; } } $order_summary['country'] = (is_numeric($order_summary['country'])) ? getCountryFormat($order_summary['country']) : $order_summary['country']; $order_summary['state'] = (is_numeric($order_summary['state'])) ? getStateFormat($order_summary['state']) : $order_summary['state']; $order_summary['country_d'] = (is_numeric($order_summary['country_d'])) ? getCountryFormat($order_summary['country_d']) : $order_summary['country_d']; $order_summary['state_d'] = (is_numeric($order_summary['state_d'])) ? getStateFormat($order_summary['state_d']) : $order_summary['state_d']; $order_summary['date'] = formatTime($order_summary['order_date'],false,true); ## Run line of external report data if (isset($external_report) && is_object($external_report)) $external_report->report_order_data($order_summary); unset($order_summary['order_date'], $values); foreach ($order_summary as $field => $value) { if ($i == 0) $headers[] = $field; $values[] = (is_numeric($value) || !strpos($value, ',')) ? $value : sprintf('"%s"', addslashes($value)); } if ($i == 0 && $add_headers) $data[] = implode(',', $headers); $data[] = implode(',', $values); $smarty_data['report_date'][] = $order_summary; $i++; } $GLOBALS['smarty']->assign('REPORT_DATE', $smarty_data['report_date']); if (isset($_POST['download']) || (isset($_POST['external_report']) && is_array($_POST['external_report']))) { $GLOBALS['debug']->supress(true); if (isset($_POST['download'])) { $file_content = implode("\r\n", $data); $file_name = $lang['reports']['sales_data'].' '.$download_range; } else { $file_content = $external_report->_report_data; $file_name = ucfirst($module_name[0]).' '.$lang['reports']['data'].' '.$download_range; } deliverFile(false, false, $file_content, $file_name.'.csv'); exit; } ## Show table footer $tally['orders'] = count($orders); foreach ($tally as $key => $value) { $tallyformatted[$key] = ($key=='orders') ? $value : sprintf('%.2F', $value); } $smarty_data['tally'] = $tallyformatted; $GLOBALS['smarty']->assign('DOWNLOAD', true); ## Get external module export code $where = array('module' => 'external', 'status' => '1'); ## Start classes for external reports if (($module = $GLOBALS['db']->select('CubeCart_modules', 'folder', $where)) !== false) { foreach ($module as $module_data) { if(file_exists(CC_ROOT_DIR.'/modules/external/'.$module_data['folder'])) { $module_data['description'] = ucfirst(str_replace('_',' ',$module_data['folder'])); $smarty_data['export'][] = $module_data; } } $GLOBALS['smarty']->assign('EXPORT', $smarty_data['export']); } } else { if (isset($_POST['download'])) httpredir(currentPage()); $smarty_data['tally'] = array('orders' => 0); } $GLOBALS['smarty']->assign('TALLY', $smarty_data['tally']); $GLOBALS['smarty']->assign('POST', $report_filter); foreach ($GLOBALS['hooks']->load('admin.reports.order.filter') as $hook) include $hook; Thanks~
  2. 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
  3. It doesn't show much. Just as shown in picture even though I've already enabled debugging.
  4. 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?
  5. 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?
  6. 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
  7. 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
  8. Anyone can assist me on this? Or Am I making you guys not clear on the problem?
  9. 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
×
×
  • Create New...