Upgrading to 2.0.7 Error

I just tried upgrading to 2.0.7 and now my store doesn’t work. The error I get is:


Incorrect key file for table 'cscart_products_categories'; try to repair it (1034)



I am just doing this on my localhost if it matters.



Any help would be greatly appreciated.



Thank you,



Brandon

I didn’t know there was a 2.0.7. How do I get it and what are the new features/bug fixes from 2.0.6?

[quote name=‘brandonvd’]I just tried upgrading to 2.0.7 and now my store doesn’t work. The error I get is:


Incorrect key file for table 'cscart_products_categories'; try to repair it (1034)



I am just doing this on my localhost if it matters.



Any help would be greatly appreciated.



Thank you,



Brandon[/QUOTE]



I better stay of from updates for another couple of days… :slight_smile:

Also clean instalation 2.0.6 containing one product only, throws errors.

My god i am getting the database problem. :cry:


Database error: Incorrect key file for table 'cscart_products_categories'; try to repair it (1034)
Invalid query: SELECT SQL_CALC_FOUND_ROWS products.product_id, descr1.product as product, products.tracking, products.feature_comparison, products.zero_price_action, products.product_type, products.tax_ids, GROUP_CONCAT(IF(products_categories.link_type = 'M', CONCAT(products_categories.category_id, 'M'), products_categories.category_id)) as category_ids, min_qty, max_qty, products.qty_step, products.list_qty_count, avail_since, buy_in_advance, popularity.total as popularity, products.product_code, products.amount, MIN(prices.price) as price, products.status, products.list_price, descr1.short_description, IF(descr1.short_description = '', descr1.full_description, '') as full_description, products.is_edp, cscart_seo_names.name as seo_name FROM cscart_products as products LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'EN' LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id AND cscart_categories.membership_id IN (0, 0) AND cscart_categories.status IN ('A', 'H') AND products.status IN ('A') LEFT JOIN cscart_product_sales ON cscart_product_sales.product_id = products.product_id AND cscart_product_sales.category_id = products_categories.category_id LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = products.product_id AND cscart_seo_names.type = 'p' WHERE 1 AND products.product_id IN (29850, 29781) AND prices.membership_id IN (0, 0) GROUP BY products.product_id ORDER BY descr1.product asc




Please help

Well I decided to just revert back to 2.0.6 and everything works fine now. I am assuming that CS has seen this problem since I can’t try to do the upgrade again. I am now getting an error message saying that the upgrade package is broken. I don’t know, I’ll just have to wait and see.



Brandon

Yep, I had to revert back to 2.0.6 too. I received the same db error.



Error: Incorrect key file for table ‘cscart_products_categories’; try to repair it

Grrr… posting to get noification the repair asap - hopefully sooner than later.



[edit] ok now I am thoroughly upset. I reverted to 2.0.6 and I am getting the following:



Database error: Table 'cscart.cscart_product_popularity' doesn't exist (1146)




This needs to be addressed soon. Anyone else know where to look for this? My only thought is to reload the blocks since there seem to be changes made in that area which did no revert. Trying to clear all cache and compiled templates had no effect.

I’m getting the same thing, my whole store is down.



This is so frustrating because I was using Wordpress and an ecommerce plugin for my store, and every time there was an upgrade, it caused massive problems trying to get everything working again.



I heard good things about cs-cart, so decided to spend the money and get away from Wordpress. I spent several weeks getting the new store up and running and guess what, here I am having the same problems again.



Very discouraging…



Guess I will try reverting back to 2.0.6 and see what happens.



Lewis

Pain in the butt… was finally able to revert…

I reverted back to 2.0.6 and it seems to be working, but I have the problem again of the “files” tab showing on all of my product details pages.



I just spent hours and hours going to each product and deleting and re-adding the download file to correct that problem, and now all of that was in vain.



Lewis

2.0.6 for now

Well after reverting to 2.0.6 earlier I thought I would take a look at this thing again after work.



I just got my store upgraded to 2.0.7 and it went real smooth.



What I did was this:


  1. First I tried the upgrade this morning and got the error in the original post.


  2. I reverted back to 2.0.6 with no problems


  3. I used my ftp program and deleted these files in var/upgrade:

    The folder named: upgrade_2.0.6-2.0.7.tgz

    The file named: uc.tgz

    The file named: package.xml (I think this was the name)


  4. Once the files were deleted I then went into my admin backend and did the upgrade process over again.



    The second time around worked great and there weren’t any conflicts. One thing about me though is that almost all of my modifications have been done through hooks and the “local addon”. By using hooks everything was able to upgrade and I didn’t have to change any files.



    I hope this information helps someone,



    Brandon

Sorry you guys ran into a snag!



I just updated from 2.06 to 2.07 without any errors whatsover, interesting that it is only occuring for some and not for others. :confused:

[quote name=‘brandonvd’]The second time around worked great and there weren’t any conflicts. One thing about me though is that almost all of my modifications have been done through hooks and the “local addon”. By using hooks everything was able to upgrade and I didn’t have to change any files.[/QUOTE]

It is great to see someone else comment on the value of hooks. I really think it is a matter of “pay me now or pay me later”. Hopefully others will see the value of paying the initial cost of learning how to use hooks.



Bob

[QUOTE]It is great to see someone else comment on the value of hooks. I really think it is a matter of “pay me now or pay me later”. Hopefully others will see the value of paying the initial cost of learning how to use hooks.[/QUOTE]



Figuring out the whole “Hooks Concept” is the absolute next thing on my todo list as the overall concept makes total sense!



First I had to port over two ASP/SQL sites to CS-Cart & get it live, now that this is only a few hours away from being completed i can see the light at the end of the tunnel! :wink:

I guess I don’t see what using hooks has to do with an upgrade failing in a massive way to a lot of people.



The only file I changed on my site was the one below, and I only did that because disabling ajax in cs-cart didn’t work as it was supposed to to start with:


  1. First of all disable “Ajax add to cart”
  2. In the following file:

    [CSCART_ROOT_DIR]/skins/[YOUR_SKIN_NAME]/customer/views/products/components/buy_now.tpl

    delete the code from line 33 till 35.



    {if !$stay_in_cart}



    {/if}



    I plan to learn how hooks work and how to use them because I can see the value, but I don’t think that should be a pre-requisite to being able to do a successful upgrade, and if it is, then users should be warned not to do the upgrade.



    My 2 cents worth…

store down here too, not only is it down I have the whitescreen of death and the hot deals addon is freaking out on the admin side…lol

hot_deals_addon_freaks_out.jpg

[quote name=‘TutorDaddy’]I plan to learn how hooks work and how to use them because I can see the value, but I don’t think that should be a pre-requisite to being able to do a successful upgrade, and if it is, then users should be warned not to do the upgrade.



My 2 cents worth…[/QUOTE]

I don’t believe anyone suggested that using hooks is, or should be, a prerequisite to a successful upgrade. Brandon simply commented on how nice it was not having to resolve conflicts or make the same changes to a new version. I agreed because I have been a pretty vocal proponent while others seemed to feel they have little value. Hopefully others will appreciate their value as people provide additional comments on their experiences.



Bob

I tried deleting the files mentioned in a previous post, except didn’t have a package.xml file or anything similar.



Tried the update again, same results.



I’m going to call it quits until they come up with a definite answer on how to do the upgrade, and learned a lesson…wait a few days before doing future upgrades.

[quote name=‘jobosales’]I don’t believe anyone suggested that using hooks is, or should be, a prerequisite to a successful upgrade. Brandon simply commented on how nice it was not having to resolve conflicts or make the same changes to a new version. I agreed because I have been a pretty vocal proponent while others seemed to feel they have little value. Hopefully others will appreciate their value as people provide additional comments on their experiences.



Bob[/QUOTE]



What are hooks and where can I learn more about them?