Jump to content
  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Hi, I have noticed that the ascending and descending functionality is only available for a few columns (e.g. $THEAD.name) listed in product.index.php in the admin section. I am finding difficult to see how this could be extended to other columns. Where exactly is the Sort by originating from / thank you for your help.
  2. I actually got it. You can amend the code at /classes/catalogue.class.php, the public function searchCatalogue(). you can add the column you want the search engine to look at below : $like = " AND (I.name ".$like_keyword." '".$regexp."' OR I.description ".$like_keyword." '".$regexp_desc."' OR I.product_code ".$like_keyword." '".$regexp."')"; However, if you want to avoid the search engine from looking into the description column you need to DROP it from the indexes in your MySQL database in the FULLTEXT keyname. You can therefore add other columns instead there and make it searc
  3. I have been trying to understand how to avoid the keywords searching into the description columns but all to no avail. I guess this is too complex in the whole catalogue.class.php scripting to amend. I have made made changes but this is now beyond me... Thank you in any case.
  4. Hi all, I found the code which says : $like = " AND (I.name ".$like_keyword." '".$regexp."' OR I.description ".$like_keyword." '".$regexp_desc."' OR I.product_code ".$like_keyword." '".$regexp."')"; However, when I change 'description' to another data base column it starts searching in that new column indeed but still keeps searching the 'description' one too. Would anyone know why ?
  5. Thank you, all fixed. Since I had imported a bulk file of over 11000 titles via phpMyAdmin, the category index files needed the primary column to follow the tagged one (both on 1) in the inventory file. Thank you for your help, Rick
  6. Hi, I have noticed that the featured product box in foundation seldom appears (www.preserving-football-history.net). I know this is randomly chosen from whichever products are tagged as 'featured' but it does not seem to work reliably. I have over 10000 products and only perhaps about 100 tagged as featured. Anyone knows why ? Regards, rick
  7. I had already cleared the internal cache several times but all to no avail. I have now turned the debugging to enables and it's back but has the debugging at the bottom of all pages. I couldn't find any 20190424073644 files in the cache from 24 April. I have disabled debugging and also disable caching and it seems to be working fine. However when I go into the admin site is gives a warning to turn caching on. Does it matter if I leave it off ?
  8. Hi all, I am a bit lost here and I think it's something to do with the cache. My site http://www.preserving-football-history.net/ looks like lost connectivity to the .css file as you can see. Whne I look at the Browser report it says : Failed to load resource: the server responded with a status of 404 (Not Found) 19796.css.foundation_20190424073644.css:1 Failed to load resource: the server responded with a status of 404 (Not Found) 19796.js_foot.foundation_20190411061840.js:1 Failed to load resource: the server responded with a status of 404 (Not Found) (index):1 Uncaugh
  9. I actually found the answer. Yes the mod remains the same : TRUNCATE TABLE CubeCart_category_index; INSERT INTO CubeCart_category_index (product_id, cat_id) SELECT product_id, cat_id FROM CubeCart_inventory; On a different note, what does the primary field do in CubeCart_category_index ? Thank you
  10. Hi all, there used to be a simple script required to fix the category counts when the database was populated manually or loaded with a CSV file. The categories have been created/added and now I have about 11000 products to add and all have their allocated category/sub category number. However, after adding a few products as a test the CubeCart_category_index stays empty and all products need to be manually allocated to their individual category. Is the following work around still the same as at https://swscripts.com/cubecart-mods/fixcatcount.html ? I looked in the forum and to my am
  • Create New...