Results 1 to 9 of 9
  1. #1
    Join Date
    Sep 2004
    Posts
    690
    Plugin Contributions
    0

    Default 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:

    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.
    Last edited by nadsab; 12 Mar 2012 at 10:44 PM.
    Happy to be a Zen Cart Monthly Donor! :)

  2. #2
    Join Date
    Sep 2004
    Posts
    690
    Plugin Contributions
    0

    Default Re: The following indexes appear to be equal and one of them should be removed warnin

    So....under the heading in phpMyAdmin :
    Documentation Keyname Type Cardinality Action Field
    I have the below...

    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:

    PRIMARY PRIMARY 0 Edit Drop products_id
    Is this correct?
    Happy to be a Zen Cart Monthly Donor! :)

  3. #3
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default 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 ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  4. #4
    Join Date
    Sep 2004
    Posts
    690
    Plugin Contributions
    0

    Default Re: The following indexes appear to be equal and one of them should be removed warnin

    OK thanks....

    I delete this one?

    products_id INDEX None Edit Drop products_id
    Happy to be a Zen Cart Monthly Donor! :)

  5. #5
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default 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 ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  6. #6
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default 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.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  7. #7
    Join Date
    Sep 2004
    Posts
    690
    Plugin Contributions
    0

    Default 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
    PRIMARY, products_id.
    ...and neither of the two have the idx prefix...
    Happy to be a Zen Cart Monthly Donor! :)

  8. #8
    Join Date
    Sep 2004
    Posts
    690
    Plugin Contributions
    0

    Default 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.
    Happy to be a Zen Cart Monthly Donor! :)

  9. #9
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: The following indexes appear to be equal and one of them should be removed warnin

    Use the Browse tab.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

 

 

Similar Threads

  1. Replies: 4
    Last Post: 13 Nov 2016, 11:03 PM
  2. v151 admin/includes/column_left.php should be removed
    By swguy in forum Bug Reports
    Replies: 0
    Last Post: 30 Nov 2013, 02:29 PM
  3. How to add indexes and drop them?
    By AJweb in forum Contribution-Writing Guidelines
    Replies: 1
    Last Post: 3 Apr 2011, 07:56 PM
  4. Replies: 9
    Last Post: 27 Jul 2010, 09:54 PM
  5. I've lost the 'special product' page that should appear in the centre
    By Shelleym in forum Templates, Stylesheets, Page Layout
    Replies: 0
    Last Post: 24 Jan 2009, 04:42 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR