Created
November 26, 2012 20:25
-
-
Save mclevenger/4150398 to your computer and use it in GitHub Desktop.
Magento Repairdb.php results before/after repair ran on old.dev Mage version 1.12.02
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ACTUALLY I USED THE WRONG DATABASE AS A REFERENCE ON THIS ONE | |
| Change storage engine type on table "catalog_category_anc_categs_index_tmp" from MEMORY to INNODB | |
| Change storage engine type on table "catalog_category_anc_products_index_tmp" from MEMORY to INNODB | |
| Change storage engine type on table "catalog_category_product_index_enbl_tmp" from MEMORY to INNODB | |
| Change storage engine type on table "catalog_category_product_index_tmp" from MEMORY to INNODB | |
| Change storage engine type on table "catalog_product_index_eav_decimal_tmp" from MEMORY to INNODB | |
| Change storage engine type on table "catalog_product_index_eav_tmp" from MEMORY to INNODB | |
| Change storage engine type on table "catalog_product_index_price_bundle_opt_tmp" from MEMORY to INNODB | |
| Change storage engine type on table "catalog_product_index_price_bundle_sel_tmp" from MEMORY to INNODB | |
| Change storage engine type on table "catalog_product_index_price_bundle_tmp" from MEMORY to INNODB | |
| Change storage engine type on table "catalog_product_index_price_cfg_opt_agr_tmp" from MEMORY to INNODB | |
| Change storage engine type on table "catalog_product_index_price_cfg_opt_tmp" from MEMORY to INNODB | |
| Change storage engine type on table "catalog_product_index_price_final_tmp" from MEMORY to INNODB | |
| Change storage engine type on table "catalog_product_index_price_opt_agr_tmp" from MEMORY to INNODB | |
| Change storage engine type on table "catalog_product_index_price_opt_tmp" from MEMORY to INNODB | |
| Change storage engine type on table "catalog_product_index_price_tmp" from MEMORY to INNODB | |
| Change storage engine type on table "cataloginventory_stock_status_tmp" from MEMORY to INNODB | |
| Add missing field(s) "include_in_menu, custom_use_parent_settings, custom_apply_to_products, filter_price_range, thumbnail" to table "catalog_category_flat_store_4" | |
| Add missing field(s) "activation_information, computer_manufacturers, computer_manufacturers_value, contrast_ratio, contrast_ratio_value, country_orgin, cpu_speed, cpu_speed_value, dimension, finish, gender, gender_value, harddrive_speed, hardrive, in_depth, manufacturer, manufacturer_value, max_resolution, megapixels, megapixels_value, memory, model, processor, ram_size, response_time, room, room_value, screensize, shirt_size, shirt_size_value, shoe_size, shoe_size_value, shoe_type, shoe_type_value" to table "catalog_product_flat_1" | |
| Add missing field(s) "activation_information, computer_manufacturers, computer_manufacturers_value, contrast_ratio, contrast_ratio_value, country_orgin, cpu_speed, cpu_speed_value, dimension, finish, gender, gender_value, harddrive_speed, hardrive, in_depth, manufacturer, manufacturer_value, max_resolution, megapixels, megapixels_value, memory, model, processor, ram_size, response_time, room, room_value, screensize, shirt_size, shirt_size_value, shoe_size, shoe_size_value, shoe_type, shoe_type_value" to table "catalog_product_flat_2" | |
| Add missing field(s) "activation_information, allow_message, allow_open_amount, color, color_value, computer_manufacturers, computer_manufacturers_value, contrast_ratio, contrast_ratio_value, country_orgin, cpu_speed, cpu_speed_value, custom_design_from, custom_design_to, custom_layout_update, description, dimension, finish, gallery, gender, gender_value, gift_message_available, gift_wrapping_available, gift_wrapping_price, harddrive_speed, hardrive, image, in_depth, is_recurring, manufacturer, manufacturer_value, max_resolution, media_gallery, megapixels, megapixels_value, memory, meta_description, meta_keyword, meta_title, minimal_price, model, msrp, msrp_display_actual_price_type, msrp_enabled, old_id, processor, ram_size, recurring_profile, response_time, room, room_value, samples_title, screensize, shape, shirt_size, shirt_size_value, shoe_size, shoe_size_value, shoe_type, shoe_type_value, use_config_allow_message" to table "catalog_product_flat_4" | |
| Add missing field(s) "customer_group_ids, website_ids" to table "catalogrule" | |
| Add missing field(s) "active_from, active_to" to table "enterprise_reminder_rule" | |
| Add missing field(s) "invoice_type, customer_id, real_order_id, invoice_status_id, is_virtual, total_paid, total_due" to table "sales_flat_invoice" | |
| Add missing field(s) "shipment_id" to table "sales_flat_invoice_item" | |
| Add missing field(s) "currency_rate, tax_percent, custbalance_amount, currency_base_id, real_order_id, currency_code, is_multi_payment, tracking_numbers, is_hold, base_custbalance_amount" to table "sales_flat_order" | |
| Add missing field(s) "address_id, tax_id, gift_message_id" to table "sales_flat_order_address" | |
| Add missing field(s) "cc_raw_request, cc_raw_response, customer_payment_id, amount" to table "sales_flat_order_payment" | |
| Add missing field(s) "ideal_issuer_id, ideal_issuer_list" to table "sales_flat_quote_payment" | |
| Add missing field(s) "customer_group_ids, website_ids" to table "salesrule" | |
| Add missing index(es) "IDX_CATALOG_CATEGORY_FLAT_STORE_4_STORE_ID, IDX_CATALOG_CATEGORY_FLAT_STORE_4_PATH, IDX_CATALOG_CATEGORY_FLAT_STORE_4_LEVEL" to table "catalog_category_flat_store_4" | |
| Add missing index(es) "IDX_CATALOG_CATEGORY_PRODUCT_INDEX_ENBL_IDX_PRODUCT_ID" to table "catalog_category_product_index_enbl_idx" | |
| Add missing index(es) "IDX_CATALOG_CATEGORY_PRODUCT_INDEX_ENBL_TMP_PRODUCT_ID" to table "catalog_category_product_index_enbl_tmp" | |
| Add missing index(es) "IDX_CATALOG_PRODUCT_FLAT_4_TYPE_ID, IDX_CATALOG_PRODUCT_FLAT_4_ATTRIBUTE_SET_ID, IDX_CATALOG_PRODUCT_FLAT_4_NAME, IDX_CATALOG_PRODUCT_FLAT_4_PRICE" to table "catalog_product_flat_4" | |
| Add missing index(es) "UNQ_ENTERPRISE_CMS_HIERARCHY_NODE_REQUEST_URL" to table "enterprise_cms_hierarchy_node" | |
| Add missing index(es) "FK_ENTERPRISE_INVITATION_STORE" to table "enterprise_invitation" | |
| Add missing index(es) "UNQ_WISHLIST_CUSTOMER_ID" to table "wishlist" | |
| Add missing table "catalog_category_flat_store_3" | |
| Add missing table "catalog_product_flat_3" | |
| Add missing foreign key(s) "FK_CAT_CTGR_FLAT_STORE_4_ENTT_ID_CAT_CTGR_ENTT_ENTT_ID, FK_CATALOG_CATEGORY_FLAT_STORE_4_STORE_ID_CORE_STORE_STORE_ID" to table "catalog_category_flat_store_4" | |
| Add missing foreign key(s) "FK_CAT_PRD_FLAT_4_ENTT_ID_CAT_PRD_ENTT_ENTT_ID" to table "catalog_product_flat_4" | |
| Add missing foreign key(s) "FK_ENTERPRISE_INVITATION_STORE" to table "enterprise_invitation" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ACTUALLY I USED THE WRONG DATABASE AS A REFERENCE ON THIS ONE | |
| Module "bundle_setup" has wrong version 1.6.0.0.1 in corrupted DB (reference DB contains "bundle_setup" ver. 1.6.0.0) | |
| Module "cataloginventory_setup" has wrong version 1.6.0.0.2 in corrupted DB (reference DB contains "cataloginventory_setup" ver. 1.6.0.0) | |
| Module "catalogrule_setup" has wrong version 1.6.0.3 in corrupted DB (reference DB contains "catalogrule_setup" ver. 1.6.0.1) | |
| Module "catalog_setup" has wrong version 1.6.0.0.14 in corrupted DB (reference DB contains "catalog_setup" ver. 1.6.0.0.6) | |
| Module "cms_setup" has wrong version 1.6.0.0.1 in corrupted DB (reference DB contains "cms_setup" ver. 1.6.0.0) | |
| Module "customer_setup" has wrong version 1.6.2.0.1 in corrupted DB (reference DB contains "customer_setup" ver. 1.6.1.0) | |
| Module "directory_setup" has wrong version 1.6.0.1 in corrupted DB (reference DB contains "directory_setup" ver. 1.6.0.0) | |
| Module "downloadable_setup" has wrong version 1.6.0.0.2 in corrupted DB (reference DB contains "downloadable_setup" ver. 1.6.0.0.1) | |
| Module "enterprise_cms_setup" has wrong version 1.11.0.3 in corrupted DB (reference DB contains "enterprise_cms_setup" ver. 1.11.0.0) | |
| Module "enterprise_customersegment_setup" has wrong version 1.11.0.0.3 in corrupted DB (reference DB contains "enterprise_customersegment_setup" ver. 1.11.0.0.2) | |
| Module "enterprise_giftregistry_setup" has wrong version 1.11.0.0.1 in corrupted DB (reference DB contains "enterprise_giftregistry_setup" ver. 1.11.0.0) | |
| Module "enterprise_giftwrapping_setup" has wrong version 1.11.0.0.1 in corrupted DB (reference DB contains "enterprise_giftwrapping_setup" ver. 1.11.0.0) | |
| Module "enterprise_reminder_setup" has wrong version 1.11.0.1 in corrupted DB (reference DB contains "enterprise_reminder_setup" ver. 1.11.0.0) | |
| Module "enterprise_targetrule_setup" has wrong version 1.11.0.0.3 in corrupted DB (reference DB contains "enterprise_targetrule_setup" ver. 1.11.0.0) | |
| Module "enterprise_websiterestriction_setup" has wrong version 1.11.0.0.1 in corrupted DB (reference DB contains "enterprise_websiterestriction_setup" ver. 1.11.0.0) | |
| Module "googleanalytics_setup" is not installed in corrupted DB | |
| Module "newsletter_setup" has wrong version 1.6.0.1 in corrupted DB (reference DB contains "newsletter_setup" ver. 1.6.0.0) | |
| Module "paypal_setup" has wrong version 1.6.0.2 in corrupted DB (reference DB contains "paypal_setup" ver. 1.6.0.1) | |
| Module "reports_setup" has wrong version 1.6.0.0.1 in corrupted DB (reference DB contains "reports_setup" ver. 1.6.0.0) | |
| Module "salesrule_setup" has wrong version 1.6.0.3 in corrupted DB (reference DB contains "salesrule_setup" ver. 1.6.0.1) | |
| Module "sales_setup" has wrong version 1.6.0.7 in corrupted DB (reference DB contains "sales_setup" ver. 1.6.0.4) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment