jdmdecals Posted November 24, 2013 Share Posted November 24, 2013 After doing the update, i noticed that the catagory sidebar still shows all the catagories. however when i click on one there are no longer any products assigned to that catagory. I do find that the products are still on the site. So thats good atleast.. IS there a refresh section on the admin panel maybe i need to 'repair' I spent about 20min looking on the forums to see if others had this issue. didnt see anything. Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 24, 2013 Share Posted November 24, 2013 I have no answer (yet), but we would need to know what version you upgraded from. Please use a utility such as phpMyAdmin to view the contents of the CubeCart_category_index table. Is there anything in this table? Quote Link to comment Share on other sites More sharing options...
jdmdecals Posted November 24, 2013 Author Share Posted November 24, 2013 i just edited my signature so you'd have teh correct info :/ i belive it was 5.1.2 i went into the admin part and checked the box for the catagory_ file and went to repair.. and now the site seems to not load :/ I emailed my host to see if they know what happend. must have konked out. when it comes back up i can be more help. Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 24, 2013 Share Posted November 24, 2013 There is nothing in the upgrade scripts that would have affected the associations between products and categories. At this time, I can see your storefront. Quote Link to comment Share on other sites More sharing options...
jdmdecals Posted November 24, 2013 Author Share Posted November 24, 2013 are the products popping up in the catagory section? Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 24, 2013 Share Posted November 24, 2013 No. Which is why I asked you to use a utility such as phpMyAdmin to view the contents of the CubeCart_category_index table. Is there anything in this table? Quote Link to comment Share on other sites More sharing options...
jdmdecals Posted November 25, 2013 Author Share Posted November 25, 2013 looks like there is something there... what do i look at from here? Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted November 25, 2013 Share Posted November 25, 2013 That screenshot is probably of the File Manager. Look in your cpanel homepage again for an icon for phpMyAdmin. That will give you a view of all the database tables. Bsmither needs to know if the CubeCart_category_index table has any entries. There are hopefully at least as many entries as the number of product listings you have. It can have more, if you have assigned more than one category to any of your products. Quote Link to comment Share on other sites More sharing options...
jdmdecals Posted November 25, 2013 Author Share Posted November 25, 2013 thats inside of the storename.com/cpanel then i went to phpadmin and found that.. am i looking wrong? Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted November 25, 2013 Share Posted November 25, 2013 I have a different version and mine doesn't look like yours. Sorry. Try clicking on admin_users and see if you can get the results you'd expect - showing your admins in some way. Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted November 25, 2013 Share Posted November 25, 2013 Oh, I think you're looking at the Structure tab. Try clicking on the Browse tab instead on the right hand side. Quote Link to comment Share on other sites More sharing options...
jdmdecals Posted November 25, 2013 Author Share Posted November 25, 2013 how about this info. Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted November 25, 2013 Share Posted November 25, 2013 That's what he needed to know. So your category data has not been lost, thank goodness, unless you have more than 231 products. I did notice that all the primary entries were ones. Do you have any of your products listed in more than one category? If so, there should be some listings in the primary column with zero as the entry. Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 25, 2013 Share Posted November 25, 2013 Yes, excellent. So, if I were to view index.php?_a=category&cat_id=1, I should see at least 13 items. But I don't. Could it be that the products are disabled? Viewing index.php?_a=product&product_id=4, I get that product. (id=194 in the screen grab above) So that's not the problem. In admin, Store Settings, Advanced tab, enable Debug mode. Enter your IP address in the next field. (www.whatismyip.com) When you next call up a category page, there will be a grey section at the bottom of the page. In there, I want you to find the SQL query that references the CubeCart_category_index table. Copy that query here. Quote Link to comment Share on other sites More sharing options...
jdmdecals Posted November 25, 2013 Author Share Posted November 25, 2013 15] SELECT CI.* , C.status FROM `CubeCart_category_index` AS CI, `CubeCart_category` AS C WHERE CI.cat_id = C.cat_id ORDER BY CI.product_id -- (0.0123870372772 sec) [CACHED] Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 25, 2013 Share Posted November 25, 2013 Hmmm. Do you have this query: SELECT I.product_id FROM `CubeCart_category_index` as I, `CubeCart_inventory` as INV WHERE I.cat_id = 1 AND I.product_id = INV.product_id AND INV.status = 1 -- (0.015625 sec) [CACHED] Just to make sure, in admin, Maintenance, Rebuild tab, clear the cache (SQL cache, especially). Quote Link to comment Share on other sites More sharing options...
jdmdecals Posted November 25, 2013 Author Share Posted November 25, 2013 i cleared the cache SQL and it appears to fix the issue. Just to not leave you hanging. this is the info i had before clearing it... MySQLiQueries (53): [1] SELECT * FROM `CubeCart_sessions` WHERE CubeCart_sessions.session_id = '020ea301148a982537e45934192d0df5' LIMIT 1; -- (0.000256061553955 sec) [2] SELECT * FROM `CubeCart_lang_strings` WHERE CubeCart_lang_strings.language = 'en' ; -- (0.000264883041382 sec) [CACHED] [3] SELECT * FROM `CubeCart_hooks` WHERE CubeCart_hooks.enabled = '1' ORDER BY priority ASC ; -- (8.89301300049E-5 sec) [CACHED] [4] INSERT INTO `CubeCart_system_error_log` (`message`,`time`) VALUES ('File: [hookloader.class.php] Line: [418] "SELECT * FROM `CubeCart_code_snippet` ;" - Table 'bchytka_cc5.CubeCart_code_snippet' doesn't exist','1385346674'); -- (0.000159025192261 sec) [5] -- (0.000159025192261 sec) [CACHED] [6] SELECT * FROM `CubeCart_permissions` WHERE CubeCart_permissions.admin_id = '1' ; -- (5.81741333008E-5 sec) [CACHED] [7] SELECT * FROM `CubeCart_category` WHERE CubeCart_category.cat_parent_id = '0' ORDER BY `priority` ASC ; -- (0.00804805755615 sec) [CACHED] [8] SELECT `translation_id`, `language` FROM `CubeCart_category_language` WHERE CubeCart_category_language.cat_id = '1' ; -- (0.00539112091064 sec) [CACHED] [9] SELECT COUNT(cat_id) AS Count FROM `CubeCart_category` WHERE CubeCart_category.cat_parent_id = '1'; -- (0.0133500099182 sec) [CACHED] [10] SELECT `translation_id`, `language` FROM `CubeCart_category_language` WHERE CubeCart_category_language.cat_id = '2' ; -- (0.014683008194 sec) [CACHED] [11] SELECT COUNT(cat_id) AS Count FROM `CubeCart_category` WHERE CubeCart_category.cat_parent_id = '2'; -- (0.00880098342896 sec) [CACHED] [12] SELECT `translation_id`, `language` FROM `CubeCart_category_language` WHERE CubeCart_category_language.cat_id = '9' ; -- (0.0124199390411 sec) [CACHED] [13] SELECT COUNT(cat_id) AS Count FROM `CubeCart_category` WHERE CubeCart_category.cat_parent_id = '9'; -- (0.0115230083466 sec) [CACHED] [14] SELECT `translation_id`, `language` FROM `CubeCart_category_language` WHERE CubeCart_category_language.cat_id = '11' ; -- (0.0163969993591 sec) [CACHED] [15] SELECT COUNT(cat_id) AS Count FROM `CubeCart_category` WHERE CubeCart_category.cat_parent_id = '11'; -- (0.0162990093231 sec) [CACHED] [16] SELECT `translation_id`, `language` FROM `CubeCart_category_language` WHERE CubeCart_category_language.cat_id = '12' ; -- (0.000582933425903 sec) [CACHED] [17] SELECT COUNT(cat_id) AS Count FROM `CubeCart_category` WHERE CubeCart_category.cat_parent_id = '12'; -- (0.000156879425049 sec) [CACHED] [18] SELECT `translation_id`, `language` FROM `CubeCart_category_language` WHERE CubeCart_category_language.cat_id = '13' ; -- (0.000156164169312 sec) [CACHED] [19] SELECT COUNT(cat_id) AS Count FROM `CubeCart_category` WHERE CubeCart_category.cat_parent_id = '13'; -- (0.000191926956177 sec) [CACHED] [20] SELECT `translation_id`, `language` FROM `CubeCart_category_language` WHERE CubeCart_category_language.cat_id = '14' ; -- (0.000128984451294 sec) [CACHED] [21] SELECT COUNT(cat_id) AS Count FROM `CubeCart_category` WHERE CubeCart_category.cat_parent_id = '14'; -- (0.000151872634888 sec) [CACHED] [22] SELECT `translation_id`, `language` FROM `CubeCart_category_language` WHERE CubeCart_category_language.cat_id = '15' ; -- (0.00023078918457 sec) [CACHED] [23] SELECT COUNT(cat_id) AS Count FROM `CubeCart_category` WHERE CubeCart_category.cat_parent_id = '15'; -- (0.000159978866577 sec) [CACHED] [24] SELECT `translation_id`, `language` FROM `CubeCart_category_language` WHERE CubeCart_category_language.cat_id = '16' ; -- (0.000128030776978 sec) [CACHED] [25] SELECT COUNT(cat_id) AS Count FROM `CubeCart_category` WHERE CubeCart_category.cat_parent_id = '16'; -- (0.00016188621521 sec) [CACHED] [26] SELECT `translation_id`, `language` FROM `CubeCart_category_language` WHERE CubeCart_category_language.cat_id = '17' ; -- (0.0010039806366 sec) [CACHED] [27] SELECT COUNT(cat_id) AS Count FROM `CubeCart_category` WHERE CubeCart_category.cat_parent_id = '17'; -- (0.000159025192261 sec) [CACHED] [28] SELECT `translation_id`, `language` FROM `CubeCart_category_language` WHERE CubeCart_category_language.cat_id = '18' ; -- (0.000144004821777 sec) [CACHED] [29] SELECT COUNT(cat_id) AS Count FROM `CubeCart_category` WHERE CubeCart_category.cat_parent_id = '18'; -- (0.000158071517944 sec) [CACHED] [30] SELECT `translation_id`, `language` FROM `CubeCart_category_language` WHERE CubeCart_category_language.cat_id = '19' ; -- (0.000120878219604 sec) [CACHED] [31] SELECT COUNT(cat_id) AS Count FROM `CubeCart_category` WHERE CubeCart_category.cat_parent_id = '19'; -- (0.000169992446899 sec) [CACHED] [32] SELECT `translation_id`, `language` FROM `CubeCart_category_language` WHERE CubeCart_category_language.cat_id = '20' ; -- (0.000149011611938 sec) [CACHED] [33] SELECT COUNT(cat_id) AS Count FROM `CubeCart_category` WHERE CubeCart_category.cat_parent_id = '20'; -- (0.000188827514648 sec) [CACHED] [34] SELECT `translation_id`, `language` FROM `CubeCart_category_language` WHERE CubeCart_category_language.cat_id = '21' ; -- (0.000121831893921 sec) [CACHED] [35] SELECT COUNT(cat_id) AS Count FROM `CubeCart_category` WHERE CubeCart_category.cat_parent_id = '21'; -- (0.000170946121216 sec) [CACHED] [36] SELECT `translation_id`, `language` FROM `CubeCart_category_language` WHERE CubeCart_category_language.cat_id = '22' ; -- (0.000125885009766 sec) [CACHED] [37] SELECT COUNT(cat_id) AS Count FROM `CubeCart_category` WHERE CubeCart_category.cat_parent_id = '22'; -- (0.000166177749634 sec) [CACHED] [38] SELECT `translation_id`, `language` FROM `CubeCart_category_language` WHERE CubeCart_category_language.cat_id = '24' ; -- (0.000121831893921 sec) [CACHED] [39] SELECT COUNT(cat_id) AS Count FROM `CubeCart_category` WHERE CubeCart_category.cat_parent_id = '24'; -- (0.0001540184021 sec) [CACHED] [40] SELECT `translation_id`, `language` FROM `CubeCart_category_language` WHERE CubeCart_category_language.cat_id = '25' ; -- (0.000143051147461 sec) [CACHED] [41] SELECT COUNT(cat_id) AS Count FROM `CubeCart_category` WHERE CubeCart_category.cat_parent_id = '25'; -- (0.0556938648224 sec) [CACHED] [42] SELECT `translation_id`, `language` FROM `CubeCart_category_language` WHERE CubeCart_category_language.cat_id = '27' ; -- (0.0250279903412 sec) [CACHED] [43] SELECT COUNT(cat_id) AS Count FROM `CubeCart_category` WHERE CubeCart_category.cat_parent_id = '27'; -- (0.038770198822 sec) [CACHED] [44] SELECT `translation_id`, `language` FROM `CubeCart_category_language` WHERE CubeCart_category_language.cat_id = '29' ; -- (0.0243179798126 sec) [CACHED] [45] SELECT COUNT(cat_id) AS Count FROM `CubeCart_category` WHERE CubeCart_category.cat_parent_id = '29'; -- (0.0130558013916 sec) [CACHED] [46] SELECT `translation_id`, `language` FROM `CubeCart_category_language` WHERE CubeCart_category_language.cat_id = '30' ; -- (0.0452828407288 sec) [CACHED] [47] SELECT COUNT(cat_id) AS Count FROM `CubeCart_category` WHERE CubeCart_category.cat_parent_id = '30'; -- (0.0497629642487 sec) [CACHED] [48] SELECT `translation_id`, `language` FROM `CubeCart_category_language` WHERE CubeCart_category_language.cat_id = '31' ; -- (0.0102431774139 sec) [CACHED] [49] SELECT COUNT(cat_id) AS Count FROM `CubeCart_category` WHERE CubeCart_category.cat_parent_id = '31'; -- (0.0686600208282 sec) [CACHED] [50] SELECT `translation_id`, `language` FROM `CubeCart_category_language` WHERE CubeCart_category_language.cat_id = '32' ; -- (0.0346081256866 sec) [CACHED] [51] SELECT COUNT(cat_id) AS Count FROM `CubeCart_category` WHERE CubeCart_category.cat_parent_id = '32'; -- (0.193404912949 sec) [CACHED] [52] SELECT `translation_id`, `language` FROM `CubeCart_category_language` WHERE CubeCart_category_language.cat_id = '10' ; -- (0.15832901001 sec) [CACHED] [53] SELECT COUNT(cat_id) AS Count FROM `CubeCart_category` WHERE CubeCart_category.cat_parent_id = '10'; -- (0.00227689743042 sec) [CACHED]Errors: No Errors Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 25, 2013 Share Posted November 25, 2013 This message, "Table bchytka_cc5.CubeCart_code_snippet doesn't exist" tells me that the code may have been updated, but CubeCart has not executed the setup routine that updates the database schema. Be sure the setup folder is present, then go to www.your_store.com/setup/index.php, and choose Upgrade on the second screen. (There should have been a warning advisory about that on the admin Dashboard.) Quote Link to comment Share on other sites More sharing options...
jdmdecals Posted November 25, 2013 Author Share Posted November 25, 2013 i just did what you told me. so far everything worked good. I did the update through teh dashboard (update) apprently it must have not went through. the yourstore/update thing worked smoothly. i checked the catagories things seem ok! thank you! You are always so helpful. thanks to both of you Quote Link to comment Share on other sites More sharing options...
jdmdecals Posted November 25, 2013 Author Share Posted November 25, 2013 i also spent about 20min looking for the thread on how to center up that header logo image. I knew i found the thread in past about how to do it. even made a few comments. i went to my profile and searched through my posts. only to find the posts must have been so old it does not bring them up.. I hate to start a new thread just to find that info. am i using the correct search terms.. "center header image"... Quote Link to comment Share on other sites More sharing options...
bsmither Posted November 25, 2013 Share Posted November 25, 2013 I spent about 30 minutes trying to get that image positioned correctly. I couldn't (with keeping the search box). I will conclude that because the image is so wide (and no reason why it shouldn't be), it is falling "below" the search box. Because the image is so wide (and it does look nice), this is my advice: * load the original photoshop image back into the editor * slice out a 560x120 box of the lettering layer (transparent background) and save just that * save just the background In the CSS for the header background, use the background just saved. For the logo (in the foreground), use the lettering image. The lettering image should now not be "pushed down" below the search box. Quote Link to comment Share on other sites More sharing options...
jdmdecals Posted November 25, 2013 Author Share Posted November 25, 2013 that image actually was centered before i did the update... maybe i have a backup of the code i used to do it. Do you happen to remember what file you edit it in? maybe i can search my backup and see what was done. Quote Link to comment Share on other sites More sharing options...
jdmdecals Posted November 25, 2013 Author Share Posted November 25, 2013 i found the thread. i was able to find the one you helped me with at a previous point. it still worked! '?do=embed' frameborder='0' data-embedContent>> thank you! 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.