vidmarc Posted November 15, 2019 Share Posted November 15, 2019 Just spotted these, highlighted in orange: CubeCart_admin_users.admin_id has a key type KEY but expecting PRIMARY. CubeCart_inventory.popularity has no key set. Expecting KEY. CubeCart_order_summary.cart_order_id has a key type KEY but expecting UNIQUE KEY. CubeCart_order_summary.custom_oid has a key type KEY but expecting UNIQUE KEY. CubeCart_reviews.approved has no key set. Expecting KEY. CubeCart_seo_urls.type has no key set. Expecting KEY. CubeCart_seo_urls.item_id has no key set. Expecting KEY. Anything I should worry about? Link to comment Share on other sites More sharing options...
havenswift-hosting Posted November 15, 2019 Share Posted November 15, 2019 They are unlikely to cause any real issues but having indexes on columns that dont currently have them and (to a lesser extent) having the correct type of index, will speed up queries made by CubeCart. As it is so simple to add them, I would definitely recommend you do so Ian Link to comment Share on other sites More sharing options...
vidmarc Posted November 15, 2019 Author Share Posted November 15, 2019 Thanks - How do I fix them all? It's a bit beyond me. If I select each table, do I simply then select "optimise"? Link to comment Share on other sites More sharing options...
havenswift-hosting Posted November 15, 2019 Share Posted November 15, 2019 No - it has to be done using phpMyAdmin - there is a post on here somewhere where I detailed the process Link to comment Share on other sites More sharing options...
vidmarc Posted November 15, 2019 Author Share Posted November 15, 2019 Just found this: Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.