Issue with Index Column size and default character set
-
We are using your app in tandem with the BuddyBoss social learner theme (its a required plugin) on the Pantheon platform and the app is throwing the following two errors:
ordPress database error Index column size too large. The maximum column size is 767 bytes. for query CREATE TABLE wp_p2pmeta (
meta_id bigint(20) unsigned NOT NULL auto_increment,
p2p_id bigint(20) unsigned NOT NULL default ‘0’,
meta_key varchar(255) default NULL,
meta_value longtext,
PRIMARY KEY (meta_id),
KEY p2p_id (p2p_id),
KEY meta_key (meta_key)
DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci made by require_once(‘wp-admin/admin-header.php’), do_action(‘admin_notices’), WP_Hook->do_action, WP_Hook->apply_filters, P2P_Tools_Page->maybe_install, P2P_Storage::install, scb_install_table, dbDeltaPantheon narrowed it down to the storage.php file in the p2pcore folder and the scb_install_table.
it should be detecting utf8 in our wp_config and it cannot be 255 characters, it has to be 191
This is holding up an entire project so help would be greatly appreciated.
- The topic ‘Issue with Index Column size and default character set’ is closed to new replies.