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
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.
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.
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.
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:
First I tried the upgrade this morning and got the error in the original post.
I reverted back to 2.0.6 with no problems
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)
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.
[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.
[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!
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:
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.
[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.
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?