Hello, I am getting syntax errors while trying to convert the keys of those tables: postmeta, usermeta & posts
Fatal error: Uncaught ImfsException: [0]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-meta_key/**imfs-query-tag*90313031*/' at line 1 in ALTER TABLE ccwp_postmeta ADD UNIQUE KEY meta_id (meta_id), DROP PRIMARY KEY, ADD PRIMARY KEY (post_id, meta_key, meta_id), DROP KEY meta_key, ADD KEY meta_key (meta_key, meta_value(32), post_id, meta_id), ADD KEY meta_value (meta_value(32), meta_id), DROP KEY meta_key_meta_value, DROP KEY post_id, DROP KEY post_id-meta_key/**imfs-query-tag*90313031*/
Fatal error: Uncaught ImfsException: [0]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'key-value, DROP KEY user_id, DROP KEY userid/**imfs-query-tag*691360193*/' at line 1 in ALTER TABLE ccwp_usermeta ADD UNIQUE KEY umeta_id (umeta_id), DROP PRIMARY KEY, ADD PRIMARY KEY (user_id, meta_key, umeta_id), DROP KEY meta_key, ADD KEY meta_key (meta_key, meta_value(32), user_id, umeta_id), ADD KEY meta_value (meta_value(32), umeta_id), DROP KEY key-value, DROP KEY user_id, DROP KEY userid/**imfs-query-tag*691360193*/
Fatal error: Uncaught ImfsException: [0]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-type-status-auth, DROP KEY ID-status-type, DROP KEY ToPing-Status, DROP KEY Typ' at line 1 in ALTER TABLE ccwp_posts DROP KEY post_name, ADD KEY post_name (post_name), DROP KEY post_parent, ADD KEY post_parent (post_parent, post_type, post_status), DROP KEY type_status_date, ADD KEY type_status_date (post_type, post_status, post_date, post_author), DROP KEY post_author, ADD KEY post_author (post_author, post_type, post_status, post_date), DROP KEY content-type-status-auth, DROP KEY ID-status-type, DROP KEY ToPing-Status, DROP KEY Type-mime_type/**imfs-query-tag*519889348*Any ideas?
Upload id: tdsX7sLw
Thanks for your help!