Jump to content

Update to 5.2.4 Catagory Now Empty


jdmdecals

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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).

Link to comment
Share on other sites

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...

 

MySQLi
Queries (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

Link to comment
Share on other sites

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.)

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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"...

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...