STB Pro and utf8mb4
- Published in: Documentation
- Written by minimus
- Leave a reply
- Permalink
Starting from version 4.2 WordPress supports MySQL charset utf8mb4, and determines the possibility of using it automatically according to the version of MySQL (must be 5.5.3+). Some users use a special versions of MySQL (for example 5.5.42-cll) that must but does not support this charset. As a result – error when creating the table with all the consequences.
What to do? Below is a small instruction how to combat this problem.
Open phpMyAdmin or if you do not have access to it install any of the plugins that allows you to run SQL scripts (for example: SQL Executioner, MiwoSQL etc.). You need to execute two SQL scripts.
The first:
|
1 2 3 4 5 6 7 8 9 10 |
CREATE TABLE [PREFIX]_stb_pro_styles ( slug varchar(255) NOT NULL, caption varchar(255) NOT NULL, style text DEFAULT NULL, stype varchar(8) DEFAULT NULL, trash tinyint(1) DEFAULT 0, PRIMARY KEY (slug) ) CHARACTER SET utf8 COLLATE utf8_general_ci; |
This script creates a style table and set its charset to utf8. Do not forget to change [PREFIX] to the real prefix of your database (usually wp).
The second:
|
1 2 3 4 5 6 7 8 9 |
INSERT INTO wp_stb_pro_styles(slug, caption, stype, trash) VALUES ('alert', 'Alert!', 'system', 0), ('black', 'Black Quote', 'system', 0), ('custom', 'Custom Style', 'custom', 0), ('download', 'Download', 'system', 0), ('grey', 'Codes', 'special', 0), ('info', 'Info', 'system', 0), ('warning', 'Warning!', 'system', 0); |
This script fills in the table with the default data. Do not forget to change [PREFIX] to the real prefix of your database (usually wp).
After completing both scripts, go to “Themes” page of the plugin and activate any theme.
That’s all. Good luck!
© 2015, minimus. All rights reserved.