2

Over the last few days I have been carefully analysing my database and noticed some tables, which I believe are from previous versions. Searching my 1.9.3.8 code base to analyse the scripts, I cannot see them being removed anywhere. Thus, how can I remove them?

These tables are:

  • commentbox_comment
  • cms_widget
  • catalogindex_price
  • catalogindex_minimal_price
  • catalogindex_eav
  • catalogindex_aggregation_to_tag
  • catalogindex_aggregation_tag
  • catalogindex_aggregation
  • find_feed_import_codes
  • googlebase_attributes
  • googlebase_items
  • googlebase_types
  • googlecheckout_api_debug
  • googlecheckout_notification
  • googleoptimizer_code
  • shipping_matrixrate
  • xmlconnect_application
  • xmlconnect_config_data
  • xmlconnect_notification_template
  • xmlconnect_queue

I have also noticed catalog_product_index_eav and catalog_eav are emptpy shouldn't these tables be full or is it also an obsolete table?

Improve this question
3
  • I guess commentbox_comment, shipping_matrixrate and uni_fileuploaderaren't magento tables (not checked).
    – sv3n
    Jul 16, 2018 at 17:17
  • @sv3n commentbox_comment is present in numerous core location :S
    – Vaishal Patel
    Jul 18, 2018 at 13:34
  • Can't confirm. There is no no table/code in 1.9.3 ...
    – sv3n
    Jul 18, 2018 at 14:54

1 Answer 1

Reset to default
-1

You could add a custom module with a setup script to remove them, or run a direct SQL query, however unless these tables are huge they shouldn't impact anything and won't be worth removing in case it causes any issues in the future

Improve this answer
10
  • I could indeed. I also want to know why they weren't removed by default
    – Vaishal Patel
    Jul 18, 2018 at 13:34
  • I guess maybe to prevent issues with dependant 3rd party modules in updates?
    – eddhall
    Jul 18, 2018 at 16:09
  • eddhall, but they aren't in fresh installs. Only when upgrading from previous versions.
    – Vaishal Patel
    Jul 19, 2018 at 9:33
  • In that case they should be safe to delete, obviously worth trying it on a staging site first!
    – eddhall
    Jul 19, 2018 at 12:09
  • eddhall I shall do.
    – Vaishal Patel
    Jul 19, 2018 at 15:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.