Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Upgrading to 2.0.7 Error Rate Topic   - - - - -

 
  • brandonvd
  • is Super Awesome
  • Members
  • Join Date: 19-Dec 06
  • 2633 posts

Posted 24 August 2009 - 02:45 PM #1

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

 

Posted 24 August 2009 - 02:51 PM #2

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?

 
  • Darius
  • Douchebag
  • Members
  • Join Date: 20-Apr 08
  • 3349 posts

Posted 24 August 2009 - 03:39 PM #3

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 better stay of from updates for another couple of days... :)

 
  • MimiWatch
  • Member
  • Members
  • Join Date: 14-Jun 08
  • 138 posts

Posted 24 August 2009 - 05:39 PM #4

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

 
  • miracles
  • Senior Member
  • Members
  • Join Date: 19-Sep 07
  • 1533 posts

Posted 24 August 2009 - 07:07 PM #5

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
CS-CART 3.0.6 GRENADE

Please vote for CDN Add-on

For SEO Article Submission, Forum Profile Links, Web 2.0 links, contact me through PM.

 
  • brandonvd
  • is Super Awesome
  • Members
  • Join Date: 19-Dec 06
  • 2633 posts

Posted 24 August 2009 - 07:54 PM #6

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

 
  • MorganaM
  • Junior Member
  • Members
  • Join Date: 24-Aug 09
  • 2 posts

Posted 24 August 2009 - 09:13 PM #7

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

 
  • jagorny
  • Senior Member
  • Members
  • Join Date: 29-Nov 08
  • 226 posts

Posted 24 August 2009 - 09:34 PM #8

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

www.orthodoxmarketplace.com - CS-Cart 2.2.4 Pro (Dedicated)

 
  • TutorDaddy
  • Junior Member
  • Members
  • Join Date: 09-Jul 09
  • 23 posts

Posted 24 August 2009 - 10:08 PM #9

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

 
  • jagorny
  • Senior Member
  • Members
  • Join Date: 29-Nov 08
  • 226 posts

Posted 24 August 2009 - 10:21 PM #10

Pain in the butt... was finally able to revert..
Jacob Gorny

www.orthodoxmarketplace.com - CS-Cart 2.2.4 Pro (Dedicated)

 
  • TutorDaddy
  • Junior Member
  • Members
  • Join Date: 09-Jul 09
  • 23 posts

Posted 24 August 2009 - 10:41 PM #11

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

 
  • brandonvd
  • is Super Awesome
  • Members
  • Join Date: 19-Dec 06
  • 2633 posts

Posted 25 August 2009 - 12:40 AM #12

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

 
  • Struck
  • Teetering on Genious
  • Members
  • Join Date: 07-Mar 09
  • 2502 posts

Posted 25 August 2009 - 12:42 AM #13

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:
Cooking with Gas on Version 4.1.2 (But proceeding with caution....)

 
  • jobosales
  • Senior Member
  • Members
  • Join Date: 04-Nov 06
  • 3114 posts

Posted 25 August 2009 - 12:52 AM #14

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.

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
CS-Cart 2.0.14 (testing)

 
  • Struck
  • Teetering on Genious
  • Members
  • Join Date: 07-Mar 09
  • 2502 posts

Posted 25 August 2009 - 01:00 AM #15

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.


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! ;)
Cooking with Gas on Version 4.1.2 (But proceeding with caution....)

 
  • TutorDaddy
  • Junior Member
  • Members
  • Join Date: 09-Jul 09
  • 23 posts

Posted 25 August 2009 - 01:44 AM #16

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}
<input type="hidden" name="redirect_url" value="{$config.current_url}" />
{/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.....

 
  • snorocket
  • Forum Janitor
  • Members
  • Join Date: 15-Mar 06
  • 2519 posts

Posted 25 August 2009 - 01:58 AM #17

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

Attached Thumbnails

  • hot_deals_addon_freaks_out.jpg

SNOROCKET.COM, Now Accepting PRE-ORDERS:
Customer Service (Helpdesk) Addon for CS-Cart v4.3.1
Quote and Invoicing Addon for CS-Cart v4.3.1

 
  • jobosales
  • Senior Member
  • Members
  • Join Date: 04-Nov 06
  • 3114 posts

Posted 25 August 2009 - 02:02 AM #18

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

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
CS-Cart 2.0.14 (testing)

 
  • TutorDaddy
  • Junior Member
  • Members
  • Join Date: 09-Jul 09
  • 23 posts

Posted 25 August 2009 - 02:03 AM #19

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.

 

Posted 25 August 2009 - 02:11 AM #20

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


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