Created
October 21, 2022 13:50
-
-
Save ideadude/9826f74b44f607127c67ea66ddc190ab to your computer and use it in GitHub Desktop.
Update some PMPro DB tables to use UTF8 character sets.
This file contains hidden or 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
# PMPro doesn't set the character set when creating its tables. | |
# So on install PMPro will use the default character set for your DB. | |
# In some cases this might be something like latin1, which will not | |
# work with special characters for non-latin languages, e.g. Hebrew. | |
# To fix this, you can update the character set on these tables using MySQL. | |
# | |
# IMPORTANT: Back up your DB (at least these tables) before running any queries. | |
ALTER TABLE wp_pmpro_membership_levels CONVERT TO CHARACTER SET utf8; | |
ALTER TABLE wp_pmpro_membership_levelmeta CONVERT TO CHARACTER SET utf8; | |
ALTER TABLE wp_pmpro_membership_ordermeta CONVERT TO CHARACTER SET utf8; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment