The following indexes appear to be equal and one of them should be removed warning
Quick question,
I am learning phpMyAdmin to learn backups etc, today is the first time I accessed my ZC database using it. This is an empty freshly created ZC database on a new install, ZC 1.5
By mistake I clicked the "Index" action button for the products_id field in the products table, after clicking on the structure icon for the products table, and now I have warning message at screen bottom which says:
Quote:
The following indexes appear to be equal and one of them should be removed: PRIMARY, products_id.
I am assuming I added a redundant index entry in the table that I need to delete; Can anyone tell me what I need to do here to correct?
Thanks so much.
Re: The following indexes appear to be equal and one of them should be removed warnin
So....under the heading in phpMyAdmin :
Quote:
Documentation Keyname Type Cardinality Action Field
I have the below...
Quote:
PRIMARY PRIMARY 0 Edit Drop products_id
idx_products_date_added_zen INDEX None Edit Drop products_date_added
idx_products_status_zen INDEX None Edit Drop products_status
idx_products_date_available_zen INDEX None Edit Drop products_date_available
idx_products_ordered_zen INDEX None Edit Drop products_ordered
idx_products_model_zen INDEX None Edit Drop products_model
idx_products_price_sorter_zen INDEX None Edit Drop products_price_sorter
idx_master_categories_id_zen INDEX None Edit Drop master_categories_id
idx_products_sort_order_zen INDEX None Edit Drop products_sort_order
idx_manufacturers_id_zen INDEX None Edit Drop manufacturers_id
products_id INDEX None Edit Drop products_id
I am assuing I need to delete the first entry of:
Quote:
PRIMARY PRIMARY 0 Edit Drop products_id
Is this correct?
Re: The following indexes appear to be equal and one of them should be removed warnin
Do not delete the primary delete the other index ...
Re: The following indexes appear to be equal and one of them should be removed warnin
OK thanks....
I delete this one?
Quote:
products_id INDEX None Edit Drop products_id
Re: The following indexes appear to be equal and one of them should be removed warnin
That is the one I would get rid of ...
Re: The following indexes appear to be equal and one of them should be removed warnin
Be careful!!!!!!!
Don't go just deleting things willy-nilly.
Sometimes duplication is INTENTIONAL. (notwithstanding the example you cited is clearly needless duplication).
Any indexes named "idx_xxxxxxxxx_zen" are intentional indexes placed by Zen Cart (unless someone has modified them post-install). If you see duplication messages about those, ignore them.
NOTE: the PRIMARY will never have any idx_ prefix or _zen suffix.
Re: The following indexes appear to be equal and one of them should be removed warnin
OK thanks to U 2...will take your advice,
I was not sure that's why i asked, because the warning message said to delete the
Quote:
PRIMARY, products_id.
...and neither of the two have the idx prefix...
Re: The following indexes appear to be equal and one of them should be removed warnin
Just curious while I'm on the subject.....how does one view an entire MySQL table in phpMyAdmin?
I'm not going to do any table editing - I plan on using easy populate to upload a store, just curious how to view an entire table like the products table.
All I have been able to figure out my first day on phpMyAdmin is view the fields (or column headings) of a table.
Re: The following indexes appear to be equal and one of them should be removed warnin