Magento - 1.4.0.0 - Cannot Refresh Indexes - Magento Upgrades - eCommerce Software for Growth

Log In

Username or Email

Password:

Forgot Password

or
Register

Skip to site navigation »
Skip to main content »
Skip to footer content »

Magento Forum

1.4.0.0 - Cannot Refresh Indexes

PoleWebAT Total Posts: 10 Joined: 2009-12-04 Ignore user	hello everybody, i’ve got the same problem, i can’t reindex my product’s attribute index, it still lock on working and when i try to reindex i got this message ‘Some problem with reindexing process.’ When i look at my exception.log file : i’ve got those lines : 2010-12-03T11:14:06+00:00 ERR (3): exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'mage_catalog_product_index_eav_idx'' in /var/www/vhosts/my-site.com/httpdocs/lib/Zend/Db/Statement/Pdo.php:234 Stack trace: #0 /var/www/vhosts/my-site.com/httpdocs/lib/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array) #1 /var/www/vhosts/my-site.com/httpdocs/lib/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array) #2 /var/www/vhosts/my-site.com/httpdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('DROP TABLE IF E...', Array) #3 /var/www/vhosts/my-site.com/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php(333): Zend_Db_Adapter_Pdo_Abstract->query('DROP TABLE IF E...', Array) #4 /var/www/vhosts/my-site.com/httpdocs/app/code/core/Mage/Index/Model/Mysql4/Abstract.php(92): Varien_Db_Adapter_Pdo_Mysql->query('DROP TABLE IF E...') #5 /var/www/vhosts/my-site.com/httpdocs/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Eav/Abstract.php(66): Mage_Index_Model_Mysql4_Abstract->cloneIndexTable(true) #6 /var/www/vhosts/my-site.com/httpdocs/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Eav.php(107): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Indexer_Eav_Abstract->reindexEntities('708') #7 /var/www/vhosts/my-site.com/httpdocs/app/code/core/Mage/Index/Model/Indexer/Abstract.php(144): Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Indexer_Eav->catalogProductSave(Object(Mage_Index_Model_Event)) #8 /var/www/vhosts/my-site.com/httpdocs/app/code/core/Mage/Catalog/Model/Product/Indexer/Eav.php(254): Mage_Index_Model_Indexer_Abstract->callEventHandler(Object(Mage_Index_Model_Event)) #9 /var/www/vhosts/my-site.com/httpdocs/app/code/core/Mage/Index/Model/Indexer/Abstract.php(85): Mage_Catalog_Model_Product_Indexer_Eav->_processEvent(Object(Mage_Index_Model_Event)) #10 /var/www/vhosts/my-site.com/httpdocs/app/code/core/Mage/Index/Model/Process.php(185): Mage_Index_Model_Indexer_Abstract->processEvent(Object(Mage_Index_Model_Event)) #11 [internal function]: Mage_Index_Model_Process->processEvent(Object(Mage_Index_Model_Event)) #12 /var/www/vhosts/my-site.com/httpdocs/app/code/core/Mage/Index/Model/Indexer.php(252): call_user_func_array(Array, Array) #13 /var/www/vhosts/my-site.com/httpdocs/app/code/core/Mage/Index/Model/Indexer.php(154): Mage_Index_Model_Indexer->_runAll('processEvent', Array) #14 /var/www/vhosts/my-site.com/httpdocs/app/code/core/Mage/Index/Model/Indexer.php(219): Mage_Index_Model_Indexer->indexEvent(Object(Mage_Index_Model_Event)) #15 /var/www/vhosts/my-site.com/httpdocs/app/code/core/Mage/Catalog/Model/Product.php(518): Mage_Index_Model_Indexer->processEntityAction(Object(Mage_Catalog_Model_Product), 'catalog_product', 'save') #16 [internal function]: Mage_Catalog_Model_Product->afterCommitCallback() #17 /var/www/vhosts/my-site.com/httpdocs/app/code/core/Mage/Core/Model/Resource/Abstract.php(104): call_user_func(Array) #18 /var/www/vhosts/my-site.com/httpdocs/app/code/core/Mage/Core/Model/Abstract.php(288): Mage_Core_Model_Resource_Abstract->commit() #19 /var/www/vhosts/my-site.com/httpdocs/app/code/core/Mage/Adminhtml/controllers/Catalog/ProductController.php(626): Mage_Core_Model_Abstract->save() #20 /var/www/vhosts/my-site.com/httpdocs/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Adminhtml_Catalog_ProductController->saveAction() #21 /var/www/vhosts/my-site.com/httpdocs/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('save') #22 /var/www/vhosts/my-site.com/httpdocs/app/code/core/Mage/Core/Controller/Varien/Front.php(177): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) #23 /var/www/vhosts/my-site.com/httpdocs/app/code/core/Mage/Core/Model/App.php(304): Mage_Core_Controller_Varien_Front->dispatch() #24 /var/www/vhosts/my-site.com/httpdocs/app/Mage.php(596): Mage_Core_Model_App->run(Array) #25 /var/www/vhosts/my-site.com/httpdocs/index.php(78): Mage::run('', 'store') #26 {main} The problem seems to be the table ‘mage_catalog_product_index_eav_idx’ and when i look int the phpMyAdmin, i could see this table marked as ‘in use’ and i can’t drop the table, modify or view data. I tryed to delete the var/locks/ files, but no results. i tryed the magento cleanup tools, but no results. Is anyone can help me ? Thanks a lot !
	Posted: December 3 2010 \| top \| # 46

PoleWebAT Total Posts: 10 Joined: 2009-12-04 Ignore user	I deleted the table and recreate it manually and restart the indexes and everything\’s good !! Hope it could help someone !
	Posted: December 13 2010 \| top \| # 47

tipofloe Total Posts: 22 Joined: 2009-02-17 Ignore user	Anthony Charrex - 26 November 2010 05:34 AM To force the refresh of “Catalog URL Rewrites “ (if blocked to Processing state), truncate the table “core_url_rewrite” and restart the index process ! Please forgive my ignorance, but where would you do what you wrote?
	Posted: February 23 2011 \| top \| # 48

chiefair Total Posts: 1707 Joined: 2009-06-04 Ignore user	Most websites use phpMyAdmin to manage MySQL databases. You use it to select the particular table of interest and empty or truncate it. If you are this unfamiliar with working with MySQL, you should concentrate on doing full database backups as you will want to have protection against any mishaps. This site has good php/mysql tutorials for doing this... Signature ----- 1) For preserving thy future happiness, thou shalt back up thy HTTP doc directories and Magento database regularly. 2) For preserving thy sanity during module installs and moves, thou shalt disable thy cache and compiler and flush their caches.
	Posted: February 24 2011 \| top \| # 49

hkp Total Posts: 3 Joined: 2010-10-05 Ignore user	Hi , I have solve this error by deleting some attributes and deleting the products
	Posted: March 17 2011 \| top \| # 50

bunnicula Total Posts: 3 Joined: 2010-10-26 Ignore user	Hi guys, having what appears to be the same problem, all indexing is working and store is fully operational except for “Category Flat Data” which won’t reindex. Getting the error “Cannot initialize the indexer process.” Here’s the error log: 2011-08-29T18:49:30+00:00 DEBUG (7): Exception message: SQLSTATE[HY000]: General error: 1005 Can’t create table ‘mystore_magento.catalog_category_flat_store_1’ (errno: 150) Trace: #0 /home/mystore/public_html/lib/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array) #1 /home/mystore/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #2 /home/mystore/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’CREATE TABLE `c...’, Array) #3 /home/mystore/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(333): Zend_Db_Adapter_Pdo_Abstract->query(’CREATE TABLE `c...’, Array) #4 /home/mystore/public_html/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Category/Flat.php(526): Varien_Db_Adapter_Pdo_Mysql->query(’CREATE TABLE `c...’) #5 /home/mystore/public_html/app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Category/Flat.php(433): Mage_Catalog_Model_Resource_Eav_Mysql4_Category_Flat->_createTable(’1’) #6 /home/mystore/public_html/app/code/core/Mage/Catalog/Model/Category/Indexer/Flat.php(237): Mage_Catalog_Model_Resource_Eav_Mysql4_Category_Flat->rebuild() #7 /home/mystore/public_html/app/code/core/Mage/Index/Model/Process.php(139): Mage_Catalog_Model_Category_Indexer_Flat->reindexAll() #8 /home/mystore/public_html/app/code/core/Mage/Index/Model/Process.php(167): Mage_Index_Model_Process->reindexAll() #9 /home/mystore/public_html/app/code/core/Mage/Index/controllers/Adminhtml/ProcessController.php(178): Mage_Index_Model_Process->reindexEverything() #10 /home/mystore/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Index_Adminhtml_ProcessController->massReindexAction() #11 /home/mystore/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(253): Mage_Core_Controller_Varien_Action->dispatch(’massReindex’) #12 /home/mystore/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) #13 /home/mystore/public_html/app/code/core/Mage/Core/Model/App.php(340): Mage_Core_Controller_Varien_Front->dispatch() #14 /home/mystore/public_html/app/Mage.php(627): Mage_Core_Model_App->run(Array) #15 /home/mystore/public_html/index.php(80): Mage::run(’’, ‘store’) #16 {main} Anyone have any idea what might fix this?
	Posted: August 29 2011 \| top \| # 51

suleymankaygisiz Total Posts: 53 Joined: 2010-06-30 Ignore user	For that indexing problem, my problem was solved by deleting all the products.
	Posted: August 31 2011 \| top \| # 52

PauGNU Total Posts: 19 Joined: 2011-01-25 Barcelona Ignore user	Hi, I finally could work something out about this. I actually solved my problem when it came to reindexing product prices. It was actually what dwdonline said: some rows on the catalog_product_entity_tier_price table where related to products that didn\\\’t exist anymore. I created a script to find this rows and delete them. You can find the script here (and a howto)
	Posted: October 11 2011 \| top \| # 53

shane242 Total Posts: 13 Joined: 2008-09-29 Ignore user	I had the same problem, being unable to rebuild the Product Attributes index. I tried every fix in this thread and a wide array of other things. Fresh install, deleted and recreated all Attributes, and it works? I did some investigation as I wanted to know what the issue was and after 3 hours i found it. My issue came after i had imported products, i noticed if i imported a single product (1 product in the database) i couldn’t index. if i went o the product and hit save it let me index. My CSV used had multiple images (multi rows per product) as well as other options. This was fine for all but one of my Attributes, I had a Multi select type field setup, and on the rows where this wasn’t entered, it was picking the default item from the Attributes settings, in this case “Other”. The result of which is 5 rows of the entry “Other”. I removed the default flag from the Attributes and cleared the system and it worked correctly. 6,000 products indexed without issue. Hope this helps somebody else. Image Attachments Click thumbnail to see full-size image
	Posted: November 12 2011 \| top \| # 54

bijalbhavsar99 Total Posts: 71 Joined: 2009-04-13 Ahmedabad Ignore user	taocode - 27 May 2010 03:05 AM I upgraded from a 1.3xxx and performed the hack that removed the mysql4-upgrade-1.4.0.0.19-1.4.0.0.20.php file because it failed during the upgrade process. I found this solution to the upgrade problem here: http://www.simplehelix.com/forums/showthread.php?t=43 The upgrade error is probably corrected by updating most tables to use the InnoDB engine (instead of MyISAM). The syntax to update tables to the InnoDB engine is as follows: ALTER TABLE table_name ENGINE = InnoDB; I noticed that a fresh install had no problem reindexing everything, but there were odd errors creating tables after an upgrade. The errors are found by turning on the exceptions log: Admin -> System -> Configuration -> Developer -> Log Settings -> Enabled = Yes. This outputs to: /var/log/exception.log Most errors had something to do with cryptic foreign key constraints. Changing most tables to InnoDB seems to solve this problem. I’m including the code that I ran on my install (note you can copy and paste and change to your prefix instead of ‘magento_’): ALTER TABLE magento_admin_assert ENGINE = InnoDB; ALTER TABLE magento_admin_role ENGINE = InnoDB; ALTER TABLE magento_admin_rule ENGINE = InnoDB; ALTER TABLE magento_admin_user ENGINE = InnoDB; ALTER TABLE magento_api_assert ENGINE = InnoDB; ALTER TABLE magento_api_role ENGINE = InnoDB; ALTER TABLE magento_api_rule ENGINE = InnoDB; ALTER TABLE magento_api_user ENGINE = InnoDB; ALTER TABLE magento_catalogindex_eav ENGINE = InnoDB; ALTER TABLE magento_catalogindex_minimal_price ENGINE = InnoDB; ALTER TABLE magento_catalogindex_price ENGINE = InnoDB; ALTER TABLE magento_cataloginventory_stock_item ENGINE = InnoDB; ALTER TABLE magento_catalogrule ENGINE = InnoDB; ALTER TABLE magento_catalogrule_product ENGINE = InnoDB; ALTER TABLE magento_catalogrule_product_price ENGINE = InnoDB; ALTER TABLE magento_catalogsearch_query ENGINE = InnoDB; ALTER TABLE magento_catalog_category_entity ENGINE = InnoDB; ALTER TABLE magento_catalog_category_entity_datetime ENGINE = InnoDB; ALTER TABLE magento_catalog_category_entity_decimal ENGINE = InnoDB; ALTER TABLE magento_catalog_category_entity_int ENGINE = InnoDB; ALTER TABLE magento_catalog_category_entity_text ENGINE = InnoDB; ALTER TABLE magento_catalog_category_entity_varchar ENGINE = InnoDB; ALTER TABLE magento_catalog_category_product ENGINE = InnoDB; ALTER TABLE magento_catalog_category_product_index ENGINE = InnoDB; ALTER TABLE magento_catalog_compare_item ENGINE = InnoDB; ALTER TABLE magento_catalog_product_bundle_option ENGINE = InnoDB; ALTER TABLE magento_catalog_product_bundle_option_value ENGINE = InnoDB; ALTER TABLE magento_catalog_product_bundle_selection ENGINE = InnoDB; ALTER TABLE magento_catalog_product_enabled_index ENGINE = InnoDB; ALTER TABLE magento_catalog_product_entity_datetime ENGINE = InnoDB; ALTER TABLE magento_catalog_product_entity_decimal ENGINE = InnoDB; ALTER TABLE magento_catalog_product_entity_gallery ENGINE = InnoDB; ALTER TABLE magento_catalog_product_entity_int ENGINE = InnoDB; ALTER TABLE magento_catalog_product_entity_media_gallery ENGINE = InnoDB; ALTER TABLE magento_catalog_product_entity_media_gallery_value ENGINE = InnoDB; ALTER TABLE magento_catalog_product_entity_text ENGINE = InnoDB; ALTER TABLE magento_catalog_product_entity_tier_price ENGINE = InnoDB; ALTER TABLE magento_catalog_product_entity_varchar ENGINE = InnoDB; ALTER TABLE magento_catalog_product_link ENGINE = InnoDB; ALTER TABLE magento_catalog_product_link_attribute ENGINE = InnoDB; ALTER TABLE magento_catalog_product_link_attribute_decimal ENGINE = InnoDB; ALTER TABLE magento_catalog_product_link_attribute_int ENGINE = InnoDB; ALTER TABLE magento_catalog_product_link_attribute_varchar ENGINE = InnoDB; ALTER TABLE magento_catalog_product_link_type ENGINE = InnoDB; ALTER TABLE magento_catalog_product_option ENGINE = InnoDB; ALTER TABLE magento_catalog_product_option_price ENGINE = InnoDB; ALTER TABLE magento_catalog_product_option_title ENGINE = InnoDB; ALTER TABLE magento_catalog_product_option_type_price ENGINE = InnoDB; ALTER TABLE magento_catalog_product_option_type_title ENGINE = InnoDB; ALTER TABLE magento_catalog_product_option_type_value ENGINE = InnoDB; ALTER TABLE magento_catalog_product_super_attribute ENGINE = InnoDB; ALTER TABLE magento_catalog_product_super_attribute_label ENGINE = InnoDB; ALTER TABLE magento_catalog_product_super_attribute_pricing ENGINE = InnoDB; ALTER TABLE magento_catalog_product_super_link ENGINE = InnoDB; ALTER TABLE magento_catalog_product_website ENGINE = InnoDB; ALTER TABLE magento_checkout_agreement ENGINE = InnoDB; ALTER TABLE magento_checkout_agreement_store ENGINE = InnoDB; ALTER TABLE magento_cms_block ENGINE = InnoDB; ALTER TABLE magento_cms_block_store ENGINE = InnoDB; ALTER TABLE magento_cms_page ENGINE = InnoDB; ALTER TABLE magento_cms_page_store ENGINE = InnoDB; ALTER TABLE magento_core_config_data ENGINE = InnoDB; ALTER TABLE magento_core_email_template ENGINE = InnoDB; ALTER TABLE magento_core_flag ENGINE = InnoDB; ALTER TABLE magento_core_layout_link ENGINE = InnoDB; ALTER TABLE magento_core_layout_update ENGINE = InnoDB; ALTER TABLE magento_core_resource ENGINE = InnoDB; ALTER TABLE magento_core_session ENGINE = InnoDB; ALTER TABLE magento_core_store ENGINE = InnoDB; ALTER TABLE magento_core_store_group ENGINE = InnoDB; ALTER TABLE magento_core_translate ENGINE = InnoDB; ALTER TABLE magento_core_url_rewrite ENGINE = InnoDB; ALTER TABLE magento_cron_schedule ENGINE = InnoDB; ALTER TABLE magento_customer_address_entity ENGINE = InnoDB; ALTER TABLE magento_customer_address_entity_datetime ENGINE = InnoDB; ALTER TABLE magento_customer_address_entity_decimal ENGINE = InnoDB; ALTER TABLE magento_customer_address_entity_int ENGINE = InnoDB; ALTER TABLE magento_customer_address_entity_text ENGINE = InnoDB; ALTER TABLE magento_customer_address_entity_varchar ENGINE = InnoDB; ALTER TABLE magento_customer_entity ENGINE = InnoDB; ALTER TABLE magento_customer_entity_datetime ENGINE = InnoDB; ALTER TABLE magento_customer_entity_decimal ENGINE = InnoDB; ALTER TABLE magento_customer_entity_int ENGINE = InnoDB; ALTER TABLE magento_customer_entity_text ENGINE = InnoDB; ALTER TABLE magento_customer_entity_varchar ENGINE = InnoDB; ALTER TABLE magento_customer_group ENGINE = InnoDB; ALTER TABLE magento_dataflow_batch ENGINE = InnoDB; ALTER TABLE magento_dataflow_batch_export ENGINE = InnoDB; ALTER TABLE magento_dataflow_batch_import ENGINE = InnoDB; ALTER TABLE magento_dataflow_import_data ENGINE = InnoDB; ALTER TABLE magento_dataflow_profile ENGINE = InnoDB; ALTER TABLE magento_dataflow_profile_history ENGINE = InnoDB; ALTER TABLE magento_dataflow_session ENGINE = InnoDB; ALTER TABLE magento_design_change ENGINE = InnoDB; ALTER TABLE magento_directory_country ENGINE = InnoDB; ALTER TABLE magento_directory_country_region ENGINE = InnoDB; ALTER TABLE magento_directory_country_region_name ENGINE = InnoDB; ALTER TABLE magento_directory_currency_rate ENGINE = InnoDB; ALTER TABLE magento_eav_attribute_group ENGINE = InnoDB; ALTER TABLE magento_eav_attribute_option ENGINE = InnoDB; ALTER TABLE magento_eav_attribute_option_value ENGINE = InnoDB; ALTER TABLE magento_eav_attribute_set ENGINE = InnoDB; ALTER TABLE magento_eav_entity ENGINE = InnoDB; ALTER TABLE magento_eav_entity_attribute ENGINE = InnoDB; ALTER TABLE magento_eav_entity_datetime ENGINE = InnoDB; ALTER TABLE magento_eav_entity_decimal ENGINE = InnoDB; ALTER TABLE magento_eav_entity_int ENGINE = InnoDB; ALTER TABLE magento_eav_entity_text ENGINE = InnoDB; ALTER TABLE magento_eav_entity_type ENGINE = InnoDB; ALTER TABLE magento_eav_entity_varchar ENGINE = InnoDB; ALTER TABLE magento_gift_message ENGINE = InnoDB; ALTER TABLE magento_googlebase_attributes ENGINE = InnoDB; ALTER TABLE magento_googlebase_items ENGINE = InnoDB; ALTER TABLE magento_googlebase_types ENGINE = InnoDB; ALTER TABLE magento_googlecheckout_api_debug ENGINE = InnoDB; ALTER TABLE magento_googleoptimizer_code ENGINE = InnoDB; ALTER TABLE magento_newsletter_problem ENGINE = InnoDB; ALTER TABLE magento_newsletter_queue ENGINE = InnoDB; ALTER TABLE magento_newsletter_queue_link ENGINE = InnoDB; ALTER TABLE magento_newsletter_queue_store_link ENGINE = InnoDB; ALTER TABLE magento_newsletter_subscriber ENGINE = InnoDB; ALTER TABLE magento_newsletter_template ENGINE = InnoDB; ALTER TABLE magento_paygate_authorizenet_debug ENGINE = InnoDB; ALTER TABLE magento_paypaluk_api_debug ENGINE = InnoDB; ALTER TABLE magento_paypal_api_debug ENGINE = InnoDB; ALTER TABLE magento_poll ENGINE = InnoDB; ALTER TABLE magento_poll_answer ENGINE = InnoDB; ALTER TABLE magento_poll_store ENGINE = InnoDB; ALTER TABLE magento_poll_vote ENGINE = InnoDB; ALTER TABLE magento_product_alert_price ENGINE = InnoDB; ALTER TABLE magento_rating ENGINE = InnoDB; ALTER TABLE magento_rating_entity ENGINE = InnoDB; ALTER TABLE magento_rating_option ENGINE = InnoDB; ALTER TABLE magento_rating_option_vote ENGINE = InnoDB; ALTER TABLE magento_rating_option_vote_aggregated ENGINE = InnoDB; ALTER TABLE magento_rating_store ENGINE = InnoDB; ALTER TABLE magento_rating_title ENGINE = InnoDB; ALTER TABLE magento_report_event ENGINE = InnoDB; ALTER TABLE magento_report_event_types ENGINE = InnoDB; ALTER TABLE magento_review ENGINE = InnoDB; ALTER TABLE magento_review_detail ENGINE = InnoDB; ALTER TABLE magento_review_entity ENGINE = InnoDB; ALTER TABLE magento_review_entity_summary ENGINE = InnoDB; ALTER TABLE magento_review_status ENGINE = InnoDB; ALTER TABLE magento_review_store ENGINE = InnoDB; ALTER TABLE magento_salesrule ENGINE = InnoDB; ALTER TABLE magento_salesrule_customer ENGINE = InnoDB; ALTER TABLE magento_sales_flat_order_item ENGINE = InnoDB; ALTER TABLE magento_sales_flat_quote ENGINE = InnoDB; ALTER TABLE magento_sales_flat_quote_address ENGINE = InnoDB; ALTER TABLE magento_sales_flat_quote_address_item ENGINE = InnoDB; ALTER TABLE magento_sales_flat_quote_item ENGINE = InnoDB; ALTER TABLE magento_sales_flat_quote_item_option ENGINE = InnoDB; ALTER TABLE magento_sales_flat_quote_payment ENGINE = InnoDB; ALTER TABLE magento_sales_flat_quote_shipping_rate ENGINE = InnoDB; ALTER TABLE magento_sales_order ENGINE = InnoDB; ALTER TABLE magento_sales_order_datetime ENGINE = InnoDB; ALTER TABLE magento_sales_order_decimal ENGINE = InnoDB; ALTER TABLE magento_sales_order_entity ENGINE = InnoDB; ALTER TABLE magento_sales_order_entity_datetime ENGINE = InnoDB; ALTER TABLE magento_sales_order_entity_decimal ENGINE = InnoDB; ALTER TABLE magento_sales_order_entity_int ENGINE = InnoDB; ALTER TABLE magento_sales_order_entity_text ENGINE = InnoDB; ALTER TABLE magento_sales_order_entity_varchar ENGINE = InnoDB; ALTER TABLE magento_sales_order_int ENGINE = InnoDB; ALTER TABLE magento_sales_order_tax ENGINE = InnoDB; ALTER TABLE magento_sales_order_text ENGINE = InnoDB; ALTER TABLE magento_sales_order_varchar ENGINE = InnoDB; In the end, the only tables that are using the MyISAM engine are as follows: magento_catalogsearch_fulltext magento_catalog_product_index_price_bndl_opt magento_catalog_product_index_price_bndl_sel magento_catalog_product_index_price_bundle magento_catalog_product_index_price_downloadable_idx magento_catalog_product_index_price_final_idx magento_catalog_product_index_price_idx_cfg_option magento_catalog_product_index_price_idx_cfg_opt_aggregate magento_catalog_product_index_price_idx_option magento_catalog_product_index_price_idx_option_aggregate magento_sendfriend_log After updating to InnoDB I was able to reindex everything successfully and the store seems to be back up and running as it should. Good luck! Thank you.. it works great!! -bijal bhavsar Signature MageCracker - [Lets Crack the code ] Mage Cracker
	Posted: December 6 2011 \| top \| # 55

pablogreg Total Posts: 3 Joined: 2010-02-01 Ignore user	I used the Cpanel Repair DB Function inside MySQL Databases and now it’s working again!
	Posted: February 22 2012 \| top \| # 56

kacu Total Posts: 9 Joined: 2009-10-23 Ignore user	pablogreg - 22 February 2012 02:45 AM I used the Cpanel Repair DB Function inside MySQL Databases and now it’s working again! Hi, can you explane pleas, how can I do that? Is ist poosible to make repair DB function form php myadmin? Signature ----- regards kacu fotomarket.com.pl
	Posted: November 22 2012 \| top \| # 57

Magento Community

Magento Community

Back to top

Fatal error: Element.php on line 89 in Magento ver. 1.4.0.0

Why has 1.3.2.4 been removed from Release Archives?