Created
July 6, 2021 09:46
-
-
Save shamsbd71/26242b4f9872e9109dc6cc7174cf376e to your computer and use it in GitHub Desktop.
Fix auto-increment WordPress database and duplicate entry. source: https://www.codegrepper.com/code-examples/whatever/fix+autoincrement+wordpress+database
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DELETE FROM wp_termmeta WHERE meta_id=0; | |
DELETE FROM wp_terms WHERE term_id=0; | |
DELETE FROM wp_term_taxonomy WHERE term_taxonomy_id=0; | |
DELETE FROM wp_commentmeta WHERE meta_id=0; | |
DELETE FROM wp_comments WHERE comment_ID=0; | |
DELETE FROM wp_links WHERE link_id=0; | |
DELETE FROM wp_options WHERE option_id=0; | |
DELETE FROM wp_postmeta WHERE meta_id=0; | |
DELETE FROM wp_users WHERE ID=0; | |
DELETE FROM wp_posts WHERE ID=0; | |
DELETE FROM wp_usermeta WHERE umeta_id=0; | |
ALTER TABLE wp_termmeta ADD PRIMARY KEY(meta_id); | |
ALTER TABLE wp_terms ADD PRIMARY KEY(term_id); | |
ALTER TABLE wp_term_taxonomy ADD PRIMARY KEY(term_taxonomy_id); | |
ALTER TABLE wp_commentmeta ADD PRIMARY KEY(meta_id); | |
ALTER TABLE wp_comments ADD PRIMARY KEY(comment_ID); | |
ALTER TABLE wp_links ADD PRIMARY KEY(link_id); | |
ALTER TABLE wp_options ADD PRIMARY KEY(option_id); | |
ALTER TABLE wp_postmeta ADD PRIMARY KEY(meta_id); | |
ALTER TABLE wp_users ADD PRIMARY KEY(ID); | |
ALTER TABLE wp_posts ADD PRIMARY KEY(ID); | |
ALTER TABLE wp_usermeta ADD PRIMARY KEY(umeta_id); | |
ALTER TABLE wp_termmeta CHANGE meta_id meta_id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT; | |
ALTER TABLE wp_terms CHANGE term_id term_id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT; | |
ALTER TABLE wp_term_taxonomy CHANGE term_taxonomy_id term_taxonomy_id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT; | |
ALTER TABLE wp_commentmeta CHANGE meta_id meta_id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT; | |
ALTER TABLE wp_comments CHANGE comment_ID comment_ID BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT; | |
ALTER TABLE wp_links CHANGE link_id link_id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT; | |
ALTER TABLE wp_options CHANGE option_id option_id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT; | |
ALTER TABLE wp_postmeta CHANGE meta_id meta_id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT; | |
ALTER TABLE wp_users CHANGE ID ID BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT; | |
ALTER TABLE wp_posts CHANGE ID ID BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT; | |
ALTER TABLE wp_usermeta CHANGE umeta_id umeta_id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment