New Zenner
- Join Date:
- Aug 2022
- Location:
- Adelaide
- Posts:
- 14
- Plugin Contributions:
- 0
Products orphaned from caregories
Hi,
I am using v 1.5.5f, responsive classic, this was current version when I downloaded last month. https://yarnpig2-au.stackstaging.com/
Just fixed issue with main page not displaying and now I realise that items showing on the storefront have disappeared from the admin/catalog/categories. I wanted to amend some of their details. But there are several missing.
If I click on one of these orphans in the shopfront featured products, I can add to my cart. Also search doesnt find them. Search does find the other products.
Looking at a backup file, the sql for that table seems to have all my missing data. Categories 3, 67, 66, 75 are missing.
-- Dumping data for table categories_description
LOCK TABLES categories_description WRITE;
/*!40000 ALTER TABLE categories_description DISABLE KEYS */;
INSERT INTO categories_description VALUES (3,1,'Notions','Accessories/bits n bobs - For all your non-yarn needs'),(79,1,'Misc','Yarns that dont belong in other categories!'),(10,1,'Knitting Needles','<p>Straight Needles, sets of needles or circular needles<br /><br /></p>'),(67,1,'Misc things','Blocking wires, yarn needles, stitch counters & other bits n pieces'),(66,1,'Crochet Hooks','Crochet hooks and hook sets'),(21,1,'Gift Certificates','Send a Gift Certificate today!<br /><br />Gift Certificates are good for anything in the store.'),(75,1,'Azteca','Beautiful 10 ply mix of 50% wool and 50% (........cut off, whole thing not needed)