northwalesinks Posted November 6, 2013 Author Share Posted November 6, 2013 What category has a cat_id of 47? = AVG Anti-Virus Desc Anti-Virus Software This is in database but not showing up in cubecart Admin Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 6, 2013 Share Posted November 6, 2013 With respect to cat_id 47, what is its cat_parent_id? Quote Link to comment Share on other sites More sharing options...
northwalesinks Posted November 6, 2013 Author Share Posted November 6, 2013 With respect to cat_id 47, what is its cat_parent_id? = 46 With respect to cat_id 99 Software what is its cat_parent_id? = 0 With respect to cat_id 170 Eset what is its cat_parent_id? = 46 With respect to cat_id 171 Antivirus what is its cat_parent_id? = 31 With respect to cat_id 172 Antivirus what is its cat_parent_id? = 99 With respect to cat_id 175 Smart Security what is its cat_parent_id? = 99 Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 6, 2013 Share Posted November 6, 2013 "With respect to cat_id 47, what is its cat_parent_id? = 46" And does cat_id 46 have a name? Is it enabled? Does it show anywhere on CubeCart? For cat_id 46, what is its cat_parent_id? Quote Link to comment Share on other sites More sharing options...
northwalesinks Posted November 6, 2013 Author Share Posted November 6, 2013 does cat_id 46 have a name? = Anti-Virus Desc Anti-Virus cat_parent_id? 46 = Anti-Virus What do you mean by " Is it enabled? " Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 6, 2013 Share Posted November 6, 2013 For cat_id 46, what is its cat_parent_id? You said: 46 = Anti-Virus Are you saying cat_id 46 has a cat_parent_id also of 46? When you edit this category, there is a Status green checkmark or a red x. Quote Link to comment Share on other sites More sharing options...
northwalesinks Posted November 6, 2013 Author Share Posted November 6, 2013 cat_id cat_name cat_desc cat_parent_id 1 Cases-Storage Storage cases 0 2 CD Media <p> CDR, CD-R, blank media, blank discs... 0 3 DVD Media DVDR, DVD-R, CDR, CD-R, blank media, blank discs, ... 0 4 Hardware 0 5 Ink Cartridges 0 6 Paper and Labels 0 7 Printers Printers and labeling Printers 97 8 Software 31 9 CD/DVD Cases CD/DVD Cases, CD Cases, DVD Cases, 1 10 Storage Cases 10 11 DVD Duel Layer 3 12 DVD+R 3 13 8cm DVDR/RW/RAM 3 14 DVD-R 3 16 Paper 6 17 Labels 6 20 Cables 22 21 DVD Writers 4 22 PC Accessories PC Accessories 0 24 Compatible Ink For Epson 5 25 FAXES 5 26 REFILL KITS 5 27 Toners 5 30 7 31 8 37 DVD-RW ReWritable 3 38 DVD+RW ReWritable 3 39 Matte 16 40 Silk 16 41 Gloss 16 42 Special Offers <p> <a href="http://www.northwalesinks.com/store... 0 43 Lexmark 5 46 Anti-Virus 8 47 AVG Anti-Virus 46 48 NOD32 Anti-Virus 46 51 Routers 4 52 Mouses 22 53 Cleaning Cartridges 5 54 Cleaning Cartridges For Epson 5 55 Cleaning Cartridges For Canon 5 60 Sleeves 1 69 Mp3 Players 119 70 PressIt Kits & Labels 6 71 Dell Remanufactured 5 72 Samsung 5 75 Mp4 Media Player 119 76 Pen Drives USB Pens Drives 0 79 CD Cases 9 80 DVD Cases DVD Cases 9 82 Speaker 22 89 Headphones 22 90 Continuous Ink System 5 93 keyboards 22 94 Laptop Cases 22 95 Brother Printer 30 96 Epson Printer 30 97 Fax Machines 30 99 Software <p>Software</p> 0 100 Compatible Ink for Brother 5 103 Original Canon 5 104 Compatible Ink for Canon 5 105 Webcam WEBCAM 22 106 Labels 6 107 HP Remanufactured 5 108 Storage Cases Storage Cases 240, 300, 630, 1000 1 109 Memory Cards CF, M2, MMC, PRO DUO, SD, SDC, SDM, USB, XD digita... 0 110 SD CARD 109 111 MMC 109 112 COMPACT FLASH 109 113 MEMORY STICK PRO DUO 109 114 MICROSD 109 115 XD 109 116 RSMMC 109 117 MINI SD 109 118 Card Readers 109 119 MP3 / MP4 Players MP3 / MP4 Players 0 120 Brother Printers Brother Printers 0 121 Epson Printers Epson Printers 0 122 Labelling Systems 0 123 Digital Photo Frames 0 124 Pitney Bowes Ink Cartridges 5 125 Toners 0 126 BROTHER TONER 125 127 BLACK TONER <p>BROTHER BLACK TONER CARTRIDGE</p> 126 128 COLOUR TONER <p>COLOUR TONER CARTRIDGE</p> 126 129 DRUM UNITS <p>BROTHER DRUM UNITS</p> 126 131 CANON TONER <p>High Quality Canon Toner Cartridges</p> 125 132 DELL TONER <p>DELL TONER Cartridges</p> 125 133 Dell Toner Cartridges for Colour Printers <p>Dell Toner Cartridges for Colour Printers ... 132 134 Dell Black Toner Cartridges <p>High Quality Dell Black Toner Cartridges for Mo... 132 135 APPLE TONER <p>Apple Laserwriter Toner Cartridges</p> 125 136 EPSON TONER <p>EPSON TONER CARTRIDGE</p> 125 137 Epson Aculaser <p>Epson Aculaser Toner Cartridges</p> 136 138 Epson EPL <p>High Quality Epson EPL Series Toner Cartridges<... 136 139 GESTETNER TONER 125 140 HEWLETT PACKARD TONER <p>HEWLETT PACKARD TONER CARTRIDGE</p> 125 141 Hewlett Packard Colour Printers <p>Toner Cartridges for HP Colour Printer Models</... 140 142 Hewlett Packard Toner Cartridge for Mono Printers <p>Hewlett Packard Toner Cartridge for Mono P... 140 143 INFOTEC TONER <p>INFOTEC TONER CARTRIDGE</p> 125 144 IBM TONER <p>IBM TONER CARTRIDGE</p> 125 cat_id cat_name cat_desc cat_parent_id 145 KONICA COPIER TONER <p>KONICA COPIER TONER CARTRIDGE</p> 125 146 KYOCERA TONER <p><span style="font-family: Times New Roman">KYOC... 125 147 FS Series <p>High Quality Kyocera FS Series Laser Toner cart... 146 148 KM Series <p>High Quality Kyocera KM Series Laser Toner cart... 146 149 FSC Series <p>High Quality Kyocera FSC Series Laser Toner car... 146 150 LEXMARK TONER <p>LEXMARK TONER CARTRIDGE</p> 125 151 MINOLTA QMS TONER <p>MINOLTA QMS TONER CARTRIDGE</p> 125 152 Minolta QMS Toner Cartridges for Mono Printers <p>High Quality Minolta QMS Toner Cartridges for M... 151 153 Minolta QMS Toner Cartridges for Colour Printers <p>High Quality Minolta QMS Toner Cartridges for C... 151 154 OKI TONER <p>OKI TONER CARTRIDGE</p> 125 155 Oki Toner for Black Printer <p>Oki Toner Cartridges for Oki Black Printers and... 154 156 OKI TONER CARTRIDGE FOR COLOUR PRINTERS <p>OKI TONERCARTRIDGE FOR COLOUR PRINTERS</p... 154 157 OKI DRUM UNITS 154 158 PANASONIC TONER <p>PANASONIC TONER CARTRIDGE</p> 125 159 PHILIPS TONER <p>PHILIPS TONER CARTRIDGE</p> 125 160 RICOH FAX CARTRIDGES <p>RICOH FAX CARTRIDGES</p> 125 161 SAMSUNG TONER <p>SAMSUNG TONER CARTRIDGE</p> 125 162 Toner Cartridges For Samsung Mono / Black Printers <p>Samsung Toner Cartridges for Samsung Mono / Bla... 161 163 Toner Cartridges For Samsung Colour Printers <p>Samsung Toner Cartridges for Samsung Colour Pri... 161 164 TALLY <p>TALLY Toner Cartridge</p> 125 165 Tally T Series Toner Cartridges <p>High Quality Tally Genicom Compatible Toner Car... 164 166 XEROX TONER <p>XEROX TONER Cartridges</p> 125 167 Xerox Phaser Toner Cartridges <p>High Quality Xerox Phaser Laser Toner cartridge... 166 168 Xerox Workcentre Toner Cartridges <p>High quality Xerox Workcentre toner cartridges<... 166 169 Really Useful Boxes 1 170 ESET Smart Security <p> ESET Smart Security</p> 46 171 Antivirus <p><span style="font-size: medium"><span style="fo... 31 172 Antivirus <p> <meta content="text/html; charset=utf-8" http... 99 173 test again <p>test again</p> <p> </p> 31 174 test again 2 <p>tedtstxvhsghdb</p> 31 175 Smart Security 99 176 Home Entertainment 0 177 Blank Media Accessories <p><strong>Blank Media Accessories</strong></p> 0 178 Compatible Ink for KODAK 5 179 SDHC CARD 109 180 Backpack 94 181 Briefcase Bags 94 182 Messenger Bags 94 183 Trolley Bags 94 184 Sleeve Bags 94 I think should help you more Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 7, 2013 Share Posted November 7, 2013 There are cat_id's that are the parents of themselves. There are cat_id's which the parents are the children of themselves. Using phpMyAdmin, these are the records you must change: cat_id: 7 cat_name: Printers cat_parent_id: 0 cat_id: 30 cat_name: Printer Things cat_parent_id: 7 cat_id: 8 cat_name: Software cat_parent_id: 0 cat_id: 175 cat_name: Smart Security cat_parent_id: 8 cat_id: 10, 31, 99, 171, 172, 173, 174 DELETE THESE RECORDS Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 7, 2013 Share Posted November 7, 2013 Then, in admin, Maintenance, Rebuild, clear the cache. 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.