northwalesinks Posted October 19, 2013 Share Posted October 19, 2013 Hi After i have upgraded from cubecart 4 to cubecart 5 i have got lot of ghost categories In categories menu system in admin section, when i try to deleted them i get this message es The following errors were detected: Failed to delete category, as it contains 1 or more subcategories. But nothing in it at all it's blank Sorry for all the questions i am asking on here.now Quote Link to comment Share on other sites More sharing options...
bsmither Posted October 20, 2013 Share Posted October 20, 2013 In the Categories list, if you hover the mouse cursor over the name of the category, there will be a tooltip that says, "This category contains 1 (or more) sub-categories." If you click on the name, it will fetch and list all the children of that category. (And I hope this is how CubeCart normally behaves and is not something I hacked into it.) Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted October 20, 2013 Share Posted October 20, 2013 I have in the past had to delete a child from the database to get rid of that message.Hopefully you won't have to do that, but will be able to get rid of it from within Admin. Quote Link to comment Share on other sites More sharing options...
northwalesinks Posted October 20, 2013 Author Share Posted October 20, 2013 Hello i got loads of catagories in the database not showing in admin catagories list. How can i fix it Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted October 20, 2013 Share Posted October 20, 2013 In the Categories list, if you hover the mouse cursor over the name of the category, there will be a tooltip that says, "This category contains 1 (or more) sub-categories." If you click on the name, it will fetch and list all the children of that category. (And I hope this is how CubeCart normally behaves and is not something I hacked into it.) A Category with children shows as a link, and you are correct - a tooltip indicates how many children. Quote Link to comment Share on other sites More sharing options...
bsmither Posted October 20, 2013 Share Posted October 20, 2013 "I have a number of categories in the database not showing in the admin categories list." Please be aware that the initial list shows "top-level" categories. The list will never show "all" categories as a choice. If all you have are top-level categories, then the list will be complete, in that there will be no sub-categories not included in the list. The list will show all categories that have a specific "parent" (the top-level having a parent_id of zero). Quote Link to comment Share on other sites More sharing options...
northwalesinks Posted October 20, 2013 Author Share Posted October 20, 2013 all you have are top-level categories I know This listed is missing load from old cubecart 4 version i had before. Quote Link to comment Share on other sites More sharing options...
bsmither Posted October 20, 2013 Share Posted October 20, 2013 "I have a number of categories in the database not showing in the admin categories list." "The list is missing many categories from CubeCart 4 version I had before." So the categories (top-level?) that were used in CC4 are still in the database table, but not showing in the admin list? That is very odd. The categories not listed that are still in the database table, what is their parent_id? Quote Link to comment Share on other sites More sharing options...
northwalesinks Posted October 20, 2013 Author Share Posted October 20, 2013 hi which one you talking about CubeCart_category CubeCart_category_backup CubeCart_category_index CubeCart_category_language Quote Link to comment Share on other sites More sharing options...
northwalesinks Posted October 20, 2013 Author Share Posted October 20, 2013 "I have a number of categories in the database not showing in the admin categories list." Please be aware that the initial list shows "top-level" categories. The list will never show "all" categories as a choice. If all you have are top-level categories, then the list will be complete, in that there will be no sub-categories not included in the list. The list will show all categories that have a specific "parent" (the top-level having a parent_id of zero). HI Are you talking about this cat_id cat_name cat_desc cat_parent_id cat_image Quote Link to comment Share on other sites More sharing options...
bsmither Posted October 20, 2013 Share Posted October 20, 2013 I was paraphrasing what you said. "I have a number of categories in the database not showing in the admin categories list." The items in the list comes from the CubeCart_category table. Quote Link to comment Share on other sites More sharing options...
northwalesinks Posted October 20, 2013 Author Share Posted October 20, 2013 The categories not listed that are still in the database table, what is their parent_id? where do i need to look at to answer you Quote Link to comment Share on other sites More sharing options...
bsmither Posted October 20, 2013 Share Posted October 20, 2013 CubeCart_category table, the column 'cat_parent_id'. Quote Link to comment Share on other sites More sharing options...
northwalesinks Posted October 20, 2013 Author Share Posted October 20, 2013 CubeCart_category table, the column 'cat_parent_id'. by i got the following 1 31 89 109 many more too Quote Link to comment Share on other sites More sharing options...
bsmither Posted October 20, 2013 Share Posted October 20, 2013 Ok, you have one or more table records where the 'cat_parent_id' is 1. Now, what is the name of the category that has a 'cat_id' of 1? Quote Link to comment Share on other sites More sharing options...
northwalesinks Posted October 20, 2013 Author Share Posted October 20, 2013 cat_id cat_name cat_desc cat_parent_id cat_image per_ship item_ship item_int_ship per_int_ship seo_meta_title seo_meta_description seo_meta_keywords cat_sefurl hide priority status Edit Copy Delete 1 Cases-Storage Storage cases 0 0.00 0.00 0.00 0.00 Cases - Storage Storage Storage DVD, CD cases, DJ cases, 0 8 1 Edit Copy Delete 2 CD Media <p> CDR, CD-R, blank media, blank discs... 0 0.00 0.00 0.00 0.00 CD Blank Media CDR, CD-R, SVP, blank media, blank discs, blank ch... CDR, CD-R blank media, blank discs cd-r, 0 12 1 Edit Copy Delete 3 DVD Media DVDR, DVD-R, CDR, CD-R, blank media, blank discs, ... 0 0.00 0.00 0.00 0.00 DVD Media DVDR, DVD-R, CDR, CD-R, blank media, blank discs, ... DVDR, DVD-R, CDR, CD-R, SVP, blank media, blank di... 0 11 1 Edit Copy Delete 4 Hardware 0 0.00 0.00 0.00 0.00 Hardware Hardware Hardware, 0 9 1 Edit Copy Delete 5 Ink Cartridges 0 0.00 0.00 0.00 0.00 Ink Cartridges Inks supplier of compatible and remanufactured ink... Inks supplier, compatible, remanufactured ink car... 0 1 1 Edit Copy Delete 6 Paper and Labels 0 0.00 0.00 0.00 0.00 Paper and Labels photo paper inkjet photo paper photo printer pape... photo paper, inkjet photo paper, photo printer pap... 0 5 1 Edit Copy Delete 7 Printers Printers and labeling Printers 97 Quote Link to comment Share on other sites More sharing options...
bsmither Posted October 20, 2013 Share Posted October 20, 2013 The category that has cat_id = 1 is "Cases-Storage". "Cases-Storage" has a cat_parent_id = 0, so it is a top-level category. The category you say is not in the list Categories (but having a cat_parent_id of 1), is a child of "Cases-Storage". In the Categories list, click the link that is Cases-Storage. All the children of "Cases-Storage" will now be listed. Tell us if there is a category you know should be listed here, but isn't. ================ If we are discussing the categories in your store at pcutile, then the "CATEGORIE" box on the storefront has "Spille", "Posters". etc, but not "Cases-Storage". Are you looking at the correct database? Oops! Wrong site. Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted October 20, 2013 Share Posted October 20, 2013 If we are discussing the categories in your store at pcutile, then the "CATEGORIE" box on the storefront has "Spille", "Posters". etc, but not "Cases-Storage". Are you looking at the correct database? I think you're getting mixed up with the Italian site you're helping with. I don't know how you keep all this straight!!! Quote Link to comment Share on other sites More sharing options...
northwalesinks Posted October 22, 2013 Author Share Posted October 22, 2013 This is showing up in database but not showing up in cubecart at all. 173 test again <p>test again</p> <p> </p> 31 11 0.00 0.00 0.00 0.00 0 173 1 174 test again 2 <p>tedtstxvhsghdb</p> 31 cat_parent_id =31 Quote Link to comment Share on other sites More sharing options...
northwalesinks Posted October 22, 2013 Author Share Posted October 22, 2013 HI 170 ESET Smart Security <p> ESET Smart Security</p> 46 0.00 0.00 0.00 0.00 ESET Smart Security ESET Smart Security ESET Smart Security, 0 170 1 171 Antivirus <p><span style="font-size: medium"><span style="fo... 31 0.00 0.00 0.00 0.00 Antivirus Antivirus Antivirus, 0 171 1 172 Antivirus <p> <meta content="text/html; charset=utf-8" http... 99 Antivirus 0 1 1 173 test again <p>test again</p> <p> </p> 31 Quote Link to comment Share on other sites More sharing options...
bsmither Posted October 23, 2013 Share Posted October 23, 2013 What category has a cat_id of 31? And is it enabled? Quote Link to comment Share on other sites More sharing options...
northwalesinks Posted October 25, 2013 Author Share Posted October 25, 2013 Do you mean "cat_id" or cat_pasrent_Id Quote Link to comment Share on other sites More sharing options...
bsmither Posted October 25, 2013 Share Posted October 25, 2013 cat_id Quote Link to comment Share on other sites More sharing options...
northwalesinks Posted November 6, 2013 Author Share Posted November 6, 2013 What category has a cat_id of 31? And is it enabled? What category has a cat_id of 27? = Toners What category has a cat_id of 31? = blank text What category has a cat_id of 30? = blank text What category has a cat_id of 37?= DVD-RW ReWriters What category has a cat_id of 38?= DVD+RW ReWriters snapshot how it is listed Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 6, 2013 Share Posted November 6, 2013 In CubeCart admin, enter this directly into the web browser address bar: www.northwalesinks.com/admin.php?_g=categories&action=edit&cat_id=31 If it has blank text as the Category Name, give it one. Do the same for cat_id=30, and any other category that doesn't show up anywhere in CubeCart. 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.