Jump to content

keat

Premium Member
  • Content Count

    1,322
  • Joined

  • Last visited

  • Days Won

    18

keat last won the day on October 20 2017

keat had the most liked content!

Community Reputation

19 Good

1 Follower

Profile Information

  • Gender
    Male
  • Location
    Leeds UK

Recent Profile Visitors

5,862 profile views
  1. keat

    order of tabs

    I'm not sure I understand 🙁
  2. keat

    order of tabs

    I figured I can change the order of the tabs in sources\products.index.inc.php around line 631 // Display product info Whilst this moves the tabs around, the cart still opens on the General tab despite which order they are in.
  3. keat

    order of tabs

    Thanks, but it didn't work. I have caching disabled and cleared my browser cache, but it didn't appear to make any difference.
  4. keat

    order of tabs

    I thoght I'd found this in admin/skins/default/templates/product.index.php But seems to screw up the product when I edit it.
  5. keat

    order of tabs

    I've lots of price changes to make. Is there any way I can re-order the tabs on a product admin side, so either a product opens on the pricing tab, or make the pricing tab the first tab in the list. Whilst it may sound minimal, any time saved will add up and save me considerable time.
  6. keat

    Importing products: a problem...

    Reinstalling CC was a tad extreme. I've never done an import this way, but the import file should contain an entry ID for the category you're importing in to. When you recreated the site, did you recreate the categories in the exactly same order. There's a good chance that your category has changed ID's since the rebuild. Does your site have any products at the moment ? If so you could try this. In admin down the left hand column under inventory, use the export catalogue function to create a CSV file. Using your favorite editor, clear the CSV file bar just 1 entry. Below this single entry, add your own products, the single entry will ensure you can figure out which column corresponds to category, product code, descriptions etc etc, and that your data is in the correct fields, in the correct format. When this is populated, delete the single entry, and try importing the CSV back using the import catalogue function. If your site doesn't yet contain any products, then create a new category manually, to this add a test product manually. Follow the above steps.
  7. keat

    Importing products: a problem...

    If you are familiar with PHP Myadmin, then it might be quicker to delete them in there, but I'd recommend making a backup of the table first.
  8. keat

    Upgrade v3.0.20 to v6.2.2

    If you have the facility/space, then I'd be tempted to recreate a copy of your v3 site on another domain space, get this working before doing anything else. Streamline and document your technique, then do a dummy run of your V6 upgrade. You can do this as many times as you like until you are happy with the process before going live. I'm lucky in the respect that I have my own dedicated server, and a handful of spare domain names
  9. I was struggling to comprehend, but now I sort of get it. because the landing page it's a category , it has the '?page=all' appended to the end. Is this detrimental to SEO ? and if so, is there anyway to resolve it ?
  10. I created a url in the search engine section of a category called 'cable-ties', but google has somehow translated this to https://www.cabletiesonline.co.uk/cable-ties.html?page=all any ideas where it's pulled the '?page=all' from
  11. keat

    Moving website to another domain

    Personally, I'd just recreate the whole site on the new domain, no need for redirects, 301's, htaccess etc. On the new domain create the databse with the same name, same password, same user rights etc. Ftp the site files and folders from one to the other. Export the database on the live site, and import on it's new home. You could make as many dummy runs as you like until you've fine tuned the process, without affecting anything on the live domain. This also gives you the liberty of playing with the transferred site to make sure everything works as expected. I've done this a few times, I could probably get actual down time to under 30 minutes.
  12. keat

    View All not working

    I made the edit, but the same happens. Here is the debug output from about page 4 (although it's technically all page 1) [1] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_sessions` WHERE CubeCart_sessions.session_id = 'ifhdc73bbgfn2o38k9rgmf3jb6' LIMIT 1; -- (0.00016689300537109 sec) [NOT CACHED] [2] SELECT FOUND_ROWS() as Count; -- (7.4863433837891E-5 sec) [NOT CACHED] [3] SELECT * FROM `CubeCart_hooks` WHERE CubeCart_hooks.enabled = '1' ORDER BY priority ASC ; -- (0.0003209114074707 sec) [CACHE WRITE] [4] SELECT `php_code`, `unique_id`, `description`, `hook_trigger` FROM `CubeCart_code_snippet` WHERE CubeCart_code_snippet.enabled = '1' ORDER BY `priority` ASC ; -- (0.00020694732666016 sec) [CACHE WRITE] [5] SELECT * FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.path = 'search' ; -- (0.00020098686218262 sec) [CACHE WRITE] [6] SELECT SQL_CALC_FOUND_ROWS `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'logos' LIMIT 1; -- (0.00023984909057617 sec) [CACHE WRITE] [7] SELECT FOUND_ROWS() as Count; -- (0.00010299682617188 sec) [NOT CACHED] [8] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `CubeCart_modules` WHERE CubeCart_modules.folder = 'logos' LIMIT 1; -- (0.00024700164794922 sec) [CACHE WRITE] [9] SELECT `folder` FROM `CubeCart_modules` WHERE CubeCart_modules.module = 'livehelp' AND CubeCart_modules.status = '1' ; -- (0.00021600723266602 sec) [CACHE WRITE] [10] SELECT * FROM `CubeCart_currency` WHERE CubeCart_currency.code = 'GBP' ; -- (0.00024294853210449 sec) [CACHE WRITE] [11] SELECT SQL_CALC_FOUND_ROWS `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'ccss' LIMIT 1; -- (0.0003349781036377 sec) [CACHE WRITE] [12] SELECT FOUND_ROWS() as Count; -- (8.2969665527344E-5 sec) [NOT CACHED] [13] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `CubeCart_modules` WHERE CubeCart_modules.folder = 'ccss' LIMIT 1; -- (0.00017690658569336 sec) [CACHE WRITE] [14] SELECT FOUND_ROWS() as Count; -- (8.2969665527344E-5 sec) [NOT CACHED] [15] SELECT `ip_address` FROM `CubeCart_ccss_ip_addresses` WHERE CubeCart_ccss_ip_addresses.trusted = '0' ; -- (0.00015711784362793 sec) [CACHE WRITE] [16] SELECT SQL_CALC_FOUND_ROWS `id`, `hits` FROM `CubeCart_search` WHERE CubeCart_search.searchstr = 'SOK' LIMIT 1; -- (0.0038690567016602 sec) [NOT CACHED] [17] SELECT FOUND_ROWS() as Count; -- (7.4863433837891E-5 sec) [NOT CACHED] [18] UPDATE `CubeCart_search` SET `hits` = '43' WHERE CubeCart_search.id = '10073'; -- (0.00015592575073242 sec) [NOT CACHED] [19] SHOW INDEX FROM `CubeCart_inventory`; -- (0.00026702880859375 sec) [CACHE WRITE] [20] SHOW VARIABLES LIKE 'ft_min_word_len' -- (0.0004270076751709 sec) [CACHE WRITE] [21] SELECT I.*, MATCH (I.product_code,I.description,I.name) AGAINST('sok' IN BOOLEAN MODE) AS Relevance FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (MATCH (I.product_code,I.description,I.name) AGAINST('sok' IN BOOLEAN MODE)) >= 0.5 ORDER BY Relevance DESC LIMIT 12 OFFSET 36 -- (0.00053691864013672 sec) [CACHE WRITE] [22] SHOW INDEX FROM `CubeCart_inventory`; -- (0.00053691864013672 sec) [CACHE READ] [23] SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.name RLIKE '[[::]]' OR I.description RLIKE '[[::]]' OR I.product_code RLIKE '[[::]]') ORDER BY product_code ASC LIMIT 12 OFFSET 0 -- (0.14987921714783 sec) [CACHE WRITE] [24] SHOW INDEX FROM `CubeCart_inventory`; -- (0.14987921714783 sec) [CACHE READ] [25] SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.name LIKE '%sok%' OR I.description LIKE '%sok%' OR I.product_code LIKE '%sok%') ORDER BY product_code ASC LIMIT 12 OFFSET 0 -- (0.073055028915405 sec) [CACHE WRITE] [26] SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.name LIKE '%sok%' OR I.description LIKE '%sok%' OR I.product_code LIKE '%sok%') -- (0.074651002883911 sec) [CACHE WRITE] [27] SELECT `quantity`, `price` FROM `CubeCart_pricing_quantity` WHERE CubeCart_pricing_quantity.product_id = '4777' AND CubeCart_pricing_quantity.group_id = '0' ORDER BY `quantity` ASC, `price` ASC ; -- (0.00023889541625977 sec) [CACHE WRITE] [28] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_image_index` WHERE CubeCart_image_index.product_id = '4777' ORDER BY `main_img` DESC LIMIT 1; -- (0.00018215179443359 sec) [CACHE WRITE] [29] SELECT FOUND_ROWS() as Count; -- (7.3909759521484E-5 sec) [NOT CACHED]
  13. keat

    View All not working

    Those results were from the first page of results. If I choose the second page I get the following.# MySQLi Queries (502): [1] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_sessions` WHERE CubeCart_sessions.session_id = '49aq0mke0qa602o1dc5m632in4' LIMIT 1; -- (0.0001990795135498 sec) [NOT CACHED] [2] SELECT FOUND_ROWS() as Count; -- (7.5101852416992E-5 sec) [NOT CACHED] [3] SELECT * FROM `CubeCart_lang_strings` WHERE CubeCart_lang_strings.language = 'en-GB' ; -- (0.0033090114593506 sec) [CACHE WRITE] [4] SELECT * FROM `CubeCart_hooks` WHERE CubeCart_hooks.enabled = '1' ORDER BY priority ASC ; -- (0.00030279159545898 sec) [CACHE WRITE] [5] SELECT `php_code`, `unique_id`, `description`, `hook_trigger` FROM `CubeCart_code_snippet` WHERE CubeCart_code_snippet.enabled = '1' ORDER BY `priority` ASC ; -- (0.00018215179443359 sec) [CACHE WRITE] [6] SELECT C.cat_id, C.cat_name, C.cat_parent_id, S.path FROM `CubeCart_category` as C LEFT JOIN `CubeCart_seo_urls` as S ON S.item_id=C.cat_id AND S.type='cat' AND S.custom='1' ORDER BY C.cat_id DESC -- (0.0043911933898926 sec) [CACHE WRITE] [7] SELECT `cat_id`, `cat_name` FROM `CubeCart_category_language` WHERE CubeCart_category_language.language = 'en-GB' ; -- (0.0043911933898926 sec) [CACHE READ] [8] SELECT * FROM `CubeCart_seo_urls` WHERE CubeCart_seo_urls.path = 'search' ; -- (0.00034785270690918 sec) [CACHE WRITE] [9] SELECT SQL_CALC_FOUND_ROWS `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'logos' LIMIT 1; -- (0.00029301643371582 sec) [CACHE WRITE] [10] SELECT FOUND_ROWS() as Count; -- (9.5129013061523E-5 sec) [NOT CACHED] [11] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `CubeCart_modules` WHERE CubeCart_modules.folder = 'logos' LIMIT 1; -- (9.5129013061523E-5 sec) [CACHE READ] [12] SELECT `folder` FROM `CubeCart_modules` WHERE CubeCart_modules.module = 'livehelp' AND CubeCart_modules.status = '1' ; -- (9.5129013061523E-5 sec) [CACHE READ] [13] SELECT * FROM `CubeCart_currency` WHERE CubeCart_currency.code = 'GBP' ; -- (0.00024914741516113 sec) [CACHE WRITE] [14] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_customer` WHERE CubeCart_customer.customer_id = '19834' LIMIT 1; -- (0.00030708312988281 sec) [CACHE WRITE] [15] SELECT FOUND_ROWS() as Count; -- (0.00010991096496582 sec) [NOT CACHED] [16] SELECT * FROM `CubeCart_lang_strings` WHERE CubeCart_lang_strings.language = 'en-GB' ; -- (0.00010991096496582 sec) [CACHE READ] [17] SELECT SQL_CALC_FOUND_ROWS `array` FROM `CubeCart_config` WHERE CubeCart_config.name = 'ccss' LIMIT 1; -- (0.0003972053527832 sec) [CACHE WRITE] [18] SELECT FOUND_ROWS() as Count; -- (0.00011491775512695 sec) [NOT CACHED] [19] SELECT SQL_CALC_FOUND_ROWS `status`, `countries` FROM `CubeCart_modules` WHERE CubeCart_modules.folder = 'ccss' LIMIT 1; -- (0.00031518936157227 sec) [CACHE WRITE] [20] SELECT FOUND_ROWS() as Count; -- (0.00010299682617188 sec) [NOT CACHED] [21] SELECT `ip_address` FROM `CubeCart_ccss_ip_addresses` WHERE CubeCart_ccss_ip_addresses.trusted = '0' ; -- (0.00010299682617188 sec) [CACHE READ] [22] SELECT SQL_CALC_FOUND_ROWS `id`, `hits` FROM `CubeCart_search` WHERE CubeCart_search.searchstr = 'SOK' LIMIT 1; -- (0.0061938762664795 sec) [NOT CACHED] [23] SELECT FOUND_ROWS() as Count; -- (0.00012397766113281 sec) [NOT CACHED] [24] UPDATE `CubeCart_search` SET `hits` = '34' WHERE CubeCart_search.id = '10073'; -- (0.00026893615722656 sec) [NOT CACHED] [25] SELECT `group_id` FROM `CubeCart_customer_membership` WHERE CubeCart_customer_membership.customer_id = '19834' ; -- (0.00026893615722656 sec) [CACHE READ] [26] SHOW INDEX FROM `CubeCart_inventory`; -- (0.00034594535827637 sec) [CACHE WRITE] [27] SHOW VARIABLES LIKE 'ft_min_word_len' -- (0.00070905685424805 sec) [CACHE WRITE] [28] SELECT I.*, MATCH (I.product_code,I.description,I.name) AGAINST('sok' IN BOOLEAN MODE) AS Relevance FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (MATCH (I.product_code,I.description,I.name) AGAINST('sok' IN BOOLEAN MODE)) >= 0.5 ORDER BY Relevance DESC LIMIT 12 OFFSET 12 -- (0.00077390670776367 sec) [CACHE WRITE] [29] SELECT `group_id` FROM `CubeCart_customer_membership` WHERE CubeCart_customer_membership.customer_id = '19834' ; -- (0.00077390670776367 sec) [CACHE READ] [30] SHOW INDEX FROM `CubeCart_inventory`; -- (0.00077390670776367 sec) [CACHE READ] [31] SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.name RLIKE '[[::]]' OR I.description RLIKE '[[::]]' OR I.product_code RLIKE '[[::]]') ORDER BY product_code ASC LIMIT 12 OFFSET 0 -- (0.00077390670776367 sec) [CACHE READ] [32] SELECT `group_id` FROM `CubeCart_customer_membership` WHERE CubeCart_customer_membership.customer_id = '19834' ; -- (0.00077390670776367 sec) [CACHE READ] [33] SHOW INDEX FROM `CubeCart_inventory`; -- (0.00077390670776367 sec) [CACHE READ] [34] SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.name LIKE '%sok%' OR I.description LIKE '%sok%' OR I.product_code LIKE '%sok%') ORDER BY product_code ASC LIMIT 12 OFFSET 0 -- (0.086556911468506 sec) [CACHE WRITE] [35] SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.name LIKE '%sok%' OR I.description LIKE '%sok%' OR I.product_code LIKE '%sok%') -- (0.084884881973267 sec) [CACHE WRITE]
×