Created
October 9, 2019 19:25
-
-
Save cartpauj/49d1cf4fbb170bd77c92e8bfa9ef8795 to your computer and use it in GitHub Desktop.
Pretty Links 3.0 reset CPT's Queries
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_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type = 'pretty-link'); | |
| DELETE FROM wp_posts WHERE post_type = 'pretty-link'; | |
| UPDATE wp_prli_links SET link_cpt_id = NULL; | |
| UPDATE wp_options SET option_value = 1 WHERE option_name = 'prli_db_version'; | |
| UPDATE wp_options SET option_value = 1 WHERE option_name = 'prlipro_db_version'; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
After running these queries, refresh the WP Dashboard a couple of times.